Using SQL with Node,.js

All the tutorials and books for node.js seem to use Mongo as the database.  I am not sold on 'document' databases and would like to know how difficult it is to use any version for plain old tried-and-true SQL with Node.js.

Does anybody have any experience in this area?

Views: 168

▶ Reply to This

Replies to This Discussion

Permalink Reply by Lou Caudell on November 10, 2015 at 11:33pm

One of the traditional knocks on JS is the volatility of doing sql queries from a interpreted script. Not to mention security. In other words, how do you regulate resource for results in a varying client environment. Node.js is supposed to provide a server side capability. However I would be skeptical of it its implementation of a transnational capability. A memento pattern, or ability to rollback transactions, at least until thoroughly tested. Given the fact that most discussions are coupled with no-sql db's is a clue as to what its intended usage should be. Perhaps caches for local search tools like solr. Easy to update, and rebuild, but less likely to be an efficient engine for individualized rdbms queries.

▶ Reply to Discussion

RSS

Happy 10th year, JCertif!

Notes

Welcome to Codetown!

Codetown is a social network. It's got blogs, forums, groups, personal pages and more! You might think of Codetown as a funky camper van with lots of compartments for your stuff and a great multimedia system, too! Best of all, Codetown has room for all of your friends.

When you create a profile for yourself you get a personal page automatically. That's where you can be creative and do your own thing. People who want to get to know you will click on your name or picture and…
Continue

Created by Michael Levin Dec 18, 2008 at 6:56pm. Last updated by Michael Levin May 4, 2018.

Looking for Jobs or Staff?

Check out the Codetown Jobs group.

There's also a free Java Jobs mailing list. It's a Yahoo group so you have to create a Yahoo account to use it.

 

Enjoy the site? Support Codetown with your donation.



InfoQ Reading List

Micronaut 2.0 Enhances Tooling, Improves Support for Serverless and GraalVM

Object Computing, Inc. (OCI) has formally released Micronaut 2.0, a major release of the full-stack JVM-based framework that helps creating microservices-based, cloud-native and serverless applications utilizing languages such as Java, Groovy, and Kotlin.

By Vijay Nair

Bootstrap 5 Removes jQuery Dependency

The new Bootstrap 5 removes jQuery and no longer supports Internet Explorer (IE)

By Vivian Hu

Presentation: Operating Pivotal Application Service at Scale

Yusuke Kondo, Akinori Nitta explain the challenges faced and solutions experienced to run and manage a large-scale platform.

By Yusuke Kondo, Akinori Nitta

Article: Q&A on the Book Further, Faster

Businesses that thrive over the long term can focus on just a few things that truly matter to their teams and core customers. The book Further, Faster by Bill Flynn provides ideas for business leaders to build teams, create a strategy to stay close to customers, and manage a company’s growth with cash as the primary metric.

By Ben Linders, Bill Flynn

Presentation: Managing Systems in an Age of Dynamic Complexity

Laura Nolan looks at the common architectural shapes of dynamic control planes, and some examples of how they fail spectacularly - many major cloud outages are caused by dynamic control plane issues. Why are dynamic control planes so hard to run, and what can be done about it?

By Laura Nolan

© 2020   Created by Michael Levin.   Powered by

Badges  |  Report an Issue  |  Terms of Service