Comment by yen223

Comment by yen223 10 months ago

14 replies

View on Hacker News

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 10 months ago

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

Reply View 8 replies
  • yen223 10 months 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.

    Reply View 2 replies
    • nkrisc 10 months 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.

      Reply View 0 replies
    • MrLeap 10 months ago

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

      Reply View 0 replies
  • glazskunrukitis 10 months 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.

    Reply View 1 reply
    • yen223 10 months 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?

      Reply View 0 replies
  • rtcoms 10 months 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.

    Reply View 0 replies
  • danirod 10 months 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.

    Reply View 0 replies
  • ray_v 10 months ago

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

    Reply View 0 replies
iudqnolq 10 months 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.

Reply View 2 replies
  • yen223 10 months ago

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

    Reply View 0 replies
  • yen223 10 months ago

    Both very good suggestions, thanks.

    Reply View 0 replies
jayknight 10 months ago

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

Reply View 0 replies