fdb — my first database

Tiny database for a school project.

How to run?

Download the Rust Language toolchain at https://www.rust-lang.org/tools/install.

Clone the repository and run:

cargo run

If one wants to see logs:

RUST_LOG=<level> cargo run

Where <level> can be trace, debug, info, warn or error.

Dataset for tests

Though this database supports arbitrary user-defined schemas, while being developed, we used the Lichess database for testing purposes. If you also want to use such a dataset for testing purposes, you may download it at https://database.lichess.org. Follow the instructions on how to decompress the archive.

Hence, while not related to the database implementation, this repository also provides a script to parse the unpacked PGN file and ingest it into the database.

References

• CMU Database Systems Course.
• SQLite Database File Format.
• Database Internals: A Deep Dive Into How Distributed Data Systems Work.