News for hackers. Stuff that matters.
Re:Show HN: Selectable – mobile-friendly Postgres client by yen223 on Wednesday September 18, 2024 @04:23PM (#41585018)
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...

Re:Show HN: Selectable – mobile-friendly Postgres client by jayknight on Thursday September 19, 2024 @11:03AM (#41592662)
I'm not sure I'll ever need this, but it looks really neat.
Re:Show HN: Selectable – mobile-friendly Postgres client by dandigangi on Thursday September 19, 2024 @12:39PM (#41593700)
Full honesty - I really have a hard time seeing the need for things like this on mobile.
Re:Show HN: Selectable – mobile-friendly Postgres client by danirod on Thursday September 19, 2024 @02:10PM (#41594619)
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.
Re:Show HN: Selectable – mobile-friendly Postgres client by yen223 on Thursday September 19, 2024 @06:32PM (#41597030)
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.

Re:Show HN: Selectable – mobile-friendly Postgres client by nkrisc on Thursday September 19, 2024 @06:54PM (#41597184)
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.

Re:Show HN: Selectable – mobile-friendly Postgres client by MrLeap on Thursday September 19, 2024 @06:39PM (#41597073)
You might be a little ahead of the times, but I think you're keyed into something with this.
Re:Show HN: Selectable – mobile-friendly Postgres client by rtcoms on Friday September 20, 2024 @01:12PM (#41603870)
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.

Re:Show HN: Selectable – mobile-friendly Postgres client by ray_v on Friday September 20, 2024 @06:32PM (#41606082)
I could see myself using it from time to time ... I'm _just_ nerdy enough to even do it in public!
Re:Show HN: Selectable – mobile-friendly Postgres client by glazskunrukitis on Tuesday September 24, 2024 @05:46AM (#41634841)
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.

Re:Show HN: Selectable – mobile-friendly Postgres client by yen223 on Wednesday September 25, 2024 @10:32AM (#41647981)
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?
Re:Show HN: Selectable – mobile-friendly Postgres client by ilrwbwrkhv on Thursday September 19, 2024 @04:14PM (#41595946)
Really slick! Will try it out today.
Re:Show HN: Selectable – mobile-friendly Postgres client by iudqnolq on Friday September 20, 2024 @06:50AM (#41600662)
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.

Re:Show HN: Selectable – mobile-friendly Postgres client by yen223 on Friday September 20, 2024 @10:26AM (#41602344)
Both very good suggestions, thanks.
Re:Show HN: Selectable – mobile-friendly Postgres client by yen223 on Saturday September 21, 2024 @01:44AM (#41607775)
I've deployed a release that addresses point #1. Thanks for the feedback!