R comes to SQL Server

Posted on Posted in Rax, SQL Rants

Database vendors understand that SQL, while great for simple queries, is not a good enough interface for complex analytics. Here at Coders’Co. we would say: use Rax :-). Since R so popular among data scientists, though, many database vendors attempt to somehow integrate R into their technology. This post is the beginning of a series […]

Rax/MySQL vs. Rax/Azure vs. Rax/Redshift

Posted on Posted in Coding, Rax, SQL Rants

Our SQL-backend family is contantly growing. Rax could already connect to SQLite, MySQL and PostgreSQL databases. Now we have also ported Rax to two major cloud databases: Microsoft Azure and AWS Redshift. The port to Azure gave us some headache due to problems with their ODBC driver for Linux. The port to Redshift was straightforward, […]

Write Once, Run Everywhere – Rax SQL Backends

Posted on Posted in Big-Data Blab, Coding, Rax, SQL Rants

Rax is running atop an SQL-based relational database backend, translating data-heavy operations into SQL queries. Actually, there are several SQL backends that Rax can use. Rax syntax and functionality are not dependent on the backend used. In other words, Rax/Redshift can execute exactly the same Rax code as Rax/MySQL and Rax/Azure. The subtle differences between […]

Complexity versus Complexity

Posted on Leave a commentPosted in Rax, SQL Rants

“A simple way of quantifying complexity […] would be to count the number of components and/or interactions within a system.” [Scholarpedia]  By reduction, code complexity could be defined as the count of instructions and their interactions. This does not give a good quantitative measures for complexity. However, whenever I have to explain why SQL is […]

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 […]