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

▶ 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

Apple's Illusion of Thinking Paper Explores Limits of Large Reasoning Models

Apple Machine Learning Research published a paper titled "The Illusion of Thinking," which investigates the abilities of Large Reasoning Models (LRMs) on a set of puzzles. As the complexity of the puzzles increases, the researchers found that LRMs encounter a "collapse" threshold where the models reduce their reasoning effort, indicating a limit to the models' scalability.

By Anthony Alford

Presentation: A Framework for Building Micro Metrics for LLM System Evaluation

Denys Linkov shares lessons on preventing LLM production issues. He explains the flaws of single metrics, the importance of treating models as observable systems, building user-issue-alerting metrics, and focusing on business value. He emphasizes a "crawl, walk, run" approach to LLM metric maturity for successful, trust-building deployments.

By Denys Linkov

Google DeepMind Unveils AlphaGenome: A Unified AI Model for High-Resolution Genome Interpretation

Google DeepMind has announced the release of AlphaGenome, a new AI model designed to predict how genetic variants affect gene regulation across the entire genome. It represents a significant advancement in computational genomics by integrating long-range sequence context with base-pair resolution in a single, general-purpose architecture.

By Robert Krzaczyński

Jakarta EE 11 Delivers One New Specification, 16 Updated Specifications and Modernized TCK

What was originally planned for a full GA release of Jakarta EE 11 in July 2024, only the Core Profile and the Web Profile were delivered in December 2024 and April 2025, respectively. And now, the Jakarta EE 11 Platform has been delivered featuring one new specification and a new TCK. Ed Burns, Release Coordinator for Jakarta EE 11, spoke to InfoQ about the release of Jakarta EE 11.

By Michael Redlich

Logz.io and Dynatrace Innovations Shift Observability Into the AI Age

Major observability platform providers are integrating artificial intelligence into their monitoring systems, as enterprises look to their suppliers to reduce the manual work involved in keeping an eye on digital infrastructure. Companies have implemented AI-driven features designed to automate routine operational tasks and accelerate incident resolution processes.

By Matt Saunders