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

Airbnb Open-Sources its ML Feature Platform Chronon

Chronon, Airbnb platform to create the infrastructure required to transform raw data into ML-ready features, is now open source. As Airbnb ML infrastructure engineer Varant Zanoyan explains, Chronon supports a variety of data sources and aims to provide low-latency streaming.

By Sergio De Simone

How to Do Sustainable Software Development

Software sustainability includes computing for environmental purposes and using resources appropriately. According to Coral Calero, software engineers need a holistic way of looking at software and should be aware of the environmental impact of software. Several tools and frameworks are available for software engineers to do sustainable software development.

By Ben Linders

Presentation: Protecting APIs in Financial Services with Zero Trust Overlay Mesh Networks

Clint Dovholuk reviews the three components of OpenZiti's architecture: controller, edge routers, and SDKs in addition to diving into the internal physical and logical architecture of OpenZiti.

By Clint Dovholuk

Building SaaS from Scratch Using Cloud-Native Patterns: A Deep Dive into a Cloud Startup

Joni Collinge, Diagrid's Founding Software Engineer, presented at QCon London and discussed a case study on the evolutionary design and implementation of the Diagrid Cloud platform, which underpins Diagrid’s SaaS offerings.

By Steef-Jan Wiggers

KubeCon EU: Mercedes-Benz’s Migration From Pod Security Policies to Validation Admission Policies

During KubeCon EU the Mercedes Benz team presented their migration journey from Pod Security Policies to Validation Admission Policies to secure their 1000+ Kubernetes clusters. The solution was chosen in favour of Kyverno due to its improved performance.

By Olimpiu Pop

© 2024   Created by Michael Levin.   Powered by

Badges  |  Report an Issue  |  Terms of Service