Re:How the SQLite virtual machine works
by avl999 on Wednesday September 07, 2022 @05:15PM
(#32757006)
With that setup you have essentially lost any benefits that SQLite provides, specifically any performance benefits by making a DB read/write a network call instead of a local call in the same process that manipulates some file on the same machine. You are closer to a postgres/mysql patterne except now your writes don't scale as well. What are we actually gaining with this setup other than perhaps easier administration of the "db service" compared to a mysql/postgres deployment?
[ Parent
| on HN ]