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: 262
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
Cloudflare and ETH Zurich Outline Approaches for AI-Driven Cache Optimization
Cloudflare and ETH Zurich highlight how AI-driven crawler traffic challenges traditional caching in CDNs and databases. They propose AI-aware strategies including separate cache tiers, adaptive algorithms, and pay-per-crawl models to balance performance for human users and AI services while maintaining cache efficiency and system stability.
By Leela KumiliGitHub Actions Custom Runner Images Reach General Availability
GitHub has just announced the availability of custom images for its hosted runners. They've finally left the public preview phase that started back in October behind them. This feature will enable teams to use a GitHub-approved base image and then construct a virtual machine image that really meets their workflow requirements.
By Claudio MasoloPresentation: Local First – How To Build Software Which Still Works After the Acquihire
Alex Good discusses the fragility of modern cloud-dependent apps and shares a roadmap for "local-first" software. By leveraging a Git-like DAG structure and Automerge, he explains how to move from brittle client-server models to resilient systems where data lives on-device. He explores technical implementation, rich-text merging, and how this infrastructure simplifies engineering workflows.
By Alex GoodArticle: Stateful Continuation for AI Agents: Why Transport Layers Now Matter
Agent workflows make transport a first-order concern. Multi-turn, tool-heavy loops amplify overhead that is negligible in single-turn LLM use. Stateful continuation cuts overhead dramatically. Caching context server-side can reduce client-sent data by 80%+ and improve execution time by 15–29% .
By Anirudh MendirattaPresentation: State of Play: AI Coding Assistants
Birgitta Böckeler discusses the rapid evolution of AI agents, moving beyond "vibe coding" to sophisticated context engineering. She explains how architectural constraints and "harness engineering" create the safety nets required for autonomous code generation. She shares vital insights for leaders on balancing speed with maintainability, security risks, and the cost of AI autonomy.
By Birgitta Böckeler
© 2026 Created by Michael Levin.
Powered by
