1. Installer is Finished
2. WordPress DB core conversion finished
Now I am stuck with Role Management and I will finish it hopefully within a day. Last night a funny thing happened. In wordpress installer they check whether a table has been successfully created by invoking “SHOW Tables” command which is not compliant with SQLite. So I start searching how to get information about database scheme. After searching for a while, I finally went thru the code of phpsqliteadmin and found the solution.
Every SQLite database has a table called SQLITE_MASTER which remains hidden. So you can just execute the following command to get all the table names.
“SELECT name FROM SQLITE_MASTER where type=’table'”
Really Cool. !!! I am very much excited abt this project and I am sure – I will release it in friendly way. In WordPress SQLite edition you can use standard wordpress distribution (with modified db core) but you can just configure your config file and add the following line.
driver = ‘sqlite’
I just want to avoid all the hassle for the end user 🙂