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
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