Perspectives on LedgerSMB

This blog tracks development of the open source accounting and ERP software LedgerSMB. I also offer some perspectives on PostgreSQL including new features which we may find useful. Brought to you by Metatron Technology Consulting.

Saturday, September 8, 2012

O/R modelling interlude: PostgreSQL vs MySQL

›

Every time we see people look at PostgreSQL and MySQL on the internet it falls into a flame war fast. I think that a large part of the pr...

17 comments:

Wednesday, September 5, 2012

O/R Modelling part 5: Nested Data Structures, Do's and Don'ts

›

One of the promises of object-relational modelling is the ability to address information modelling on complex and nested data structures. ...

1 comment:

Sunday, September 2, 2012

O/R Modelling in PostgreSQL part 4: Composite Columns and Cross-Table Refs

›

So far, we have looked at tables as classes and various ways of looking at inheritance within that structure. However, tables can be nested...

Thursday, August 30, 2012

O/R Modelling 3.2: Set/Subset Modelling with Inheritance

›

Despite the fact that set/subset modelling is usually not a win for inheritance, sometimes in the cases of more complex logic, it can be. D...

1 comment:

Monday, August 27, 2012

PostgreSQL O/R Modelling Part 3: Table Inheritance and O/R Modelling in PostgreSQL

›

Note: PostgreSQL 9.2 will allow constraints which are not inherited. This will significantly impact the use of inheritance, and allow fo...

3 comments:

‹

›

Home

View web version