Rax/MySQL vs. Rax/Azure vs. Rax/Redhift

Posted on Leave a commentPosted in Rax

Our SQL-backend family is contantly growing. Rax could already connect to SQLite, MySQL and PostgreSQL databases. Recently we have also ported Rax to two major cloud databases: Microsoft Azure and AWS Redshift. Now we can easily compare the performance of various database systems on behavioral data. Before Rax it was difficult, as each database vendor […]

Sets, Multisets and… SQL

Posted on Leave a commentPosted in SQL Rants

Those of you who paid attention at your ‘Introduction to Databases’ class will probably remember that SQL is based on Relational Algebra. Maybe you also remember that Relational Algebra operates on relations, which are a special category of sets. As such, they do not contain duplicates. An SQL table, however, can easily contain duplicate rows and therefore it’s […]