Hi all, Hope everyone has a great week ahead. This week we focus on deadlock and concurency primitive. Thank you to the readers who have bought me a coffee, really appreciate that ❤.️
Many might have seen PostgreSQL issue the following error message: “ERROR: deadlock detected”. But what does it really mean? How can we prevent a deadlock and how can we reproduce the problem? Let’s dive into PostgreSQL locking and understand what deadlock and deadlock_timeout really mean.
Concurrent programming requires synchronization. We can’t have more than one thread accessing data at the same time; otherwise, we end up with a data race. The most common solution is to wrap the critical data access in a mutex. When misused, it can cause a program to run worse in threaded mode than it would have single threaded!
Now we know about mutex, then how about futexes, which are popup sometime especially when you are working with strace. Futex mechanism was proposed by Linux contributors from IBM in 2002 ; it was integrated into the kernel in late 2003. The main idea is to enable a more efficient way for userspace code to synchronize multiple threads, with minimal kernel involvement.
(or any static file hoster). So how do you use a database on a static file hoster? Firstly, SQLite (written in C) is compiled to WebAssembly. SQLite can be compiled with emscripten without any modifications, and the sql.js library is a thin JS wrapper around the wasm code. It also leverage HTTP Range header, which we cover in issue #196
cd all day long. It’s a built-in shell primitive. But at the same time, we also have
/usr/bin/cd.What purpose does it serve? Another deep dive on this is cd is not a program, check it out too
With an increasing number of breaches, intrusions, and data thefts, securing a web application is extremely important. On the other hand, programmers often do not have a strong grasp of how attacks work and how to mitigate them. This post attempts to close that gap a little.
JWT is gaining popularity due to its convenience use to hold information without issuing an auth storage. Naturally, it has a lot of attacking vectors. Let’s learn about those attacks so we can use JWT securely
The post target data scientist to use SQL instead of analyze data with Panda. But we can see how thing are done in raw SQL to extract information out of SQL database Running and Cumulative Aggregation, one of topic in this article can be quite useful to analyze the growth or trend.
Back in old day, we take picture use film in camera. To create different look of image, we used a different film. Modern mirrorless cameras from Fujifilm have film simulation presets that digitally mimic the style of a particular film stock. So how these simulations were achieved? A good post to learn about image maniupulation, vector
Github praises feature flags in release rollout. This is a better post in my opinion in this topic because it also talk about the cost of feature flags.
We don’t usually include article that just show code without technical deep dive but this has some useful ones so we include it here
a pure Python from-scratch zero-dependency implementation of Bitcoin for educational purposes.
Verify email via Regex, DNS, SMTP, MX blacklist. A useful way to fightbox and ensure no typo on email.Ruby
Fast high-level web crawling Ruby frameworkRuby
a single-pass compiler for a tiny subset of the Go programming language – just enough to compile itself. It outputs (very naive) x86-64 assembly, and supports just enough of the language to implement a Mugo compiler.Go
Convert images to computer generated art using delaunay triangulation. Kind of a fun code to read about image manipulationGo
If you are into Software-Defined Radio then this is a great resource to dive into it.
Highly Configurable Terminal Dashboard for Developers and Creators
Run SQL queries on your Terraform infrastructure. Query resources and analyze its configuration using a SQL-powered framework.
steps you through the local branches of a repo one at a time, outputting the following information about each: last commit, last author etc then you can select to delete them. Useful to cleanup when you hacked a lot on a repo.
Open-source vector similarity search for Postgres
Fast, modern, easy-to-use network scanner. If you use nc, nmap a lot, absolutely give this a try.
Open source Firebase + Heroku to develop, scale and secure serverless apps on Kubernetes
Better Dev Link