HN Explorer

Show HN: Slashbase – open-source collaborative IDE for databases in browser (github.com)

89 points by paraswaykole ↗ HN
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.

23 comments

[ 3.0 ms ] story [ 63.4 ms ] thread
[deleted]
(comment deleted)
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

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
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.
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
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

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
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.
ravivyas
What got you interested in building something like this?
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.

mritchie712
I also like tableplus. small team charging a reasonable fee for a great product.
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.
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