Show HN: Mathesar – open-source collaborative UI for Postgres databases https://ift.tt/tasN6FM

Show HN: Mathesar – open-source collaborative UI for Postgres databases Hi HN! We just released the public alpha version of Mathesar ( https://mathesar.org/ , code: https://ift.tt/4j9roUB ). Mathesar is an open source tool that provides a spreadsheet-like interface to a PostgreSQL database. I was originally inspired by wanting to build something like Dabble DB. I was in awe of their user experience for working with relational data. There’s plenty of “relational spreadsheet” software out there, but I haven’t been able to find anything with a comparable UX since Twitter shut Dabble DB down. We're a non-profit project. The core team is based out of a US 501(c)(3). Features: * Built on Postgres : Connect to an existing Postgres database or set one up from scratch. * Utilizes Postgres Features : Mathesar’s UI uses Postgres features. e.g. "Links" in the UI are foreign keys in the database. * Set up Data Models : Easily create and update Postgres schemas and tables. * Data Entry : Use our spreadsheet-like interface to view, create, update, and delete table records. * Data Explorer : Use our Data Explorer to build queries without knowing anything about SQL or joins. * Schema Migrations : Transfer columns between tables in two clicks in the UI. * Custom Data Types :: Custom data types for emails and URLs (more coming soon), validated at the database level. Links: CODE: https://ift.tt/4j9roUB LIVE DEMO: https://ift.tt/lyXfL6v DOCS: https://ift.tt/xwtpdEl COMMUNITY: https://ift.tt/hwneLAV WEBSITE: https:/mathesar.org/ SPONSOR US: https://ift.tt/vkzANQ9 or https://ift.tt/7sCv2BD https://ift.tt/4j9roUB March 3, 2023 at 12:04AM