Hello world! We are very pleased to announce yet another Rax integration: Rax on Google’s BigQuery. BigQuery is the fourth large-scale, in-the-cloud database supported by Rax, next to Amazon’s Redshift, Snowflake and Azure’s SQL Database. The biggest advantage of this new integration is that now it’s possible to use Rax to process Google Analytics 360 data directly where it lives …
THE RISE OF PROGRAMMATIC BUYING More and more online ad space is sold nowadays via a process called programmatic buying. What this means, is that every time a person visits a website or an app with an advertising space, this space is offered for sale on an auction. Advertisers can now bid for this person’s attention …
Rax 1.2 with shiny new features is now available! Get your fee Rax for SQLite copy to try it out! Regular Expressions Rax supports now Perl-compatible regular expressions to simply matching text fields, for example URLs. Rax has two new match operators: =~ (match) and !~ (not match). For example, to select all web clicks …
We are happy to announce that Rax 1.1 is avalaible from today! This release contains many stability and performance improvements. Most importantly: Added r’years and a’weeks magic tags to relative duration. Added a sample \ operator for sets: some_set\10 will list random 10 elements of some_set. In explorative analytics scenarios this is handy as it’s …
A common problem in web analytics is sessionization or session reconstruction: taking a series of user events and splitting the series into a set of sessions [1]. Often, it is done based solely on the timestamps of the events: a session ends after a certain time of user inactivity. As an example, let’s take the …
Snowflake Computing has recently emerged from stealth with a bold claim of having reinvented the data warehouse. Ease of use is their main motto and I dare to say they live up to this promise. Since one of Snowflake’s co-founders, Marcin Żukowski, is a good friend of mine, I’ve got a chance to play with …
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, …
Programming is hard. There is a lot of complexity that needs to handled. To hide at least some of this complexity, people come up with abstractions. SQL is an example of an abstraction – it provides a way to process data without worrying about all sorts of details like: How to find the relevant data …