SQLite Driver

Your opinion will help to improve our service

Leave a feedback >

Table of Contents

• Features
• More information

Quality: Silver Tier.

🐙 userver provides access to SQLite databases servers via components::SQLite. The uSQLite driver is asynchronous, and with it one can write queries like this: Sample SQLite usage

No macros, no meta-structs, no boilerplate, just your types used directly.

Features

• Asynchronous API based on userver coroutines;
• Automatic connection pooling with smart routing;
• Prepared statements with variadic-template parameter binding;
• Full transaction & savepoint support (RAII);
• Read-only cursors;
• Compile-time-safe composite bindings, runtime-checked primitives;
• Straightforward result extraction into C++ types;
• Bi-directional mapping between C++ and native SQLite types;
• Built-in support for userver types: Decimal64, JSON, boost::uuid;
• Nullable wrappers for all types via std::optional<T>;
• Seamless integration with userver infrastructure: configuration, logging, metrics, etc.

More information

• For configuring see components::SQLite
• For client operations see storages::sqlite::Client
• For C++ <-> SQLite mapping see SQLite supported types
• For typed extraction of statements results into C++ types see storages::sqlite::ResultSet
• For high-level design and implementation details see SQLite driver design and implementation details
• SQLite Docs: https://www.sqlite.org/docs.html

---

Go backYDBUp nextSQLite supported types