SQLite
Are we sure we want to support it "by default"?
As far as I've seen in the last few months, it's both not very suitable for any kind of forum (unless you have 3 users and you post 5 messages a month) and is quite a security risk (many people don't realise the database can be downloaded by anyone if not properly configured).
I understand it could be useful in some circumstances, but I'm leaning toward considering a nice "add-on" rather then a "core" feature...
Re: SQLite
Reply #1 –
I didn't realise it was that bad!
Re: SQLite
Reply #3 –
I''d bet the number of SMF installations with PostgreSQL or SQLite is < 1%
To be honest, I'd drop both and prepare for PDO instead.
Re: SQLite
Reply #7 –
I have been saying that since Compuart added that garbage in there. Get rid of them both. Why waste time trying to get them to work?
The abstraction helps because there are currently 3 MySQL libraries that people use - mysqli, PDO (on top of mysql), and mysql. If you are going to work on it, add in prepared statements and async queries. They can both be emulated where they aren't available. Prepared statements are almost there. Just take the arguments that get passed to the functions anyway.
Re: SQLite
Reply #8 –
This has been moved "outside", so no more relevant.