Ask HN: Is there a resource to help choose the right DB for you needs?

Re:Ask HN: Is there a resource to help choose the right DB f... by facorreia on Tuesday January 26, 2021 @11:59AM (#25918189)

If your business grows so quickly that one Postgress instance can't cope, by that time hopefully you should have enough revenue (or investors) to add a few read replicas.

Also, are you planning on storing large blobs in the database? If so, consider storing them in a blob store (e.g. S3) and only storing their path in the DB.

[ Parent | on HN ]

Re:Ask HN: Is there a resource to help choose the right DB f... by getcrunk on Tuesday January 26, 2021 @02:55PM (#25920355)

think something like google keep or trello or airtable. Its just a lot of text/json. Its in a db and not blobs or object store due to sync, filtering, tagging, reporting ..... larger assets(img) will be in an object store

Maybe its not supposed to be in a DB, but using my export of google keep as a guide on average my larger files are 10-20kb of json. x that by 1000 for unlimited* storage and x that per user you're over 1 TB.

Even in that case postgres will still work and there will be enough time to scale up manually. But from the perspective of architecting something on this scale or beyond I made my original post.

And so maybe I am over architecting then both of yours advice about pg still applies. (you guys are ultimately right, practically)

[ Parent | on HN ]