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.

Mock Data Generators for Tabular Data

Leider ist der Eintrag nur auf Britisches Englisch verfügbar.Developing a JavaScript-based web front-end, e.g. with frameworks such as Angular, at some point - especially during the prototype phase - often requires working with data supplied by a back-end data source. Tools such as JSON Server enable you to spin up such a data source as a REST API server in no time with zero coding involved. However, running a back-end server is only part of the equation that is testing a front-end against ... Read more

Rarely Used But Useful PostgreSQL Features

Leider ist der Eintrag nur auf Britisches Englisch 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 ... Read more

Sharing and exploring data models and database patterns

Leider ist der Eintrag nur auf Britisches Englisch verfügbar.Somewhat in the vein of last week's post, I'd like to share a new service called dbpatterns with you. dbpatterns allows you to create ER models in the browser and share them with other users. If a particular pattern or model suits your needs you can directly export its DDL for PostgreSQL, SQLite, MySQL or Oracle RDBMS. I really appreciate the idea of promoting and sharing best practices for database systems. While object-oriented software ... Read more

Hands-on SQL Tips: Sentinels And Window Functions

Leider ist der Eintrag nur auf Britisches Englisch 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-6606527571738898256212/] Now, what if you want to not only display the data but also inform the user in case the total number of rows ... Read more