Open halojoy opened 7 years ago
Both PostgreSQL and SQLite support is in my roadmap. They're quite popular and work well with PHP.
Basically, the Kernel\Database class should be rewritten to use PDO (yes, AC has nostalgic feelings and still uses mysqli_
methods) to reduce the effort required on the controllers.
MySQL and PostgreSQL are the 2 most used FREE databases.
I saw a test of 7 free databases, where MariaDB was best. It is somewhat faster than big brother MySQL. Now if using MariaDB we can use MySQLi just if it was MySQL running. And of course connect to PDO in same way.
Providing good support for MySQL should also benefit MariaDB, since both share basically the same architecture. But PostgreSQL and SQLite are definitely on my roadmap.
Now I'm investing my time (I mean, what's left of it) in the new Articles feature. I'm trying to create an interesting design, but the back-end code is almost ready. I hope to be able to release this month, and then we can begin to develop these expansions of the database class.
AC supports MySQLi. That is good.
But do you plan to support anything else? On my wishlist is SQLite. Myself I use PDO for connection to MySQL or SQLite.
It is simple to use PDO and I think it is secure. We only have to write separate connections, but the PDO itself is only one script. For all connections.
https://db-engines.com/en/ranking