Hello.
We have a PostgreSQL database with many tables, as well as foreign table,
dblink, triggers, functions, indexes, etc, for managing the business logics
of the data within the database. We also have a custom table for the
purpose of tracking the slowly changing dimensions (type 2).
Currently
Experts,
A very high level question... Subject sums it up.
I love PGSQL, but I don't know if it is a good fit for this back-end... I
hope it is.
Imagine something akin to stocks, where you have a row for every stock, and
a column for every stock. Except where the same stock is the row & col, a