Our live demo is having trouble keeping up with traffic; we're spinning up a load balancer right now and the server will be down temporarily. I'll edit this post when it's fixed. EDIT: demo server is back up.
[dead]
Show HN: Mathesar – open-source collaborative UI for Postgres databases
21–30 of 80 posts
Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases
#22[deleted]
Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases
#23[deleted]
[deleted]
Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases
#24The 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.
Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases
#25Nice 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.
https://github.com/beekeeper-studio/beekeeper-studio is pretty decent.
Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases
#26I'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?
Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases
#27I'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.
Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases
#28Love the reference to GalaxyQuest. (Mathesar was the Thermian leader.)
Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases
#29Earlier quoted context omitted.
Could you elaborate that a bit? That sounds interesting too.
Yes! We have set up a Postgres template database[1] with our demo data sets. When a user logs in, we create a new database based on the template database and associate the database with the session key set up for that login. So every session is associated with a different database and we have some Django middleware that routes you to the URL associated with your session's database. If you log out and log back in (thu…
How on earth are you handling HN front page traffic if you spin up a template copy per session? That is impressive.
Re: Show HN: Mathesar – open-source collaborative UI for Postgres databases
#30Earlier quoted context omitted.
Yes! We have set up a Postgres template database[1] with our demo data sets. When a user logs in, we create a new database based on the template database and associate the database with the session key set up for that login. So every session is associated with a different database and we have some Django middleware that routes you to the URL associated with your session's database. If you log out and log back in (thu…
How on earth are you handling HN front page traffic if you spin up a template copy per session? That is impressive.
You’d be (pleasantly) surprised how easy it is to copy a postgres database. It literally copies the data files for the database to a new directory so the operation is relatively quick if the total volume of data is not large.
What’s more challenging is handling many concurrent connections as a different database would mandate a separate connection and you can’t perform any meaningful connection pooling.