PHPackages                             bootpress/sqlite - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. bootpress/sqlite

ActiveLibrary[Database & ORM](/categories/database)

bootpress/sqlite
================

Extends the BootPress Database Component to create and update tables and indexes at will, and simplifies FTS full-text searching.

v1.0(9y ago)21.2k↑2900%2[1 PRs](https://github.com/Kylob/SQLite/pulls)3MITPHPPHP >=5.4

Since Sep 26Pushed 7y ago1 watchersCompare

[ Source](https://github.com/Kylob/SQLite)[ Packagist](https://packagist.org/packages/bootpress/sqlite)[ Docs](https://www.bootpress.org/components/sqlite/)[ RSS](/packages/bootpress-sqlite/feed)WikiDiscussions master Synced 2mo ago

READMEChangelog (1)Dependencies (6)Versions (2)Used By (3)

use BootPress\\SQLite\\Component as Sqlite;
===========================================

[](#use-bootpresssqlitecomponent-as-sqlite)

[![Packagist](https://camo.githubusercontent.com/b983d6cf7aa0ebebdacea3568f07d5634ed2efc54f65a2573fb3e585408f5ce5/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f626f6f7470726573732f73716c6974652e7376673f7374796c653d666c61742d737175617265266c6162656c3d5061636b6167697374)](https://packagist.org/packages/bootpress/sqlite)[![License MIT](https://camo.githubusercontent.com/a7e65aee57b11d28e4caff8b945729a66be0bb663f7f93bd24c5aa65699f148e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4c6963656e73652d4d49542d626c75652e7376673f7374796c653d666c61742d737175617265)](LICENSE.md)[![HHVM Tested](https://camo.githubusercontent.com/3422fab0fbdb2e50d74ced25d6df3e7e1be8b373f48c708a785f247a503409d1/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4848564d2d5465737465642d3838393262662e7376673f7374796c653d666c61742d737175617265)](https://travis-ci.org/Kylob/SQLite)[![PHP 7 Supported](https://camo.githubusercontent.com/7dae9186d16bac6b5d5cee34d3bec4400516657b575bc1c784125d70a6871126/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f504850253230372d537570706f727465642d3838393262662e7376673f7374796c653d666c61742d737175617265)](https://travis-ci.org/Kylob/SQLite)[![Build Status](https://camo.githubusercontent.com/cf8b999e136db4751324d1a84ecd6987dfa8cf72bfc59f66040313d4de6ae526/68747470733a2f2f696d672e736869656c64732e696f2f7472617669732f4b796c6f622f53514c6974652f6d61737465722e7376673f7374796c653d666c61742d737175617265)](https://travis-ci.org/Kylob/SQLite)[![Code Climate](https://camo.githubusercontent.com/8fc847a46a599f0d1c429442cb3985f2fc37b36e7885e78a8749a1074438c479/68747470733a2f2f696d672e736869656c64732e696f2f636f6465636c696d6174652f6769746875622f4b796c6f622f53514c6974652e7376673f7374796c653d666c61742d737175617265)](https://codeclimate.com/github/Kylob/SQLite)[![Test Coverage](https://camo.githubusercontent.com/e1982eaad314f3b47ad269d16fdd250e280dc62d72b64f628648d15498416614/68747470733a2f2f696d672e736869656c64732e696f2f636f6465636c696d6174652f636f7665726167652f6769746875622f4b796c6f622f53514c6974652e7376673f7374796c653d666c61742d737175617265)](https://codeclimate.com/github/Kylob/SQLite/coverage)

Extends the BootPress\\Database\\Component to easily create and update SQLite database tables and indexes at will. It overrides the underlying PDO wrappers of the Database Component to use the PHP SQLite3 class. The main reason is so that you can free the file from it's cold dead hands when you `$db->connection()->close()`. The only side effect of that is you can't fetch 'obj' or 'named' rows. Otherwise, we are just adding more functionality here. It also facilitates FTS full-text searching.

Installation
------------

[](#installation)

Add the following to your `composer.json` file.

```
{
    "require": {
        "bootpress/sqlite": "^1.0"
    }
}
```

Example Usage
-------------

[](#example-usage)

```