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.

Security Expert Mario Heiderich About AngularJS and Security

At beyond tellerrand in Düsseldorf this year security expert Mario Heidrich gave a fast-paced - if sometimes too abrasive for my liking - talk about security and AngularJS: This talk contains a lot of useful insights as to what to pay attention to in order to secure your AngularJS applications (or in fact any web application created with a modern JavaScript framework), as well as techniques and approaches security consultants and hackers (both the white and black hat varieties) use in order ...

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

Jeremy Keith About Resilience In Web Applications @ beyond tellerrand 2016

At this year's beyond tellerrand conference in Düsseldorf web developer Jeremy Keith gave a talk on resilience in web applications: Resilience - Jeremy Keith - btconfDUS 2016 from beyond tellerrand on Vimeo. The World Wide Web - or the Internet for that matter - since its inception always was designed as a resilient, fault-tolerant medium. This not just applies in a technical sense but in a social or even political way, too. As John Gilmore is famously quoted: "The Net interprets censorship as ...

Sunday May 29th, 2016 by Bjoern in Front End Development, Web, Web Applications

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

Why motion matters in UI design

UI designer Craig Dehner wrote this interesting article about why he thinks motion design is the future. I wouldn't necessarily use such grandiose terms but essentially I agree: Motion design might not be THE future but it'll certainly play a vital role in current and future user interfaces. It took operating systems and browsers some time to be able to display smooth, seemingly natural animation (using CSS3 animations in the latter case). Now that animation is a staple of modern UI frameworks and ...

Sunday May 8th, 2016 by Bjoern in Design, Front End Development, Mobile Applications, Web Applications

Dropdown menus and alternative approaches for selecting from a choice of options

In this post designer Luke Wroblewski outlines why dropdowns should be the UI of last resort. The problem with dropdown menus - also known as select boxes in HTML lingo - is that they're something of a general purpose, one-size-fits all solution for dealing with lists of elements. Although dropdown menus accommodate most list-based use cases using them often doesn't take the specifics of the use case at hand into consideration. As pointed out by Luke most of the times other, more ...

Sunday April 24th, 2016 by Bjoern in Design, 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-68f4029d56e64861618157/] 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

So sollten Freelancer ihre Preise wirklich kalkulieren

Sorry, this entry is only available in Deutsch.Vor kurzem machte ein Artikel auf dem Startup Blog Gründerszene die Runde, der behauptet: „So sollten Freelancer ihr Gehalt berechnen“. Darin geht es um den Preis, den Freiberufler in der IT Branche für ihre Leistungen verlangen können. Autor dieses Gastartikels ist Thomas Jajeh, Gründer und Geschäftsführer der Projekt-Vermittlungsplattform Twago. Eigentlich sollte man also meinen, dass hier ein Branchenkenner eine fundierte Analyse und sinnvolle Tipps für Freiberufler liefert. Allerdings verspricht bereits der Titel nichts Gutes. Die ...

Sunday March 27th, 2016 by Bjoern in Business, Entrepreneurship, Software

Björn Wilmsmann

my blog. for you.

Let’s talk digital.