MIME-Version: 1.0
References: 
 <FD4Iyd89i-sbetQTcbUPO1SqWrYMGhzyso4ltpYmvWiI5LtHUxnPZNCyoJOhMOr3aQqvSKR9pISe55L3HStXrim-Q2wuufRQFkjGtAjIyS8=@protonmail.com>
In-Reply-To: 
 <FD4Iyd89i-sbetQTcbUPO1SqWrYMGhzyso4ltpYmvWiI5LtHUxnPZNCyoJOhMOr3aQqvSKR9pISe55L3HStXrim-Q2wuufRQFkjGtAjIyS8=@protonmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 10 May 2022 18:43:08 -0700
Message-ID: 
 <CAKFQuwZMze+X-pVSNTWkY+vV3pFrX1S-kC0WCr4FGupzignhjA@mail.gmail.com>
Subject: Re: Using "object orientated" tables?
To: Simon Connah <simon.n.connah@protonmail.com>
Cc: pgsql-novice <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000047705105deb291f4"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZMze%2BX-pVSNTWkY%2BvV3pFrX1S-kC0WCr4FGupzignhjA%40mail.gmail.com>
Precedence: bulk

--00000000000047705105deb291f4
Content-Type: text/plain; charset="UTF-8"

On Tue, May 10, 2022 at 6:33 PM Simon Connah <simon.n.connah@protonmail.com>
wrote:

> Hi,
>
> I was wondering what the community thought of using table inheritance in
> PostgreSQL? Is it considered bad practice these days?
>
> Basically, I have a users table and every user has a unique, not null UUID
> which is used as the primary key. There are only three columns on the
> table. User ID, Username, Email.
>
> Having said that I'll have to store data about them which I don't want to
> do in one massive table as it would be ugly as hell. So what I want is my
> main user's table to stick to three columns and then sub-tables which
> inherit from it to add their own column? So for instance I might want to
> store an account balance for people making money on my site.
>
> Hopefully, I've managed to explain what I mean properly. If you need any
> extra information then let me.
>
>
I wouldn't use inheritance, especially since I do not want to carry around
copies of Username and Email.  Having a "core data" users table then adding
additional one-to-one related tables based upon application needs is quite
common.

David J.

--00000000000047705105deb291f4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, May 10, 2022 at 6:33 PM Simon Connah &lt;<a href=
=3D"mailto:simon.n.connah@protonmail.com">simon.n.connah@protonmail.com</a>=
&gt; wrote:</span><br></div></div><div class=3D"gmail_quote"><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
I was wondering what the community thought of using table inheritance in Po=
stgreSQL? Is it considered bad practice these days?<br>
<br>
Basically, I have a users table and every user has a unique, not null UUID =
which is used as the primary key. There are only three columns on the table=
. User ID, Username, Email.<br>
<br>
Having said that I&#39;ll have to store data about them which I don&#39;t w=
ant to do in one massive table as it would be ugly as hell. So what I want =
is my main user&#39;s table to stick to three columns and then sub-tables w=
hich inherit from it to add their own column? So for instance I might want =
to store an account balance for people making money on my site.<br>
<br>
Hopefully, I&#39;ve managed to explain what I mean properly. If you need an=
y extra information then let me.<br><br></blockquote><div><br></div><div cl=
ass=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">I wo=
uldn&#39;t use inheritance, especially since I do not want to carry around =
copies of Username and Email.=C2=A0 Having a &quot;core data&quot; users ta=
ble then adding additional one-to-one related tables based upon application=
 needs is quite common.</div><div class=3D"gmail_default" style=3D"font-fam=
ily:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" styl=
e=3D"font-family:arial,helvetica,sans-serif">David J.</div><div class=3D"gm=
ail_default" style=3D"font-family:arial,helvetica,sans-serif"></div></div><=
/div>

--00000000000047705105deb291f4--