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

Article: 9 Steps Towards an Agile Architecture

Just as a Minimum-Viable Architecture (MVA) approach does not create a system’s architecture in a single step, adopting an MVA approach takes a series of incremental steps as well. These organizational changes start with a single development team and use feedback to evolve the process as more teams are brought in.

By Kurt Bittner, Pierre Pureur

JetBrains IntelliJ IDEA 2024.1 Delivers Support for Java 22 Features

JetBrains released IntelliJ IDEA 2024.1 featuring support for Java 22 features, OpenRewrite, WireMock server, the Maven Shade Plugin and full line code completion for Java and Kotlin.

By Johan Janssen

Presentation: The Creative Act: How Staff+ Is More Art Than Science

David Grizzanti talks about his path to Staff+ and how he views it as more art than science, looking at the parallels between creating art, creating software, and dealing with organizational dynamics.

By David Grizzanti

Terraform 1.8 Adds Provider-Defined Functions, Improves AWS, GCP, and Kubernetes Providers

HashiCorp has released version 1.8 of Terraform, their infrastructure-as-code language. The release introduces provider-defined functions. This enables the creation of custom functions within a given provider that handle computational-style tasks. Several providers have introduced new provider-defined functions. Version 1.8 also introduces improvements to refactoring across resource types.

By Matt Campbell

API Access with Amazon Verified Permissions and Amazon Cognito

AWS recently announced that Amazon API Gateway requests can now be authorized with Amazon Verified Permissions. With this feature, HTTP requests containing tokens issued by Amazon Cognito can be used to perform authorization decisions against API resources.

By Nsikan Essien

© 2024   Created by Michael Levin.   Powered by

Badges  |  Report an Issue  |  Terms of Service