RE: PostgresSQL project

Hi Peter

Thanks for the prompt response.

Yes, this is an open source project which will be shared with the community. We will also consider hiring appropriate consultants.

At a summary level, we have a proven approach for how a relational database can provide comprehensive logical insert, update and delete functionality through an append only paradigm which effectively delivers a perfect audit ie a means to access the database at any point in the audit (time) and for all data to be in a relationally correct state.

In so doing, we are removing the need for the use of update and delete code (as presently used) with enhancements to the insert code module.

We presently achieve this affect by use of a generator which creates an application specific database environment for append only (with a normal current view schema being the input for the generator).

The specification for the requirements of the insert code module is very detailed. Our challenge is to identify appropriate PostgreSQL architects/programmers who have experience of the PostgreSQL database kernel. More specifically, to outline the general approach and work packages to go about this.

Regards

Luke

-----Original Message-----
From: Peter Eisentraut <peter(dot)eisentraut(at)2ndadrant(dot)com>
Sent: 18 May 2020 22:40
To: Luke Porter <luke_porter(at)hotmail(dot)com>; pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: PostgresSQL project

On 2020-05-18 18:21, Luke Porter wrote:
> I am a member of a small UK based team with extensive database
> experience. We are considering a project using PostgresSQL source code
> which only uses the insert data capabilities.
>
> Is there a contact who we could speak with and discuss our project
> aims in principal.

If yours is an open-source project that you eventually want to share with the community, then you can discuss it on this mailing list.

If it is a closed-source, proprietary, or in-house project, then the community isn't the right place to discuss it, but you could hire professional consultants to help you, depending on your needs.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services