6 ms·

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

89 points by paraswaykole 4y ago

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.

gbear605 4y ago
Do you have plans for extending it to other databases in the future (eg. MySQL)?
- paraswaykole 4y ago
  yes! I do have plans for adding other databases.
  - Gys 4y ago
    Do you have a time path? I am also interested in mysql
deleted 4y ago
[deleted]
swyx 4y ago
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 4y ago
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 4y ago
  no particular reason.
  - csdvrx 4y ago
    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 4y ago
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 4y ago
  yes, right now basic authentication is available for multiple users.
vichle 4y ago
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 4y ago
  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 4y ago
  +1 on the opt-in telemetry
  - paraswaykole 4y ago
    agreed. will make it opt-in telemetry.
- db3pt0 4y ago
  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/ https://app.posthog.com/capture/": dial tcp x.x.x.x:443: connect: connection refused 1: https://github.com/slashbaseide/slashbase/blob/a7cb7871b07a978009b649ccc55f0858e1325188/internal/tasks/cron.go#L42-L47 https://github.com/slashbaseide/slashbase/blob/a7cb7871b07a9...
  - paraswaykole 4y ago
    thanks for pointing out. will be fixed.
ako 4y ago
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 4y ago
What got you interested in building something like this?
reassembled 4y ago
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 4y ago
  I also like tableplus. small team charging a reasonable fee for a great product.
- bbkane 4y ago
  The two open source SQL IDEs I really like are https://www.beekeeperstudio.io/ https://www.beekeeperstudio.io/ and https://dbgate.org/ https://dbgate.org/ . Both very nice for my somewhat simple querying needs
mmaia 4y ago
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 4y ago
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/ https://github.com/sqlpad/sqlpad/ I set it up for our company yesterday and it works great

89 points by paraswaykole 4y ago

gbear605 4y ago

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

paraswaykole 4y ago
yes! I do have plans for adding other databases.
- Gys 4y ago
  Do you have a time path? I am also interested in mysql

deleted 4y ago

[deleted]

swyx 4y ago

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 4y ago

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 4y ago
no particular reason.
- csdvrx 4y ago
  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 4y ago

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 4y ago
yes, right now basic authentication is available for multiple users.

vichle 4y ago

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 4y ago
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 4y ago
+1 on the opt-in telemetry
- paraswaykole 4y ago
  agreed. will make it opt-in telemetry.
db3pt0 4y ago
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/ https://app.posthog.com/capture/": dial tcp x.x.x.x:443: connect: connection refused 1: https://github.com/slashbaseide/slashbase/blob/a7cb7871b07a978009b649ccc55f0858e1325188/internal/tasks/cron.go#L42-L47 https://github.com/slashbaseide/slashbase/blob/a7cb7871b07a9...
- paraswaykole 4y ago
  thanks for pointing out. will be fixed.

ako 4y ago

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 4y ago

What got you interested in building something like this?

reassembled 4y ago

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 4y ago
I also like tableplus. small team charging a reasonable fee for a great product.
bbkane 4y ago
The two open source SQL IDEs I really like are https://www.beekeeperstudio.io/ https://www.beekeeperstudio.io/ and https://dbgate.org/ https://dbgate.org/ . Both very nice for my somewhat simple querying needs

mmaia 4y ago

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 4y ago

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/ https://github.com/sqlpad/sqlpad/ I set it up for our company yesterday and it works great