sqllogictest
TDengine
sqllogictest | TDengine | |
---|---|---|
1 | 182 | |
35 | 22,870 | |
- | 0.8% | |
5.7 | 10.0 | |
4 months ago | 4 days ago | |
C | C | |
- | GNU Affero General Public License v3.0 |
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.
sqllogictest
-
Goal: Pass all 4259065 tests in sqllogictest in 1 week
That specific SQLite test suite (one of four [1]) has loads of generated SQL functions, and a long tail of more complex hand-written tests. That 95% of the test suite will be mostly generated queries that follow the same basic pattern of joins and projections with basic arithmetic and comparisons. See for example [2] and [3].
The generated tests are not designed to test a wide breadth of features of the SQL language, and passing them with a simple engine is very doable. A lot of the value of these tests is that the sheer volume of queries tends to find obscure problems in optimizers that would not easily surface otherwise. That is of course not a problem in a simple engine that does not have an optimizer.
[1] https://www.sqlite.org/testing.html#test_harnesses
[2] https://github.com/gregrahn/sqllogictest/blob/master/test/ra...
[3] https://raw.githubusercontent.com/gregrahn/sqllogictest/mast...
TDengine
What are some alternatives?
citus - Distributed PostgreSQL as an extension
InfluxDB - Scalable datastore for metrics, events, and real-time analytics
hytradboi-jam-2022
TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
QuestDB - An open source time-series database for fast ingest and SQL queries
scc - Sloc, Cloc and Code: scc is a very fast accurate code counter with complexity calculations and COCOMO estimates written in pure Go
fpart - Sort files and pack them into partitions
zig - General-purpose programming language and toolchain for maintaining robust, optimal, and reusable software.
bg_mon - Background worker for monitoring PostgreSQL
griddb - GridDB is a next-generation open source database that makes time series IoT and big data fast,and easy.
PipelineDB - High-performance time-series aggregation for PostgreSQL