Live data from Hacker News

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

github.com

41–50 of 80 posts

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

#41
post #28

Love the reference to GalaxyQuest. (Mathesar was the Thermian leader.)

Haha, yes!

We also intend to release our Svelte component-library as a separate package and considering if we should establish a GalaxyQuest theme when naming it, perhaps Laliari.

Here's the discussion: https://github.com/centerofci/mathesar/discussions/833

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

#42
post #6

Earlier quoted context omitted.

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.

Typescript has made me stop loving Python. I wish Python typing was powerful enough to be as complete as TS.

Vanilla JS is just fine.

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

#43
post #37

Not to distract from this project — it's very cool! — but I'd love to know if there's something similar in principle to this, but that's focused less on collaborative querying , and more on collaborative database administration . Specifically, I've been in the market for a while now for a webapp you can run on a server, that presents a UX for submitting, watching the progress, and managing, long-running schema change…

Mongo's Ops Manager is kind of like this with all its automation (managing machines, shards, index rollouts, etc) and monitoring, but not really the long running query part (there is a profiler though).

It's also not free and breaks in all kinds of fun ways.

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

#44
post #26

I'm sorry if this question is stupid, I'm still learning a little about technology. The little bit of knowledge I have tells me that my product team shouldn't directly access the same production database as my application. The idea for this product would be to create a copy of my production base and give access to it through this tool? Wouldn't the cost of this replica be too expensive?

You’re actually right. You don’t want people to edit the DB or schema in this manner.

Schema migrations should go via CI/CD and data changes via your app.

Otherwise it’s gets messy indeed.

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

#45
post #26

I'm sorry if this question is stupid, I'm still learning a little about technology. The little bit of knowledge I have tells me that my product team shouldn't directly access the same production database as my application. The idea for this product would be to create a copy of my production base and give access to it through this tool? Wouldn't the cost of this replica be too expensive?

In my experience in tech, most teams directly access and manipulate production frequently. Bigger companies usually have restrictions on this but in the start up world not so much.

That’s a big red flag if those teams are not engineering teams. Don’t you have CI CD pipelines setup with something like flyway?

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

#47
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 are the main differences between them and what you are offering?

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

#48
post #46

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.

Thank you! We're glad to take your feature request into consideration.

We have had discussions regarding auditing in Mathesar[1], though it's not explicitly documented in the roadmap yet. We do have plans to implement Undo & Redo support for data editing operations in our roadmap[2] which would depend on the auditing implementation.

[1] https://github.com/centerofci/mathesar/discussions/113#discu... [2] https://mathesar.org/roadmap.html

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

#49

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 are the main differences between them and what you are offering?

Thank you!

We've documented the differences between Mathesar and other similar products including NocoDB on the FAQ section[1] in our website.

[1] https://mathesar.org/faq.html#how-is-mathesar-different-from...

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

#50
post #24

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 Explorer views would open access to even more users.

Thank you!

A hosted version is definitely on our plans for Mathesar, and being able to share tables and explorations publicly via a permalink is part of our roadmap[1][2].

[1] https://mathesar.org/roadmap.html [2] https://github.com/centerofci/mathesar/discussions/2266

Post reply on HN