Re: Creating complex track changes database - challenge!
От | Thiemo Kellner |
---|---|
Тема | Re: Creating complex track changes database - challenge! |
Дата | |
Msg-id | 20180227084345.80751f5vl9r8wm68@www.gelassene-pferde.biz обсуждение исходный текст |
Ответ на | Re: Creating complex track changes database - challenge! (Thiemo Kellner <thiemo@gelassene-pferde.biz>) |
Ответы |
Re: Creating complex track changes database - challenge!
|
Список | pgsql-general |
I attached what I have got so far. I will setup a shared repository these days. Zitat von Thiemo Kellner <thiemo@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 Öffentlicher PGP-Schlüssel: http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.
Вложения
В списке pgsql-general по дате отправления: