Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tPnyx-00FRJj-Gx for pgsql-general@arkaria.postgresql.org; Mon, 23 Dec 2024 19:20:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tPnyw-00EzRu-HS for pgsql-general@arkaria.postgresql.org; Mon, 23 Dec 2024 19:20:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tPnyw-00EzRm-6d for pgsql-general@lists.postgresql.org; Mon, 23 Dec 2024 19:20:45 +0000 Received: from mail-oo1-xc2f.google.com ([2607:f8b0:4864:20::c2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tPnyt-001GgN-A0 for pgsql-general@lists.postgresql.org; Mon, 23 Dec 2024 19:20:45 +0000 Received: by mail-oo1-xc2f.google.com with SMTP id 006d021491bc7-5f4c111991bso2321766eaf.0 for ; Mon, 23 Dec 2024 11:20:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734981642; x=1735586442; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=aQggz4a1Z1LpeDtqKPDK8g4BBkATrWGPdOis3PfsKL8=; b=mINx69+Z8L4rUJ+rzUmJLOeZ7967wn/U4lgsLcdVIdyKwEmeyreF+9mGNsjt2XUp1G NEm6v+weKJUJ9c3t5g5Mq6QEzmQ9pubaYucaRWb20ahxAYNM4TavF+G9AGQWQI0Iyg0m TKhY7yoQfCU1tEg2GbOq0ULJDJEsFzDRu7LM5v+aLJ1UbyyV/HSP2/F/hwGCBK/W50w2 L7IssuxHIh4LP8JIChin+hViHFbUSnqejCj0S1D4INev2rT57ccPucZ+aFwSeAvY+OQN ICnxhHHKYPjuf/2/eR2tUXRIe0Wc9Y7tlTPZZ7nKTH+6s6toJptChfdCD5xx8scdfbFS w+Yw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734981642; x=1735586442; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=aQggz4a1Z1LpeDtqKPDK8g4BBkATrWGPdOis3PfsKL8=; b=JkhpQSfGlVW2iWfq7hvmdvhs9y2zzWu/BB2a6EYSOoZjrofNdkKrzUJK3OLRrhCHaI VRTkFZiWRlixuJUtx/+Q2z2zZSkOFMewHrOAfdG0o/ogmVAMS98XyfcEOuAgns2xPzoN qW/TGGCHkyUTcm1Mq3ArIAkepqHZ4+cX5VDOmMoseGdXywJ91V07VSgdobnIhsffbcoS OgFTN5kxccj41hGBeQiNy39EIugP2mzAV3eTzyKBd9gMwJOvR4PpeT1kvkTQV5PCeZFG dE+/9yHRR6+5npJ5ncQTd4hmcpSKn7GXSA3YFt1bipgYcoPsIo11IVtvVUbgOZeKd6QR oQbA== X-Gm-Message-State: AOJu0YzEhgb3+q6ascUqj9Etl3Metb7WJt75qnZMEC7IaTgwzNVa7pCX eME1V/nBeCzMUf+zuLZORVwqOY5CHy/i8g1/z+pq56r28kysj8EqEkxXoA0CeaTSL43LtsJhsYv 0vI+ZlPpg5Y/8jG1IwKzKKpkyiGOEqc2zMccR5w== X-Gm-Gg: ASbGncsgX0ecJlrMh8aLNWVDMuS5+XKZ+kDThliNSJC1rDT3HZ8HQOcA1NKsdCrfNxT 2EfIyb7rx9dW6NzdOoFXBk00execN2vd3VwflrFtizkLCuzbhNbttQXCXqpxl36in/VL6LHdE X-Google-Smtp-Source: AGHT+IF++s7hioH3RU00kP9565ouFa1cC9Trcv0FGlZVPA0jOYjzaJ/a4JJlZzumtJUyXY6S5nbr31wzsfZD6q/EvU0= X-Received: by 2002:a05:6820:452:b0:5f6:3246:8ab7 with SMTP id 006d021491bc7-5f632468ce8mr5613716eaf.4.1734981641689; Mon, 23 Dec 2024 11:20:41 -0800 (PST) MIME-Version: 1.0 References: <06e1f1ee-74b2-43a2-9a63-da20ae455ae2@aklaver.com> <20241223201730.Horde.OJdWyIuOqgrvOVIuuahjbqS@webmail.gelassene-pferde.biz> In-Reply-To: <20241223201730.Horde.OJdWyIuOqgrvOVIuuahjbqS@webmail.gelassene-pferde.biz> From: Divyansh Gupta JNsThMAudy Date: Tue, 24 Dec 2024 00:50:28 +0530 Message-ID: Subject: Re: Need help in database design To: thiemo@gelassene-pferde.biz Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000071e3e80629f4e410" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000071e3e80629f4e410 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable The current application does not have support for that, If I go for that, it will require a lot of effort from the team which Is not possible right now. On Tue, 24 Dec 2024, 12:47=E2=80=AFam , wrote= : > 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 escribi=C3=B3: > > 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 > > --00000000000071e3e80629f4e410 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

The current application does not have support for that, If I= go for that, it will require a lot of effort from the team which Is not po= ssible right now.


On Tue, 24 Dec 2024, 12:47=E2=80=AFam , <thiemo@gelassene-pferde.biz> wrote:<= br>

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

Divyansh Gupta JNsThMAudy <ag1567827@gmail.com> escribi=C3=B3:

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

--00000000000071e3e80629f4e410--