Hacker Newsnew | past | comments | ask | show | jobs | submit | kbendyk's commentslogin

(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.


Same thing here, I would love this feature. I like to make my tables have a common structure:

    id
    created_at
    updated_at
    status
    fkey1_id
    fkey2_id
    fkey3_id
    date_field1
    date_field2
    column1
    column2
    column3
Being able to add a new foreign key column with the "rest" of them would be awesome.


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).

http://www.postgresql.org/message-id/flat/20141209174146.GP1...


Unsure what you mean. A subset of columns can be selected in any order, across tables. Were you referring to the select order used by "*"?


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.

[1]https://wiki.postgresql.org/wiki/Alter_column_position



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.


Yes, MySQL: ALTER TABLE t1 ADD COLUMN `count` SMALLINT(6) NOT NULL AFTER `lastname`


I'd love this too. I wanted materialised views and upsert, so here's hoping :)


This really looks very nice!

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.

Good luck!


Thanks for the feedback! Good points - will add these to our queue for features


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.


Preach it brother! 8)

I have been using Total Commander for YEARS and it is the first thing I load on a computer that does not already have it.


There is an error message after hitting the download button: No mirror defined for download "Windows" [1]

[1]http://www.appserver.io/dl/Windows

Edit: Shouldn't be the case event if it isn't available yet :)


Windows version is not ready yet. Thanks


Thanks for the try, right now they only have Mac/Linux. Will inform when windows version is available. http://appserver.io/downloads


437(chrome) vs 402(yandex) PS yandex detected as chrome 19


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: