Re: Modelling a web CMS in Postgres ... a little advice needed

2022-08-11 Thread Rob Sargent
> On Aug 11, 2022, at 5:30 AM, Laura Smith > wrote: > > > > > > > Sent with Proton Mail secure email. > > --- Original Message --- > On Thursday, August 11th, 2022 at 13:11, Ray O'Donnell > wrote: > > >> On 11/08/2022 11:00, Laura Smith wrote: >> >>> Hi Tony >>> >>> The re

Re: Fwd: Modelling a web CMS in Postgres ... a little advice needed

2022-08-11 Thread Tony Shelver
On Thu, 11 Aug 2022 at 12:00, Laura Smith < n5d9xq3ti233xiyif...@protonmail.ch> wrote: > Hi Tony > > The reason I'm looking to do it from scratch is that its a case of "once > bitten, twice shy". > > This CMS will be replacing a Joomla based CMS. > > I can't quite say I'm enamoured by the option o

Re: Fwd: Modelling a web CMS in Postgres ... a little advice needed

2022-08-11 Thread Laura Smith
Sent with Proton Mail secure email. --- Original Message --- On Thursday, August 11th, 2022 at 13:11, Ray O'Donnell wrote: > On 11/08/2022 11:00, Laura Smith wrote: > > > Hi Tony > > > > The reason I'm looking to do it from scratch is that its a case of > > "once bitten, twice sh

Re: Fwd: Modelling a web CMS in Postgres ... a little advice needed

2022-08-11 Thread Laura Smith
Also in this day and age, removing the excess baggage means an improved security footprint. Laura --- Original Message --- On Thursday, August 11th, 2022 at 10:49, Tony Shelver wrote: > From: Tony Shelver > Date: Thu, 11 Aug 2022 at 11:47 > Subject: Re: Modelling a web CMS

Fwd: Modelling a web CMS in Postgres ... a little advice needed

2022-08-11 Thread Tony Shelver
From: Tony Shelver Date: Thu, 11 Aug 2022 at 11:47 Subject: Re: Modelling a web CMS in Postgres ... a little advice needed To: Laura Smith On Thu, 11 Aug 2022 at 09:35, Laura Smith < n5d9xq3ti233xiyif...@protonmail.ch> wrote: > Hi > > I'm looking at using pgsql as a back

Modelling a web CMS in Postgres ... a little advice needed

2022-08-11 Thread Laura Smith
Hi I'm looking at using pgsql as a backend to a web CMS but could do with a little advice from the crowd on the wiseness of my schema thinking. TL;DR the design is centered around two tables "pages" and "page_content", where "pages" has a jsonb column that refers to "page_content" in a key-valu