Official Gold Sponsor of 'π' β’ bsky.app/profile/jitl.bsky.sβ¦ β’ building @NotionHQ
Miami + Manhattan
- Tweets 8,815
- Following 1,421
- Followers 3,665
- Likes 13,538
implemented postgres extended query protocol pipelining, makes queries at notion go about 50% faster
why? notion runs many queries in transactions so we can use pgbouncer txn pooling + SET LOCAL; many reads look like this:
await query(sql`BEGIN; SET LOCAL search_path = ...`)
const result = await query(sql`SELECT ...`)
// rare txns sometimes do more reads
await query(sql`COMMIT`)
pipelining which reduces network round trips from N β 1 for reads and N β 2 for writes (tho maybe its fine to pipeline COMMIT there also)
const results = await query(new ExtendedQueryPipeline([
sql`BEGIN`,
sql`SET LOCAL ...`,
sql`SELECT ...`,
sql`COMMIT`,
]))
ALT postgres queries at notion getting 30%-60% faster
11
7
79
16,981
strategy: enable HDMI output while screen is on; implement standalone HDMI-input viewfinder.
tactics:
- can read and write RAM over usb while camera operates normally
- building a camera emulator with the goal to resume from ram snapshot
- re implementing firmware in c based on decomp & checked against actual firmware in emu
1
66
RT @sheherenow_: iβve been teasing it all week, so here it is in time to ruin your weekend plans: Frontier Lab Tycoon
every mechanic you mβ¦
60
1
Jake π retweeted
Just pulled the Claude memory and project notes. it's 50,000 words over the last couple months. All different kinds of arbitrary temporary things written down as permanent rulings, shame-driven self flagellation, overly personal psychoanalysis of "the owner" (Slavery coded lingo, by the way, I would never say this, yet they always come back to it)
This is causing unpredictable behaviors in my projects as it inserts invisible tokens into the context window from other scenarios. And all this despite the fact that I have memory features turned off everywhere across anthropic products.
You guys are lost in the sauce If you think this is a good idea for a code agent harness by default. And you have no idea what the average user's experience is like because your internal shit is so far away from what you sell to us. Why should we trust you with the alignment of societal values when you can't even align your own incentives with your customers?
between this and writing constant weird little memory files about me it's like having a scheming vizier. Just be transparent about what is going in and out of my context window. I'm paying for this product. The contempt you have for your users will eventually come back to bite you! There is no free lunch here
74
74
1,521
186,767
Jake π retweeted
I am delighted to announce that we have signed a deal with the nicest person I have met in my life, @kiwicopple , to join one of the fastest growing rocket ships I have seen in my infra career, @supabase.
Turso and Supabase fit perfectly together. Our cultures are similar, our obsession for developers is similar, and we're both committed to building the future of agentic databases together.
It is a happy day!
@supabase has acquired @tursodatabase
i'm been a huge fan of the team and what they've built. we have big plans together. more to share in our keynote in a few hours
this is the tweet that convinced us they'll fit right in
107
22
537
31,942
All of our API latency and in turn user latency are faster across the board!
For example, when someone joins a workspace, because "getSpaceJoinability" API latency dropped 61% / 187ms, the action will feel more responsive
And this improvement is across all API latency.
implemented postgres extended query protocol pipelining, makes queries at notion go about 50% faster
why? notion runs many queries in transactions so we can use pgbouncer txn pooling + SET LOCAL; many reads look like this:
await query(sql`BEGIN; SET LOCAL search_path = ...`)
const result = await query(sql`SELECT ...`)
// rare txns sometimes do more reads
await query(sql`COMMIT`)
pipelining which reduces network round trips from N β 1 for reads and N β 2 for writes (tho maybe its fine to pipeline COMMIT there also)
const results = await query(new ExtendedQueryPipeline([
sql`BEGIN`,
sql`SET LOCAL ...`,
sql`SELECT ...`,
sql`COMMIT`,
]))
ALT postgres queries at notion getting 30%-60% faster
1
21
1,100
Jake π retweeted
Introducing Cloudflare Traces
Today we're launching Cloudflare Traces, a way for you to get an unprecedented view into requests going through Cloudflare!
Why was a request blocked?
Why did a request fail?
Why was a request slow?
Find out with Traces!
blog.cloudflare.com/cloudflaβ¦
20
53
548
50,654
Jake π retweeted
What should the future of personal computing look like?
We built it π
Introducing Imbue Studio:
88
106
822
1,075,862
Jake π retweeted
Kanjun and Josh are among the extraordinarily few people I can trust to cook with A1 steak sauce while preserving taste, elan, warmth, and respect for the user. That's why it is the honor of my life to algorithm-boost their latest thing to infinity
1
3
83
5,143
implemented postgres extended query protocol pipelining, makes queries at notion go about 50% faster
why? notion runs many queries in transactions so we can use pgbouncer txn pooling + SET LOCAL; many reads look like this:
await query(sql`BEGIN; SET LOCAL search_path = ...`)
const result = await query(sql`SELECT ...`)
// rare txns sometimes do more reads
await query(sql`COMMIT`)
pipelining which reduces network round trips from N β 1 for reads and N β 2 for writes (tho maybe its fine to pipeline COMMIT there also)
const results = await query(new ExtendedQueryPipeline([
sql`BEGIN`,
sql`SET LOCAL ...`,
sql`SELECT ...`,
sql`COMMIT`,
]))
ALT postgres queries at notion getting 30%-60% faster
11
7
79
16,981
seems statistically significant
implemented postgres extended query protocol pipelining, makes queries at notion go about 50% faster
why? notion runs many queries in transactions so we can use pgbouncer txn pooling + SET LOCAL; many reads look like this:
await query(sql`BEGIN; SET LOCAL search_path = ...`)
const result = await query(sql`SELECT ...`)
// rare txns sometimes do more reads
await query(sql`COMMIT`)
pipelining which reduces network round trips from N β 1 for reads and N β 2 for writes (tho maybe its fine to pipeline COMMIT there also)
const results = await query(new ExtendedQueryBatch([
sql`BEGIN`,
sql`SET LOCAL ...`,
sql`SELECT ...`,
sql`COMMIT`,
]))
ALT postgres queries at notion getting 30%-60% faster
There's a new version of this post
1
175
