Use Postgres JSON Type and Aggregate Functions to Map Relational Data to JSON
Postgres is just too cool. Because Postgres can work with both JSON and arrays as first-class data types, it is possible to perform some very handy mappings on the server end which would become potential performance bottlenecks...
Installing and Configuring PostgreSQL 9.4 on Linux Mint/Ubuntu
Installing and configuring PostgreSQL on a Linux box is either simple, because you are a Linux and/or Postgres expert, or not so simple, because you are new(er) to Linux, Postgres, or both. Over the past year, I have resided...
A More Useful Port of the Chinook Database to Postgresql
Image by Ingrid Talar | Some Rights Reserved I use Chinook Database as the sample database for a lot of things, primarily because the same data set is available for most of the major database platforms, so it’s easy to...
Biggy Available as Pre-Release on Nuget
Image by fortfan | Some Rights Reserved Biggy is a very fast, synchronized, in-memory document/relational query tool for .NET. If you have been following the Biggy project over the past year, you are aware that there has been a...
C#: Avoiding Performance Issues with Inserts in SQLite
Image by Lance McCord | Some Rights Reserved If you are new to SQLite, you may well run across one of the most confounding of its implementation details the moment you attempt to do some sort of bulk or batch processing of...
Installing and Using SQLite on Windows
Image by shinichi | Some Rights Reserved When one is developing in .NET with Visual Studio and other Microsoft tools, it is easy to lose sight of alternative solutions to common problems. MS does a competent job of creating a...
Biggy: Interface Semantics and The Interface Segregation Principle
Image by Dennis Yang | Some Rights Reserved Over the past few months I’ve been working hard on Rob Conery’s Biggy project, a high-performance, in-memory query and persistence tool for .NET. Recently, the...
Biggy: Evolving the Architecture
Image by Ian Kershaw | Some Rights Reserved Recently, K. Scott Allen proposed a re-thinking of the fundamental architecture for Rob Conery’s Biggy project. Over the past month, the project has grown from a simple,...
Building Biggy: Resolving Dissonance Between Domain Objects and Backing Store Entities
Image by Dee Ashley | Some Rights Reserved I’ve recently been hard at work contributing to an exciting new open source project, Rob Conery’s Biggy. Biggy is just getting off the ground, so things are evolving rapidly,...
Biggy: A Fresh Look at High-Performance, Synchronized In-Memory Persistence for .NET
Image by Elif Ayiter | Some Rights Reserved About a month ago, Rob Conery popped off with the following tweet: And hence, Biggy was born. Rob’s “most ridiculous thing he has ever created” has quickly morphed...