database-js VS Lowdb

That I understand.

But of course for the user of the driver it might be fine if that is 2 or more HTTP requests. I expect that is how PlanetScale does it in their transaction implementation, https://github.com/planetscale/database-js#transactions, and I know that is how Prisma Data Proxy handles it - the transaction is identified with an ID which is returned to the Client and then included in further requests for the same transaction.

It's valid tradeoff to make to prefer a persistent connection to keep the overhead for multiple queries in a transaction as low as possible - which seems what Neon has done here.

The PlanetScale team recently released their database driver which lets your query your PlanetScale database using the Fetch API. This means you can use this library to query your database in edge environments which is HUGE.

> what happens if the company goes down?

It's open-source. What's your concern now?

https://github.com/planetscale/database-js

https://github.com/typicode/lowdb is a cool option.

I just finished the first stable version of go-store, a lightweight embeeded database written in pure Go. It was heavily inspired by lowdb. The motivation was that I needed something simple to store information for another project and that I wanted to try out Go's generics.

https://jsondb.io/ or https://github.com/typicode/lowdb

By default, requests are stored locally in a JSON file with the help of LowDB.

For 1: Don't.* For 2: You're looking for a cache. I've published an OS npm module. Looking at the code might help: https://github.com/tq-bit/qache/blob/master/src/Cache.ts For 3: Maybe the code of lowdb can point you in the right direction: https://github.com/typicode/lowdb/tree/main/src

Another thing you might consider is literally using the filesystem as a database. There are plenty of vanillla ways to simply read/write to JSON or you could even use a JSON based db github.com/typicode/lowdb again you don't need to think about it as a db your just handling JS objects.

I did want something performant so that I would (hopefully) not run into issues when there are around 100-ish clients connected at the same time. I looked at low-db for a while but did not like that it would JSON.stringify my whole database on every change, which could become a problem when it becomes to big.