which database type is best for filament to store millions of records?
which database type is best for filament to store millions of records?
9 Replies
best for filamentThere is nothing that makes Filament special.
to store millions of recordsProbably any of them. So use the one you are comfortable with and probably use the latest version.
If you need to store millions of records I would reccomend timscaledb
Its a fork of postgres
But again, it depends what kind of data you need to store
PostgreSQL ++ for time series and events | Timescale
Engineered to handle demanding workloads, like time series, vector, events, and analytics data. Built on PostgreSQL, with expert support at no extra charge.
I worked at a company and we used it to store camera data
Why would you recommend Timescale when it’s just about normal data and no time series mentioned?!
Thats why I said depends on the data you need to store.
Im not sure if postgres or mysql or great if you have 1m+ records
Even SQLite can probably handle 1m records. It’s not much for a database
My understanding, for what it’s worth, is that MySQL and Postgres are both more than fine for a million rows. the difference is whether your app needs are more about writes or reads. The data I’ve seen is that MySQL is better for reads and Postgres is better at writes. But the amount of data basically becomes irrelevant. If you’re at the point where it actually matters then you will have a whole other layer of db sharding and distribution.
Long story short, don’t worry about scale before you need to.
reason i asked i laravel cloud, they only have postgres right now. we have to convert our database from mysql