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

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… Read more →

Write Once, Run Everywhere - Rax SQL Backends

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/… Read more →

What Is Rax?

Rax (Relational Algebra with eXtensions) is a scripting language for behavioral-data exploration. The language is a mix of relational, regular, and temporal algebra and is designed to facilitate the transition from ETL to data modeling. Rax empowers data analysts to explore behavioral data in a way that feels intuitive and… Read more →

Graphics and Plotting in Rax

Rax contains a number of built-in graphical procedures ranging from simple ones, like `line to complete charting procedures, like `scatterplot. The set of simple or primitive graphical procedures is modelled on PostScript: Rax has procedures which manipulate the current graphical state, such as `setrgbcolor,`setlinewidth, `translate/`scale or `gsave/`grestore,… Read more →

Understanding Time

With behavioral data, time plays a very important role. Yet, time-related data is especially hard to analyze. The main culprit is the fact that time concepts are confusing. While humans can handle time intuitively, passing these intuitions to a computer program is hard. For example, implementing a growth rate using… Read more →