18272
Ryan

@ryansmith #18272

Building @indexsupply https://r.32k.io
1896 Follower 105 Following
https://www.depesz.com/2022/07/05/understanding-pg_stat_activity/

1) Depsez is pg legend
2) This is a great explainer on pg_stat_activity
https://www.jmeiners.com/lc3-vm/

Neat page on learning virtual machine fundamentals
https://www.youtube.com/watch?v=S828_f0-dQI

TIL there's a guy who takes old, live DMB recordings and turns them into high quality audio / video.

Also, this is THE BEST version of #41 I've heard -- except for when I first heard it IRL in 2003 at my first DMB concert.
/Music
just added a new chain to @indexsupply and used PG 17!

eager to see how the new vector IO impacts table scans
People talk too much about refactoring and not enough about factoring.
/dev
Teach Yourself Scheme in Fixnum Days

https://docs.scheme.org/tyscheme/

a lovely web site
enriching myself on japan's bluegrass scene in response to seeing REDBULL make the rounds. i'm having fun trying to figure out how/when it made it's way across the pacific

https://www.youtube.com/watch?v=jlv_NcJ_Luk
There's a kinda person who can say monad without saying haskell
Pretty cool seeing a new product launch on the @indexsupply API
If you enjoy fun web sites then you have to check this one out!
I have a new product that is in private beta.

It has a fairly unique architecture that makes it fast, cheap, and easy to do SQL queries over arbitrary events.

Please dm/reply if you are interested in trying it out
/EVM
Computers are a Sadness, I am the Cure

Easily the most entertaining and educational talk I've seen!

Please watch it later tonight after you get your last prod deploy out for the week.

https://www.youtube.com/watch?v=3-GpiKQr9Rs
/dev
Fantastic talk on PG's share buffers -- and memory in general

https://www.youtube.com/watch?v=u-r8VuzXeBE
i have little mnemonics that i've collected over the years that include:

css/margin values: pump up the bass & turn down the treble -> TRBL

dstat args: see ya later, nerd! -> dstat -cnrd

whatcha got?
Is anyone working on a Zig++ ?

Excited to see shared pointers and templates in Zig!
/dev
I'm moderately tempted to read this

https://www.amazon.com/Inside-Windows-NT-Helen-Custer/dp/155615481X

I stopped using windows when I was 12 but it seems fun to explore the big ideas in NT.
I enjoyed this read / critique on E2EE systems:

https://www.devever.net/~hl/webcrypto
one of the best investments i've made in my life is learning the keyboard shortcut for quickly ending a zoom meeting

it's saved countless awkward moments while people are trying to exit