Exposes SQLite APIs that are otherwise not available in PHP
Exposes SQLite APIs that are otherwise not available in PHP. You can connect
to an SQLite database as you normally would using PHP's
PDO extension, then
use this library to call SQLite API methods that
PDO does not offer (e.g.
Warning: under the hood, this library makes use of Z-Engine, which proclaims itself not ready for production until version 1.0.0. Use it at your own risk.
This library requires PHP version 7.4 or higher with the FFI extension enabled. It only works with x64 non-thread-safe builds of PHP.
Install as a dependency using composer:
$ composer require moxio/sqlite-extended-api
If you have an existing
PDO connection to an SQLite database, you can use the
wrapPDO() static method on the
Facade class to obtain access to extra SQLite
<?php use Moxio\SQLiteExtendedAPI\Facade; // Existing PDO connection $pdo = new \PDO('sqlite::memory:'); // Wrap it using this library $wrapped_connection = Facade::wrapPDO($pdo); // Call extended APIs on the wrapped connection object $wrapped_connection->loadExtension('mod_spatialite.so');
See the next section for methods available on the wrapped connection.
Below is a short overview; see
Load additional SQLite extension libraries using
This corresponds to the
method in PHP's SQLite3 extension, or [
sqlite3_load_extension](https://sqlite.org/c3ref/load_extension.html) in the SQLite C interface. Returns true` if the extension was successfully loaded,
false if it was not.
To obtain the full disk path of the database connected to, use
For an in-memory database, this returns an empty string.
In short: we use the awesome Z-Engine project by Alexander Lisachenko and PHP's Foreign Function Interface (FFI) to resolve your PHP variable to the raw connection pointer for the SQLite C API, then call that C API using FFI.
More details can be found in this blog post.
This project adheres to Semantic Versioning.
Contributions to this project are more than welcome. If there are other SQLite APIs that you would like to be able to use in PHP, feel free to send a PR or to file a feature request.
This project is released under the MIT license.
This package is Treeware. If you use it in production, then we'd appreciate it if you buy the world a tree to thank us for our work. By contributing to the Treeware forest you'll be creating employment for local families and restoring wildlife habitats.