my blog. for you.

Let’s talk digital.

I’m an independent IT consultant and entrepreneur in the Internet and software business. I’m interested in design, enterprise applications, web apps and SaaS products. I design and develop business solutions and applications. I help companies in terms of software quality and knowledge transfer, e.g. with Angular and Spring Boot.

FnordMetric and ChartSQL: Create Charts Directly From SQL

FnordMetric is an interesting new software package that allows you to create good-looking charts (in SVG format) directly from SQL using a query language called ChartSQL. The are quite a few examples available here. A typical ChartSQL query for a timeline series chart for instance looks like this: DRAW LINECHART WITH AXIS BOTTOM AXIS LEFT; SELECT 'data' AS series, FROM_TIMESTAMP(time) AS x, value2 * 1000 AS y FROM example_data WHERE series = "measurement2"; The software currently is ... Read more