As for the popularity of SQLite the main reasons are 1) it is a c based embedded database 2) it is under the BSD license and 3) it has a small footprint. Those reasons makes it a good solution for storage limited devices (mobiles phones, tablets etc). it is not its technical superiority over (firebird for example) other databases that it was chosen.
It is not under any license. see: https://sqlite.org/copyright.html It is copyright protected, though. It is public domain in the strictest sense of public domain. (Which differs from free software, that includes licensed software)
Because of the copyright protection the only limitation is that you can not claim to have written it.
Does not change the reasoning it only makes it even easier to use but you are right.
It is technically superior to firebird. That's a fact, not an opinion. Although I hate firebird, for the record.
Any proof to support your claim? Which feature are technically superior to firebird? As far as I know it has no concurrent access, limited SQL support (views become available the past year or two if I recall correctly), data types are non existent, they are considered requests not data types (try creating a field with data type thaddy and see for your self) numeric checks follow the string convention more than the numeric one and a number of other falsities which make it a bad choice for any mid to big data sized application.
And fpindexer contains a full text search engine, but it is an indexer.
A full text search engine is an indexer for text it does not make it a database the same way a index of a paradox table is not the database.
But feel free to use FF. I did so for years. In my opinion it is a bad idea to recommend it, though, for the reasons I mentioned before.
- Not mainstream
true then again very few database are mainstream and most of them you have no access to their code.
- Not maintained
Not yet. But its the only one that (if code properly) can go everywhere fpc goes with out the need a C/C++ compiler.
- Can you access your data in 20 years time?
well as long as I have the code the answer is yes. Can you say the same for Oracle? MSSQL? those are as mainstream as they come.