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 1sAB6e-0082vU-Np for pgsql-general@arkaria.postgresql.org; Thu, 23 May 2024 16:15:54 +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 1sAB6e-00E9Mq-Pi for pgsql-general@arkaria.postgresql.org; Thu, 23 May 2024 16:15:52 +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 1sAB6e-00E9JO-Aj for pgsql-general@lists.postgresql.org; Thu, 23 May 2024 16:15:52 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sAB6X-000P8Q-EY for pgsql-general@lists.postgresql.org; Thu, 23 May 2024 16:15:51 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-244bdd730dcso2989782fac.0 for ; Thu, 23 May 2024 09:15:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1716480944; x=1717085744; 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=YcquGhQnFYBIDli+g08R+DXZ1vxGCCMC1hgeX6MzzN4=; b=PL43Uf81dA8SNxghqUWfoKLyxWKDsKMZulZPIuTFQP1UFCDxFLyxry9qtOeml9poMy hM3nIzSC5hkCDyP4N+xIoa6TL/bsS5fGuS5aTrIBx1WZw7MbCBm0P/zDx8UOr9sZfncZ WWdA8bWU8ynrqoO4n+FN/uzx0owjuPTmZCXqWO+g0dSUWYlHQx05pJgB8hJOVWRR+nY+ Udl+6VTgn8whIPp75lJocXFgUjVtOwNz/snIpLZ/WYibD4SNGJKX/sTVbmO3/wOvCjKg 9ddR/uVaLyYJskAXJh9iPEJcSlDkaLqUZXUb17oy15G8ftpWcqhvBYmsKGsoskTFD+yG 9gdA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1716480944; x=1717085744; 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=YcquGhQnFYBIDli+g08R+DXZ1vxGCCMC1hgeX6MzzN4=; b=CPdqO2fZoBvWT6G4yw0Dc//cY+o/fKpeTimWG6m8RC5Yb2f8P35JxT2wk+iFj0pHgG 2mgS2kkkcaVQzLqDdr6jtKxMvOIP+7eweZtFTVMWC5B46+zrjGCuMAuUIjeJySdxX3fG q5drf6bdSh8PVIXMmJHK9ZOCfMWHFaMNuT9BqBAs4yIL11JCl6x/9mJK5IJKAu/MTnci XsiHJJCmS9sDZ0eCe48Svxk5FQqVirqdsoG4WMB7tkUK+sGKADUyzLCTRsrhjfVDy151 XKmRbM1BTJLigDara7o6LV1P3q8xbnU62MP8e2sPNTsB2XEqbbRvQJZaUElD9YIk2cqP K3MQ== X-Gm-Message-State: AOJu0YzAla20P6ayd0kSSQcCZh8KZo1UDOPFB2SeMoVTVhAtivmUjoeG r/VzHEJE6OJ4Bx9YccjaeLWBUPLWVjXYutoVFvgG8sP/yJ6AcV+8SLzPTeTpzd2D+ltOe5LL5Ku V+3vl1YLUoXoNadWV455gmUGL5iQ= X-Google-Smtp-Source: AGHT+IHlKXuVezI3err5U6YYpAPX3rDWASMtbqhNWJ3xbgVlKYIyQZAw2W7tCr1pLOSsUIJvS2xTbGOTB7U5DORxJtw= X-Received: by 2002:a05:6870:a690:b0:24c:4e2f:9a55 with SMTP id 586e51a60fabf-24c68d7be47mr5740931fac.22.1716480943898; Thu, 23 May 2024 09:15:43 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "David G. Johnston" Date: Thu, 23 May 2024 10:15:35 -0600 Message-ID: Subject: Re: Json table/column design question To: Skorpeo Skorpeo Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000ecca0e0619215c15" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ecca0e0619215c15 Content-Type: text/plain; charset="UTF-8" On Thu, May 23, 2024, 10:07 Skorpeo Skorpeo wrote: > Thank you for the valuable feedback. I see people are big fans of json > here. > >> It's better for data interchange than as a basis for long term model storage. David J. --000000000000ecca0e0619215c15 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Thu, May 23, 2024, 10:07 Skorpeo Skorpeo &= lt;skorpeo11@gmail.com> wrote= :
Thank you for th= e valuable feedback.=C2=A0 I see people are big fans of json here.

It's better for data interchange than as a basis for long t= erm model storage.

David= J.


--000000000000ecca0e0619215c15--