top of page
SQLite ORM Logo

SQLite3 Frontend Library with Lightweight Header for C++

SQLite ORM is a top-tier C++ library that enables the effortless creation of data model mappings for your SQLite3 database schema, eliminating the need for code generation, macros, or raw string queries. This library is designed to manage Create, Read, Update, and Delete (CRUD) operations for objects, both with and without primary keys. It also offers the flexibility to define table and column names explicitly, regardless of your class naming conventions. SQLite ORM delivers a highly customizable interaction with your SQLite database, free from superfluous actions or temporary service objects, requiring only a single expression for each SQL query. It is compatible with C++14 or later and SQLite3, and is fully supported on the latest versions of Windows, Linux, macOS, iOS, and Android. The sole packaging prerequisite is linking SQLite3 directly to your binary.

Features

  • No raw string queries

  • Intuitive syntax

  • Comfortable interface - one code line per single query

  • Built with modern C++14 features (no macros and external scripts)

  • Create, Read, Update, and Delete (CRUD) support

  • Pure select query support

  • Prepared statements support

  • UNION, EXCEPT and INTERSECT support

  • STL compatible

  • Custom types binding support

  • BLOB support - maps to std::vector<char> or one can bind your custom type

  • FOREIGN KEY support

  • Composite key support

  • JOIN support

  • Transactions support

  • Migrations functionality

  • Powerful conditions

  • ORDER BY and LIMIT, OFFSET support

  • GROUP BY / DISTINCT support

  • INDEX support

  • Follows single responsibility principle - no need write code inside your data model classes

  • Easy integration - single header only lib.

  • The only dependency - libsqlite3

  • C++ standard code style

  • In memory database support - provide :memory: or empty filename

  • COLLATE support

  • Limits setting/getting support

  • User defined functions support

Editions

SQLite ORM

Free

Use with open source projects


Use with closed source projects


Support via GitHub Issue


Priority email support *


Migrations functionality

Support

1 support ticket per annum

​

License

AGPL

Free

per project per year

SQLite ORM

Standard

Use with open source projects


Use with closed source projects


Support via GitHub Issue


Priority email support *


Migrations functionality

Support

1 support ticket per annum

​

License

MIT

$50

per project per year

SQLite ORM

Plus

Use with open source projects


Use with closed source projects


Support via GitHub Issue


Priority email support *


Migrations functionality

Support

2 support tickets per annum

​

License

MIT

$1,000

per project per year

SQLite ORM Plus

Long Term Support (LTS)

Use with open source projects


Use with closed source projects


Support via GitHub Issue


Priority email support *


Migrations functionality

Support

5 support tickets and 2 hours developer support per annum 

License

MIT

$10,000

per project per year **

Download

* Email support is provided the next business day (NBD). Support stops if the subscription is not renewed.

** Minimum 3 years commitment

Support

Support

Support for SQLite ORM Standard, Plus, and Plus LTS is provided by the team at SQLite ORM. To obtain technical support please email fnc12@me.com. For all licensing and sales support questions please contact us.

SQLite ORM Developer Support Package

Developer support is available on an ad hoc basis. Time can be purchased in advance to obtain one-on-one developer support. A minimum of 2 hours developer support must be purchased in advance. Time is consumed in 30-minute increments. Unused time  is forfeited after 3 months. Support is provided via email ticket, voice, and video.

$240

for two hours

bottom of page