SQLite
From RadPHP XE2 Documentation
Contents |
Initial Setup
To get PHP and SQLite working together, download the SQLite ODBC driver:
- For 32-bit systems, you will find the installer at ch-werner.de/sqliteodbc/sqliteodbc.exe.
- For 64-bit systems, you will find the installer at ch-werner.de/sqliteodbc/sqliteodbc_w64.exe.
Once downloaded, run it to install the driver on your system.
Usage
You can connect to an SQLite with ODBC. Click here for information on how to do so.
Testing
Sample Database
There are lots of dabatases available on the Internet you can use to test your SQLite connection. For example, this database.
Tools
These are some tools you might find useful while working with SQLite databases:
- SQLite Database Browser
- You can use this application to browse the content of an SQLite dabatase file.