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

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/FkRNras ). 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/FkRNras LIVE DEMO: https://ift.tt/rj6JQFp DOCS: https://ift.tt/suaY6CT COMMUNITY: https://ift.tt/ifOtI50 WEBSITE: https:/mathesar.org/ SPONSOR US: https://ift.tt/OHd7kNc or https://ift.tt/zDxYnJ2 https://ift.tt/FkRNras March 3, 2023 at 12:04AM