quail
@quail.wtf
A cursed quail. I think too much about databases.
The year is 365.25 days long, that means we can fall back ~6 times a year.
November 2, 2025 at 6:05 PM
The year is 365.25 days long, that means we can fall back ~6 times a year.
YESSSSS DO IT IT'S SO UNDERRATED AND MAKING YOUR OWN CLOTHES IS EASIER THAN YOU THINK
October 21, 2025 at 11:23 PM
YESSSSS DO IT IT'S SO UNDERRATED AND MAKING YOUR OWN CLOTHES IS EASIER THAN YOU THINK
Ah you can actually see if you're having icache or dcache misses with perf! But also I haven't ran into icache issues yet, so I wouldn't have any advice there 😅
September 3, 2025 at 12:08 PM
Ah you can actually see if you're having icache or dcache misses with perf! But also I haven't ran into icache issues yet, so I wouldn't have any advice there 😅
Back when I was fighting this problem, I just did a bunch of shit to try and use less memory in the hot loop, and then suddenly, as if by magic, I stopped having cache misses on a certain mov instruction.
September 3, 2025 at 12:06 PM
Back when I was fighting this problem, I just did a bunch of shit to try and use less memory in the hot loop, and then suddenly, as if by magic, I stopped having cache misses on a certain mov instruction.
perf can tell you which instructions tend to have misses, but you're almost definitely profiling your release binary & so there's ~zero connection between that and your source 😔.
September 3, 2025 at 12:06 PM
perf can tell you which instructions tend to have misses, but you're almost definitely profiling your release binary & so there's ~zero connection between that and your source 😔.
Tomorrow's headline: Anthropic acquires LD out of spite
September 3, 2025 at 12:02 PM
Tomorrow's headline: Anthropic acquires LD out of spite
It def feels more art than science to me. The main thing is:
- understand how cache lines work
- understand how much memory you're touching during the hot loop
- understand how cache lines work
- understand how much memory you're touching during the hot loop
September 3, 2025 at 11:57 AM
It def feels more art than science to me. The main thing is:
- understand how cache lines work
- understand how much memory you're touching during the hot loop
- understand how cache lines work
- understand how much memory you're touching during the hot loop
shout-out to vulkan-zig for providing a darn good vulkan SDK in a language that isn't C.
And for making their examples the "hello triangle" bit itself so it's uhhhh easy to copy code when I get tired of hand-copying :)
And for making their examples the "hello triangle" bit itself so it's uhhhh easy to copy code when I get tired of hand-copying :)
August 31, 2025 at 3:05 AM
shout-out to vulkan-zig for providing a darn good vulkan SDK in a language that isn't C.
And for making their examples the "hello triangle" bit itself so it's uhhhh easy to copy code when I get tired of hand-copying :)
And for making their examples the "hello triangle" bit itself so it's uhhhh easy to copy code when I get tired of hand-copying :)
Zig is very new contributor friendly 🙏
August 20, 2025 at 10:58 PM
Zig is very new contributor friendly 🙏
Lmk if you want help, I've been running it for years 😅
August 12, 2025 at 11:19 AM
Lmk if you want help, I've been running it for years 😅
still not enough! cows need food, and with two puny fields you don't have nearly enough space to do the kind of rotation you need.
if there is one problem I have with this image, it really is "you just cannot raise large animals on that little land". at least not without outside "help"
if there is one problem I have with this image, it really is "you just cannot raise large animals on that little land". at least not without outside "help"
July 1, 2025 at 5:20 PM
still not enough! cows need food, and with two puny fields you don't have nearly enough space to do the kind of rotation you need.
if there is one problem I have with this image, it really is "you just cannot raise large animals on that little land". at least not without outside "help"
if there is one problem I have with this image, it really is "you just cannot raise large animals on that little land". at least not without outside "help"
zig's packed structs + a kv database is actually pretty comfy? packed structs make it REALLLLLLLL easy to do the ser/de dance, which I find to be the most tedious parts. also packed structs are cool AF
July 1, 2025 at 1:37 AM
zig's packed structs + a kv database is actually pretty comfy? packed structs make it REALLLLLLLL easy to do the ser/de dance, which I find to be the most tedious parts. also packed structs are cool AF
sqlite is great but honestly I am becoming very anti-SQL for embedded DBs! mostly because I just don't like SQL very much (gasp) and because the embedded DB model means that you just don't _need_ SQL all that much - smaller queries are perfectly efficient www.sqlite.org/np1queryprob...
Many Small Queries Are Efficient In SQLite
www.sqlite.org
July 1, 2025 at 1:37 AM
sqlite is great but honestly I am becoming very anti-SQL for embedded DBs! mostly because I just don't like SQL very much (gasp) and because the embedded DB model means that you just don't _need_ SQL all that much - smaller queries are perfectly efficient www.sqlite.org/np1queryprob...
Wait TWO cows? A calf? Where did the bull come from?
July 1, 2025 at 1:09 AM
Wait TWO cows? A calf? Where did the bull come from?
Where does that hay come from? We don't talk about that
July 1, 2025 at 1:08 AM
Where does that hay come from? We don't talk about that
You could do this! You would just need a loooooooot of hay for the cow.
July 1, 2025 at 1:07 AM
You could do this! You would just need a loooooooot of hay for the cow.
Rocksdb is criminally underrated (despite the C bindings being a bit of a mess)
June 29, 2025 at 9:38 PM
Rocksdb is criminally underrated (despite the C bindings being a bit of a mess)
Ehhhh but the nature of a public API is that you can't really predict how it's going to be used. It's all mostly ceremony around map[string, any]. But having a spec can help you avoid reinventing the wheel like "how do you do pagination"
June 27, 2025 at 12:10 PM
Ehhhh but the nature of a public API is that you can't really predict how it's going to be used. It's all mostly ceremony around map[string, any]. But having a spec can help you avoid reinventing the wheel like "how do you do pagination"
Which also gets into the idea of "do I even want to be more successful" and the answer to that is no lol. I spent so many years climbing the ladder, and now I'm just trying to figure out who I am now that I'm at the top
June 4, 2025 at 12:32 PM
Which also gets into the idea of "do I even want to be more successful" and the answer to that is no lol. I spent so many years climbing the ladder, and now I'm just trying to figure out who I am now that I'm at the top
I'm trying to write a follow up and failing. There's a lot to unpack, but it does feel strange to be where I'm at, having worked entirely remote, and be told that I would have been more successful had I worked in person
June 4, 2025 at 12:32 PM
I'm trying to write a follow up and failing. There's a lot to unpack, but it does feel strange to be where I'm at, having worked entirely remote, and be told that I would have been more successful had I worked in person