Menu
I'm using a web hosting service on a shared account. They have MySQL, but I need to use SQLite for a Joomla extension called SobiPro. How can I tell if SQLite is installed and working properly on Linux?
845
If you are using Linux or a Mac, open a terminal window instead a command prompt. Open a command prompt (cmd.exe) and 'cd' to the folder location of the SQL_SAFI. sqlite database file. run the command 'sqlite3' This should open the SQLite shell and present a screen similar to that below.
First open the SQLite database from File > Open Database… Now select your SQLite database file and click on Open. Your database should be opened. Now you can click on File > Export and then select either Database to SQL file… or Table(s) as CSV file… or Table(s) to JSON… to export the database to your desired format.
To see if it's opened, check the pointer to see if it's NULL (which you of course must initialize it to, or else it has an unspecified value). After you close it, assign it to NULL again, and there's your "is open" flag. By the way, creating a DatabaseHandle class using RAII is strongly suggested.
SQLite is an embedded database, i.e., it is usually compiled directly into the application that uses it.
In your case, SQLite must be enabled in the PHP configuration. The SobiPro documentation says:
SQLite can be supported directly via the SQLite extension or through the PHP Data Objects extension.
To check PHP extensions, use get_loaded_extensions or something like <?php phpinfo(INFO_MODULES); ?>.
141
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
