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-08-21 10:53:46 UTC (01 14:06:37 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-08-20 10:59:30 UTC (02 14:00:53 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-08-20 10:46:45 UTC (02 14:13:37 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-08-20 10:44:07 UTC (02 14:16:15 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-08-20 10:44:06 UTC (02 14:16:16 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-08-20 10:43:01 UTC (02 14:17:21 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-08-20 10:42:29 UTC (02 14:17:54 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-08-20 10:41:56 UTC (02 14:18:27 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-08-20 10:41:25 UTC (02 14:18:57 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-08-20 10:39:31 UTC (02 14:20:51 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-08-20 10:38:59 UTC (02 14:21:24 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-08-20 10:38:20 UTC (02 14:22:03 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-08-20 10:37:47 UTC (02 14:22:35 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-08-20 10:32:11 UTC (02 14:28:11 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-08-20 10:31:46 UTC (02 14:28:37 days ago)
result	error (update) \| 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-08-20 10:31:09 UTC (02 14:29:14 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-08-20 10:28:28 UTC (02 14:31:54 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-static_O2
timestamp	2025-08-20 10:28:25 UTC (02 14:31:58 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-08-20 10:27:57 UTC (02 14:32:26 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-08-20 10:27:54 UTC (02 14:32:29 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-08-20 10:27:47 UTC (02 14:32:35 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-08-20 10:27:34 UTC (02 14:32:49 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-08-20 10:27:31 UTC (02 14:32:52 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.10-O2
timestamp	2025-08-20 10:27:24 UTC (02 14:32:59 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-08-20 10:27:09 UTC (02 14:33:14 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-08-20 10:27:08 UTC (02 14:33:15 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-gcc_14-static_O3
timestamp	2025-08-20 10:27:04 UTC (02 14:33:19 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-O3
timestamp	2025-08-20 10:26:47 UTC (02 14:33:36 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-gcc_14-ndebug_O3
timestamp	2025-08-20 10:26:38 UTC (02 14:33:45 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-08-20 10:26:34 UTC (02 14:33:49 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-08-20 10:26:18 UTC (02 14:34:05 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-08-20 10:26:17 UTC (02 14:34:06 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
timestamp	2025-08-20 10:25:35 UTC (02 14:34:47 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_12-bindist
timestamp	2025-08-20 10:25:29 UTC (02 14:34:53 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-08-20 10:25:23 UTC (02 14:34:59 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-08-20 10:25:15 UTC (02 14:35:08 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-clang_17_libc++
timestamp	2025-08-20 10:24:27 UTC (02 14:35:56 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-08-20 10:24:08 UTC (02 14:36:15 days ago)
result	error (update) \| log \| rebuild

toolchain	public-0.17.0
target	x86_64-linux-gnu
tgt config	linux_debian_12-gcc_13.1
timestamp	2025-08-20 10:23:45 UTC (02 14:36: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_13
timestamp	2025-08-20 10:22:52 UTC (02 14:37: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-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