I got introduced to it by Claude the other day as I was interrogating several GB of public csv files. Seemed magical as it out them all in parquet files and transformed what I needed into the normalized sqllite for my server. Coding agents seen quite comfortable with it!
claude + duckdb combo is legendary for doing quick analysis of huge datasets. every time i need to analyze a big ass csv (200mb+) or as you noted a parquet file or really anything columnar i'll tell claude, 'you have duckdb at your disposal for this' and within minutes it's all sorted (no pun intended)
Until just a couple years ago I would regularly read comments complaining when a website doesn't work because the hacker browses with javascript disabled, for example.
This isn't the early-adopter crowd: it's the refuses to even be a late-adopter crowd.
It is the crowd that understands what parts are functional and in fact chooses security over the dancing bears of the world. It isn't an aversion to tech, it is an aversion to doing things which are worse. In this case massive bloat, ads, and tracking of websites which does the opposite of serving the user when they're just looking for text.
Adoption of technology shouldn't be a binary of 'use it for everything/refuse to use it for anything'.
I can't speak for anyone else, but I have a very strong, borderline-irrational distaste for ads. I hate advertising, I hate having to watch advertisements, I will go out of my way considerably to avoid ads. I have over 400 blu-rays specifically because I wanted to guarantee that I don't have to risk seeing ads in my media.
I liked YouTube Premium because it was an ethical way to avoid ads on YouTube; there's always been adblock but I always felt bad depriving creators of their revenue; most of them (at least at the time) weren't big heartless corporations, they were individuals creating stuff.
If I start seeing ads unless I'm extorted for more money, that might end up being a final straw for me.
I gave up ~2021. Bought one of the 10tb 5200rpm disks and just started yt-dlping entire channels when I found something good. With mixed 360p/480p/720p backups, I've used ~1/5th of the disc across nearly 50,000 files.
This does make me the unethical bad-guy, but my aversion to advertisement is so strong that I can't feel any remorse. AdSense is a scourge on the internet, and once Google is held accountable for it they'll immediately try to extort their licensed library of millions of videos to make a living. And they'll have to try a lot harder than that if they want to deprive me of a daily Tom Scott video with my morning coffee.
Right now it's pocket money, but the content could very easily (and legally) be turned into a different business model if Google's de-facto ad monopoly falls through.
> I liked YouTube Premium because it was an ethical way to avoid ads on YouTube
Why would you behave ethically towards a company that is anything but?
The slight remorse I feel by not using official YT frontends is towards creators I enjoy watching, who I try to support via other means, if possible. But then again, any creator or business who chooses advertising as their only business model doesn't deserve my support.
Advertising is a scourge on humanity. It corrupts every medium of information by allowing sleazy middlemen to psychologically manipulate one party not just into buying products out of manufactured desire, but into thinking and behaving in ways that serve someone's agenda. It is weaponized via platforms built by adtech companies, which have played a major role in the current sociopolitical instability in the world. It is so insidious that even though it has concentrated incredible amounts of wealth into the hands of a few, most people see it as harmless because they get products and services for "free". To hell with all of that.
What I was doing, was use YouTube Premium registered via a VPN. I was paying equivalent to 2 EUR in Indian Rupees. And I did not feel bad about it because the main users were my kids on our TV. Now my kid uses SmartTube on TV, and YouTube ReVanced on a smartphone (with NewPipe as backup, sometimes or the other is broken). So they lost money.
I do believe the better solution is to go to DIY channel, but yeah. I got Amazon Prime, which gives me free shipping on Amazon. Add on top of that, I can freely support one Twitch stream. So I am going with Critical Role. They also sell their own platform, but it is more expensive than Bezos' deal. It is hard to compete with big tech...
I got a hunch feeling my IPv4 is shitlisted here and there though, but it could also be Linux + Firefox + plethora of extensions. I'll get a new IPv4 soon, so a good time to also clear all my cookies and part with some extensions.
> The slight remorse I feel by not using official YT frontends is towards creators I enjoy watching
That's what I felt bad about. I didn't care if I was depriving Google of money, but I was watching a lot of videos of relatively small channels, and I was watching them with ad block, and I wasn't compensating them otherwise. In a bit of fairness (though not much) I was not making much money at the time.
I agree that advertising is bad for humanity. I hate ads. I don't like the idea that a corporation is weaponizing my psychology to sell me crap I don't need. For the most part I would rather pay for things, but of course I make a lot more money now than I did back in 2015.
I've said it before, but I think it bears repeating: people will pay for things if those things don't suck. I think it speaks to the shittiness of the platforms that people will only use stuff like Facebook and YouTube if they're "free".
Yeah I have literally spent tens of thousands to host media that I could technically have access to for a handful of $10/month subscriptions, but I can't stand ads and cross promotion. A nice bonus is that a movie or TV show can't just randomly leave licensing window and disappear from my catalog.
>If I start seeing ads unless I'm extorted for more money, that might end up being a final straw for me.
How is it any different than the price increases that have happened up until now? Or do you mean $27 per month for up to 6 accounts is the most you will ever be willing to pay?
I'm not a huge fan of the current price increase, but what I was referring to was what Amazon Prime did about a year ago.
Amazon Prime has ads by default now, or you can get rid of the ads if you pay an additional $3 a month.
If they start showing some amount of ads on my YouTube Premium, and start charging a fee to get rid of all of them, I think it will just piss me off; I already pay for YouTube Premium, I am not going to pay extra for extra ad free.
I think it is best not to get emotional over a business' marketing decisions.
It is simply a change in price, dressed up to be more palatable for people who are not as discerning.
Before, Amazon Prime Video without ads was the price of Amazon Prime. Then it became the price of Amazon Prime plus $3 per month. Now it's the price of Amazon Prime plus $5 per month or $46 per year.
Same thing with Youtube, or any other product/service, price changes happen all the time. Pay if it is worth it, or don't if it's no longer worth it.
I guess I'm just saying I'm not sure I'm going to put up with another price hike.
I've grown kind of tired of YouTube as of late anyway, and it's not like I get a lot out of it in any kind of deep meaningful sense. I probably could fairly easily justify canceling it and surviving on my blu-rays.
Correct. But the llm can also program you the exact automation you want! Much more efficiently than gui madness with N8N. And if you want observability just program that too!
Already very possible and super easy if you do a little vibecoding. Although it will hit the api. Have a stack polling my email every five minutes, classifying email, taking action based on the types. 30 minute coding session.
I don't get it. Last week on the 100 bucks plan I generated probably 50k LOC (not a quality measure for sure!) and just barely kissed the weekly limit. I did get rate limited on some sessions for sure, but that's to be expected.
I'm curious what are people doing that is consuming your limits? I can't imagine filling the $200 a month plan unless I was essentially using Claude code itself as the api to mass process stuff? For basic coding what are people doing?
This is the problem most people are facing. Before March, I had hit the rate limit as single time. That involved security audit of our entire code base from a few different angles.
As of now, I’m consistently hitting my 5 hour limit in less than 1 hour during N/A business hours. I’m getting to the point where I basically can’t use CC for work unless I work very early or late in the day.
$200 plan and VERY tame usage (not 24/7, not every day even, maybe 8-10 hours for ~4 days). Suddenly I am at 96% weekly (!) limit, multiple session limits, two daily limits.
Either they decimated the limits internally, or they broke something.
Tried all the third-party tricks (headroom, etc.), switched to 200k context window, switched back to 4.5.
I hope 4.5 will help, but the rest of the efforts didn’t move the needle much
I have the same experience as you. I’m wondering if it is regional? I’m in Europe so don’t overlap much with US usage, which is likely to be way higher
Also in Europe and can only agree. Granted I'm on the 20x plan, but I have yet to hit a limit once and I'm using Claude 12h+ per day on multiple projects.
I don't hit limits either on $100, it's more that claude-code seems to be constantly broken and they added some vague bullshit about not using claude-code before 2pm so I just don't expect it to work anymore and tend to use codex-cli as my driver nowadays. I also never hit limits in codex but... codex is $20/mo not $100/mo so it's making me consider relocating the $100 I spend to Anthropic as play money for z.ai and other tools. I think claude-code has great training wheels (codex does not) but once the training wheels come off, and claude-code becomes as unreliable as it has been then it makes you consider alternatives.
Is that true? What I saw was an official announcement linked on the claude code subreddit that said that if you claude code within the high-demand times using a subscription account, then you will now burn through your usage faster than previously. They did have a promotion as a carrot but the stick is the stick.
I feel the Claude subreddits are mostly full of speculation and dramatics, not much productive discussion, like endless exaggerated complaining about downtime. Pretty much the same as a pretty significant chunk of reddit nowadays.
It does look pretty bad, especially not announcing it on a primary channel, but also they claim it's balanced out by efficiency gains and would affect 7% of users overall and 2% of 20x users.
> Your weekly limits remain unchanged. During peak hours (weekdays, 5am–11am PT / 1pm–7pm GMT), you'll move through your 5-hour session limits faster than before. Overall weekly limits stay the same, just how they're distributed across the week is changing.
I'm Eastern time and peak usage works out as 8am-2pm (the bulk of my work day). It's nice that Europe gets to use it in the morning and Pacific gets to use it in the afternoon, but this is completely bullshit and infuriating. I would have no problem if it were 2x outside peak but that's NOT what they're saying.
Yeah I hadn't been aware of that change previously. I'm also ET, but perhaps I just don't use it enough to hit the limits. They could definitely do to be more transparent, maybe instead of percentages, show a "credit" allocation such that the time-based variation in 5-hour windows is visible.
I am also not a heavy user, it's just so frustrating because nothing is ever defined. Something is always under one promotion or another. Abd the vagueness about weekly limits remain unchanged is they refuse to clarify whether that means tokens or number of 5hr blocks per week (that now get used faster during peak).
Yea, I found myself maxing out the $20/mo plan occasionally, so I tried the $100/mo, but I don't think I even once even approached the session limit, let alone the weekly limit. And this is doing what I would consider heavy, continuous programming. I probably ought to go back down to $20 one. It would be nice if they had a cheaper tier in between them, but the tiers they have are probably a good business trick to get people to buy much more than they need.
I’m on the $20/mo plan right now and I hit the limit in under an hour, sometimes 20-30 minutes. I don’t understand how people can work with this plan; maybe it was better before?
Anthropic is going through major growing pains, both technical and organizational. The left hand doesn't know what the right hand is doing. It's chaos, things are changing too quickly, and us users are getting caught in the middle of it.
Think Twitter's fail-whale problems. Sometimes you are lucky, sometimes you aren't. Why? We won't know until Anthropic figures it out and from the outside it sure looks like they're struggling.
I'm in the same camp but I mostly do backed. My coworker doing frontend is chewing through rate limits consistently. React code is quite logic shallow, stuff gets pulled in all over so not localized, especially when you start using js styling frameworks - hundreds of k of tokens to do simple changes.
If you start to parallelize and you have permission prompts on you're likely missing cache windows as well.
What does it look like when you get rate limited? Does the instance just kind of sit and spin?
I suspect I was getting rate limited very aggressively on Thursday last week. It honestly infuriated me, because I'm paying $200 a month for this thing. If it's going to rate limit me, at least tell me what it's doing instead of just making it seem like it's taking 12 hours to run through something that I would expect to be 15 minutes. The worst part is that it never even finished it.
My gut feeling is this is not enough money for them by far (not to mention their investors), and we'll eventually get ratcheted up inline with dev salaries. E.g. "look how many devs you didn't have to hire", etc.
Correct. And also hiving off areas that they own, vs you own. Who has decision right and controls the burn down of the kanban board? Basically treat yourself like an API that they consume. You build the good stuff that you know is right. They are responsible for making their crap works right. (Understandably there is some obvious tension around the interfaces.)
Not sure this is the same site but somebody sure took off with the idea! Just thought it would be fun to post a little history here for the long timers around here!
that's too bad. I'm microdosing tirz -- 1/2 the "starter" dose they use to titrate you on, so essentially 1/4 of the therapeutic dose. Totally helped me reduce appetite driven snacking and eating. I still enjoy food, but now I leave half a beer left on the table. No problem. Makes you wonder what free will is like.
I am in a totally different setup than you though - 225 weight, goal to get down to 180 (my Army weight was 170.) I exercise a lot, and lost 30 pounds through diet two years ago. But it was the hardest thing I've done since Ranger school! So paintful to not eat enough. Gained it all back. I'm in month one of tirz and it is as easy as pie.
Yeah, the 18 months it took me to lose that first 100 pounds was about the most miserable I've ever been in my entire life. Constantly hungry, constantly thinking about food, exercising 3 hours a day, having to sit out of social events because more than half of them involve going to restaurants, etc.
It really opened my eyes to just how food centric society is.
reply