Viewing profile — CapriciousCptl

Neat! Seeing this I'm considering making a similar project that takes a search and drops the preview pictures. No post-video-watching suggest + no 1 minute video shorts + no clickb…

Personally, I tried pgtyped in a greenfield project but ended up switching to Slonik. Both are brilliant packages-- if you ever peak at the source of pgtyped it basically parses SQ…

Note that this is watch time *per active user* lest anyone interprets the title as TikTok having more total active user-time.

This is nice! Quiver was my previous go-to, but it's all but abandonware in 2021.

I was curious so I tried it in postgres 13. Postgres, at least, uses the index to form a bitmap and scans that when aggregating in the first case (10% rows in the bitmap) and not i…

Sweet! An MMORPG element would be the bees knees here. Years ago there was a similar (though-MMORPG) game called Diaspora from a small studio[1]. I still remember waking up at all …

I could be wrong but didn’t phoenix just switch to webpack from some other package manager? I guess that was 3ish years ago so a lifetime more or less in JS.

I think SQS was the first AWS offering. In that context “simple” means simple compared to other offerings of the 2000s/rolling it out yourself. I agree it’s a little convoluted for…

The bug, which used a single & in an if statement instead of a double && reminds me of this one from years ago -- https://lwn.net/Articles/57135/ In that case it was a single = ver…

This is useful! Every so often Docker acts up or a Youtube video hidden in a tab somewhere or some silly mistake opens tons of Postgres connections on my M1. Previously the only cu…

Good writeup! It's an interesting gotcha because Postgres and SQLite docs expressly disclaim that their sequences/AUTOINCREMENT are gapless but experienced and talented programmers…

Thanks, what about getting historical values from the API? It’d be very nice to get more historical data from the fianancial statements

Hey, this looks pretty neat. You even have some financials data. I see that all the financials data is in terms of “growth,” is there any chance you could expose the raw numbers? A…

Does intent not matter? Pasting code for explanatory reasons and citing the source seems different than silently incorporating it directly into a commercial work product.

This isn't exactly a quote but fits in the sense of "general ideas mentioned frequently on HN and not frequently elsewhere"-- Gell-Mann Amnesia https://hn.algolia.com/?dateRange=al…

ctrl+f arpu ctrl+f churn ctrl+f key performance etc

Per-user revenue was $109 for 2020. My goodness payment for order flow and cryptocurrency rebates are lucrative.

I can speak for myself— venv is good enough for most things and conda works for everything else (pandas/numpy/tensorflow on Mac m1). For production code I’m more worried about mini…

Hmm, I dug further. The story probably comes from Plutarch (Lives), "[Crassus] would buy houses that were afire, and houses which adjoined those that were afire, and these their ow…

I think wikipedia got the details wrong there. Crassus didn't offer to buy the burning buildings, he offered to put fires out. At least, that's how I understood it years ago and th…

WU incurred $41.3 million in "non-credit related losses," which includes fraud in 2020[1] which is only maybe 1% of their revenue. It had another ~$40 million in expected credit lo…