5 ms·

Hey folks, This is a passion project from myself and a friend. Been looking for a slick and easy to use SQL client on Linux for a while (I wanted basically Se

Hey folks, This is a passion project from myself and a friend. Been looking for a slick and easy to use SQL client on Linux for a while (I wanted basically Sequel Pro, on Linux, for PSQL). Couldn't find what I wanted, so we made one ourselves. It's built on Electron using Vue.js - I know HN opinions on electron apps, but I've been surprised on how snappy the app is. It's fully open source (MIT), cross-platform (Linux, Mac, and Windows), and we're committed to respecting privacy. Hope someone else finds it useful too.

sreekotay 6y ago
Quite cool! Nice work :) Why an app vs. full hosted given it's Electron?
- mjamil 6y ago
  Perhaps to live up to the stated commitment that an internet connection isn’t required.
- rathboma 6y ago
  I've built both! My personal frustration was the lack of a simple SQL client on Linux. So here we are :-)
mappu 6y ago
> I wanted basically Sequel Pro, on Linux, for PSQL Have you seen http://sequeljoe.ohwg.net/ http://sequeljoe.ohwg.net/ ? I'm also following https://github.com/ragnar-lodbrok/meow-sql https://github.com/ragnar-lodbrok/meow-sql closely, a C++/Qt port of the FOSS-but-Windows-only https://www.heidisql.com/ https://www.heidisql.com/ . But neither of these are really "fully baked" options. EDIT: This may have come across as the typical HN "middlebrow dismissal" so I just want to say, phenomenal work and a heartfelt thanks for being fully FOSS. Tools like this are a really important part of the SWE landscape that could use some more good entrants.
- lykr0n 6y ago
  HeidiSQL works really well under Wine. I would still be using it
- rathboma 6y ago
  Thanks!
- jstewartmobile 6y ago
  HeidiSQL on Wine, seconded.
arjunbajaj 6y ago
Hey, it would be great if you published it to AUR (Arch Linux)!
- rathboma 6y ago
  Hoping to! It's built with electron-builder and there's no plugin for aur yet, so will have to manually figure it out. I'm very pro Linux.
  - arjunbajaj 6y ago
    I tried out your app, and it's awesome! Simple and solves my need. Can you add a setting to zoom?
    - rathboma 6y ago
      Working on it!
jacek 6y ago
Thank you for your work. I just installed your app and it is working well.
nicoburns 6y ago
I have a couple of feature requests that nothing else seems to be able to do: 1. Parameterised queries (ideally with an ability to customise the syntax for the placeholders - we use :param for named parameters). All of our production queries are parameterised, and it would be awesome to be able to copy and paste them into this kind of tool, and run them unmodified. Especially as they sometimes use the same parameter in multiple places, so updating them. 2. A full editor control (e.g. Code Mirror, Monaco, or Ace) for editing SQL queries. Specifically I really want multiple cursors for editing queries quickly and efficiently.
- dewey 6y ago
  Just in case you are not aware of it, DataGrip can do all these things: https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/
  - davedx 6y ago
    I use Rider daily and pay for it, but I found the price tag for DataGrip to be pretty steep considering what I typically use a SQL client for (running ad hoc queries mostly). The competition is not great on MacOS either so I've been using Azure Data Studio and dbBeaver mostly and not really happy with this state of affairs either. Excited to see a fresh new attempt in this space.
    - rathboma 6y ago
      I like a lot of the paid tools, but I just feel like open databases deserve open tools. DBeaver is great for DBAs.
    - manzu 6y ago
      Rider comes with DB tools on par with DataGrip included. Same for PHPStorm. The exception si WebStorm and maybe other smaller ones
  - fullstackchris 6y ago
    hopping on the train here - does anyone know an editor that can do editing of postgres enums? (i know you can't 'edit' an enum in postgres, but i would love a GUI that would 'allow' this. (i.e. in the background DROP CASCADE the enum, create a new one with the same name and new value, as well as restoring to previous dependencies that the old enum had)
zerr 6y ago
Passion aside, how do you plan to monetize?
- rathboma 6y ago
  There are plenty of opportunities to monetize once there are lots of users. I think with FOSS it's more important to outline how I'm NOT going to monetize. For us that means never charging for core features, eg having 'CE' vs 'EE', and never doing anything sketch with personal data.
  - stephenr 6y ago
    > There are plenty of opportunities to monetize once there are lots of users. > never doing anything sketch with personal data. Does not compute.

sreekotay 6y ago

Quite cool! Nice work :) Why an app vs. full hosted given it's Electron?

mjamil 6y ago
Perhaps to live up to the stated commitment that an internet connection isn’t required.
rathboma 6y ago
I've built both! My personal frustration was the lack of a simple SQL client on Linux. So here we are :-)

mappu 6y ago

> I wanted basically Sequel Pro, on Linux, for PSQL Have you seen http://sequeljoe.ohwg.net/ http://sequeljoe.ohwg.net/ ? I'm also following https://github.com/ragnar-lodbrok/meow-sql https://github.com/ragnar-lodbrok/meow-sql closely, a C++/Qt port of the FOSS-but-Windows-only https://www.heidisql.com/ https://www.heidisql.com/ . But neither of these are really "fully baked" options. EDIT: This may have come across as the typical HN "middlebrow dismissal" so I just want to say, phenomenal work and a heartfelt thanks for being fully FOSS. Tools like this are a really important part of the SWE landscape that could use some more good entrants.

lykr0n 6y ago
HeidiSQL works really well under Wine. I would still be using it
rathboma 6y ago
Thanks!
jstewartmobile 6y ago
HeidiSQL on Wine, seconded.

arjunbajaj 6y ago

Hey, it would be great if you published it to AUR (Arch Linux)!

rathboma 6y ago
Hoping to! It's built with electron-builder and there's no plugin for aur yet, so will have to manually figure it out. I'm very pro Linux.
- arjunbajaj 6y ago
  I tried out your app, and it's awesome! Simple and solves my need. Can you add a setting to zoom?
  - rathboma 6y ago
    Working on it!

jacek 6y ago

Thank you for your work. I just installed your app and it is working well.

nicoburns 6y ago

I have a couple of feature requests that nothing else seems to be able to do: 1. Parameterised queries (ideally with an ability to customise the syntax for the placeholders - we use :param for named parameters). All of our production queries are parameterised, and it would be awesome to be able to copy and paste them into this kind of tool, and run them unmodified. Especially as they sometimes use the same parameter in multiple places, so updating them. 2. A full editor control (e.g. Code Mirror, Monaco, or Ace) for editing SQL queries. Specifically I really want multiple cursors for editing queries quickly and efficiently.

dewey 6y ago
Just in case you are not aware of it, DataGrip can do all these things: https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/
- davedx 6y ago
  I use Rider daily and pay for it, but I found the price tag for DataGrip to be pretty steep considering what I typically use a SQL client for (running ad hoc queries mostly). The competition is not great on MacOS either so I've been using Azure Data Studio and dbBeaver mostly and not really happy with this state of affairs either. Excited to see a fresh new attempt in this space.
  - rathboma 6y ago
    I like a lot of the paid tools, but I just feel like open databases deserve open tools. DBeaver is great for DBAs.
  - manzu 6y ago
    Rider comes with DB tools on par with DataGrip included. Same for PHPStorm. The exception si WebStorm and maybe other smaller ones
- fullstackchris 6y ago
  hopping on the train here - does anyone know an editor that can do editing of postgres enums? (i know you can't 'edit' an enum in postgres, but i would love a GUI that would 'allow' this. (i.e. in the background DROP CASCADE the enum, create a new one with the same name and new value, as well as restoring to previous dependencies that the old enum had)

zerr 6y ago

Passion aside, how do you plan to monetize?

rathboma 6y ago
There are plenty of opportunities to monetize once there are lots of users. I think with FOSS it's more important to outline how I'm NOT going to monetize. For us that means never charging for core features, eg having 'CE' vs 'EE', and never doing anything sketch with personal data.
- stephenr 6y ago
  > There are plenty of opportunities to monetize once there are lots of users. > never doing anything sketch with personal data. Does not compute.