Live data from Hacker News

Show HN: Sortabase, a collaborative, visual database builder for communities

sortabase.com

21–30 of 38 posts

Re: Show HN: Sortabase, a collaborative, visual database builder for communities

#21
This is pretty cool, except that every database looks like a commerce site. It might be good to have some different layouts available that look less commercial?

There are some databases that have entries with a long text description. Putting a snippet of that up front would make that clearer. Also, a single-column layout would look more like a blog.

Compare with an archive page on Substack.

Re: Show HN: Sortabase, a collaborative, visual database builder for communities

#22

On HN months ago, I made a list [1] on publishing small databases, and I remember that I could not find a good service under "List sharing" (maybe one). Yours fills that slot perfectly. I have some suggestions: For initiating the DB, offering import (csv/sheets...) would help creators jump in. Then, for collaboration, you could offer the option to add without any account at all (just send the "under review" form to t…

I remember that post! I had commented on it, back when this project was still very early and using a different name. I agree with all your suggestions, and we've considered most of them. Importing CSVs presents some challenges, particularly with trying to infer the type and valid values of each column.

Since you did not address the monetization suggestion; I hope that there will be some mechanism to prevent open DBs to just become closed/paywalled over night. If such a premium content is implemented, similar to free software there should be clear limits to how an initiator can take the work of volunteer collaborators and privatize it.

Not sure if viable, but I would much rather prefer a kind of donation system with some kickback to valued collaborations.

Re: Show HN: Sortabase, a collaborative, visual database builder for communities

#23
post #13

Earlier quoted context omitted.

ah i meant to ask how it was designed in the backend

I won't get too deep into our architecture, but needless to say letting users dynamically edit/add/remove fields in their databases is not easy. We use Postgres + Prisma as our ORM, and I'm fairly happy with its DX re: handling this level of complexity

I would put everything in JSON(b) column since you're using Postgres anyway....

Re: Show HN: Sortabase, a collaborative, visual database builder for communities

#25

The website looks really good! For the search criteria filters, are you using a library or did you make that yourself? The closest thing I can think of is https://react-select.com/home

We're using Ant Design

https://ant.design/

Re: Show HN: Sortabase, a collaborative, visual database builder for communities

#30
post #4

We're doing something a bit similar at DoltHub, where databases are managed with a GitHub like workflow, and where you get the pros and cons of that kind of system. Our hospital price database (work ongoing daily) is community built: https://www.dolthub.com/repositories/dolthub/transparency-in... (context: https://docs.google.com/document/d/1NifwgKHBCeF35ZRZsfpgg4bE... )

What’s up with the name? A ‘dolt’ is a stupid person, at least in the English language.
Post reply on HN