Lightweight
Lightweight: An open-source C++ library for typed query construction and asynchronous ODBC access. Ranked #23 of 51 in Database Query Builders by our editors (6.7/10); pricing: Free plan; best for C++ teams needing typed async database queries.
At a glance
- Editor score6.7 / 10
- PricingFree plan
- Best forC++ teams needing typed async database queries
- Free planYes
- Paid fromNone
- Type safetyStatic
- Facts checked4 Oct 2026
Where it wins
- Builds typed CRUD queries with joins, filtering, ordering, and pagination
- Async coroutine API offloads blocking ODBC calls to worker threads
- Includes migrations, connection pooling, and a data mapper
Where it doesn't
- Supports only SQL Server, PostgreSQL, and SQLite
- Requires a modern C++ compiler and appropriate ODBC drivers
- Self-hosted library with community and documentation support
Our verdict on Lightweight
Lightweight is an open-source C++23 database library for applications that connect to Microsoft SQL Server, PostgreSQL, or SQLite through ODBC. Its typed query builder composes SELECT, INSERT, UPDATE, and DELETE statements, with joins, filtering, ordering, grouping, and pagination. C++ teams that want database access in their application code, rather than a hosted query service, are its natural audience; it is documented for Windows and Linux.
The query builder is one part of a broader database toolkit. Applications can use raw SQL when builder composition is not a fit, map database rows to C++ records and relationships, and manage versioned schema migrations. Connection pooling is included as well. The async coroutine API offloads blocking ODBC calls to worker threads, which lets teams use an asynchronous interface while working with those drivers. This scope suits projects that want query construction and several database operations in one library, though it is focused on three listed SQL dialects rather than a broad database ecosystem.
Lightweight is self-hosted and open source, so teams integrate the library into their C++ applications and provide the compiler and ODBC drivers it requires. The published support channels are community and documentation. Choose it if static typing, async access, migrations, and pooling align with a C++ application's needs and one of its three supported databases. Teams seeking a managed database service, wider dialect coverage, or vendor-provided support channels beyond community and docs should look elsewhere.
Your product? Our editors can test Lightweight in depth and publish a review, labelled as paid · from $99/mo →
Lightweight pricing
Lightweight fact sheet
| Free plan | Yes |
|---|---|
| Paid from | None |
| Languages | C++ |
| SQL dialects | Microsoft SQL Server, PostgreSQL, SQLite |
| Type safety | Static |
| Async queries | Yes |
| Raw SQL support | Yes |
| Compile without execution | No |
| Deployment | Self-hosted |
| Platforms | Windows, Linux |
| Support | Community, Docs |
| Built for | Solo, Small business, Mid-market, Enterprise (editorial estimate) |
| Pricing | Free plan |
| Website | github.com |
| Facts checked | 4 Oct 2026 |
Alternatives to Lightweight
- jOOQA fluent SQL framework for JVM teams that want generated, type-safe database access.9.3
- SQLAlchemySQL construction, ORM, and database services for Python applications.9.1
- JetBrains ExposedA free, open-source Kotlin library with a type-safe SQL DSL and JDBC and R2DBC access.9.0
See all Lightweight alternatives →
Used Lightweight? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Lightweight for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Lightweight is listed in our Database Query Builders directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/lightweight/"><img src="https://www.itechguides.com/best/badge/lightweight.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. How we rank.
Last updated · How we research and update