3 ms·

You can get a managed Postgres instance for $15/month these days. Likely cheaper, more secure, faster, better than an SQLite db hosted manually on a VM. >Becau

You can get a managed Postgres instance for $15/month these days. Likely cheaper, more secure, faster, better than an SQLite db hosted manually on a VM. >Because it requires no setup and has been used to scale typcial Web2 applications to millions in revenue on a single cheap VM. Plenty of setup. How would you secure your VM? SSL configuration? SSL expiration management? Security? How would you scale your VM to millions without downtime? Backups? Restoring backups? All these problems are solved with managed database hosting.

throwaway0x7E6 4y ago
my brother in Christ, SQLite is not a RDBMS. it runs on the same machine as your application. the scary, overwhelmingly complex problems you've enumerated should indeed be left to competent professionals to deal with, but they do not affect SQLite.
- geocar 4y ago
  > the scary, overwhelmingly complex problems you've enumerated should indeed be left to competent professionals to deal with You also aren’t getting that for $15/mo, either.
  - senttoschool 4y ago
    https://www.digitalocean.com/pricing/managed-databases https://www.digitalocean.com/pricing/managed-databases $15/month for Postgres managed hosting. I would consider DO as competent professionals.
    - geocar 4y ago
      And are they going to deal with that scary stuff for me for $15/mo? Or are they going to turn it off and on and tell me I need a bigger boat if it’s slow?
      - senttoschool 4y ago
        What scary stuff are you dealing with?
- oefrha 4y ago
  > it runs on the same machine as your application. Better, it runs in the same process.
zinodaur 4y ago
I recently hopped on the SQLite train myself - I think it's a great default. If your business can possibly use sqlite, you get so much performance for free - performance that translates to a better user experience without the need to build a complicated caching layer. The argument boils down to how the relative performance costs of databases have changed in the 30 years since MySQL/Postgres were designed - and the surprising observation that a read from a fast SSD is usually faster than a network call to memcached. [1] https://fly.io/blog/all-in-on-sqlite-litestream/ https://fly.io/blog/all-in-on-sqlite-litestream/ [2] https://www.usenix.org/publications/loginonline/jurassic-cloud https://www.usenix.org/publications/loginonline/jurassic-clo...

throwaway0x7E6 4y ago

my brother in Christ, SQLite is not a RDBMS. it runs on the same machine as your application. the scary, overwhelmingly complex problems you've enumerated should indeed be left to competent professionals to deal with, but they do not affect SQLite.

geocar 4y ago
> the scary, overwhelmingly complex problems you've enumerated should indeed be left to competent professionals to deal with You also aren’t getting that for $15/mo, either.
- senttoschool 4y ago
  https://www.digitalocean.com/pricing/managed-databases https://www.digitalocean.com/pricing/managed-databases $15/month for Postgres managed hosting. I would consider DO as competent professionals.
  - geocar 4y ago
    And are they going to deal with that scary stuff for me for $15/mo? Or are they going to turn it off and on and tell me I need a bigger boat if it’s slow?
    - senttoschool 4y ago
      What scary stuff are you dealing with?
oefrha 4y ago
> it runs on the same machine as your application. Better, it runs in the same process.

zinodaur 4y ago

I recently hopped on the SQLite train myself - I think it's a great default. If your business can possibly use sqlite, you get so much performance for free - performance that translates to a better user experience without the need to build a complicated caching layer. The argument boils down to how the relative performance costs of databases have changed in the 30 years since MySQL/Postgres were designed - and the surprising observation that a read from a fast SSD is usually faster than a network call to memcached. [1] https://fly.io/blog/all-in-on-sqlite-litestream/ https://fly.io/blog/all-in-on-sqlite-litestream/ [2] https://www.usenix.org/publications/loginonline/jurassic-cloud https://www.usenix.org/publications/loginonline/jurassic-clo...