Depends on what you are doing. the key thing is to decide how tightly coupled the system should be. With LedgerSMB we went with a tight-coupling approach. Th

Depends on what you are doing. the key thing is to decide how tightly coupled the system should be. With LedgerSMB we went with a tight-coupling approach. This gives us the power of the esoteric features and the ability to to write stored procedures in whatever languages we want later. HStore and Javascript, or JSON and Javascript might be used in the future for some things if we want to. There are many applications which may not need this. In those cases, you are better off focusing on portability (only ANSI SQL features).