Reading Chris Date's Database in Depth, I started to wonder what it would be like to have relational algebraic operations in Python. This is the first in a series of posts exploring that idea.
I'll start by defining a simple class for relations. In subsequent parts, I'll implement tabular display, the relational algebra and then see where it goes from there.
The goal is not to try to implement a SQL database in pure Python. Rather the goal is to extend Python's rich data structures like dictionaries and sets with additional concepts from relational theory.
It's an exploration for me and you get to come along for the ride (sort of like the Poincare Project which is by no means over yet). Maybe some of you will learn something. I certainly hope you'll teach me a thing or two in the comments and in your emails.
The original post had 4 comments I'm in the process of migrating over.