wswope

15 ms·

151.
by wswope 3y ago
Why don't you try installing Nord in a VM and monitoring traffic yourself, instead of taking low-quality blogspam Medium articles at face value? If they're truly hijacking end user clients, why don't you point to the section
152.
by wswope 3y ago
It's not "well-known"- because your links don't say what you're claiming they do, and this is a conspiracy theory that's been shut down on here a thousand times before. https://news.ycombinator.com&#
153.
by wswope 3y ago
Yeah, the gold standard for that (AFAIK) is Michael Bazzell's "Extreme Privacy" book.
154.
by wswope 3y ago
Yeah, crappy example on my end - thank you for fleshing out the details ;).
155.
by wswope 3y ago
Yeah, you've got the right idea. Specifically, functions that operate on TIMESTAMPTZ aren't typically marked as IMMUTABLE (because their output implicitly depends on the connection-level time zone setting), and that IMMUTABLE flag
156.
by wswope 3y ago
Yeah, TIMESTAMPTZ expressions don’t index nicely because they’re nondeterministic (since they depend on session time zone). So if you’re running heavy time-series queries, you can speed them up by adding a predicate that’ll use a AT TIME ZO
157.
by wswope 3y ago
BAAs for OpenAI services are available through Microsoft’s Azure offerings, wherein Microsoft hosts the models on behalf of OpenAI and assumes the compliance responsibilities.
158.
by wswope 3y ago
I’ll bite: Anyone doing fun stuff on the personal-music-collection front with these datasets? I’m a big fan of Picard (via beets), and the ListenBrainz dataset seems like a fun resource for finding new music… but despite being intrigued by
159.
by wswope 3y ago
If you’re talking about a self-hostable Reddit-like service, Tildes’ platform might be a good option if it suits your taste. https://docs.tildes.net/
160.
by wswope 3y ago
Ah, thanks for the correction; I’m guessing I read your comment too literally. Would strikethrough my prior comment if it weren’t past the edit window…
161.
by wswope 3y ago
The implication is that the PL/SQL job was operating rowwise. Batch processing, backed by set theory in this case, is far more efficient than rowwise operations because of the potential for greater parallelism (SIMD) and fewer cache mi
162.
by wswope 3y ago
https://github.com/ellie/atuin
163.
by wswope 3y ago
This is a read-heavy workload per the OP: https://news.ycombinator.com/item?id=36071799
164.
by wswope 3y ago
I take the point of your examples as written in the post, but I think both of those are a bad comparison to the Reddit Premium subscriber table being discussed, because: - We’re already using a database, so there’s very minimal added comple
165.
by wswope 3y ago
Typically, you create a large number of test records and see how your expected access patterns perform.
166.
by wswope 3y ago
> What's an example of a system that generates v1 uuids by default? MySQL. One of many reasons to avoid it.
167.
by wswope 3y ago
Agreed; I don’t mean to imply I’m firmly against controlled burns now. I am disenchanted with our current system for executing them in the US, however. Like you say, we need a system for accountability to deal with the externalities.
168.
by wswope 3y ago
Totally agreed. I was 100% in the pro-controlled-burn camp until I happened to stumble upon the consequences of rubber hitting the road. A few months back I was visiting family in New Mexico and chatting with some locals. I asked offhandedl
169.
by wswope 3y ago
For any historical-context addicts out there, Evan Thomas’ “The Very Best Men” is a grounded yet engaging study of the run-up to the Church Committee that I highly recommend. It spends a lot of time on the backroom dealings and connections
170.
by wswope 3y ago
> The proper term is Immunological memory, and is a complicated subject I don't fully grasp. It’s very obvious. You’re citing a popsci video while accusing others of falling prey to urban legends, and declining to offer references t
171.
by wswope 3y ago
Just to throw additional warnings on the pile, MySQL FKs are not ANSI SQL compliant and can be set up on non-unique columns, which can be a major pain when porting across DBs. https://dev.mysql.com/doc/refman/8.0&#
172.
by wswope 3y ago
Sadly, I don’t know any good references; everything’s a bit more underground these days IME. I hang out on flipping discords, and that’s how I’ve run into/chatted with a few people who were still in the botting scene.
173.
by wswope 3y ago
My point is that power cost is absolutely not the bottleneck, but to address the rest of your comment: 4M is actually relatively low endgame profit per hour. I haven’t touched the botting scene since 2012, but I run 9 merching accounts on t
174.
by wswope 3y ago
Power draw from a desktop running 16 RuneScape clients ≈ 500W @ $0.13/kW h ≈ $0.07 Reasonable profit/hr from botting ≈ 4M/hr/account ≈ $1/hr/account ≈ $16
175.
by wswope 3y ago
Pull kernel source, apply patches, build kernel, run kernel. https://wiki.ubuntu.com/Kernel/BuildYourOwnKernel
176.
by wswope 3y ago
> I can live with print-debugging even if I don't get a true debugger There’s been a plpgsql debugger built into pgadmin for about a decade, FYI.
177.
by wswope 3y ago
While I appreciate it as an irreplaceable tool for countering DDoS, its premise is antithetical to a reliable and open web IMO, and it suffers from the same lack of accessible, customer-facing support as other big tech players. Lazy example
178.
by wswope 3y ago
Cat & mouse game. If you’re defending against a whitehat business scraping with curl from data center IPs, sure. Against a less-savory actor using hundreds of IPs from residential proxies/compromised hosts, you’re gonna have a roug
179.
by wswope 4y ago
Ah, it all makes sense now after seeing that pg_locks query. Thanks for sharing your design! :)
180.
by wswope 4y ago
That helps, thanks. Totally possible that I'm just missing the nuances of your implementation. I'm imagining this is the sorta setup we're comparing: Row Lock - https://pastebin.com/sgm45gF2 Advisory Lock -

More ›