(A bit )off topic - chatGPT managed to infer your email address based on this comment. Required some hints though - most likely due to my lack of experience (first try).
I was curious to see how it can improve indexing in general.
You’re absolutely right, as myowz pointed out, it was ignored with G/Alphabet, but it would funnily confusing to say “He works for a MANGA (or MAAAN) company” to someone…
I once used FDW to synchronize Microsoft SQL server DB with PostreSQL, after setting up, It was just a matter of a single UPDATE to sync quite complex data across systems. It isn’t a perfect way, but given there was no public interface in MS SQL backed application it was a pretty effective solution.
I know, but when I look at a table structure in PgAdmin, all newly added columns appear at the end, of course this can handled properly in select col2, col1... , or by creating a view, but by any other way as this wiki [1] page says.
But during development, ability to create logical column order is somehow important to me.
I know it doesn't matter to some developers out there, but for me, the only thing left is the ability to add a column after another one. Even if it's only logical order, it's easier for me to read a table structure when fields are ordered nicely.
After defining 3 tables with related records, some thoughts:
- Trying to enter some records, I pressed space in the checkbox column, "zoom view" appeared instead of changing the value (enter changes the value), I understand that this is a convention in your system, but what's the point of the zoome checkbox? :)
- Detail view shows checkbox columns, as checkbox - name and another value-changing checkbox below, waste of space - record with 4 column takes almost all modal window.
- Changing value of checkbox with enter, disallows submitting detail view, so there is no submit, but then I cannot simply discard changes made in the detail view, when I press ESC - data still changes. To revert changes, I had to press ctrl-z several times.
- I noticed that of the entered characters changed to ?, I'm not shure how cannot replicate it, but entering some strange character, and clicking around does the trick.
- I think you should consider adding standard spreadsheet/browser keyboard shortcuts: F2, alt+down.
- Make page up / page down work.
- Adding related record, could automatically open new detail window - creating unnamed row seem pointless.
As a Total Commander addict, I cannot believe some is still copying files using drag and drop, manually selecting files etc. There are some alternatives for a Mac as well.
As far as remapping goes, I've remapped my right ctrl to delete. I delete a lot, and reaching to the far right corner of the keyboard was a pain.