castorp

5 ms·

1.
by castorp 3y ago
> I suspect that's a pretty non-standard/rarely-used feature though. If you learn SQL you likely won't encounter this Recursive common table expressions are part of the SQL standard (since 1999) and are quite frequently us
2.
by castorp 4y ago
> PostgreSQL has built in support for UUIDv4 through the pgcrypto or the uuid-ossp extensions. Since Postgres 13 installing an extension is no longer necessary as gen_random_uuid() is part of the core.
3.
by castorp 4y ago
Yes, it matters. Many Postgres features aren't supported on Redshift (set returning functions, indexes, ...) and many tools that work just fine with Postgres error out because Redshift does things differently or doesn't support fe
4.
by castorp 4y ago
> rather than Redshift Despite what the Amazon marketing is telling, Redshift is not really a "fork" of Postgres. To my knowledge they only used the SQL parser and the wire protocol from Postgres. The optimizer, query executor
5.
by castorp 4y ago
You need to use pg_dump from the new version, not from the old version.
6.
by castorp 4y ago
> It sounds like Russia might get declared a terrorist state soon. Lithuania has apparently already done that.
7.
by castorp 5y ago
I have been working with Oracle for more than 20 years now. I think I only had very few situations where an "index organized table" (=clustered index) was useful or actually provided a major performance benefit over a "heap t
8.
by castorp 5y ago
> Without dura, you use Ctrl-Z in your editor to get back to a good state. I just turn on "Local History" in my NetBeans IDE which creates a new version of the file each time I save it. No need to use Ctrl-Z for that.
9.
by castorp 5y ago
You don't have to do that "manually". Postgres supports the conversion using the `at time zone` operator.
10.
by castorp 5y ago
Did you try Qwant? https://www.qwant.com/maps
11.
by castorp 5y ago
select extract(month from justify_interval(timestamp '2022-01-01' - timestamp '2021-11-01')) returns 2
12.
by castorp 5y ago
Well for "counting buckets" you can use `date_bin()` since Postgres 14 which groups the difference between timestamps into defined intervals.
13.
by castorp 5y ago
But the difference between 2021-01-01 and 2020-12-31 is only one day, not a year. It gets even strange for e.g. select DATEDIFF(year, '2021-12-01', '2022-01-01') which still returns 1 even though that's a whole mont
14.
by castorp 5y ago
> For example, find all users who have have been active at least 10 days. Well, then you only need to compare the difference of the timestamp (or date) values with an interval of 10 days. e.g. end_time - start_time >= interval '1
15.
by castorp 5y ago
> No, for example, the datediff in years for New Year's Eve and New Year's Day should be 1 I don't understand the purpose of such a calculation. If you want to check if two dates (or timestamps) fall into the same year, yo
16.
by castorp 5y ago
The question is: what do you do with the result? If you e.g. want to check if two timestamps are more than a year apart you just compare the difference to an interval of 1 year.
17.
by castorp 5y ago
The "distance" between two dates seems quite useful. In Postgres there is no need for a datediff() function - you would just subtract the two dates: date '2021-01-01' - date '2020-12-31'
18.
by castorp 5y ago
I never understood the need for a datediff function. In Postgres (or Oracle) you just subtract two timestamps and use the resulting interval. It's a different approach to the same problem.
19.
by castorp 5y ago
"hundreds" of concurrent connections isn't really a problem for Postgres. Several thousands are - at least up until now. V14 will improve this substantially.
20.
by castorp 5y ago
There about 10 issues logged with Bugzilla regarding this. All closed as "wontfix"
21.
by castorp 5y ago
Only helps until the next release. Then all customization options where you can turn off Proton will be removed.
22.
by castorp 5y ago
The new bookmark menus are simply terrible. The use much more space than before. I even have one that needs scrolling now. And it's not possible to use the "compact" layout anymore. You can enable the menu item, but the huge
23.
by castorp 6y ago
You shouldn't see downvoting as a personal attack. It's simply a way to express disagreement with the statement. How else would one signal agreement or disagreement if not by up- or downvoting? Would you rather have everyone answe
24.
by castorp 6y ago
Ages ago I installed a shareware product. And it also had a scrollable "terms and condition" screen (about 2 pages long) when starting it for the first time. When you clicked the "I Agree" button too quickly it would ask
25.
by castorp 6y ago
So I should pay $50 dollar just to read one article? (And pay for a foreign currency transfer on top of that?) There is no option to read the article without signing up for one year subscription. From a link shared on a public news aggregat
26.
by castorp 6y ago
> Don't they all? No. Threema does not require a phone number (it uses one for the registration verification, but your account is not linked to that number).
27.
by castorp 6y ago
Doesn't this mean that anybody agreeing to those terms needs to ask permission from each and everybody in their address book? And if they don't, can I sue them (at least in the EU) or ask my contact to be removed before the agree
28.
by castorp 6y ago
Paywall
29.
by castorp 6y ago
This is from 2013! That should be added to the HN title
30.
by castorp 6y ago
> Well, our legal units will move first. They're the heart of our company And I always thought that the (software) engineers would be the heart of the company. That puts their (allegedly) preferred way of interacting with customers

More ›