From: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Creating complex track changes database - challenge! |
Date: | 2018-02-27 22:58:23 |
Message-ID: | 00f1de3b-1875-09d4-8034-a1082f32d588@gelassene-pferde.biz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <thiemo(at)gelassene-pferde(dot)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 | Content-Type | Size |
---|---|---|
thiemo.vcf | text/x-vcard | 693 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Tanzer | 2018-02-28 00:15:14 | Re: Given a set of daterange, finding the continuous range that includes a particular date (aggregates) |
Previous Message | Tom Kazimiers | 2018-02-27 22:54:44 | Re: Unexpected behavior with transition tables in update statement trigger |