New post on Android Developers: Best practices for SQLite performance. Looks good! Sad, that it hasn't been there before.

#sqlite #db #performance

You've probably seen how someone generates art-QR-codes using Stable Diffusion. Now take a look at how QRs work and how to decode them manually.

#ai #qr #art

Apple Vision Pro seems to be a big deal, but it's hard to tell anything about the real experience. Well, some journalists were allowed to try the thing, check out their report. Google's move? Microsoft's?

#ar #vr #hardware

Well, DeepMind has tasked their AI with better sorting and it actually came up with a faster sorting algorithm. And a little bonus: thread about bubblesort being slow in FreeBSD kernel.

#ai #sorting #algorithm

Camera with a mole's nose instead of a lens. It checks for location, orientation, weather, etc., and asks AI to generate an image using a constructed prompt. Nice!

#ai #camera #hardware

A deep dive into what DeepMind's AI has actually done to speed sorting up.

#ai #sorting #algorithm

In a comment in SQLite sources there's this fascinating story on why temporary files prefix had to be changed to "etilqs_" (SQLite spelled backwards).

#sqlite #db #humor

Short, but interesting: why minSdk bump may result in dex-file size increase.

#minsdk #apk #build

A couple of posts by Vitalik. The 1st one - the dangers of using the consensus mechanism to solve problems that it's not designed to solve. The 2nd - the big challenges Ethereum faces to become a "mature platform".

#crypto #blockchain #ethereum

A nice talk about building more reliable, easier to understand and self-repairing (to some extent) systems using Erlang. I do not recommend reading the transcript, just watch the video, it's not too long.

#talk #language #erlang

This is nice! A tiny function for our ~/.zshrc (not sure whether bash will accept it or not) that wraps adb calls and shows an interactive picker when more than one device is attached.

#adb #cli #tool

Yikes! Now we know that such crap is valid in Kotlin.

#humor #kotlin

Madness again! Regular expression (rather simple, elegant even!) to check whether a number is prime or not. Number has to be converted to a bunch of 1s (e.g. 5 -> 11111).

#regex #math

More from Vitalik. There's this interesting data structure: Merkle tree. The post is about Verkle trees. Similar thing, but with much more compact proofs.

#datastructure #crypto #cs

A very nice post criticizing an old announcement of a "perfect" Go GC. Basically, my man describes, what are the difficulties in this area, why it's always trade-offs and how configurations are usually chosen. 13 stop the worlds out of 10!

#gc #golang

There's this Gradle plugin that generates type-safe and named formatters for string resources. How hard does it hit build time, I wonder. But hey, looks cool!

#localization #resources #gradle

On potential memory leak caused by double brace initialization (something along the lines of new HashMap<>() {{ ... }}) in Java. I believe I had to fix several such leaks in our app long time ago.

#java #memory #leak

A bunch of macOS native CLI tools. networkQuality is nice, had to install speedtest for that. say is awesome too! say -v Yuri "So Long, and Thanks for All the Fish"

#macos #cli #tool

Excellent post that shows only some part of text rendering hardship.

#text #font #rendering

Oy vey! Restoring private key from video footage of flickering of a power LED in a phone or a hub. Filmed on another phone or a regular security camera! Let's thank @istima for sharing

#cybersec #camera #hack