Introduction
The database is an important aspect of any application. They help in storing and managing different data generated by the a...
For further actions, you may consider blocking this person and/or reporting abuse
Pocketbase is also very interesting, it is realtime and very easy to use
Great addition to the list.
Postgresql Always
Always great.
Which is your favorite database?
I might be a little biased but CockroachDB serverless is my choice. It's postgres compatible and has a generous free tier that will scale with you. And multi-region options are going to be available soon.
That's sounds awesome.
My favorite database is ArcadeDB.
Never heard. What's it USP?
Versatility, see: dev.to/gramian/one-minute-arcadedb...
MySQL
Is PlanetScale Free?
Until a point yes. Though it has a very fair price structure.
For more info see: planetscale.com/pricing
so long
They do have a free plan. You can check it here.
Supabase rocks
Supabase is Awesome!
SQLite is my preferred database these days if I'm not using a heavyweight relational DB like Postgres/MySQL/MariaDB. In particular, if I'm already writing a TCP/IP application server, the server naturally provides concurrent access control to the SQLite backend (concurrency is something that SQLite is known to not be great at doing for itself) and can do things such as only commit transactions every few seconds as well as cache very specific, frequently accessed information in RAM from the DB that is always correct and also ready for instant delivery whenever requested by connected clients thereby avoiding making queries for common information that doesn't change very often.
Time-delayed commits do run the risk of losing data during a power outage or an application crash - both are extremely rare events - but the tradeoff is major application performance gains when the system is under heavy load. I've had fairly remarkable success with the approach.
As SQlite is just a file based database, you will need some kind of "driver" to access your DB, that might give you a different experience of usage. This might be PHP, node.js, Java or Pyhton, it is also possible to run SQlite over NodeRed, which gives you access to the DB via REST or MQTT.
Depending on your needs, if your app provides mainly static data, you can also use simple txt- or JSON-files to store your data. You might need some PHP or Node.js to organize the files, but it might make things much easier in some cases.