
Light Header only SQLite Frontend Library for Modern C++
SQLite ORM is the leading C++ library that allows you to easily create data model mappings to your SQLite database schema without code generation, macros, or raw string queries. SQLite ORM is built to manage Create, Read, Update, and Delete (CRUD) objects with and without a primary key. SQLite ORM allows you to specify table names and column names explicitly irrespective of how your classes are named. SQLite ORM provides a fully customisable way of interacting with your SQLite database without any redundant actions or temporary service objects. Only one expression is required per SQL query. SQLite ORM SQLite ORM is designed for use with modern C++14 or later and SQLite3. The product is fully supported on all recent version of Windows, Linux, macOS, iOS, and Android. The only packaging requirement is that SQLite is linked 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
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
$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
$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
$10,000
per project per year **
* Email support is provided the next business day (NBD). Support stops if the subscription is not renewed.
** Minimum 3 years commitment
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