HN user
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 used to traverse hierarchical data (aka "adjacency list").
It is part of basically all (good) SQL tutorials - at least in the "advanced" part.
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.
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 features that Postgres does.
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 and storage engine are totally different. The whole "Redshift is Postgres" is complete marketing BS in my opinion.
You need to use pg_dump from the new version, not from the old version.
It sounds like Russia might get declared a terrorist state soon.
Lithuania has apparently already done that.
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 table". So I never really miss them in Postgres.
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.
You don't have to do that "manually". Postgres supports the conversion using the `at time zone` operator.
Did you try Qwant? https://www.qwant.com/maps
select extract(month from justify_interval(timestamp '2022-01-01' - timestamp '2021-11-01'))
Well for "counting buckets" you can use `date_bin()` since Postgres 14 which groups the difference between timestamps into defined intervals.
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 month. I don't see a use case for this kind of result
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 '10 days'
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, you compare the year part of them. If you want to check how far they are apart, you compare the difference between the two to an interval.
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.
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'
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.
"hundreds" of concurrent connections isn't really a problem for Postgres.
Several thousands are - at least up until now. V14 will improve this substantially.
There about 10 issues logged with Bugzilla regarding this. All closed as "wontfix"
Only helps until the next release. Then all customization options where you can turn off Proton will be removed.
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 spacing between bookmark menu items is still there.
Mozilla please stop applying smartphone designs on the desktop. I love the browser, but I hate it that you wreck a perfectly fine UI every other release.
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 answer with "I agree" or "I disagree"?
Maybe Hacker News simply attracts more US readers than non-US readers and thus they are bound to disagree with any criticism.
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 you "Do you really agree to the terms you read in only 0.76 seconds?"
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 aggregation site, I would expect the content to be publicly available as well (or at least some kind of indicator in the title)
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).
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 to the terms?
Paywall
This is from 2013! That should be added to the HN title
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 and the rest of the world into perspective