Show HN: Slashbase – open-source collaborative IDE for databases in browser

[paraswaykole]

Hello HN! My name is Paras and I am building this project called Slashbase. It's an open-source collaborative IDE for databases in browser. Connect to your database, browse data, run a bunch of queries or share queries within your team, right from your browser. Works with two types of databases: PostgreSQL and MongoDB.

It's written in Golang and Nextjs React Framework and runs as a single binary.

Features:

- Cloud based: Setup on your server. Works in browser.

- Easy to use: with minimal interface it is simple to use.

- Collaborative: Works with your teams. Easy sharing queries within team.

- Database Support: Works with two types of databases: PostgreSQL and MongoDB.

It's in beta phase and all I am looking for is some users who want to try it out and drop some feedback in comments.

[vichle]

Looks promising. There are a couple of things that worries me though. (I haven't tried it yet, only skimmed the docs)

1. Telemetry needs to be opt-in during install. 2. The roles are weird, why would a developer need write access by default? That's just a recipe for disaster. Would be better to default to read-only in all roles and allow upgrading to write permission as an active choice. 3. There needs to be a clear way to distinguish between prod/staging. I like clients where you can change the background color for different connections, eg screaming red for prod.

Good luck, keep up the good work

[db3pt0]

Not only should telemetry be optional, but a failure to send it should not result in the application refusing to run¹. With a host-level block of PostHog, the server crashes with:

Post "https://app.posthog.com/capture/": dial tcp x.x.x.x:443: connect: connection refused

1: https://github.com/slashbaseide/slashbase/blob/a7cb7871b07a9...

[paraswaykole]

thanks for pointing out. will be fixed.

[paraswaykole]

Thanks for the awesome suggestions. On point 2, I had removed the roles part from the software code, since it was absurd at the moment. Just need to update the same in docs.

[mmaia]

+1 on the opt-in telemetry

[paraswaykole]

agreed. will make it opt-in telemetry.

[ZiggerZZ]

Hey!

Just a few weeks ago I was searching for such a solution (IDE for databases in browsers without viz) and I found a bit old but still very good and simple to use project https://github.com/sqlpad/sqlpad/ I set it up for our company yesterday and it works great

[mftb]

I see (on the architecture page) Slashbase uses SQLite to store it's own app data, but it doesn't support SQLite as the target database? Is there some particular reason?

[paraswaykole]

no particular reason.

[csdvrx]

You may want to add it, as it could give a simple backend backed into the binary, so it would be fully standalone: it could just create and use a file.sqlite

[reassembled]

I just want to add a plug for the very awesome DBeaver, a cross platform native GUI front end which supports pretty much every major database format.

I use it every day on Windows and Linux for viewing and editing SQLite and PSQL databases. I've also used it to dump and restore tables in a pinch. It supports dumping and importing tables in a multitude of formats, including JSON and plain SQL statements.

[bbkane]

The two open source SQL IDEs I really like are https://www.beekeeperstudio.io/ and https://dbgate.org/ . Both very nice for my somewhat simple querying needs

[mritchie712]

I also like tableplus. small team charging a reasonable fee for a great product.

[jacquesc]

Looks super useful, and brings me back to the days of installing phpMyAdmin on all my servers

Browsing through the docs, is there some kind of authentication that could be done in app? Would need to figure out how to keep things protected and only accessible by a few people.

[paraswaykole]

yes, right now basic authentication is available for multiple users.

[ako]

Since this is an IDE I wonder what your idea is for version control? In my opinion a database should be considered a deployment container, not a place where you’d normally do live development.

[mmaia]

Very interesting project. Looks like you are going in the direction of an open source PopSQL instead of something like dbeaver and I really like it.

[swyx]

very cool :) love the docs

may i ask why you started working on such a project? am interested in motivations and what gaps you see in the market

[gbear605]

Do you have plans for extending it to other databases in the future (eg. MySQL)?

[paraswaykole]

yes! I do have plans for adding other databases.

[Gys]

Do you have a time path? I am also interested in mysql

[ravivyas]

What got you interested in building something like this?