Support SQLite

[n1trux]

I'd really like to run this on devices without a "fat" DB daemon, which is where SQLite would be beneficial.

[wernersbacher]

+1, it would make it really quick and easy. SQLite can handle websites with up to millions of request a day. So for a self hosted private service, SQLite should be strong enough.

[jrie]

I agree, it might be nice to have SQLite support - but at the moment, there are several database changes going on and possible coming and adding another database to work with, might be slowing down the development.

When things are more settled this is definitely something to look into.

[n1trux]

at the moment, there are several database changes going on and possible coming and adding another database to work with, might be slowing down the development.

Or you could use an abstraction layer which works with both.

I found Medoo on the lightweight-php list which "supports all SQL databases, including MySQL, MSSQL, SQLite, MariaDB, PostgreSQL, Sybase, Oracle and more".

Changes to the database scheme could be implemented by properly versioning the database (related: #34) and creating migrations. These could easily be written with Medoo if there's a mismatch between installed DB version and upgraded DB version.

[schnoog]

Would prefer to wait for SergeyTsalkov/meekrodb#66 to keep the current wrapper syntax alive.