Skip to content
プロジェクト

rbock/sqlpp23 has 183 GitHub stars and 21 forks. GitHot measured 0 stars in 24 hours and 0 in 7 days. Last checked 2026-11-21 10:51 UTC. Last push 2026-10-29.

この数値の測り方

計測したスター増加

24時間
0
7日間
0
15日間
履歴を収集中
1か月
履歴を収集中

期間ごとの純増数です。期間は重複しており、日別の値ではありません。未計測の値は空欄です。スター数は注目度の指標であり、品質の保証ではありません。

概要

A type safe SQL library for C++

データ

sqlpp23

sqlpp23 is a type-safe embedded domain specific language for SQL queries and results in C++. It allows you to write SQL in the form of C++ expressions:

  • Tables, columns, result fields are represented as structs or data members
  • Statements and clauses are constructed by functions
  • Your IDE can help you write SQL in C++
  • Your compiler will find a lot of typical mistakes long before they hit integration tests or even production, e.g.
    • typos
    • comparing apples to oranges
    • a missing table in from()
    • missing a non-default column in insert_into()
    • selecting a mix of aggregates and non-aggregates
    • differences in SQL dialects from one database backend to the next, see below

sqlpp23’s core is vendor-neutral.

Specific traits of databases (e.g. unsupported or non-standard features) are handled by connector libraries. Connector libraries can inform you and your IDE of missing features at compile time. They also interpret expressions specifically where needed. For example, the connector could use the operator|| or the concat method for string concatenation without your being required to change the statement.

Connectors for MariaDB, MySQL, PostgreSQL, sqlite3, sqlcipher are included in this repository.

Documentation is found in docs.

If you are coming from sqlpp11, you might be interested in differences.

Examples:

Let's assume we have a database connection object db and a table object foo representing something like

CREATE TABLE foo (
    id bigint NOT NULL,
    name varchar(50),
    hasFun bool NOT NULL
);

insert

db(insert_into(foo).set(foo.id = 17, foo.name = "bar", foo.hasFun = true));

update

db(update(foo).set(foo.name = std::nullopt).where(foo.name != "nobody"));

delete

db(delete_from(foo).where(not foo.hasFun));

select

// selecting zero or more results, iterating over the results
for (const auto& row : db(select(foo.id, foo.name, foo.hasFun)
                          .from(foo)
                          .where(foo.id > 17 and foo.name.like("%bar%"))))
{
  std::cout << row.id << '\n';                    // int64_t
  std::cout << row.name.value_or("NULL") << '\n'; // std::optional<std::string_view>
  std::cout << row.hasFun() << '\n';              // bool
}

database specific

  for (const auto &row : db(sql::insert_into(foo)
                                .set(foo.id = 7, foo.name = std::nullopt, foo.hasFun = false)
                                .on_conflict(foo.id)
                                .do_update(foo.name = "updated")
                                .where(foo.id > 17)
                                .returning(foo.name))) {
    std::cout << row.name.value_or("NULL") << '\n';
  }

Requirements:

Compiler: sqlpp23 makes use of C++23 and requires a recent compiler and standard library.

If you use the library without modules, the following compiler versions are known to be sufficient:

  • clang: 20.1 (both libstdc++ and libc++ work)
  • gcc: 14.2
  • MSVC: 19.44.35219

For modules, please check out /docs/modules.md.

License:

sqlpp23 is distributed under the BSD 2-Clause License.

Status:

Build status

Getting involved:

Feature requests, bug reports, contributions to code or documentation are most welcome.

関連プロジェクトを探す

読み込み中…