Re:Ask HN: What's the database you use for your simple website?
by meretext on Monday November 25, 2019 @05:15PM
(#21633393)
The thought is always start with the simplest capability you can use to meet your requirements -- PG is awesome, but it does require care and feeding by a DBA. Here's a tool to migrate from SQLite to PostgreSQL if and when necessary, but if your schema is reasonably clean it shouldn't be a hardship:
My suggestion is script what you need to test to check throughput for the number of concurrent conns you think you'll be needing and base decisions on that. FYI - I use Fossil SCM over git. It is awesome.
https://github.com/dimitri/pgloader
My suggestion is script what you need to test to check throughput for the number of concurrent conns you think you'll be needing and base decisions on that. FYI - I use Fossil SCM over git. It is awesome.
https://www.fossil-scm.org/home/doc/trunk/www/index.wiki