which database type is best for filament to store millions of records?

which database type is best for filament to store millions of records?
No description
9 Replies
Dennis Koch
Dennis Koch2mo ago
best for filament
There is nothing that makes Filament special.
to store millions of records
Probably any of them. So use the one you are comfortable with and probably use the latest version.
Matthew
Matthew2mo ago
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
Matthew
Matthew2mo ago
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.
Matthew
Matthew2mo ago
I worked at a company and we used it to store camera data
Dennis Koch
Dennis Koch2mo ago
Why would you recommend Timescale when it’s just about normal data and no time series mentioned?!
Matthew
Matthew2mo ago
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
Dennis Koch
Dennis Koch2mo ago
Even SQLite can probably handle 1m records. It’s not much for a database
awcodes
awcodes2mo ago
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.
Sam Pizzo
Sam PizzoOP2mo ago
reason i asked i laravel cloud, they only have postgres right now. we have to convert our database from mysql

Did you find this page helpful?