Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated)
Date: Mon, 23 Dec 2024 20:17:30 +0100
Message-ID: 
 <20241223201730.Horde.OJdWyIuOqgrvOVIuuahjbqS@webmail.gelassene-pferde.biz>
From: thiemo@gelassene-pferde.biz
To: pgsql-general@lists.postgresql.org
Subject: Re: Need help in database design
References: 
 <CAHesJ5LES3aTDf=xp7NOwrADQ_HWC-Spsv7yLu9ZY+zxzZO53A@mail.gmail.com>
 <b450927c-49da-46e5-ad74-bf38ceff166b@aklaver.com>
 <CAHesJ5+ASNoSNMiC5Ms0Ts=gw7v2_UeBpUT=phujO4yE_XCbEw@mail.gmail.com>
 <CAHesJ5JbkCBZ2f_AvUr8+KWnGPAsobu4zyfnWm8bEeb7X9oqDQ@mail.gmail.com>
 <06e1f1ee-74b2-43a2-9a63-da20ae455ae2@aklaver.com>
 <CAHesJ5JLzhHiGSBSkJZ7x7rGgHeeByP=wWk1D5GG=x8cJ5YY6Q@mail.gmail.com>
 <CAKFQuwYdpzwcbSdQ8TvZ-nVjPeHVVz+5=bWofCbUK+p_o=axrQ@mail.gmail.com>
 <CAHesJ5+yTenkAxOT8H33Cfe=1b2kSyXGqxFYfYz5fgYAVVvFmw@mail.gmail.com>
 <CAHesJ5KaJ8p7QhB9UUoFEbA87cU7ke4GBMkKR3q2FJPVv9GXyw@mail.gmail.com>
 <CANzqJaB_s8eXCZJvYO9CLvgJNqrshD=G5GgECi1M9=vk-JHjdQ@mail.gmail.com>
 <CAHesJ5LgLi9-uGCk3J9TUkuyttysz3fzTaP+o57EjcBtwDYKZA@mail.gmail.com>
 <CANzqJaD-MwXzvg97q0iLvAdkf=DnUMOq0Ex2_eNU7sTxEL7bfA@mail.gmail.com>
 <CAHesJ5KtKm9fjhMdR1+cC-M5jW98Sz6sWKbt0mN6SJcfkq9eig@mail.gmail.com>
 <CAHesJ5Kne6MZakdhcQ9Zc-5KhBvhgUt+zUXuX5v6z+zwTY6gLQ@mail.gmail.com>
 <CANzqJaDb901c=fbicfuzXu1kvf1OR+6rtRZvtHOPyGaOD2E99Q@mail.gmail.com>
 <CAHesJ5LbFjqN0NndYUHKsXX_JssgwM-VPPaYoi28kZvsciFifQ@mail.gmail.com>
 <CAHesJ5Kn4bm6DmEVtEmHc1itXovdqNo8iE4kiDunH3gYK5jF4A@mail.gmail.com>
 <CANzqJaBhAissakbxvn6hUBenHBkHzjODGyw-Yg3z_EcsfYhKmg@mail.gmail.com>
 <CAHesJ5++Ca0W9DSWA-XtfHohuD8a15GuaPk_DEPU3ggeq9WHWw@mail.gmail.com>
In-Reply-To: 
 <CAHesJ5++Ca0W9DSWA-XtfHohuD8a15GuaPk_DEPU3ggeq9WHWw@mail.gmail.com>
Accept-Language: de
Content-Type: multipart/alternative; boundary="=_IgZbSimisFXvUnSYEfskYg8"
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/20241223201730.Horde.OJdWyIuOqgrvOVIuuahjbqS%40webmail.gelassene-pferde.biz>
Precedence: bulk

This message is in MIME format.

--=_IgZbSimisFXvUnSYEfskYg8
Content-Type: text/plain; charset=utf-8; format=flowed; DelSp=Yes
Content-Description: =?utf-8?b?U8OzbG8=?= texto
Content-Disposition: inline
Content-Transfer-Encoding: 8bit

  Just out of curiosity, not suggestion this is the solution. Why save  
json in PostgreSQL and not in a DB specialised on JSON like MongoDB?

Divyansh Gupta JNsThMAudy <ag1567827@gmail.com> escribió:

> Thank you everyone for giving your valuable responses, I am glad  
> that everyone understands my concern. I got some good ideas about  
> the database design that I am following after going through some  
> stress testing I will implement the same.
>
>   Thank you so much Everyone

--=_IgZbSimisFXvUnSYEfskYg8
Content-Type: text/html; charset=utf-8
Content-Description: Mensaje HTML
Content-Disposition: inline

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/REC-html40/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title></title>
</head>
<body style="font-family:Arial;font-size:14px">
<p>Just out of curiosity, not suggestion this is the solution. Why save json in PostgreSQL and not in a DB specialised on JSON like MongoDB?<br>
<br>
Divyansh Gupta JNsThMAudy &lt;<a href="mailto:ag1567827@gmail.com">ag1567827@gmail.com</a>&gt; escribi&oacute;:</p>
<blockquote style="border-left:2px solid blue;margin-left:2px;padding-left:12px;" type="cite">
<p dir="ltr">Thank you everyone for giving your valuable responses, I am glad that everyone understands my concern. I got some good ideas about the database design that I am following after going through some stress testing I will implement the same.</p>
<p dir="ltr">Thank you so much Everyone</p>
</blockquote>
</body>
</html>
--=_IgZbSimisFXvUnSYEfskYg8--