Codetown
Codetown ::: a software developer's community
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: 252
Replies to This Discussion
-
Permalink Reply by Lou Caudell on
-
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.
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.
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.
InfoQ Reading List
Presentation: Are You Missing a Data Frame? The Power of Data Frames in Java
Vladimir Zakharov explains how DataFrames serve as a vital tool for data-oriented programming in the Java ecosystem. By analyzing The One Billion Row Challenge, he shares how Java frameworks can outperform Python in memory management while maintaining code readability. He discusses practical use cases for senior devs, from ad-hoc data manipulation to building scalable enterprise pipelines.
By Vladimir ZakharovUber Moves In-House Search Indexing to Pull-Based Ingestion in OpenSearch
Uber transitions its in-house search indexing to OpenSearch with a pull-based ingestion framework, improving reliability, backpressure handling, and multi-region consistency for large-scale streaming data while simplifying recovery and supporting global, real-time search experiences.
By Leela KumiliArticle: Building LLMs in Resource-Constrained Environments: A Hands-On Perspective
In this article, the author argues that infrastructure and compute limitations can drive innovation. It demonstrates how smaller, efficient models, synthetic data generation, and disciplined engineering enable the creation of impactful LLM-based AI systems despite severe resource constraints.
By Olimpiu PopPodcast: [Video Podcast] Improving Valkey with Madelyn Olson
In this episode, Thomas Betts chats with Madelyn Olson, a maintainer of the Valkey project and a Principal Software Development Engineer at Amazon ElastiCache and Amazon MemoryDB. The conversation covers how Valkey started as an open source fork of Redis and how the maintainers optimized the memory usage and improved throughput.
By Madelyn OlsonXcode 26.3 Brings Integrated Agentic Coding for Anthropic Claude Agent and OpenAI Codex
The latest release of Xcode, Xcode 26.3, extends support for coding agents, such as Anthropic's Claude Agent and OpenAI's Codex, helping developers tackle complex tasks and improve their productivity.
By Sergio De Simone
© 2026 Created by Michael Levin.
Powered by
