Re: SQLite Database on IBM i

Hello Sam,

Am 21.01.2020 um 20:57 schrieb Sam_L <lennon_s_j@xxxxxxxxxxx>:

My understanding is that it is full fledged SQL database written in C that keeps all its tables and definitions in a single file in the file system.

Yes and no. SQLite is primarily an API provider (*SRVPGM, in IBM i speak), to "embed" in your own code: There's no separate task or thread running, all will run in your program's memory space.

The original intent was to help Devs to get rid of flat file configuration files which need to be parsed. With time, it was getting bigger and bigger.

I'm not suggesting it could replace DB2/400, but it seems like quite a lot of open source software uses SQLite, including numerous PHP based program.

Top Reason: It's very convenient for users to get started with some PHP-Application: No DBMS to be installed, no need to create user accounts in there and configure passwords. Just point the configuration to a directory with appropriate access rights and you're set. This is the case most often per default parameters. I really wonder how many Sqlite-Database files one can simply download because they're within the Webroot, unprotected…

I have no real-world experience with large amounts data being chewed on by Sqlite. Given it's heritage, I'd say, no problem for small databases. The files on our webserver for Drupal-Based sites are small, between 3..8 MBytes. One exception has 40 MBytes. Two years ago, I tested if there's a measurable difference between sqlite and MySQL serving these few bytes of data. Answer: "Not really".

:wq! PoC

PGP-Key: DDD3 4ABF 6413 38DE - https://www.pocnet.net/poc-key.asc