DEV Community

Discussion on: To SQL or NoSQL

Collapse
 
cubiclesocial profile image
cubiclesocial • Edited

You can have the best of both worlds:

cubicspot.blogspot.com/2012/05/cre...

I wrote that post back in 2012. I still use the same techniques today as documented by that post with a few minor refinements. Since then, SQLite has grown and matured to the point that it is my go-to for personal projects that need a database but won't be deployed to a production environment. SQLite is small, lightweight, ultra-fast, self-contained, zero-dependencies, and comes as pre-compiled packages for several scripting languages. If there is an arbiter TCP/IP service written for it, it is also highly scalable and can even be sharded.