SQLite 3
SQLite 3 is an open source embedded relational database management system.
There are different technologies you can use to access SQLite 3 from web applications developed with HTML5 Builder:
- The Database component, documented below. Requirements: PHP PDO extension.
- PHP functions, documented here. Requirements: PHP extension.
Contents
Installation
PHP PDO Extension
Enable the extension by uncommenting (removing the ; at the beginning) the following line in PHP’s configuration file (php.ini):
;extension=php_pdo_sqlite.dll→extension=php_pdo_sqlite.dll
- For HTML5 Builder’s internal server, apply the changes to the php.ini.template file.
PHP Extension
Enable the extension by uncommenting (removing the ; at the beginning) the following line in PHP’s configuration file (php.ini):
;extension=php_sqlite3.dll→extension=php_sqlite3.dll
- For HTML5 Builder’s internal server, apply the changes to the php.ini.template file.
ODBC Driver
You will need to download and install the SQLite 3 ODBC driver:
Configuration
To use a Database component with SQLite 3, configure it with the following property values:
- DriverName: sqlite.
Then fill the rest of the mandatory properties as required.
Testing
Sample Database
There are mane 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.