Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. https://prestodb.io/
Category Archives: Coding
q – Text as Data
q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and column type detection, and provides full support for multiple …
git source control with a local repository (no server)
Even when working alone or on simple projects, I like to have the benefits of source control – history, branching, and backup. Here are the common steps that need to be taken to use git in this scenario.
gyration /jīˈrāSHən/
Photo sampling and manipulation in 3D space.
Still having fun with Processing.
Vienna districts in numbers
I created an interactive data visualization, written in JavaScript, based on the open data. This is a post about how it came to be.
Convert XML to JSON using XSLT
With increasing service reuse came the need for portable data formats, XML was one of the first widely used, but lately JSON is in bloom.
I needed to convert XML into JSON format for easier consumption on the client, so here’s an article describing the way to do it using XSLT with code and examples.
Once upon a browser
Fun bookmarklet to randomly rotate elements on the page, based on Eric Meyer’s idea.
Evolution Of The JavaScript Loop
Sometimes, the way the syntax is changing can lead to huge improvements in coding and readability. One great example is JavaScript’s forEach.
Game Of Life JavaScript Implementation
An article about implementing and redesigning the Conway’s Game Of Life in JavaScript.
Multiple Values For The Same GET or POST Parameter in ASP.NET MVC
The main advantage of passing multiple values as the same parameter via GET or POST is that it will produce a neatly cast list as the input of the action method.