Sabitlenmiş Tweet
segfault
2.8K posts

segfault
@CookingCodes
you are most precious token
United States Katılım Nisan 2022
354 Takip Edilen225 Takipçiler

He who controls the Spice... controls the future
SpiceX
TBPN@tbpn
BREAKING: SpaceX to list under the ticker $SPCX
English

@mamiczi nie wiem czy zdajesz sobie sprawe ale to jest GRUBE wykroczenie na to są paragrafy
Polski
segfault retweetledi

@ivanka_humeniuk @AngryTomtweets the only thing big there are her boobs
English

@AngryTomtweets Who even needs giant budgets these days...
English

> open source model
> is 7x cheaper than opus
> is barely behind
something you should defn use for all your general tasks

Z.ai@Zai_org
GLM-5.1 is available to ALL GLM Coding Plan users! z.ai/subscribe
English

@HabsFan3588 @BestBallJunkie @baby_ivoryy @MbarkCherguia Don’t pick fights with people you can’t take then
English

dodano kod weryfikacji wieku do systemd. Niektórzy użytkownicy Linuksa panikują. Słusznie?
The Lunduke Journal@LundukeJournal
Moderators of the r/Linux subreddit are now censoring posts which talk about Age Verification. Not only are posts being removed, but I’ve heard from multiple Reddit users who have been banned from r/Linux for expressing opposition to Age Verification.
Polski

This is a huge unbounded query on a 70M row table.
I wouldn’t run it as-is. I’d break it down step by step.
1. Understand the use case
- Does the UI really need 6 years of data in one call?
- Can we limit the range or paginate?
2. Check indexing
Make sure there’s an index on the filter
INDEX(created_at)
or better if combined filters exist
INDEX(created_at, other_filters)
3. Avoid returning massive payloads
- Add pagination / cursor-based API
- Or return aggregated data instead of raw rows
4. Consider partitioning
If this query is common
- Partition by date (created_at)
→ Only relevant partitions are scanned
5. Precompute / cache
For reports:
- Use materialized views / summary tables
- Or cache results (Redis, etc.)
6. Async processing
If it’s a heavy report
- Trigger a background job
- Return a report ID / download link
English

I'm joining SpaceX and xAI, working closely with Elon and team to build superintelligence.
Together SpaceX and xAI combine physical and digital intelligence under a leader who understands hardware at the deepest level. Add a high-agency culture with frontier-scale resources, and you get the possibility to achieve something truly unique.
I’m excited to advance the fields I’ve obsessed over for years, from robotics research to building AI models on the founding teams of Mistral and TML. Both were extraordinary journeys with extraordinary people that shaped how I think about building intelligence from the ground up.
Grateful for everything that brought me here and can’t wait to get started.

English
























