Readit News logoReadit News
ki85squared commented on You probably don't need query builders   mattrighetti.com/2025/01/... · Posted by u/mattrighetti
bruce511 · a year ago
Replying to this whole sub-thread, not just this post specifically;

All SQL advice has to take _context_ into account. In SQL, perhaps more than anywhere else, context matters. There's lots of excellent SQL advice, but most of it is bound to a specific context, and in a different context it's bad advice.

Take for example the parent comment above; In their context the CPU of the database server is their constraining resource. I'm guessing the database if "close" to the app servers (ie low network latency, high bandwidth), and I'm also guessing the app developers "own" the database. In this context moving CPU to the app server makes complete sense. Client-side validation of data makes sense because they are the only client.

Of course if the context changes, then the advice has to change as well. If the network bandwidth to the server was constrained (cost, distance etc) then transporting the smallest amount of data becomes important. In this case it doesn't matter if the filter is more work for the server, the goal is the smallest result set.

And so it goes. Write-heavy systems prefer fewer indexes. Read-heavy systems prefer lots of indexes. Databases where the data client is untrusted need more validation, relation integrity, access control - databases with a trusted client need less of that.

In my career I've followed a lot of good SQL advice - advice that was good for my context. I've also broken a lot of SQL "rules" because those rules were not compatible, or were harmful, in my context.

So my advice is this - understand your own context. Understand where you are constrained, and where you have plenty. And tailor your patterns around those parameters.

ki85squared · a year ago
The most sensible and pragmatic advice in this thread.
ki85squared commented on A three month review of kagi search and the orion web browser (2024)   flatfootfox.com/a-three-m... · Posted by u/Apocryphon
nicce · a year ago
Value proposition should be compared to the low cost alternative. Is it $10 better than Google? Maybe, I am not sure.
ki85squared · a year ago
I am comparing it to the low cost alternative.
ki85squared commented on A three month review of kagi search and the orion web browser (2024)   flatfootfox.com/a-three-m... · Posted by u/Apocryphon
Kokouane · a year ago
Kagi is a tough pill to swallow. Their search is hands down the best around, there's no other way around it.

That being said, $10/mo is also expensive.

The workaround I found is using Kagi Ultimate. I get access to Claude (and I'm still able to attach files + access a dozen other LLMs) for $25/mo, so I was able to cancel Claude and keep Kagi and get the best of both worlds from either product.

Side note: incredible that a small team like Kagi's can somehow use LLMs more effectively in search than a company that has years of search experience (i.e. Google)

ki85squared · a year ago
Can't say I understand how $10/month is expensive.

Quality search results ultimately save time digging through poor quality search results. Add up 300+ searches per month and surely you're hitting minimum wage value at least.

The value proposition is absolutely there at $10.

ki85squared commented on ChatGPT Search   openai.com/index/introduc... · Posted by u/thm
umvi · a year ago
At some point it seems like Google switch to ML-based search instead of index based search. You can search for very specific combinations of lyrics and scenes: "eyes on me pineapple bucket of water house of cards chess time loop" and you won't surface a link to the music video featuring all of those things (https://www.youtube.com/watch?v=AlzgDVLtU6g), you'll just get really generic results of the average of your query.
ki85squared · a year ago
FWIW, ChatGPT Search didn't surface the video either with that query

> Based on the elements you’ve described—eyes, a pineapple, a bucket of water, a house of cards, chess, and a time loop—it’s challenging to identify a single music video that encompasses all these features.

ki85squared commented on Why Should I Care What Color the Bikeshed Is? (1999)   bikeshed.com/... · Posted by u/Tomte
ki85squared · 2 years ago
Keen to read the original thread referenced in the email, but I can't find it anywhere.
ki85squared commented on PuTTY vulnerability vuln-p521-bias   chiark.greenend.org.uk/~s... · Posted by u/aardvark179
e79 · 2 years ago
I did a bit of a deep dive into this, in case anyone is interested. I think reading the code is a great way to understand _why_ this vulnerability happened:

https://ericrafaloff.com/your-putty-generated-nist-p-521-key...

ki85squared · 2 years ago
Thank you. Your writeup helped make it click!
ki85squared commented on 1Password rolling out “privacy-preserving” telemetry system   blog.1password.com/teleme... · Posted by u/LopRabbit
pfych · 3 years ago
The actual post mentions the following:

> We’ve designed our telemetry system to collect data on “events”. An event is essentially an action, like: Finishing our in-app onboarding, Unlocking 1Password, Creating a new item, Filling an item in a website or app.

> We won’t be collecting your saved passwords, passkeys, usernames, and any URLs associated with your items. Your private information is just that – private.

With it also being opt-in I dont see an issue with collecting basic numbers for how often people use the plugin or app, as long as they're telling the truth, I think it's fine.

ki85squared · 3 years ago
Thank you. Parent clearly didn't read the details. And wtf is with their claim of "exfiltration" when it's opt-in and you're already explicitly entrusting 1Password with your data? smh...
ki85squared commented on Crazy Thin ‘Deep Insert’ ATM Skimmers   krebsonsecurity.com/2022/... · Posted by u/todsacerdoti
kibibyte · 3 years ago
With gas stations, there is so much more to it than just replacing a card reader in the kiosk, or even just replacing the kiosk itself. You may have to even tear out all of the old networking equipment. https://news.ycombinator.com/item?id=28207062
ki85squared · 3 years ago
Thank you for this. How much of an impact is this having 1+ years on? I'm sure it's still substantial but wanted to ask if you had any current data.
ki85squared commented on Kiwi Farms response to CloudFlare   kiwifarms.ru/threads/matt... · Posted by u/boastful_inaba
dotty- · 3 years ago
The argument is about whether it's "morally" ("ethically"?) right for Cloudflare to terminate services after their public stance. Yeah, I get Cloudflare can do whatever they want, but I want to know if I can trust Cloudflare to not go back on their public positions.

Even as someone who never visited KF before this saga, you must admit that this campaign against KF is coordinated and that you can't expect either side to be completely honest. It's already been documented that Keffal's side has been either dishonest or has strongly exaggerated details during parts of the campaign and her origin story really doesn't help her case. I've also seen some of the rhetoric coming from KF, and it's incredibly toxic and understandable why someone wouldn't want it online.

Cloudflare originally voiced their support (albeit not mentioning KF by name) for offering security services to _any_ customer -- a stance I can understand and can support. But it's difficult for me to keep supporting CF because it took less than 1 week for them to go back on their public stance. It also doesn't help that CF was not more specific about the threat made that made them change their mind. It would help me be more on their side instead of it just looking like a copout.

If I had to choose a bucket, I'd lean more into the neutral category, because this situation is just so incredibly complicated and nuanced if you've looked deeper than the news stories. I don't think a coordinated social media campaign started by a leader with an incredibly dubious history should win outright, and I can completely understand CF's position of not wanting to be affiliated with KF anymore.

ki85squared · 3 years ago
> you must admit that this campaign against KF is coordinated and that you can't expect either side to be completely honest

Stating the obvious. Coordination is a prerequisite for any campaign/change movement, and no one is perfect.

But on coordination: I began advocating against CF after listening to @lizthegrey [1], a leader of the campaign, lay out the evidence of harassment - not exclusive to keffals - going back years [2]. (I mildly trust keffals by proxy, but I too am unsure of her history.)

My involvement of message amplification was purely voluntary and I received zero direction from anyone. The new friends I made along the way seem to be in the same boat. This was organic political discourse over an issue that finally came to a head.

[1] https://twitter.com/lizthegrey [2] https://twitter.com/lizthegrey/status/1560771369134170113

ki85squared commented on “Shit Academics Say” Twitter account hacked, Twitter Support refusing help   twitter.com/prof_nch/stat... · Posted by u/CaliforniaKarl
wbobeirne · 3 years ago
Looks like it's been restored: https://twitter.com/academicssay
ki85squared · 3 years ago
The account was hacked, not suspended. The spammy NFT Tweets are what the owner is looking to take down. https://twitter.com/Adidas_Web3/status/1548084214486118402

u/ki85squared

KarmaCake day34December 31, 2015
About
[ my public key: https://keybase.io/kandersonus; my proof: https://keybase.io/kandersonus/sigs/tmtigfyWDXp7RILI_aNvjlSkHESk2uMHlEpcENMsrJ8 ]
View Original