I've been using Jooq to build my queries (and run them). Beats the hell out of writing prepared statements in strings.
Not sure what power I'm missing though, I've been able to do everything via Jooq that I want to do.
I've been using Jooq to build my queries (and run them). Beats the hell out of writing prepared statements in strings.
Not sure what power I'm missing though, I've been able to do everything via Jooq that I want to do.
That’s Silicon Valley’s MO. Just half a year ago, people were putting crypto BS in their products.
Same, having competitors to Android and iOS would be great.
If you were a company, you might think twice before advertising on a site that has their users actively, publicly, and loudly trashing on the CEO.
Isn’t this just wishful thinking? Let’s be 100% real for a moment, those people posting fuck spez on r/place aren’t doing it because they’re moving or have moved to an alternative, they’re doing it because they are addicted to Reddit and can’t stop using it. The true protest is moving to an alternative like Lemmy.
If I’m an advertiser, all I see is a very captive audience. This isn’t like the Twitter situation, where your ads will be shown to increasingly objectionable content. In fact, with all the users begrudgingly downloading the official Reddit app, the value of advertising on Reddit may be going up not down.
That being said, Reddit has never been a good place for advertising outside of a few niches, and that hasn’t changed, so in the long run Reddit most likely won’t survive. But in the short run, I don’t think this is the victory lap.
A lot of schools use Chromebooks for their students. They’re cheap laptops that are easier to administer than Windows.
That’s really cool! What country do you live in if you don’t mind me asking?
But none of that affects the amount of money they lose.
In fact the CEO of the parent company has been pretty transparent about cost cutting, and I’d bet 30m is probably the lowest yearly losses for Tumblr.
I know people want to make this a moral victory, like the losses are the result of bad community management for Reddit/Twitter/Tumblr but that’s just not true. They were dumpster fires business-wise before they shat on their community, and they were dumpster fires after.
No one has cracked the code on how to make a profitable social media company. The two choices are either community funded (like the Fediverse), or steal all the data like Meta, and arguably the second option isn’t really an option for anyone because Meta would eat your lunch all day everyday.
Wouldn’t any automated system ideally escalate to the next tier of (human) support when it detects something complicated?
Though I agree with you, I don’t think LLMs are lay-off 90% good.
How many of these billboard/muni and bart ads are by companies who end up failing?
It really seems like the billboard/transit ad is perfect for founders with too much money and not enough marketing sense.
Darth Maul was in Tony Hawk’s Pro Skater 3, and you could change his special to the Dark Slide!
Looking it up, he also has the Dark Jedi Grind, which seems wrong, like aren’t the sith and dark Jedi different?
Those building in the background almost remind me of the UK, but this is Bloomington IN based on the coffee?
The point about a binary protocol is interesting, because it would inherently solve the injection issue.
However, constructing an ad-hoc query becomes tedious, as you're now dealing with bytes and text together. Doing so in a terminal can be pretty tedious, and most people would require a tool to do so. Compare this against SQL, where you can easily build a query in your terminal. I think the tradeoff is similar to protobuf vs json.
You could do a text representation (like textproto), but guess what? Now injection is an issue again.
Another thing would be the complexity of client libraries. With SQL client libraries, the library doesn't need to parse or know SQL - it can send off the prepared statement as-is. With a binary protocol, the client libraries will likely need to include a query builder that builds the byte representation since no developers are going to be concatenating bytes by hand, which makes the bar higher for open-source libraries. This also means that if you add a new query feature to your DB, all client libraries will likely need to be updated to use the feature.
And you're still going to need to tune and optimize queries for this new DB. That's just the nature of the beast: scaling is hard especially when you can't throw money at the problem.
Quite frankly, it's a lot of hard tradeoffs to not need to use prepared statements or query builders. Injection is still is an issue for SQL today, but it's been "solved" as much as it possibly can.