Skip to main content

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

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/l5SbsAI ). 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/l5SbsAI LIVE DEMO: https://ift.tt/jK5kYnq DOCS: https://ift.tt/3XkIOeJ COMMUNITY: https://ift.tt/SFKg68q WEBSITE: https:/mathesar.org/ SPONSOR US: https://ift.tt/XWF5A4x or https://ift.tt/kWflNyi https://ift.tt/l5SbsAI March 3, 2023 at 12:34AM

Comments

Popular posts from this blog

Show HN: KittenDNS – easy to setup, rule engine, LetsEncrypt compatible https://ift.tt/JEbrc0i

Show HN: KittenDNS – easy to setup, rule engine, LetsEncrypt compatible My goal was to create a DNS server as simple as the LDAP server I've been contributing to (glauth) and here it is: https://ift.tt/i6S4IHQ A few things to know about it: - It is easy to configure using a Toml file - I am using it to bail my coredns/etcd instances when under attack - (yes, it also works as a service location server) - It comes with a simple, plain English, rule engine that doesn't do much at this point - It can be used with LetsEncrypt. I use it to retrieve certificates for my home servers. - RFC: all the nice ones :) Anyway, feedback is welcome. May 16, 2022 at 03:34AM