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-662aec32995bb194063757/] 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

FnordMetric and ChartSQL: Create Charts Directly From SQL

Leider ist der Eintrag nur auf English verfügbar.FnordMetric is an interesting new software package that allows you to create good-looking charts (in SVG format) directly from SQL using a query language called ChartSQL. The are quite a few examples available here. A typical ChartSQL query for a timeline series chart for instance looks like this: DRAW LINECHART WITH AXIS BOTTOM AXIS LEFT; SELECT 'data' AS series, FROM_TIMESTAMP(time) AS x, value2 * 1000 AS y FROM example_data ...

18. Januar 2015 by Bjoern in Enterprise Software

ZenQuery is now open source

Leider ist der Eintrag nur auf English verfügbar.Today I made ZenQuery available as open source (under the Apache License). ZenQuery is an 'Enterprise Backend as a Service' and allows you to easily access databases through a REST API without any programming knowledge required. Get SQL result sets as JSON, XML or CSV data, which can easily be processed by tools such as MS Excel or in your own applications. ZenQuery provides you with an instant REST API for your SQL queries. Anything that ...

20. Dezember 2014 by Bjoern in Enterprise Software, Entrepreneurship, Front End Entwicklung, Software, Web Applikation

Airtable – A true spreadsheet / database hybrid?

Leider ist der Eintrag nur auf English verfügbar.Lots of the software of the world is written in Microsoft's Excel. A spreadsheet environment lends itself particularly well to addressing everyday computing problems. Compiling tabular data, creating connections between particular pieces of that data, condensing and aggregating over a dataset's values. These are common tasks a spreadsheet solves very well with no need for complex database or application server software. A spreadsheet is a flexible tool that provides simple, responsive and instant feedback to ...

9. November 2014 by Bjoern in Software, Web Applikation

ZenQuery 1.0 is available today!

Leider ist der Eintrag nur auf English verfügbar.A few weeks ago I wrote about a new product I'm currently developing: ZenQuery, an Enterprise Backend as a Service. I’m pleased to announce the first public version of ZenQuery today. Since the first public announcement regarding ZenQuery roughly 30 days ago we’ve been busy working on this release. Today, you’ll be able to try out ZenQuery 1.0 yourselves on your own server and environment. I really hope you like what we’ve got for you ...

21. Mai 2014 by Bjoern in Design, Enterprise Software, Entrepreneurship, Web Applikation

ZenQuery: From Idea To Product In 2 Weeks

Leider ist der Eintrag nur auf English verfügbar.Earlier this week I've launched a new product called ZenQuery. In a nutshell, ZenQuery is an application that creates an instant REST API (with JSON, XML and CSV formats) for SQL queries. This allows you to easily access any kind of data from your database without having to deal with technical details such as database drivers, connections, ORM or caching. A typical use case is an enterprise company which for example wants to create a new ...

27. April 2014 by Bjoern in Design, Enterprise Software, Entrepreneurship, Web Applikation

Björn Wilmsmann

my blog. for you.

Reden wir über Digitales.