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.

BedquiltDB – A JSON document store for PostgreSQL

Leider ist der Eintrag nur auf English verfügbar.BedquiltDB is a recently released PostgreSQL extension (written mostly in PL/pgSQL) that leverages PostgreSQL's relatively new jsonb column type (available since version 9.4) to provide a MongoDB-like NoSQL document store and API on top of a PostgreSQL database. There are a few benefits to this approach. First, this allows you to start a project with a comparatively simple document-oriented API that lends itself to many use cases in terms of modern web applications. While you get ...

Sharing and exploring data models and database patterns

Leider ist der Eintrag nur auf English 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 design ...

17. April 2016 by Bjoern in Enterprise Software, Software, Web Applikation

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-690b84b10e0aa899586051/] Now, what if you want to not only display the data but also inform the user in case the total number of rows in ...

10. April 2016 by Bjoern in Enterprise Software, Software, Web Applikation

Accounting in 2016 – Still a manual and tedious process

Leider ist der Eintrag nur auf English verfügbar.The past few weeks I've been struggling with automating my accounting, invoicing and banking processes to the point I don't really have to think about it anymore. Currently, a lot of my accounting-related processes are still way too manual for my liking. Being both a virtuous, lazy programmer and an entrepreneur I'd like to automate every process that can be automated at reasonable cost, especially if that process doesn't generate any revenue. Now, as far ...

3. April 2016 by Bjoern in Business, Enterprise Software, Entrepreneurship, Software

Varying Degrees Of Software Quality And What To Do About It

Leider ist der Eintrag nur auf English verfügbar.When working on client projects I come across copious amounts of source code, which sometimes is very well-maintained, sometimes less so. The various code bases are as diverse as their owners and respective stakeholders: A few come with an inherent sense of quality, lots of unit tests serving as the specification for the product. They're typically delightful to maintain and extend. Some though at times leave the impression of having been cobbled together in a rather ...

6. März 2016 by Bjoern in Business, Enterprise Software, Front End Entwicklung, Mobile Applikationen, Software, Web Applikation

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 ...

21. Februar 2016 by Bjoern in Enterprise Software

Enterprise UX: Huge Potential And Anything But Boring

Leider ist der Eintrag nur auf English verfügbar.Last year designer Uday Gajendar wrote this interesting post about why he designs enterprise UX suggesting more designers should follow suit. This is pretty much in the vein of another article by fellow designer Dave Malouf. I very much agree with this point of view. User experience in enterprise software generally has a huge potential for improvements that impact thousands of users in a meaningful way. Yes, enterprise software often isn't exactly nice to look ...

14. Februar 2016 by Bjoern in Design, Enterprise Software

Tracking Down Software Bugs, Automatically!

Leider ist der Eintrag nur auf English verfügbar.Last week MIT researchers published an article about an automatic bug-repair system called Prophet. Prophet is a machine-learning system that learns general properties and patterns of successful error corrections in software and applies those patterns to making new error corrections in other programs. While the possibility of having software track down and fix bugs automatically (which effectively would mean creating self-correcting computer programs) is exciting enough in its own right, Prophet possibly has far-reaching implications ...

7. Februar 2016 by Bjoern in Enterprise Software, Front End Entwicklung, Mobile Applikationen, Software, Web Applikation

Advice On Improving JavaScript Test Speed (by Shyp Engineering)

Leider ist der Eintrag nur auf English verfügbar.On their blog engineers of logistics service Shyp (defunct) talk about how they improved the turn-around times of their JavaScript test suite by an order of magnitude of 3 (i.e. 1000x), which is no small achievement. In a modern software development process continuous integration and continuous deployment play a vital role. These ensure that your software always is in an deliverable, tested state and ideally is deployed to production systems in a timely manner when ...

31. Januar 2016 by Bjoern in Enterprise Software, Front End Entwicklung, Software, Web Applikation

Internal, company-specific software frameworks are evil

Leider ist der Eintrag nur auf English verfügbar.OK, I'm exaggerating a little here, company-specific software frameworks aren't exactly evil as in the true definition of the word but who isn't fond of the occasional hyperbolic headline? What I'm trying get across is that most of the times, software frameworks developed within an organization specifically for solving that organization's business problems in a reusable, maintainable manner do more harm than good. Everybody who's been exposed to enterprise software development for longer than a very ...

24. Januar 2016 by Bjoern in Design, Enterprise Software, Software

Björn Wilmsmann

my blog. for you.

Reden wir über Digitales.