Back in 1999 or so, before SQLite was a thing, I used to throw little ASP websites together with an MS access .mdb file as the backend connected up through ODBC.
It was neat and quick and easy to get running right on your regular windows desktop.
By the criteria of this article, that was apparently the only database I ever needed. It could handle the multiple reads and occasional write of a small scale website. Backing it up consisted of copying the file. It was accessed through a simple standard library (ODBC) and supported SQL.
Since that was the only database we needed, what does SQLite bring to the table?
It was neat and quick and easy to get running right on your regular windows desktop.
By the criteria of this article, that was apparently the only database I ever needed. It could handle the multiple reads and occasional write of a small scale website. Backing it up consisted of copying the file. It was accessed through a simple standard library (ODBC) and supported SQL.
Since that was the only database we needed, what does SQLite bring to the table?