From 1a1c95d967149a4b1f499223e74600bd9f6c7ae8 Mon Sep 17 00:00:00 2001 From: Sangwan Kwon Date: Mon, 9 Mar 2020 10:05:37 +0900 Subject: [PATCH] Update query builder comparison table Signed-off-by: Sangwan Kwon --- src/vist/query-builder/README.md | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) diff --git a/src/vist/query-builder/README.md b/src/vist/query-builder/README.md index a66571e..38051c9 100644 --- a/src/vist/query-builder/README.md +++ b/src/vist/query-builder/README.md @@ -4,14 +4,16 @@ between sql query and sql schema at compile time. | | ViST | [sqlpp11](https://github.com/rbock/sqlpp11) | [sqlite_orm](https://github.com/fnc12/sqlite_orm) | |---|---|---|---| -| **Tpye** | query builder | orm | orm | -| **Query** | type safe | type safe | type safe | +| **Tpye** | orm (virtual table) | orm (real tab) | orm (real tab) | +| **Query Builder Coupling** | loosely | tightly | tightly | +| **Query Type** | type safe | type safe | type safe | | **Language** | c++17 | c++11 ([WIP to c++17](https://github.com/rbock/sqlpp17)) | c++14 | -| **Schema Location** | header file | header file | source file
(This makes hard to expose API.) | +| **Schema Location** | header file | header file | header file | +| **Instance Location** | header file | source file
(This makes hard to expose API.) | source file
(This makes hard to expose API.) | | **Intuition** | simple | complex | simple | | **Usability** | high | low | high | -| **Backend** | sqlite3
(with virtual table) | mysql
sqlite3
(without virtual table)
postgresql
odbc | sqlite3
(without virtual table) | -| **Feature** | basic(crud) | variety | variety | +| **Backend** | sqlite3
| mysql
sqlite3
postgresql
odbc | sqlite3
| +| **Feature** | basic (crud) | variety | variety | # Sample Code ## ours -- 2.34.1