News for hackers. Stuff that matters.
Re:Show HN: Sortabase, a collaborative, visual database buil... by taw1516 on Monday May 15, 2023 @02:57PM (#35952951)
ah i meant to ask how it was designed in the backend
Re:Show HN: Sortabase, a collaborative, visual database buil... by Trayja-Peter on Monday May 15, 2023 @03:51PM (#35953569)
I won't get too deep into our architecture, but needless to say letting users dynamically edit/add/remove fields in their databases is not easy. We use Postgres + Prisma as our ORM, and I'm fairly happy with its DX re: handling this level of complexity
Re:Show HN: Sortabase, a collaborative, visual database buil... by melx on Monday May 15, 2023 @04:48PM (#35954287)
I would put everything in JSON(b) column since you're using Postgres anyway....