Comment by yen223

Comment by yen223 a year ago

14 replies

I've built Selectable - a freemium Postgres client for Android devices. It's currently available for open testing, links below.

The key feature is the SQL query editor. The query editor was designed to be mobile-friendly. With autocomplete and a touch-friendly way to select parts of a SQL query, writing SQL statements with the query editor can - in some cases - be faster than typing the same query on a desktop.

The app supports the usual SQL client things:

- Browsing schemas, tables, and columns

- Running custom SQL statements

- Viewing results as a list, or as a table.

- Exporting results to CSV

- Saving queries (You can save one query in the free version)

The project is in very early stages, and is still missing a lot of features - notably the ability to insert, update, delete, or perform DDL via the query editor.

The app currently only supports Postgres, and is currently only available on Android.

Please give it a spin, and let me know if you have any feedback or feature requests.

Website: https://getselectable.com/

Play store: https://play.google.com/store/apps/details?id=net.weiyen.sel...

dandigangi a year ago

Full honesty - I really have a hard time seeing the need for things like this on mobile.

  • yen223 a year ago

    This is a very fair point.

    I'm not trying to replace desktops with mobile here. I think database administration is still going to be easier with a big monitor and a keyboard, and that's not going to change.

    Rather I'm trying to open up database administration to people who don't have desktops, or who are more comfortable working on their phones.

    • nkrisc a year ago

      Or sometimes a phone is what you have and you need access.

      Looks like very nice UI model, it’s not an easy problem to solve. Also one of the few times a portrait YT video is wholly appropriate.

    • MrLeap a year ago

      You might be a little ahead of the times, but I think you're keyed into something with this.

  • glazskunrukitis a year ago

    I, as an indie hacker/developer, have had countless times where I need to access db from mobile. I have even logged in via terminal to get to psql.

    Sadly this specific app doesn't seem very polished or useful.

    • yen223 a year ago

      Hi, developer of the app here. If you don't mind me asking, what is the biggest thing missing from the app that keeps it from being useful?

  • rtcoms a year ago

    People can mirror mobile screen to TV/Monitor and still use it.

    With the tri-fold mobiles and Samsung Dex like feature coming, that day may not be far when mobile become the single work machine.

  • danirod a year ago

    I suppose having quick access to a database in case of emergency without having to rush to a computer, similar to how some people treat having SSH clients on their phones.

  • ray_v a year ago

    I could see myself using it from time to time ... I'm _just_ nerdy enough to even do it in public!

iudqnolq a year ago

I like it. A few suggestions;

- When in the table explorer it's odd that the primary action - viewing a table - is behind a dropdown menu. maybe clicking the table name opens the browse rows screen and clicking a column opens with a select prefilled.

- Please default to a limit 500 or something like Jetbrains to prevent me making stupid mistakes.

  • yen223 a year ago

    I've deployed a release that addresses point #1. Thanks for the feedback!

jayknight a year ago

I'm not sure I'll ever need this, but it looks really neat.