Mathesar
Data
database user interface
SHOW HN2023
281points
74comments
#167of 3,109 in 2023
Top 6%of 2023 by points
How HN took it
CuriousMostly questions and neutral comments
15 positive, 25 neutral or asking, 0 mixed, 4 critical, out of 44 comments about the project. Thread score +0.32.
Idea: 4 for, 1 againstDesign: 3 for, 0 againstPrivacy: 1 for, 2 againstExecution: 1 for, 1 againstPerformance: 1 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Schema migrations and relationship explanations are well designed
From 2 comments
The schema migrations are a delight. And I appreciate the shoutout to Dabble! Thanks for working on this + congrats on the release. An optimized hosted version with permalinks to…
metasj on HNWow, this is the best explanation of db relationship types I've seen. https://capture.dropbox.com/A3a1aybKNDy1ttEx Really polished. Congrats on the launch!
nickreese on HN
Airtable-like UX for relational data is welcome
From 2 comments
This is super cool! I really dig the way airtable makes relational databases accessible to non-developers, but I've been looking for open source alternatives. Going to give this…
jtr1 on HNInteresting 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…
debarshri on HN
Clean local dev docs
From 1 comment
Their local development docs is also nice: https://docs.mathesar.org/contributing/local-dev/ I'm jumping into a django/react project right now and found that there's so much…
Existenceblinks on HN
Objections
Install script requires elevated privileges via Docker
From 2 comments
Looks really cool! I tried the install script and it asked me for my computer password. It feels really dangerous to give a random script from the internet my password. Could you…
hebrox on HNAt the moment, the only installation method we support uses Docker, which requires elevated privileges on most systems. We're probably going to reduce the privileges needed for…
mathemancer on HN
Lacks granular permissions for restricted database users
From 2 comments
Looks cool however I don’t like that it needs to be setup with a super-user and that it’s limited to your three predetermined access roles. I have a project in mind where this…
hultner on HNWe completely understand. We want to have the ability for Mathesar to gracefully handle DB users with different permissions (i.e. we'd disable features in the UI based on the…
kgodey on HN
Some file uploads failed on large datasets
From 2 comments
Tried tossing in some of the datasets found here: https://data.cms.gov/provider-data/archived-data/nursing-homes and none of the file uploads worked. Either way, really stoked…
nickreese on HNWe tested importing the files from the link and right on, some of the imported tables do not seem to work as expected. You've just helped us discover a bug. Here's the issue that…
pavish on HN
Requests
Install without Docker
From 2 comments
Thanks for the explanation. Is there a way to NOT use docker. For those of us who are NOT on linux, and are quite comfortable with postgres install and running. Would prefer just…
x98asfd on HNTo add to what silentninja said, we are already deploying Mathesar without Docker on some test servers, we just need to document our setup. Coming soon!
kgodey on HN
Export explorations as SQL
From 1 comment
Looks really nice. Is there any way to export an exploration as SQL? I guess this can be useful when creating complicated views etc.
victorbjorklund on HN
Historical record tracking
From 1 comment
I won't repeat supportive comments except to say well done. Feature request: historical tracking. E.g. on update, expire the old record with who & when.
mrslave on HN
Airtable-style interface designer
From 1 comment
Apologies, somehow missed that. Thanks for the speedy response. Your explanation is very clear. Something that is keeping me tied to Airtable is their 'interface designer'.…
ryan_platofy on HN
Questions
How the demo handles per-session databases
From 2 comments
Could you elaborate that a bit? That sounds interesting too.
debarshri on HNHow on earth are you handling HN front page traffic if you spin up a template copy per session? That is impressive.
xupybd on HN
How it differs from NocoDB
From 1 comment
This looks great and congratulations on the alpha launch! Reminds me of another open source project in this space, NocoDB. Are you guys familiar with that project? If so, what…
ryan_platofy on HN
Alternatives named
NocoDB
From 1 comment
This looks great and congratulations on the alpha launch! Reminds me of another open source project in this space, NocoDB. Are you guys familiar with that project? If so, what…
ryan_platofy on HN
TablePlus
From 2 comments
Nice work! It looks like Sequel Pro for Postgres. This might be the first free, user-friendly interface for Postgres out there. Closest would be TablePlus but it’s paid.
cadbox1 on HNtableplus is freemium like. in the free version can have 2 tabs open. it also works with way more than postgres.
minusf on HN
Beekeeper Studio
From 1 comment
https://github.com/beekeeper-studio/beekeeper-studio is pretty decent.
phamilton on HN
Airtable
From 1 comment
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…
debarshri on HN
Dabble DB
From 1 comment