Ξ Project:M36 Relational Algebra Engine
Software can always be made faster, but rarely can it be made more correct.
Project:M36 implements a relational algebra engine as inspired by the writings of Chris Date.
Unlike most database management systems (DBMS), Project:M36 is opinionated software which adheres strictly to the mathematics of the relational algebra. The purpose of this adherence is to prove that software which implements mathematically-sound design principles reaps benefits in the form of code clarity, consistency, performance, and future-proofing.
Project:M36 can be used as an in-process or remote DBMS.
Project:M36 is written entirely in the Haskell programming language.
Project:M36 supports multiple frontends which target different audiences.
- learn about the relational algebra via TutorialD
- store and manipulate databases
- use Project:M36 as a native Haskell database backend
Project:M36 can be downloaded and run via docker, which supports Windows 10, macOS, and Linux.
docker run projectm36/project-m36 tutd to start the TutorialD command line interface.
- Developer's Blog
- Mailing List/Discussion Group
- IRC Channel: chat.freenode.net #project-m36
- Diogo Biazus' Project:M36 Video Tutorial
- Installation and Introduction to Project:M36
- Introduction to the Relational Algebra
- TutorialD Cheatsheet
- TutorialD via Jupyter Notebook Walkthrough
- TutorialD Tutorial
- 15 Minute Tutorial
- Developer's Change Log
- Simple Client API
- CSV Import/Export
- ACID Database Properties
- On NULL (in SQL)
- Reaching "Out of the Tarpit" with Project:M36
- An Architecture for Data Independence
- Transaction Graph Operators
- ProjectM36.Client Library
- Data Frames for Sorting
- Adding New Data Types
- Database-Manipulating Functions
- Serving Remote ProjectM36 Databases
- Using Notifications
- Merge Transactions
- Atom (Value) Functions
- Trans-Graph Relational Expressions
- Isomorphic Schemas
- Basic Operator Benchmarks
- Merkle Transaction Hashes
Project:M36 is developed in Haskell and compiled with GHC 8.2.2 or later.
- The Third Manifesto: the philosophical basis for relational algebra engines
- Rel: a TutorialD implementation against a BerkeleyDB backend
- Andl: a new database language with SQLite and PostgreSQL backends
- Coddie: a python-based relational algebra interpreter
- Out of the Tarpit: a proposed software architecture which minimizes state and complexity. Project:M36 implements the requirements of this paper.
- Database Design & Relational Theory: Normal Forms and All That Jazz: mathematical foundations for the principles of the relational algebra
- Database Explorations: Essays on the Third Manifesto and Related Topics: additional essays and debates on practical approaches to relational algebra engine design