New JSON query operators in SQLite 3.38.0
SQLite 3.38.0 introduced improvements to JSON query syntax using -> and ->> operators that are similar to PostgreSQL JSON functions. In this post we...
The latest blog posts to take off on Hacker News. 3,821 posts.
SQLite 3.38.0 introduced improvements to JSON query syntax using -> and ->> operators that are similar to PostgreSQL JSON functions. In this post we...
It will chew you up and spit you out, and you'll not even complain. I often start new projects at the beginning of the year, around Dec...
When you hear the term, you should picture an hourglass with M things on one side, N on the other, and an important concept in the middle.
A reader recently sent me a video of a keynote speech, delivered in 2020 by the popular fantasy novelist Brandon Sanderson. The title of the ... Read more
The real-life story of Annie Shapiro - who fell into a coma at age 50 in 1963 - is more remarkable than the movie based on her miraculous re-awakening.
This post ended up being fairly popular on Hacker News and sparked conversations about project management and development in the IT industry. You can find the post here .
I’m a Haskell failure, don’t tell anyone! Recently I encountered some dubious error handling code. Not only was it failing, it was failing WRONG 1. This frus
As a product, the original iPhone exemplified Apple’s holistic approach to hardware and software that are designed for each other, yet, at the engineering level, the iPhone hardware and software teams were almost completely siloed, with only Jobs and a mere handful of his most trusted (and talented) senior executives…
Blasphemy? Probably! But still pretty awesome!
As you’re reading through our reviews or researching the best backpacks yourself, you may see a profusion of various technical terms being…
Machine Learning with PyTorch and Scikit-Learn has been a long time in the making, and I am excited to finally get to talk about the release of my new book…
Some years ago, you blogged about a research article by Hasan and colleagues (2013) .
Some days ago I noticed that on a Mac, doing snprintf calls from multiple threads shows curious lack of scaling ( see tweet ). Replacing snprintf with {fmt} library can speed up the OBJ exporter in Blender 3.2 by 3-4 times . This could have been the end of the story, filed under a “eh, sprintf is bad!” drawer, but I…
Group for Apps and Services on Exascale Research Infrastructure is a research, development, and teaching unit at FIDIT + MedRi.
Creating backups is a basic necessity for anyone who stores data. With the help of a dedicated server, the Linux operating system and the rsync software, you can securely and efficiently retrieve data from any computer via an SSH connection and store it in a backup. It doesn’t matter if there is another Linux server…
This week, I want to break from our usual format and respond to the fairly unusual global events. I expect a lot of my readers are trying to get a grasp on what is happening right now in Ukraine an…
Between 2016 and 2020 I wrote a series of blog posts called “How to speed up the Rust compiler”. These were mostly about my work on the Rust compiler, plus some updates on the progress on the Rust compiler’s speed in general.
Recently piet-gpu has taken a big step towards realizing its vision, moving the computation of path clipping from partially being done on the CPU to entirely being done on the GPU.
NOTES: I have grouped the options such that the Boolean ones (read: on/off true/false) come first, then those with a short amount of "flags", and after that the ones with a very long value.
Russia's invasion of Ukraine will be captured in incredible detail by smartphones and social media. This changes everything.
Gödel’s first incompleteness theorem states that there are mathematical statements that can neither be proven or disproven. His proof is fairly difficult to ...
Gigabit ethernet has been around for a long time, it’s so ubiquitous that there is a very strong chance that if you have a RJ-45 port on your computer, it’s going to be a gigabit ethernet network interface.
At my university, one of our internal software systems allows a professor to submit a revision to a course. The professor might change the content or the objectives of the course. In a university, professors have extensive freedom regarding course content. As long as you reasonably meet the course objectives, you can…
The time has come to replace file systems!
I think I’ve come up with a novel hack for the challenge of getting your company to financially support the open source projects that it uses: reach out to the …
It is the best of times for electronic ink but it is the worst of times for actually reading eBooks.