PHPackages                             yiisoft/db-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. [Framework](/categories/framework)
4. /
5. yiisoft/db-sqlite

ActiveLibrary[Framework](/categories/framework)

yiisoft/db-sqlite
=================

SQLite driver for Yii Database

2.0.0(5mo ago)30173.4k↓41.9%11[4 issues](https://github.com/yiisoft/db-sqlite/issues)[2 PRs](https://github.com/yiisoft/db-sqlite/pulls)9BSD-3-ClausePHPPHP 8.1 - 8.5CI passing

Since Feb 10Pushed 2mo ago14 watchersCompare

[ Source](https://github.com/yiisoft/db-sqlite)[ Packagist](https://packagist.org/packages/yiisoft/db-sqlite)[ Docs](https://www.yiiframework.com/)[ GitHub Sponsors](https://github.com/sponsors/yiisoft)[ OpenCollective](https://opencollective.com/yiisoft)[ RSS](/packages/yiisoft-db-sqlite/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (5)Dependencies (11)Versions (11)Used By (9)

 [ ![Yii](https://camo.githubusercontent.com/8317c17418b39410a660f5149071d26c5023c0d5fb2b7ebb771324812f666d73/68747470733a2f2f796969736f66742e6769746875622e696f2f646f63732f696d616765732f7969695f6c6f676f2e737667) ](https://github.com/yiisoft) [ ![SQLite](https://camo.githubusercontent.com/93efb4668089176a290bd8d19172d52db625943cc50eddd0bcfd4046d385045a/68747470733a2f2f75706c6f61642e77696b696d656469612e6f72672f77696b6970656469612f636f6d6d6f6e732f332f33382f53514c6974653337302e737667) ](https://www.sqlite.org/)

Yii Database SQLite Driver
==========================

[](#yii-database-sqlite-driver)

[![Latest Stable Version](https://camo.githubusercontent.com/90b92c0e91a7a23a57b090816bda56ed6ae40cfc770de82b6fe11fc06dd53659/68747470733a2f2f706f7365722e707567782e6f72672f796969736f66742f64622d73716c6974652f76)](https://packagist.org/packages/yiisoft/db-sqlite)[![Total Downloads](https://camo.githubusercontent.com/6f52b722715fb5140e2f11304ad76cc41df651e65e2431d52f69076adf14567f/68747470733a2f2f706f7365722e707567782e6f72672f796969736f66742f64622d73716c6974652f646f776e6c6f616473)](https://packagist.org/packages/yiisoft/db-sqlite)[![Build status](https://github.com/yiisoft/db-sqlite/actions/workflows/build.yml/badge.svg?branch=master)](https://github.com/yiisoft/db-sqlite/actions/workflows/build.yml?query=branch%3Amaster)[![Code Coverage](https://camo.githubusercontent.com/ec65b9a955ed79034abb34ed7df10c0618fa3a8fc57cd499e16e0f070708d185/68747470733a2f2f636f6465636f762e696f2f67682f796969736f66742f64622d73716c6974652f6272616e63682f6d61737465722f67726170682f62616467652e737667)](https://codecov.io/gh/yiisoft/db-sqlite)[![Mutation testing badge](https://camo.githubusercontent.com/b7d31fa7db8e52d2a114953e76a93aae636fdc243781410567dae82b73cebaf4/68747470733a2f2f696d672e736869656c64732e696f2f656e64706f696e743f7374796c653d666c61742675726c3d687474707325334125324625324662616467652d6170692e737472796b65722d6d757461746f722e696f2532466769746875622e636f6d253246796969736f667425324664622d73716c6974652532466d6173746572)](https://dashboard.stryker-mutator.io/reports/github.com/yiisoft/db-sqlite/master)[![Static analysis](https://github.com/yiisoft/db-sqlite/actions/workflows/static.yml/badge.svg?branch=master)](https://github.com/yiisoft/db-sqlite/actions/workflows/static.yml?query=branch%3Amaster)[![type-coverage](https://camo.githubusercontent.com/5abd29fbb85faf1399054427e1276911e2a1ec2fd17b9e8dc6b7da1af2e3460c/68747470733a2f2f73686570686572642e6465762f6769746875622f796969736f66742f64622d73716c6974652f636f7665726167652e737667)](https://shepherd.dev/github/yiisoft/db-sqlite)[![psalm-level](https://camo.githubusercontent.com/1990ec66f9d7d9e4387f59a805dad3355d228367e629a16ba6d05c8c7e86e755/68747470733a2f2f73686570686572642e6465762f6769746875622f796969736f66742f64622d73716c6974652f6c6576656c2e737667)](https://shepherd.dev/github/yiisoft/db-sqlite)

SQLite driver for [Yii Database](https://github.com/yiisoft/db) is a package for working with [SQLite](https://www.sqlite.org/) databases in PHP. It includes a database connection class, a command builder class, and a set of classes for representing database tables and rows as PHP objects.

Driver supports SQLite 3 or higher.

Requirements
------------

[](#requirements)

- PHP 8.1 - 8.5.
- `pdo_sqlite` PHP extension.
- `mbstring` PHP extension.

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

[](#installation)

The package could be installed with [Composer](https://getcomposer.org):

```
composer require yiisoft/db-sqlite
```

Important

See also [installation notes](https://github.com/yiisoft/db/?tab=readme-ov-file#installation) for `yiisoft/db`package.

Documentation
-------------

[](#documentation)

For config connection to SQLite database check [Connecting SQLite](https://github.com/yiisoft/db/blob/master/docs/guide/en/connection/sqlite.md).

Check the `yiisoft/db` [docs](https://github.com/yiisoft/db/blob/master/docs/guide/en/README.md) to learn about usage.

- [Internals](docs/internals.md)

If you need help or have a question, the [Yii Forum](https://forum.yiiframework.com/c/yii-3-0/63) is a good place for that. You may also check out other [Yii Community Resources](https://www.yiiframework.com/community).

License
-------

[](#license)

The Yii Database SQLite Driver is free software. It is released under the terms of the BSD License. Please see [`LICENSE`](./LICENSE.md) for more information.

Maintained by [Yii Software](https://www.yiiframework.com/).

Support the project
-------------------

[](#support-the-project)

[![Open Collective](https://camo.githubusercontent.com/a2b15f8e2268d4e3842e00d41ff7a57cce2ad8bd8d8769c5dc4fa05a546a4f62/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4f70656e253230436f6c6c6563746976652d73706f6e736f722d3765616466313f6c6f676f3d6f70656e253230636f6c6c656374697665266c6f676f436f6c6f723d376561646631266c6162656c436f6c6f723d353535353535)](https://opencollective.com/yiisoft)

Follow updates
--------------

[](#follow-updates)

[![Official website](https://camo.githubusercontent.com/d6b0929173e28cc627430d2519ca1853466a70f37395877eaf4820cb3e1e1909/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f506f77657265645f62792d5969695f4672616d65776f726b2d677265656e2e7376673f7374796c653d666c6174)](https://www.yiiframework.com/)[![Twitter](https://camo.githubusercontent.com/d077c362ac639792171af8bc002ee827816733dfc0925f70b557e6d151022226/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f747769747465722d666f6c6c6f772d3144413146323f6c6f676f3d74776974746572266c6f676f436f6c6f723d314441314632266c6162656c436f6c6f723d3535353535353f7374796c653d666c6174)](https://twitter.com/yiiframework)[![Telegram](https://camo.githubusercontent.com/4e38dd12535575c39c65bea7119b95e663abb2d1f4e3d669a27bbda07ef603f0/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f74656c656772616d2d6a6f696e2d3144413146323f7374796c653d666c6174266c6f676f3d74656c656772616d)](https://t.me/yii3en)[![Facebook](https://camo.githubusercontent.com/48204e301b34b29b0815854544f04c337fc0692096cab35e9a1f8c53a42c2307/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f66616365626f6f6b2d6a6f696e2d3144413146323f7374796c653d666c6174266c6f676f3d66616365626f6f6b266c6f676f436f6c6f723d666666666666)](https://www.facebook.com/groups/yiitalk)[![Slack](https://camo.githubusercontent.com/1a3645ba1c97e6684d0349bc478201e1621ba0d3efad516d81035364d442bad7/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f736c61636b2d6a6f696e2d3144413146323f7374796c653d666c6174266c6f676f3d736c61636b)](https://yiiframework.com/go/slack)

###  Health Score

60

—

FairBetter than 99% of packages

Maintenance75

Regular maintenance activity

Popularity45

Moderate usage in the ecosystem

Community36

Small or concentrated contributor base

Maturity73

Established project with proven stability

 Bus Factor2

2 contributors hold 50%+ of commits

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~242 days

Total

5

Last Release

164d ago

Major Versions

1.2.0 → 2.0.02025-12-05

PHP version history (2 changes)1.0.0PHP ^8.0

2.0.0PHP 8.1 - 8.5

### Community

Maintainers

![](https://www.gravatar.com/avatar/261a6249c6f605f3956a2fae40fbb813f6b2e1e6f2bf806180c851a965426e54?d=identicon)[cebe](/maintainers/cebe)

![](https://www.gravatar.com/avatar/fc29e4e7068a00fe9b9db37b8aadda1db6020adcacef810461e47b99c2b150e6?d=identicon)[samdark](/maintainers/samdark)

![](https://www.gravatar.com/avatar/ccb75e3312d6bd454ea445ea308139fd185a4ca906ca5df21cc66e6a35de25a3?d=identicon)[SilverFire](/maintainers/SilverFire)

![](https://www.gravatar.com/avatar/99106256c24a8cb23871b99fa90e48f37f1aa71608c185759b7d2a88683a5918?d=identicon)[hiqsol](/maintainers/hiqsol)

---

Top Contributors

[![terabytesoftw](https://avatars.githubusercontent.com/u/42547589?v=4)](https://github.com/terabytesoftw "terabytesoftw (151 commits)")[![Tigrov](https://avatars.githubusercontent.com/u/8563175?v=4)](https://github.com/Tigrov "Tigrov (93 commits)")[![darkdef](https://avatars.githubusercontent.com/u/8342004?v=4)](https://github.com/darkdef "darkdef (66 commits)")[![vjik](https://avatars.githubusercontent.com/u/525501?v=4)](https://github.com/vjik "vjik (51 commits)")[![samdark](https://avatars.githubusercontent.com/u/47294?v=4)](https://github.com/samdark "samdark (49 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (8 commits)")[![devanych](https://avatars.githubusercontent.com/u/20116244?v=4)](https://github.com/devanych "devanych (6 commits)")[![StyleCIBot](https://avatars.githubusercontent.com/u/11048387?v=4)](https://github.com/StyleCIBot "StyleCIBot (6 commits)")[![xepozz](https://avatars.githubusercontent.com/u/6815714?v=4)](https://github.com/xepozz "xepozz (4 commits)")[![dependabot-preview[bot]](https://avatars.githubusercontent.com/in/2141?v=4)](https://github.com/dependabot-preview[bot] "dependabot-preview[bot] (4 commits)")[![luizcmarin](https://avatars.githubusercontent.com/u/67489841?v=4)](https://github.com/luizcmarin "luizcmarin (4 commits)")[![rustamwin](https://avatars.githubusercontent.com/u/16498265?v=4)](https://github.com/rustamwin "rustamwin (2 commits)")[![mspirkov](https://avatars.githubusercontent.com/u/63721828?v=4)](https://github.com/mspirkov "mspirkov (2 commits)")[![roxblnfk](https://avatars.githubusercontent.com/u/4152481?v=4)](https://github.com/roxblnfk "roxblnfk (1 commits)")[![viktorprogger](https://avatars.githubusercontent.com/u/7670669?v=4)](https://github.com/viktorprogger "viktorprogger (1 commits)")[![mapeveri](https://avatars.githubusercontent.com/u/6276555?v=4)](https://github.com/mapeveri "mapeveri (1 commits)")[![DikoIbragimov](https://avatars.githubusercontent.com/u/167644693?v=4)](https://github.com/DikoIbragimov "DikoIbragimov (1 commits)")

---

Tags

databasedbalquery-buildersqlsqliteyii3databasesqlitedbalsqlyiiquery builder

###  Code Quality

TestsPHPUnit

Static AnalysisRector

Code StylePHP CS Fixer

### Embed Badge

![Health badge](/badges/yiisoft-db-sqlite/health.svg)

```
[![Health](https://phpackages.com/badges/yiisoft-db-sqlite/health.svg)](https://phpackages.com/packages/yiisoft-db-sqlite)
```

###  Alternatives

[doctrine/dbal

Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management.

9.7k578.4M5.6k](/packages/doctrine-dbal)[yiisoft/db

Database abstraction layer and query builder

187468.4k30](/packages/yiisoft-db)[yiisoft/db-mysql

MySQL/MariaDB driver for Yii Database

42169.1k17](/packages/yiisoft-db-mysql)[yiisoft/db-pgsql

PostgreSQL driver for Yii Database

39164.6k6](/packages/yiisoft-db-pgsql)[yiisoft/db-oracle

Oracle driver for Yii Database

3361.3k3](/packages/yiisoft-db-oracle)[yiisoft/db-mssql

Microsoft SQL Server driver for Yii Database

2877.0k3](/packages/yiisoft-db-mssql)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)
