Thread: PostgresSQL project

PostgresSQL project

From
Luke Porter
Date:

Hi

 

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.

 

Thanks

 

Luke

Re: PostgresSQL project

From
Peter Eisentraut
Date:
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



RE: PostgresSQL project

From
Luke Porter
Date:
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,
updateand delete functionality through an append only paradigm which effectively delivers a perfect audit ie a means to
accessthe 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
theinsert code module. 

We presently achieve this affect by use of a generator which creates an application specific database environment for
appendonly (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
appropriatePostgreSQL architects/programmers who have experience of the PostgreSQL database kernel. More specifically,
tooutline the general approach and work packages to go about this. 

Regards

Luke



-----Original Message-----
From: Peter Eisentraut <peter.eisentraut@2ndadrant.com>
Sent: 18 May 2020 22:40
To: Luke Porter <luke_porter@hotmail.com>; pgsql-hackers@lists.postgresql.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
thismailing list. 

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

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