Re: database design with temporary tables - Mailing list pgsql-general

From Ray O'Donnell
Subject Re: database design with temporary tables
Date
Msg-id e26308d6-695d-d501-2938-c9b776fe63c6@rodonnell.ie
Whole thread Raw
In response to Re: database design with temporary tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: database design with temporary tables  (ourdiaspora <ourdiaspora@protonmail.com>)
List pgsql-general
On 29/08/2021 17:53, Adrian Klaver wrote:
> On 8/29/21 9:38 AM, ourdiaspora wrote:
>>
>> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
>>
>> On Sunday, August 29th, 2021 at 5:30 PM, Adrian Klaver 
>> <adrian.klaver@aklaver.com> wrote:
>>
>>> On 8/29/21 9:24 AM, Adrian Klaver wrote:
>>>
>>>
>>> Whoops, unfinished thought. What I was going to ask is:
>>>
>>> The above is not clear to me. Are you asking about the Postgres
>>>
>>> documentation?
>>>
>>
>> Yes, wanted to know relevant parts because often the first problem is 
>> to know which part of the (extensive) documentation to read...
>>
> 
>  From what I see it is basic operations; CREATE TABLE, SELECT, INSERT, 
> UPDATE and COPY.
> 
> As I said in my previous post create a fairly detailed design flow first 
> and from that you will see what operations you need to do and what part 
> of the docs you need to look at.

+100 to this. Also, it's not clear from your description what is 
happening where - how much functionality is in the database, and how 
much at the web server. Are your users connecting directly to the 
database server? - or do they connect only to the web server, which then 
uses its own account on the database server? Get this clear in your own 
head and much of the rest will follow.

Ray.



-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: database design with temporary tables
Next
From: ourdiaspora
Date:
Subject: Re: database design with temporary tables