Enterprise Software | Björn Wilmsmann

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.

Less Is More

What's true for design in general certainly is true for software design in particular: Less is more - or paraphrasing Dieter Rams - "Write less software in order to write better software." A few weeks ago I read this interesting article by web accessibility consultant Heydon Pickering. In this blog post he argues that the only foolproof way of writing performant web applications is to write less code. Sure, all that fancy minification, transpiling, JIT / AoT compilation and optimisation stuff might ...

Daily Standup Meetings: Anti-patterns And What to Do About Them

Daily standup meetings are a mainstay of agile software development methods, such as XP, Kanban (which used to be an inventory control system having originated at Toyota) and Scrum, of course. Given that agile development methods are by far the most dominant ones in the software industry today, it should come as no surprise that daily standup meetings are a common feature of software development processes these days. These meetings basically serve the purpose of informing everyone on the team about these 3 ...

Sunday September 18th, 2016 by Bjoern in Business, Enterprise Software, Entrepreneurship, Software

Follow-up on “Accounting in 2016”

Two months ago, I wrote an article on how accounting in 2016 still is a manual and tedious process. What made me write this article in the first place was the problem that I couldn't automatically get the bank account statements for my business account into my accounting software because my bank's online banking service and my accounting software have incompatible import / export file formats and neither exposes a public API for facilitating communication between and automation of accounting software ...

Sunday June 5th, 2016 by Bjoern in Business, Enterprise Software, Entrepreneurship, Software

BedquiltDB – A JSON document store for PostgreSQL

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 this with your usual NoSQL, document-oriented databases ...

Sunday May 15th, 2016 by Bjoern in Enterprise Software, Software, Web Applications

Sharing and exploring data models and database patterns

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 patterns are rather common (though some particular ...

Sunday April 17th, 2016 by Bjoern in Enterprise Software, Software, Web Applications

Hands-on SQL Tips: Sentinels And Window Functions

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-68cffdd5c39f8477648581/] Now, what if you want to not only display the data but also inform the user in case the total number of rows in the table exceeds the limit set by ...

Sunday April 10th, 2016 by Bjoern in Enterprise Software, Software, Web Applications

Accounting in 2016 – Still a manual and tedious process

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 as invoicing and small business accounting is ...

Sunday April 3rd, 2016 by Bjoern in Business, Enterprise Software, Entrepreneurship, Software

Varying Degrees Of Software Quality And What To Do About It

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 haphazard, impromptu manner in order to solve ...

Sunday March 6th, 2016 by Bjoern in Business, Enterprise Software, Front End Development, Mobile Applications, Software, Web Applications

Analyzing Large Datasets With SQL

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 tools really shine when it comes to ...

Sunday February 21st, 2016 by Bjoern in Enterprise Software

Björn Wilmsmann

my blog. for you.

Let’s talk digital.