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: 219

▶ 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.

 

Enjoy the site? Support Codetown with your donation.



InfoQ Reading List

Rachael Greaves at QCon London: Ethical AI Can Decrease the Impact of Data Breaches

At QCon London, Rachael Greaves, chief executive officer at Castle Systems, presented both the obligations and benefits of data minimisation as a mechanism to decrease the impact of data breaches. AI autoclassification and automatic decision-making tools help with the ever-increasing data volumes as long as ethical principles are considered, allowing decisions to be challenged.

By Olimpiu Pop

JetBrains Launches IDE Services to Simplify Managing Development Tools

JetBrains IDE Services aims to help enterprises manage their JetBrains tool ecosystem more efficiently and boost developer productivity at the enterprise scale through the integration of AI, remote collaboration, and more.

By Sergio De Simone

Podcast: Building the Muscles for Critical Thinking

In this podcast Shane Hastie, Lead Editor for Culture & Methods spoke to Dannielle Pearson about the importance of critical thinking in technology.

By Dannielle Pearson

.NET Aspire Preview 6: Enhanced Security and Testing, New Features, and More

This week Microsoft released Preview 6 of the .NET Aspire project. Significant changes have been implemented to enhance the security and reliability of the platform. This release, version 8.0.0-preview.6.24214.1, introduces several noteworthy additions, like changes related to templates, components, dashboard, testing and more.

By Almir Vuk

Presentation: Sleeping at Scale - Delivering 10k Timers per Second per Node with Rust, Tokio, Kafka, and Scylla

Lily Mara, Hunter Laine walk through the design of a system, its performance characteristics, and how they scaled it.

By Lily Mara, Hunter Laine

© 2024   Created by Michael Levin.   Powered by

Badges  |  Report an Issue  |  Terms of Service