Category Archives: Database

Fast Postgres from .NET

It's often said that abstractions slow down your program, since they add layers which makes your application slower. While this is generally correct, it's not always true. Performance can be improved somewhat by removing layers, but the best way to improve performance is to change algorithms. So let's see how we can beat performance of […]

Multiple result sets alternatives in Postgres

While Postgres’s type system is second to none, Postgres still lacks some features here and there. Stored procedures with their own transaction management are high on that list. But, beside transaction management, SP usually come with a cool feature which can cut down chatting with the database server to the minimum. Those familiar with MS […]

Embeding model with data?

JSON is an example of simple data structure which has its model embedded with data. While it’s very popular as an interchange format for good reasons, it’s really a bad fit as main data storage format: it’s wasteful and has limited type support. For a model with a mostly fixed structure, JSON only makes sense […]

Postgres – bridge between worlds

NoSQL databases promise to solve: scaling easier database interaction Scaling often means automatic sharding, replication and multiple write points. Easier database interaction usually means schema-less data, simpler migrations and removal of object-relational impedance mismatch. Postgres is an ORDBMS, not just plain relational database, which means that many of the points that NoSQL proponents argue about […]