hans_castorp

26 ms·

1. 301.▲
   by hans_castorp 7y ago

   Ah, so not all men are created equal - only U.S.A. citizens. Yes, that goes in line with the way the U.S.A. treats the rest of the world.
2. 302.▲
   by hans_castorp 7y ago

   > Here we had a chance to impress on a foreigner that US society is great and filled with good values That ship has sailed long ago.
3. 303.▲
   by hans_castorp 7y ago

   So apparently freedom of speech in the U.S. means "freedom to say whatever the U.S. thinks is right".
4. 304.▲
   by hans_castorp 7y ago

   > What's the difference, functionally speaking? (Asking honestly, not being snarky -- I may not understand what you are saying / what the equivalent postgres feature is?) You create a single index, e.g: create index on the_tabl
5. 305.▲
   by hans_castorp 7y ago

   Actually window functions were introduced in Postgres 8.4
6. 306.▲
   by hans_castorp 7y ago

   pg_upgrade with the --link option is extremely fast and doesn't really depend on the size of the database.
7. 307.▲
   by hans_castorp 7y ago

   Indexing a generated/computed column is not the same as creating an index on an expression. If you want to support several different expressions you need to create a new column each time. Additionally, an ALTER TABLE blocks access to t
8. 308.▲
   by hans_castorp 7y ago

   Which is very often a good thing. I have tuned more than one query by moving a sub-query/derived table into a CTE. What bothers me more, that a CTE prevents parallel execution, but I think that too is fixed with Postgres 12
9. 309.▲
   by hans_castorp 8y ago

   > EdgeQL has no NULL. So how is a missing value in a column represented? A column value is a scalar value, not a "set". As much as I accept that NULL values are a pain to deal with, I don't see a way to represent the absen
10. 310.▲
    by hans_castorp 8y ago

    Part of w3fools bad reputation stems from the fact the site is (or at least was) full of errors - especially their SQL part.
11. 311.▲
    by hans_castorp 8y ago

    So there are 2197188 games in that file. Extracting only the lines with "[Result]" in them into new file (using grep) takes about 3 seconds. Importing that into a local Postgres database on my laptop takes about 1.5 seconds. Then
12. 312.▲
    by hans_castorp 9y ago

    Don't access your database with a superuser account from your application. Don't allow superuser connections from outside of your network.
13. 313.▲
    by hans_castorp 9y ago

    Creating a C language function is not allowed to regular users by default because "language C" is an untrusted language only superusers can create functions using that. Additionally, regular users don't have the privileges to
14. 314.▲
    by hans_castorp 13y ago

    This sounds very interesting. Are there any pre-built Windows binaries available for this extension?