4 ms·
I have about a week to choose between SQLite, PostgreSQL or I guess MariaDB for an API using EF Core that should quickly ramp from 0 to ~1k daily active users t
by nisegami 2y ago
I have about a week to choose between SQLite, PostgreSQL or I guess MariaDB for an API using EF Core that should quickly ramp from 0 to ~1k daily active users then slowly ramp to 4-6k DAU over the next year. I feel so in over my head.
- leosanchez 2y agoI don't know if it helps but EFCore support for Postgres is excellent :). But sqlite should handle 1k DAU.
- yread 2y agoYou need to look at other things apart from DAU, too. How many writes, how complicated is the database (number of tables, average number of joins to answer a query), what are the availability requirements? And how far can you go with having the db on the same machine: how much can you scale vertically, what's the fastest storage you can get?
- anotherhue 2y agoUse a managed Postgres and spend your time on un-solved problems.
- kbolino 2y agoI don't understand how SQLite ends up in the same category for comparison with database servers with this sort of use in mind. SQLite is a great piece of technology but a local file and a network connection are not interchangeable (NFS notwithstanding). How do you deploy an updated version or another instance of your API server while your SQLite file is busy on another machine?
- 5Qn8mNbc2FNCiVV 2y agoJust use Postgres. Sqlite migrations are a PITA