iterlib
sqlpp11
Our great sponsors
iterlib | sqlpp11 | |
---|---|---|
1 | 3 | |
81 | 2,352 | |
- | - | |
0.0 | 7.8 | |
over 4 years ago | 4 days ago | |
C++ | C++ | |
GNU General Public License v3.0 or later | BSD 2-clause "Simplified" License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
iterlib
-
I don't want to learn your garbage query language
I wrote such a C++ implementation during my days at Facebook around 8 years ago:
https://engineering.fb.com/2016/03/18/data-infrastructure/dr...
There is an example under "Functional programming primitives".
It was a C++ implementation that fell victim to Greenspun's 10th rule. So I wrote a specification for it, first in Clojure and then in python.
The C++ execution engine is open source:
https://github.com/facebookarchive/iterlib/
Main problems writing such code:
* The output of SQL is generally flat. GraphQL makes it nested, but doesn't support all the operators SQL does natively.
sqlpp11
-
What C++ library do you wish existed but hasn’t been created yet?
sqlpp11 actually helps in this area (which imo is the most error prone area of using a database) and offers compile time query checking
-
Using CPP with SQL
I haven't used this, though I did see some presentations about it which got my interest: https://github.com/rbock/sqlpp11
-
I don't want to learn your garbage query language
If you love C++ Template magic look at https://github.com/rbock/sqlpp11
This allows "normal" C++ code, which by the compiler is converted into the query string, allowing code like
for (const auto& row : db(select(all_of(foo)).from(foo).where(foo.hasFun or foo.name == "joker")))
What are some alternatives?
SqlKata Query Builder - SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
pggen - Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.
honeysql - Turn Clojure data structures into SQL
kiss-orm - An extremely simple and explicit ORM for TypeScript
libsqldb - Wrapper to different SQL backends
sqlx - general purpose extensions to golang's database/sql
mysql - MySQL C++ client based on Boost.Asio
cheap - C++ HTML Element Apparator