Hacker News: CapriciousCptl

New comment by CapriciousCptl in "A cross-platform GUI for YouTube-dl"

CapriciousCptl — Fri, 10 Sep 2021 13:27:55 +0000

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 clickbaity preview pictures + setting a watch timer or something like that might get me back on youtube.

New comment by CapriciousCptl in "How We Went All In on sqlc/pgx for Postgres and Go"

CapriciousCptl — Thu, 09 Sep 2021 00:21:08 +0000

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 SQL on its own from what I could understand. The issues I had were-- 1) writing queries sometimes felt a little contrived in order to prevent multiple roundtrips to the database and back and 2) pgtyped gave weird/non-functioning types from some more complex queries. I've had better luck with Slonik and just writing types by hand.

New comment by CapriciousCptl in "TikTok overtakes YouTube for average watch time in US and UK"

CapriciousCptl — Mon, 06 Sep 2021 14:06:09 +0000

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

TypeScript Deep Dive

CapriciousCptl — Sat, 04 Sep 2021 21:44:42 +0000

Article URL: https://basarat.gitbook.io/typescript/

Comments URL: https://news.ycombinator.com/item?id=28419580

Points: 3

# Comments: 0

New comment by CapriciousCptl in "FSNotes: Notes manager for macOS and iOS – native, open source"

CapriciousCptl — Sun, 22 Aug 2021 18:03:31 +0000

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

New comment by CapriciousCptl in "How database indexing works internally"

CapriciousCptl — Fri, 20 Aug 2021 19:17:21 +0000

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 in a second case WHERE "createdAt" BETWEEN '1990-01-01 00:00:00' AND '2020-12-31 23:59:59'; (100% rows in the bitmap, obviating the need for the intermediate step). I also tried ~20% rows (2019-2020) and the planner skipped the index. '''

CREATE TABLE temp (id SERIAL PRIMARY KEY, amount MONEY, "createdAt" TIMESTAMPTZ); CREATE INDEX ON temp ("createdAt");

INSERT INTO temp(id, "createdAt", amount) SELECT generate_series(1,1000000) AS id, NOW() + (random() * (interval '10 years')) - interval '10 years' AS createdAt, random() * 100::money AS amount.

EXPLAIN SELECT sum(amount) FROM temp WHERE "createdAt" BETWEEN '2020-01-01 00:00:00' AND '2020-12-31 23:59:59';

Aggregate (cost=10286.06..10286.07 rows=1 width=8) -> Bitmap Heap Scan on temp (cost=2148.00..10033.48 rows=101032 width=8) Recheck Cond: (("createdAt" >= '2020-01-01 00:00:00-05'::timestamp with time zone) AND ("createdAt" <= '2020-12-31 23:59:59-05'::timestamp with time zone)) -> Bitmap Index Scan on "temp_createdAt_idx" (cost=0.00..2122.75 rows=101032 width=0) Index Cond: (("createdAt" >= '2020-01-01 00:00:00-05'::timestamp with time zone) AND ("createdAt" <= '2020-12-31 23:59:59-05'::timestamp with time zone))

And when running a longer query: Finalize Aggregate (cost=14596.71..14596.72 rows=1 width=8) -> Gather (cost=14596.49..14596.70 rows=2 width=8) Workers Planned: 2 -> Partial Aggregate (cost=13596.49..13596.50 rows=1 width=8) -> Parallel Seq Scan on temp (cost=0.00..12620.00 rows=390597 width=8) Filter: (("createdAt" >= '1990-01-01 00:00:00-05'::timestamp with time zone) AND ("createdAt" <= '2020-12-31 23:59:59-05'::timestamp with time zone))

New comment by CapriciousCptl in "Endless Sky: an open source space trading and combat game"

CapriciousCptl — Tue, 17 Aug 2021 01:42:43 +0000

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 hours of the night to play inconspicuously (without tying up the phone line). It was freeware and featured in PC Gamer. Eventually cheaters/bots overtook the game, literally DDOSing the thing as each "node" could only support maybe 50 ships because of how they were displayed in game (~5x10 grid or so). Ultimately, the studio didn't have a solid monetization strategy and the project disappeared off the face of the earth when its users spiked. They would have made a killing with micro-transactions, but online payments weren't ubiquitous then. Instead these poor devs spent all this time/money developing the game, maintaining the servers and fighting cheaters for free before the whole thing crumbled under its own weight. It lived on in clones (Rillaspora, Xiaspora and The Reunion) but they all died within a year or two.

[1] https://en.wikipedia.org/wiki/Diaspora_(video_game)

New comment by CapriciousCptl in "Rails 6 with Webpacker 6, Tailwind 2 with JIT, Postcss 8 and some default setup"

CapriciousCptl — Sun, 15 Aug 2021 15:49:29 +0000

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.

New comment by CapriciousCptl in "Amazon Web Services In Plain English (2019)"

CapriciousCptl — Sun, 25 Jul 2021 12:29:14 +0000

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 newcomers in 2021 although probably unintentional.

New comment by CapriciousCptl in "Google broke a conditional statement that verifies passwords on Chrome OS"

CapriciousCptl — Fri, 23 Jul 2021 00:22:08 +0000

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 = versus a double == but also in if statement.

New comment by CapriciousCptl in "An app for M1 Macs that plays the sound of a fan as CPU usage goes up"

CapriciousCptl — Sun, 18 Jul 2021 19:27:50 +0000

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 cue was hitting the critically low power (10%?) at 6 hours instead of 12. Now there's this app. Thank you!

New comment by CapriciousCptl in "Postgres sequences can skip 32 unexpectedly"

CapriciousCptl — Fri, 16 Jul 2021 19:14:52 +0000

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 still use them as such. Is the type of thing that doesn't bite you until production.

Postgres docs-- https://www.postgresql.org/docs/13/sql-createsequence.html > Because nextval and setval calls are never rolled back, sequence objects cannot be used if “gapless” assignment of sequence numbers is needed. It is possible to build gapless assignment by using exclusive locking of a table containing a counter; but this solution is much more expensive than sequence objects, especially if many transactions need sequence numbers concurrently.

New comment by CapriciousCptl in "Show HN: Unlimited, free intraday stock data API"

CapriciousCptl — Sat, 10 Jul 2021 08:10:11 +0000

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

New comment by CapriciousCptl in "Show HN: Unlimited, free intraday stock data API"

CapriciousCptl — Sat, 10 Jul 2021 06:54:37 +0000

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? Also, cash flow? Emphasis on free cash flow.

New comment by CapriciousCptl in "All public GitHub code was used in training Copilot"

CapriciousCptl — Fri, 09 Jul 2021 11:37:47 +0000

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.

New comment by CapriciousCptl in "Ask HN: Is this the most quoted quote on HN?"

CapriciousCptl — Thu, 08 Jul 2021 13:38:48 +0000

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=all&page=0&prefix=false&qu...

New comment by CapriciousCptl in "Robinhood S-1 IPO"

CapriciousCptl — Fri, 02 Jul 2021 00:43:25 +0000

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

etc

New comment by CapriciousCptl in "Robinhood S-1 IPO"

CapriciousCptl — Thu, 01 Jul 2021 21:49:21 +0000

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

New comment by CapriciousCptl in "Ask HN: Why Poetry did not become a mainstream package manager for Python?"

CapriciousCptl — Sat, 19 Jun 2021 12:50:46 +0000

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 minimizing surprises then elegance which means it’s really hard to replace something that works. Poetry only hit 1.0 in 12/2019, so maybe I’ll try it if the api remains stable for another few years. Contrast that to JS where we’re now on webpack 5 I think and there’s really no long term support available.

New comment by CapriciousCptl in "80% of orgs that paid the ransom were hit again"

CapriciousCptl — Fri, 18 Jun 2021 19:41:40 +0000

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 owners would let go at a trifling price owing to their fear and uncertainty"[1].

Plutarch was closer to Crassus than I am so I guess I can't argue.

[1] https://penelope.uchicago.edu/Thayer/e/roman/texts/plutarch/...