{"repo":"centaurialpha/pireal","free":true,"listed":false,"github":"https://github.com/centaurialpha/pireal","clone":"git clone https://github.com/centaurialpha/pireal.git","description":"Relational Algebra Interpreter writting in Python and Qt","language":"Python","stars":33,"topics":["database","python","relational-databases","relational-algebra"],"license":"GPL-3.0","category":"databases-storage","readme_excerpt":"πreal A free and open source Relational Algebra interpreter for learning databases. Pireal lets you create relations, write Relational Algebra queries, and see results instantly, no SQL, no setup, no noise. Built for students and teachers who want to understand how databases actually work under the hood. --- The origin story Pireal was born in 2015 out of necessity. Back then the standard tool for practicing Relational Algebra in university courses was WinRDBI, a Windows-only application. The problem: I've been a Linux user my whole life, and when I took my databases course I simply couldn't use it. Instead of dual-booting into Windows like a normal person, I wrote Pireal. Ten years later it's still here, still cross-platform, and WinRDBI is still Windows-only. --- What is this Most database courses jump straight to SQL and skip the theory entirely. Pireal takes a step back and lets you work directly with Relational Algebra, the mathematical foundation that SQL is built on. Once this clicks, SQL clicks. You write queries like: Hit F5, see the results. That's it. --- Features - All core RA operators: select , project , njoin , union , intersect , difference , product , outer joins - Symbol mode: write σ , π , ⋈ instead of keywords if you're feeling fancy (or your professor insists) - AST viewer: inspect the syntax tree Pireal builds when parsing your query, useful if you're also taking a compilers course - SQL generator: translates any RA query to equivalent SQL so you can com","default_branch":null,"files":null,"tree":[],"storefront":"/r/centaurialpha","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/centaurialpha/pireal/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}