libsqlite_orm/1.8.1+1

SQLite ORM light header only library for modern C++

SQLite ORM

SQLite ORM light header only library for modern C++. Please read the license precisely. The project has AGPL license for open source project and MIT license after purchasing it for 50$ (using PayPal or any different way (contact using email fnc12@me.com)).

Status

Branch	Travis	Appveyor
`master`
`dev`

Advantages

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

... More

version	1.8.1+1
license	AGPL-3.0-only
repository	https://pkg.cppget.org/1/stable
download	libsqlite_orm-1.8.1+1.tar.gz
sha256	8977f95ac7a8d6912ea91204afdea2a754097d61bc805b35db703a32e60b0369

project	sqlite_orm
url	sqliteorm.com/
doc-url	sqliteorm.com/docs
src-url	github.com/fnc12/sqlite_orm
package-url	github.com/build2-packaging/sqlite_orm
package-email	packaging@build2.orgMailing list
topics	C++SQLite

Depends (1)

	libsqlite3 ^3.0.0

Requires (1)

	c++14

Tests

	libsqlite_orm-tests

Reviews

fail	0
pass	1

Builds

toolchain	public-0.17.0
target	x86_64-microsoft-win32-msvc14.3
tgt config	windows_10-msvc_17.10
timestamp	2025-09-23 12:41:42 UTC (01 07:09:36 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_ubuntu_24.04-gcc_13-bindist
timestamp	2025-09-22 12:12:50 UTC (02 07:38:28 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-clang_18-O3
timestamp	2025-09-22 11:28:15 UTC (02 08:23:03 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-clang_18_libc++-O3
timestamp	2025-09-22 11:26:53 UTC (02 08:24:25 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-clang_18_libc++-static_O3
timestamp	2025-09-22 11:23:02 UTC (02 08:28:16 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-clang_18-static_O3
timestamp	2025-09-22 11:21:57 UTC (02 08:29:21 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-clang_18_libc++
timestamp	2025-09-22 11:20:51 UTC (02 08:30:28 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-clang_18
timestamp	2025-09-22 11:19:09 UTC (02 08:32:09 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-gcc_14-ndebug_O3
timestamp	2025-09-22 11:11:45 UTC (02 08:39:33 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_fedora_40-gcc_14-bindist
timestamp	2025-09-22 11:11:41 UTC (02 08:39:38 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-gcc_14-O3
timestamp	2025-09-22 11:09:29 UTC (02 08:41:49 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-gcc_14-static_O3
timestamp	2025-09-22 11:07:25 UTC (02 08:43:53 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-gcc_14
timestamp	2025-09-22 11:05:15 UTC (02 08:46:03 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-microsoft-win32-msvc14.3
tgt config	windows_10-clang_18_llvm_msvc_17.10-static_O2
timestamp	2025-09-22 10:43:57 UTC (02 09:07:21 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-microsoft-win32-msvc14.3
tgt config	windows_10-clang_18_llvm_msvc_17.10-O2
timestamp	2025-09-22 10:39:43 UTC (02 09:11:35 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-gcc_14-O3
timestamp	2025-09-22 10:38:57 UTC (02 09:12:21 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-microsoft-win32-msvc14.3
tgt config	windows_10-clang_18_llvm_msvc_17.10
timestamp	2025-09-22 10:38:07 UTC (02 09:13:12 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-w64-mingw32
tgt config	windows_10-gcc_13.2_mingw_w64-static_O2
timestamp	2025-09-22 10:35:02 UTC (02 09:16:17 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-gcc_14-ndebug_O3
timestamp	2025-09-22 10:34:47 UTC (02 09:16:31 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-gcc_14-static_O3
timestamp	2025-09-22 10:34:26 UTC (02 09:16:52 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-microsoft-win32-msvc14.3
tgt config	windows_10-msvc_17.10-static_O2
timestamp	2025-09-22 10:34:03 UTC (02 09:17:15 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-w64-mingw32
tgt config	windows_10-gcc_13.2_mingw_w64-O2
timestamp	2025-09-22 10:33:23 UTC (02 09:17:56 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-microsoft-win32-msvc14.3
tgt config	windows_10-msvc_17.10-O2
timestamp	2025-09-22 10:32:51 UTC (02 09:18:27 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-gcc_14
timestamp	2025-09-22 10:32:28 UTC (02 09:18:50 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-w64-mingw32
tgt config	windows_10-gcc_13.2_mingw_w64
timestamp	2025-09-22 10:32:11 UTC (02 09:19:07 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-clang_17_libc++
timestamp	2025-09-22 10:32:10 UTC (02 09:19:08 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-microsoft-win32-msvc14.3
tgt config	windows_10-msvc_17.8-O2
timestamp	2025-09-22 10:32:00 UTC (02 09:19:18 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-clang_17
timestamp	2025-09-22 10:31:30 UTC (02 09:19:48 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-microsoft-win32-msvc14.3
tgt config	windows_10-msvc_17.8-static_O2
timestamp	2025-09-22 10:30:52 UTC (02 09:20:26 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-microsoft-win32-msvc14.3
tgt config	windows_10-clang_17_msvc_msvc_17.10
timestamp	2025-09-22 10:30:26 UTC (02 09:20:53 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-freebsd14.1
tgt config	freebsd_14-clang_18-O3
timestamp	2025-09-22 10:28:42 UTC (02 09:22:36 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-gcc_12-bindist
timestamp	2025-09-22 10:28:21 UTC (02 09:22:57 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-freebsd14.1
tgt config	freebsd_14-clang_18
timestamp	2025-09-22 10:27:44 UTC (02 09:23:34 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-microsoft-win32-msvc14.3
tgt config	windows_10-msvc_17.8
timestamp	2025-09-22 10:27:44 UTC (02 09:23:34 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-freebsd13.3
tgt config	freebsd_13-clang_17
timestamp	2025-09-22 10:27:03 UTC (02 09:24:15 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-freebsd14.1
tgt config	freebsd_14-clang_18-static_O3
timestamp	2025-09-22 10:26:59 UTC (02 09:24:19 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	aarch64-linux-gnu
tgt config	linux_debian_12-gcc_13
timestamp	2025-09-22 10:26:59 UTC (02 09:24:20 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-clang_17_libc++
timestamp	2025-09-22 10:25:32 UTC (02 09:25:46 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-gcc_13.1
timestamp	2025-09-22 10:25:10 UTC (02 09:26:08 days ago)
result	warning (update) \| error (test) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-clang_17
timestamp	2025-09-22 10:24:47 UTC (02 09:26:31 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-clang_18
result	unbuilt

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-clang_18-O3
result	unbuilt

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-clang_18-static_O3
result	unbuilt

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-clang_18_libc++
result	unbuilt

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-clang_18_libc++-O3
result	unbuilt

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-clang_18_libc++-static_O3
result	unbuilt

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_fedora_39-gcc_13-bindist
result	unbuilt

toolchain	public-0.17.0
target	x86_64-apple-darwin22.5.0
tgt config	macos_13-clang_15.0
result	unbuilt

toolchain	public-0.17.0
target	x86_64-apple-darwin23.5.0
tgt config	macos_14-clang_15.0
result	unbuilt

toolchain	public-0.17.0
target	x86_64-apple-darwin23.5.0
tgt config	macos_14-clang_15.0-O3
result	unbuilt

toolchain	public-0.17.0
target	x86_64-apple-darwin23.5.0
tgt config	macos_14-clang_15.0-static_O3
result	unbuilt

toolchain	public-0.17.0
target	x86_64-apple-darwin23.5.0
tgt config	macos_14-gcc_14_homebrew
result	unbuilt

toolchain	public-0.17.0
target	x86_64-apple-darwin23.5.0
tgt config	macos_14-gcc_14_homebrew-O3
result	unbuilt

toolchain	public-0.17.0
target	x86_64-apple-darwin23.5.0
tgt config	macos_14-gcc_14_homebrew-static_O3
result	unbuilt