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 1rBAG5-009gVh-O8 for pgadmin-hackers@arkaria.postgresql.org; Thu, 07 Dec 2023 09:01:25 +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 1rBAG4-00G6mJ-Bs for pgadmin-hackers@arkaria.postgresql.org; Thu, 07 Dec 2023 09:01:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rBAG4-00G6mB-4S for pgadmin-hackers@lists.postgresql.org; Thu, 07 Dec 2023 09:01:24 +0000 Received: from mail-oo1-xc33.google.com ([2607:f8b0:4864:20::c33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rBAG1-009DlI-1Y for pgadmin-hackers@postgresql.org; Thu, 07 Dec 2023 09:01:22 +0000 Received: by mail-oo1-xc33.google.com with SMTP id 006d021491bc7-589d4033e84so236919eaf.1 for ; Thu, 07 Dec 2023 01:01:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1701939680; x=1702544480; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=vcvOuBQjY4IkkaPpUqyimy4/vL7WwAPj5A1dcx+itd8=; b=NOHQ97SRASt6bfoJdgOjImdOcDJWm1nl+KdUBiYUWBnY496n8kzZ47AQoxOcVrenGi jzcdD4CgsQxoK0Yxd8nzdLsuY2CZJNWXlXnb0PgG7qNkOpRIeNRbCrjg9ohCauzK1jQ0 mPsBSmKmgTis12DLVfIi8Km0ImTPysQ3B9RY1NuXXirYkzOcqlxJUc7kfFtJdZH8Q2P+ l30t/EsWj03SGXcCNvbvQzgWb2npzo88mVX/5Ac9iyDXEvEB6I9PK0noguI2OSm4yMfs zr8GYP29OVT3/9uySqiURaV1fLHq9hi1zJ+OcOZ9yV0ZxnU5Z+IoyV/9C9/gY2ql+kpr 44pg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1701939680; x=1702544480; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=vcvOuBQjY4IkkaPpUqyimy4/vL7WwAPj5A1dcx+itd8=; b=uZo3Fg+O4zJNMsqFxm2ZvSaWeF2sXoJF13/1EfYgz4qxR4O/Ko0Ml/RcZ6oAGFQmnl kzyIRPJ4peX/0Glvc1Lga+FZG78BdArQR5uJiFUS4ANy8Ys+4dzReTXrwMXmYgphj4O5 SI5l7jCoN1V/HadrVI4qGIkuTgDsaLns2SAD3vFQSddUHXVHnY7cPN3vHsudd3NY9nuo F0VdGgS8t7bAON/J1DYFzYXxef508gpddoDtXiU8BM4JTyezAxoQOkmYbG6DGlAEVm/2 n+2uwdLMMycl9tLMn45ZPOlyN52eg11EsL+zFbn8YskDT23IJ2aPpD9wMa5b4FydkcaV IWww== X-Gm-Message-State: AOJu0Yx75wk//HDg7xP9UGQgvXhi09wf0FTYuUNr/486t5tuj4tRFmJc ifi7aien9hqwcEG8H01XTQ1dILsViWDlWYLWMF8jmxTM1d4elMe590w= X-Google-Smtp-Source: AGHT+IHyfer+QqW042MA6ha3GUkf8Ls8YpD+c3EhXTwNZPYj7Td8mhGcflrdiXseZlUg1SdRXW4TfiXcZxw/SViBAYM= X-Received: by 2002:a05:6870:1f16:b0:1fb:75b:99bd with SMTP id pd22-20020a0568701f1600b001fb075b99bdmr2465845oab.108.1701939680037; Thu, 07 Dec 2023 01:01:20 -0800 (PST) MIME-Version: 1.0 From: Aditya Toshniwal Date: Thu, 7 Dec 2023 14:30:44 +0530 Message-ID: Subject: Regarding improving layout for ERD To: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000000ee2c4060be7b630" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000ee2c4060be7b630 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Hackers, In ERD, the link between tables starts and ends on the exact columns. But it is actually creating more problems than helping in terms of viewing the diagram and tracing the links. There is no concrete algo for auto layouting with precise column links. I propose we=E2=80=99ll need to change how links connect to tables in ERD. = Almost all tools available for ERD sides of the table for connecting and not precise columns and we should do the same. For comparison - https://github.com/pgadmin-org/pgadmin4/issues/6592#issuecomment-1842844847 Thoughts/Suggestions? --=20 Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* "Don't Complain about Heat, Plant a TREE" --0000000000000ee2c4060be7b630 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

In ERD, the link between tables starts and end= s on the=C2=A0exact columns. But it=C2=A0is=C2=A0actually creating more pro= blems than helping in=C2=A0terms of viewing the=C2=A0diagram and tracing th= e links. There is no concrete algo for auto layouting with precise column l= inks.
I propose we=E2=80=99ll need to change how links connect to tables in= ERD. Almost all tools available for ERD sides of the table for connecting = and not precise columns and we should do the same.

Thoughts/Suggestions?

--
<= font size=3D"2" color=3D"#000000" face=3D"arial, sans-serif">Thanks,=
Aditya Toshniwal
pg= Admin Hacker=C2=A0| Sr. Software Architect=C2=A0| enterprisedb.com
"Don't= Complain about Heat, Plant a TREE"
--0000000000000ee2c4060be7b630--