benchmarks
toydb
| benchmarks | toydb | |
|---|---|---|
| 1 | 16 | |
| 0 | 5,905 | |
| - | - | |
| 0.0 | 9.2 | |
| almost 3 years ago | 4 days ago | |
| Rust | ||
| Apache License 2.0 | Apache License 2.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.
benchmarks
-
ToyDB: Distributed SQL Database in Rust
+ The result of TB's architectural performance: the untuned write throughput of TB is ~ 2x faster than that of CH in the Rust driver bench, or ~70% faster by using CH own ```clickHouse-client``` command. Use [this parallel script](https://github.com/tensorbase/tools/blob/main/import_csv_to_...) to try it yourself!
3. Thanks to the Arrow-DataFusion, TensorBase has supported good parts of TPC-H. [Untuned TPC-H Q1 result here](https://github.com/tensorbase/benchmarks/blob/main/tpch.md).
4. In simple (no-groupby) aggregation, TensorBase is several times faster than ClickHouse. [Benchmark here](https://github.com/tensorbase/benchmarks/blob/main/quick.md).
5. For complex groupby aggregations, recently we help to boost the speed of the TB engine to the same level of ClickHouse(not released, but coming soon).
6. TB will soon supports MySQl wire protocol, distributed query, adaptive columnar storage optimization... Watch [issues here](https://github.com/tensorbase/tensorbase/issues)
Finally, it is really great to build an AP database in Rust. Welcome to join!
Disclaimer: I am the author of TensorBase.
toydb
-
ToyDB: A Rust learning adventure, fun open-source project, and database learning resource for the community
This is great, but you might want to consider a different name. There's already a Rust project called ToyDB, and it's a distributed database with a Raft log, SQL, disk persistence, ACID transactions, etc. It's under active development (though the developer now works at Cockroach Labs), and has 5K stars on GitHub, so I think they have the right to the name.
- What would you rewrite in Rust?
-
Any ideas for resume
Build something you’d like to learn about. Things I’ve considered replicating: A distributed database (see https://github.com/erikgrinaker/toydb), an interpreter (crafting interpreters is a good book), a Ray tracer (http://raytracerchallenge.com/), an RPC compiler and framework, a simpler neural network framework ( https://github.com/pjreddie/darknet)…
-
Which software do you think would be essential for the RISC-V to be succesful ?
Hilariously, I was trying out ToyDB on the Lichee-RV recently. While it does compile and run the five-node example setup (and memory usage is surprisingly low, which is a plus considering the 0.5GB of RAM), performance is three orders of magnitude lower than on a desktop x86 PC. Some of that is due to just having a single core run 5 nodes, some is due to the lower clock speed and slower memory, and some is due to slower storage (SD card). I don't think that explains everything, so I may investigate that later.
-
Learning Rust You Need a Cognitive Frame
toydb
-
Database Development
Well I think if you could replicate this https://github.com/erikgrinaker/toydb anybody would hire you.
- SimpleDB: A Basic RDBMS Built from Scratch
- Ask HN: What are some good rust code to read to learn the language?
- Distributed SQL database in Rust, written as a learning project
- ToyDB: Distributed SQL Database in Rust
What are some alternatives?
tensorbase - TensorBase is a new big data warehousing with modern efforts.
duckdb - DuckDB is an in-process SQL OLAP Database Management System
sled - the champagne of beta embedded databases
surrealdb - A scalable, distributed, collaborative, document-graph database, for the realtime web
tools
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
gitplay - Learn how a software project (using git) evolved over time from its commit log. Its like YouTube for a git project. Desktop app built with Rust and SolidJS
bustub - The BusTub Relational Database Management System (Educational)
duckdb-rs - Ergonomic bindings to duckdb for Rust
talent-plan - open source training courses about distributed database and distributed systems
barrel - 🛢 A database schema migration builder for Rust