(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…
Google did not rebrand itself though, it's still Google. It's the holding company that owns Google (the company) that's called Alphabet. In contrast, Facebook does an actual name change now - there'll be no company named Facebook anymore, just a product.
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 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.
Work on this started recently, but since it is an open source project there is no way to know if this will make it to 9.6 or not (the work was start too late to get into 9.5).
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.
Yes, I think it's about changing the default presentation order. That could be a feature of the client, psql, pgcli, pgadmin3, but it won't be portable across them unless it's some metadata stored inside the db. Is there any db with that feature?
Edit: munro answered that. PostgreSQL does it but it's expensive because it has to rewrite the table.
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.