Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Mathesar – open-source collaborative UI for Postgres databases

github.com

Post reply on HN
Print view View original

1–10 of 80 posts

Show HN: Mathesar – open-source collaborative UI for Postgres databases

#1

Post by kgodey »

Hi HN! We just released the public alpha version of Mathesar (https://mathesar.org/, code: https://github.com/centerofci/mathesar).

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://github.com/centerofci/mathesar

LIVE DEMO: https://demo.mathesar.org/

DOCS: https://docs.mathesar.org/

COMMUNITY: https://wiki.mathesar.org/en/community

WEBSITE: https:/mathesar.org/

SPONSOR US: https://github.com/sponsors/centerofci or https://opencollective.com/mathesar

Show HN: Mathesar – open-source collaborative UI for Postgres databases
github.com

Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases

#3

Post by seancolsen »

debarshri wrote: post #2

Interesting how there are some airtable inspired UI elements combined with postgres. Super interesting, will definitely use it. PS. I would recommend making the demo account ready-only.

(Mathesar core team member here.) Thanks for the kind words! Our demo server actually spins up a unique database for each session, giving you the capability to make changes to the database and try Mathesar's features to the fullest extent. Your changes are only visible to you unless you send the link to someone else.

Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases

#6

Post by vhanda »

vladsanchez wrote: post #5

So happy to realize your stack includes Python, Postgres, Typescript and Svelte because I once flirted with such idea for a personal project. I'm inspired.

If I may ask, have you found using a Typed language such as Typescript has changed your tendency to use Python for other tasks, given that it isn't typed? [0]

[0] - I understand that types can be added on top, but I never found the integration to work that well with mypy when I last tried it many years ago.

Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases

#7

Post by debarshri »

seancolsen wrote: post #3
debarshri wrote: post #2

Interesting how there are some airtable inspired UI elements combined with postgres. Super interesting, will definitely use it. PS. I would recommend making the demo account ready-only.

(Mathesar core team member here.) Thanks for the kind words! Our demo server actually spins up a unique database for each session, giving you the capability to make changes to the database and try Mathesar's features to the fullest extent. Your changes are only visible to you unless you send the link to someone else.

Could you elaborate that a bit?

That sounds interesting too.

Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases

#8

Post by erinnh »

vhanda wrote: post #6
vladsanchez wrote: post #5

So happy to realize your stack includes Python, Postgres, Typescript and Svelte because I once flirted with such idea for a personal project. I'm inspired.

If I may ask, have you found using a Typed language such as Typescript has changed your tendency to use Python for other tasks, given that it isn't typed? [0] [0] - I understand that types can be added on top, but I never found the integration to work that well with mypy when I last tried it many years ago.

Lots of stuff has changed for typed Python over the last few years. (starting with 3.7, but picking up with 3.8)
Post reply on HN