memeDeFi
2.8K posts

memeDeFi
@memeDeFied
Follow me or don’t follow me I literally do not give a flying fuck
United States Katılım Ocak 2025
0 Takip Edilen36 Takipçiler

i have a feeling he's not gonna give up
Theo - t3.gg@theo
I cancelled my Claude Code sub. I give up.
English

Maybe it’s the Gen-Z in me, but i fully don’t care about privacy. I am post-privacy. I am giving OpenAI access to all of my finances, all of my health data, everything, I don’t care anymore
ChatGPT@ChatGPTapp
A preview for Pro users: a new personal finance experience in ChatGPT. Pro users in the U.S. can securely connect financial accounts, see where their money is going, and ask questions based on the information they choose to connect. Your full financial picture, now in ChatGPT.
English

I can't help but feel personally burned by the Claude Code changes announced today.
We put so much work into wrapping the (atrocious) Claude Agent SDK in T3 Code. It was the ONLY path they supported, so we made it work. It was hell.
Now our users are getting their rate limits cut by 40x, despite us doing everything right.
I listened to the Claude Code team. I had my issues with their direction, but I trusted them and took them at their word.
I will never make that mistake again.
Until we see significant change, it is safe to assume any statement from an Anthropic employee is a lie on a timer.
The rug will be pulled, no matter how many promises are made beforehand.
English

3D Artist Furflection shared a fluffy tail test showcasing their custom-built hair nodes setup with proper hair simulation in Blender.
Details: 80.lv/articles/fluff…
English

SQL has levels to it:
- level 1
SELECT, FROM, WHERE, GROUP BY, HAVING, LIMIT
Master these basic keywords and you’ll be well on your way to mastering SQL.
- level 2
Mastering JOINs:
Most common JOINs: INNER and LEFT
Less common JOINs: FULL OUTER
Joins you should avoid almost always: RIGHT and CROSS JOIN
Mastering common table expressions (CTEs).
The WITH keyword defines a CTE which you can imagine as a “variable” that you can query later.
Using variables like this you can master algorithm techniques like recursion, breadth first search and more!
CTEs also make your SQL much more readable and make your coworkers hate you less compared to nested sub queries.
- level 3
Mastering window functions
Window functions have 3 pieces:
The function (i.e. SUM, RANK, AVG)
The over clause to start the window
The window definition which has 3 pieces:
- how to split the window up with PARTITION BY
- how to order the window with ORDER BY
- how to restrict the window size with ROWS clause (useful for rolling monthly averages)
Understand RANK vs DENSE_RANK vs ROW_NUMBER, I have been asked this in interviews a million times.
- level 4
You understand table scans, b-tree indexes, and partitioning schemes to increase performance.
Doing something like COUNT(CASE WHEN) is much better than doing multiple queries with a UNION ALL. UNION ALL is terrible for all sorts of reasons that I don’t want to get into in this post.
B-trees indexes allow for efficient scanning of data in the WHERE clause.
Use explain plans to understand if an index is actually being used or not!
Partitioning is similar to indexes except it’s a “poor mans” index. It just keeps data in specific folders and skips the folders that don’t include the data I question.
What else did I miss for mastering SQL?
English

@Nithya_Shrii heard a guy beatin meat last time I found a good poop spot
English

@Nithya_Shrii Yeah don’t do this if you share an office with companies with low employee standards
English

@NotHoodlum @TXFartingsworth we should’ve had the Somali daycares just do it
English

Trump claimed that painting the Lincoln Memorial Reflecting Pool would cost $1.8 million. Now the project has ballooned to $13.1 million. Isn’t this exactly what he tried to indict Jerome Powell for, cost overruns?”#CompleteHypocrites
English

worst question from Musk's lawyer the entire trial:
"you consider yourself at the same level as Elon Musk, Bill Gates, Dustin Moskovitz, and Pierre Omidyar, to be making decisions on AGI?"
to YC's ex-president. haha.
so net worth is the AGI governance credential now?
the president of Y Combinator - who funded and advised half the companies shaping the future - doesn't get a seat because his net worth was a rounding error compared to four billionaires?
embarrassing framing. tells you everything about how that side sees the world.
English

@DailyNoud gonna start telling girls I had hantavirus and that’s what happened
English

When we came into office, we uncovered a $12 billion budget deficit.
Today, I’m proud to say we brought it down to zero.
We didn’t close the gap on the backs of working people.
We closed it while funding parks, libraries, safer streets and making historic investments in public housing.
Call it Pothole Politics. Call it Democratic Socialism. It's government that delivers for the people who make this city run.
That’s what New Yorkers deserve. And that’s what we will keep fighting for every single day.
English















