Json-Base – Database built as JSON files • Hacker News Board

pstuart wrote: post #3

tushonka wrote: post #2

Aaah the beginners project to store info without having an actual database.

SQLite with the JSON extension works well.

Who has time to learn SQL when you can just read/write JS objects from/to files. ;)

Re: Json-Base – Database built as JSON files

#6

Post by coding123 » Thu, Jul 02, 2020, 5:47 PM UTC

There are many use-cases for this for super simple ma-pa shops. It may be relegated 100% to shopping carts and checkout processes, but this would allow one to hand-edit her database, and even potentially let the server git push live changes... kinda interesting concept.

Re: Json-Base – Database built as JSON files

#7

Post by sanqui » Thu, Jul 02, 2020, 5:47 PM UTC

Sounds like how MongoDB was born. I believe that has made a lot of people very angry and been widely regarded as a bad move.

Re: Json-Base – Database built as JSON files

#8

Post by mkl95 » Thu, Jul 02, 2020, 5:47 PM UTC

This brings me back sweet memories of saving my Pygame minigames state to clunky JSON files when I was basically clueless about databases. It worked surprisingly well until it became a huge spaghetti mess :-)

Re: Json-Base – Database built as JSON files

#9

Post by time0ut » Thu, Jul 02, 2020, 5:51 PM UTC

I could see some niche uses for this. Anywhere you want a quick and dirty local db for demos and hacking. That said, I think you'll get more mileage out of SQLite. It is generally my go to for these use cases and far richer and more powerful.

Re: Json-Base – Database built as JSON files

#10

Post by jaywalk » Thu, Jul 02, 2020, 5:52 PM UTC

It's all fun and games until this ends up in somebody's production environment.