Re: Creating complex track changes database - challenge!

Поиск
Список
Период
Сортировка
От Thiemo Kellner
Тема Re: Creating complex track changes database - challenge!
Дата
Msg-id 00f1de3b-1875-09d4-8034-a1082f32d588@gelassene-pferde.biz
обсуждение исходный текст
Ответ на Re: Creating complex track changes database - challenge!  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
Список 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@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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: index-only-scan when there is an index on all columns
Следующее
От: Ken Tanzer
Дата:
Сообщение: Re: Given a set of daterange, finding the continuous range thatincludes a particular date (aggregates)