Re: Creating complex track changes database - challenge!

[Thiemo Kellner]

You can access code with
git clone ssh://<your sourceforge user>@git.code.sf.net/p/pg-scd/code 
pg-scd-code
and browse it at
https://sourceforge.net/p/pg-scd/code/
On 02/27/18 08:43, Thiemo Kellner wrote:
I attached what I have got so far. I will setup a shared repository 
these days.

Zitat von Thiemo Kellner <thi...@gelassene-pferde.biz>:

Hi Lukasz

I am working on a generic (reading the information schema and other 
database metadata), trigger based solution for SCD tables, i. e. 
tables that keep (or not according to SCD type) history of the data. 
However, it is not far grown and I am not having much time to advance 
it so it evolves very slowly. If you are interested, I would open a 
sourceforge project or the like and we can work on it together.

I am very much surprised that no database I know of supports 
SCD/historising tables out of the box. In 16 years as ETL pro I have 
seen reinvented the wheel all the time... maybe PostgreSQL wants to 
get a head start on this.

Kind regards

Thiemo


--
+49 (0)1578-772 37 37
+41 (0)78 947 36 21
SIP/iptel.org: thiemo.kellner
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0xCA167FB0E717AFFC
<<attachment: thiemo.vcf>>