Wednesday, January 30, 2013

Building SOLID Databases: Open/Closed Principle

›
Introduction Like the Single Responsibility Principle, the Open/Closed Principle is pretty easy to apply to object-relational design in P...
Wednesday, January 23, 2013

Building SOLID Databases: Single Responsibility and Normalization

›
Introduction This instalment will cover the single responsibility principle in object-relational design, and its relationship both to dat...
1 comment:
Friday, January 18, 2013

Building SOLID Databases: Introduction

›
The SOLID design approach is a set of principles developed in object-oriented programming.    This series will explore the applicability of ...
4 comments:
Thursday, January 10, 2013

An awesome one-liner for PostgreSQL

›
Recently I was looking at options for exploring CIDR blocks in PostgreSQL.  In particular, I was wondering about checking a CIDR block for u...
1 comment:
Friday, January 4, 2013

Object-Relational Algebra 3: The Series Join function

›
I am back from a break due to working hard on getting LedgerSMB 1.4 closer to release (beta 2 has been released and we are working hard on m...
4 comments:
Monday, October 15, 2012

Object/Relational Algebra 2: Function Properties

›
Previously I introduced the idea that functional notation allowed relational algebra to play well with other mathematical disciplines, and t...
1 comment:
Thursday, October 11, 2012

Object-Relational Algebra 1: Definitions and Assumptions

›
 Introduction This post begins a series to try to establish a mathematical basis for object-relational database systems.  The idea here is...