my blog. for you.

Reden wir über Digitales.

Ich bin selbständiger IT Berater und Unternehmer in der Internet und Software Branche. Ich beschäftige mich mit Design, Enterprise Applikationen, Web Apps und SaaS Produkten. Ich entwerfe und entwickle Business Lösungen und Anwendungen. Ich helfe Unternehmen in Sachen Software Qualität und Wissenstransfer, z.B. mit Angular und Spring Boot.

Rarely Used But Useful PostgreSQL Features

Leider ist der Eintrag nur auf English verfügbar.I'm an avid user of SQL and the variety of - frequently overlooked - features it provides. However, unfortunately the possibilities of SQL and modern, advanced open source incarnations of RDBMS such as PostgreSQL aren't utilised to the extent they could be when developing web or enterprise applications today. More often than not SQL database are perceived as a mere data store for persisting object-oriented data, which can give rise to the famous object-relational impedance ... Read more

Nadieh Bremer @ beyond tellerrand 2017: Hacking the Visual Norm

Leider ist der Eintrag nur auf English verfügbar.Nadieh Bremer @ beyond tellerrand 2017: Hacking the Visual Norm from beyond tellerrand on Vimeo. Read more

Hands-on SQL Tips: Sentinels And Window Functions

Leider ist der Eintrag nur auf English verfügbar.Sometimes when displaying data in an application you want the amount of data (rows, individual data points etc.) to be limited for the app to stay responsive and to allow the user to more easily scan and browse the data set. In SQL this is commonly done using a LIMIT statement: [crayon-67271323d8447712429130/] Now, what if you want to not only display the data but also inform the user in case the total number of rows in ... Read more

Analyzing Large Datasets With SQL

Leider ist der Eintrag nur auf English verfügbar.As part of a web application I've created for a client, I've been working on efficient analysis of somewhat large datasets for some time now. This analysis often involves complexing grouping, clustering and value aggregation. SQL and PostgreSQL aggregate functions in particular come in quite handy when dealing with that kind of challenge. While RDBMS and SQL certainly are useful already just for keeping and retrieving data, i.e. for running your usual CRUD operation, those ... Read more