Re:Cross-Database Queries in SQLite
by zetalemur on Sunday February 21, 2021 @07:21PM
(#26218848)
> I feel like if I am worried about those issues, when would I ever use sqlite instead of Postgres?
Sometimes you do not want to run an additional process/daemon like postgres. Your state is in essence now a file on some file system that you can atomically (full ACID) update using multi processing without the need for more complex machinery - you can get very far with this architecture.
Sometimes you do not want to run an additional process/daemon like postgres. Your state is in essence now a file on some file system that you can atomically (full ACID) update using multi processing without the need for more complex machinery - you can get very far with this architecture.