DATEDIFF is an extremely useful function for analytical queries. Given two timestamps it'll tell you how many days, weeks, months, hours, etc they are apart. Here we show an implementation of this function for Postgres.

DeepMind's model, with just 7 billion parameters, outperformed the 178 billion-parameter Jurassic-1 transformer on various language tasks.

Tämä on huikea tarina selkärankaisesta miehestä, joka päätti räjäyttää oman Tesla Model S autonsa. Mutta miksi ihmeessä joku tekee sellaista?
Katso video niin tiedät :)

Kiitos kaikille videon tekoon osallistuneille!!

At least 66m-year-old fossil discovered in southern China reveals posture previously unseen in dinosaurs

“Zero fucks given” in other languages

6. It’s sausage to me (German)
5. I care a cucumber (Spanish)
4. It can oxidize on my anus (Dutch)
3. I slap my balls on it (French)
2. It interests me as much as a kilogram of shit (Finnish)
1. Flowers on my dick and…

In my last post, Qubes-lite with KVM and Wayland, I described setting up a Qubes-inspired Linux system that runs applications in virtual machines. A …

Yes, you are living through a bubble in the financial markets. No, this is not an article about how to time the market. No, you don’t know when the bubble will burst (and neither do I). Yes, there are still things that you can do that will set you up for…

Workplace stress is rampant and resignations have risen. Employers are struggling to stop employees from leaving and to boost morale. Some are trying four-day workweeks, mandatory vacation days and other new ways of working.

Blockchains are polarising the tech community. I have repeatedly criticized, that current Blockchain-based solutions are mostly hype and little substance. However, that is an oversimplification of …

Microsoft Team's link preview feature is susceptible to spoofing and vulnerable to Server-Side Request Forgery. Team's Android users can be DoS'ed and, in the past, their IP address could be leaked.

Analog computers were the most powerful computers for thousands of years, relegated to obscurity by the digital revolution. This video is sponsored by Brilliant. The first 200 people to sign up via https://brilliant.org/veritasium get 20% off a yearly subnoscription.…

We enhance auto-regressive language models by conditioning on document chunks retrieved from a large corpus, based on local similarity with preceding tokens. With a $2$ trillion token database, our Retrieval-Enhanced Transformer (Retro) obtains comparable…

Updates: 12th of September 2021: I’m writing a book on DNA! If you want to become a beta reader, or have suggestions, I’d love to hear from you!
8th of January 2021: This article has been revised and updated, scientifically and in terms of dead links. Revision…

DuckDuckGo takes aim at Google Chrome, but insists it isn't going to fork Google's Chromium project upon which Chrome, Edge and others are built.

PC gaming on Linux isn't really a thing, right? It is now, thanks to Proton.

WARSAW, Poland (AP) — The aggressive cellphone break-ins of a high-profile lawyer representing top Polish opposition figures came in the final weeks of pivotal 2019 parliamentary elections. Two years later, a prosecutor challenging attempts by the populist…