Re:SQLite Is Serverless
by dragontamer on Sunday January 26, 2020 @05:41AM
(#22151447)
> when do you move form using in-application data structures (maps, trees, vector/arrays) to using a database?
The killer feature of databases, including no-sql or older ones like BerkeleyDB, is multiprocess synchronization.
If two programs (or two copies of the same program) need to coordinate their data, a database is often far easier to use than writing your own transaction layer through files, mutexes, and other primitives.
Web applications, such as forums or discussion boards, have many users and processes adding data simultaneously. That's why databases are so popular in web backends.
The killer feature of databases, including no-sql or older ones like BerkeleyDB, is multiprocess synchronization.
If two programs (or two copies of the same program) need to coordinate their data, a database is often far easier to use than writing your own transaction layer through files, mutexes, and other primitives.
Web applications, such as forums or discussion boards, have many users and processes adding data simultaneously. That's why databases are so popular in web backends.