4 ms·
Seems like a good place to ask: I just want some good GUI for data entry. For querying, command line already covers like 90% of my needs. I don't mean somethin
by patates 10y ago
Seems like a good place to ask:
I just want some good GUI for data entry. For querying, command line already covers like 90% of my needs. I don't mean something like Access for postgres or a full-fledged CMS which will mess with my beautiful, hand-crafted schema - I need just a table view with BLOB support (like choosing a file and maybe showing a preview if image) and foreign key support (like autocomplete).
Does anyone know a tool like this? I can pay - just need to be able to install it on my machine.
- sixhobbits 10y agoSomething like this maybe? https://www.mysql.com/why-mysql/windows/excel/ https://www.mysql.com/why-mysql/windows/excel/
- justinclift 10y agoAre you looking for PG specific stuff, or pretty much any kind of simple database? If non-PG is fine, then maybe sqlitebrowser.org? You'd want to grab the latest nightly though, as our foreign key constraint handling needs improvement, and there is good progress with that in the nightly builds. :)
- patates 10y agoSqlite is perfectly fine, at the very least, quite easy to to transfer the entered data to postgres. Thank you for the suggestion, I'll look into this.
- justinclift 10y agoCool. :) To view blobs, just keep the "Edit Database Cell" dock open (it's under the View menu). Any time you select a cell with an image in it, the image will be displayed in that dock. You can just leave that dock open and keep working on stuff in the main table area if you want.
- johnyzee 10y agoIf you don't mind using a web app, TeamPostgreSQL[1] has data entry for the database tables, with column-specific widgets laid out in a grid. This includes file upload/download widgets for BLOB columns, and as far as I remember even image thumbnails if the binary data is images. [1] http://www.teampostgresql.com http://www.teampostgresql.com