A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.
a very cool project they also maintain is a MySQL server framework for arbitrary backends (in Go): https://github.com/dolthub/go-mysql-server
You can define a "virtual" table (schema, how to retrieve rows/columns) and then a MySQL client can connect and execute arbitrary queries on your table (which could just be an API or other source)
Dolt – Git for Data
Learn any GitHub repo in 59 seconds. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev.
SirixDB is an an embeddable, bitemporal, append-only database system and event store, storing immutable lightweight snapshots. It keeps the full history of each resource. Every commit stores a space-efficient snapshot through structural sharing. It is log-structured and never overwrites data. SirixDB uses a novel page-level versioning approach.
Basically my research project I'm working on in my spare time is all about versioning and efficiently storing small sized revisions of the data as well as allowing sophisticated time travel queries for audits and analysis.
Of course all secondary user-defined, typed indexes are also versioned.
Basically the technical idea is to map a huge tree of index tries (with revisions as indexed leave pages at the top-level and a document index as well as secondary indexes on the second level) to an append-only file. To reduce write amplification and to reduce the size of each snapshot data pages are first compressed and second versioned through a sliding snapshot algorithm. Thus, Sirix does not simply do a copy on write per page. Instead it writes nodes, which have been changed in the current revision plus nodes which fall out of the sliding window (therefore it needs a fast random-read drive).
lakeFS - Data version control for your data lake | Git for data
Also in the same vein, check out https://lakefs.io/
Database branching: three-way merge for schema changes
1 project | news.ycombinator.com | 26 Apr 2023
Tell me you suck at SQL without telling me you suck at SQL
1 project | /r/ProgrammerHumor | 16 Feb 2023
1 project | /r/devopspro | 10 Feb 2023
storage of pictures into a database, and referencing them.
1 project | /r/Database | 30 Jan 2023
[Self Promotion] Superset on top of a Version Controlled Database
1 project | /r/apachesuperset | 27 Jan 2023