Software Contents Archive

It's very common for e.g.: Next.js API Routes or Pages to perform several roundtrips to the database. You should always aim to make your data requests as concurrent as possible (e.g.: `Promise.all`), but 'serialization' (in sequence) is sometimes impossible to avoid.

My other #DjangoCon sprint project today, suggested by @carltongibson, was to run some experimental load tests against a Django SQLite application to see at what point concurrent writes would break things Notes so far in this thread: https://t.co/149xJEE4Yd

As an industry we've been unnecessarily conflating "v8 isolates boot faster" with "*all* v8 isolates must execute close to the user" 🥲 Proximity between the compute and the database matters when waterfalls are involved. How does this affect you?

Goodbye #DjangoCon! Had an absolutely fantastic week in San Diego, thanks everyone who made the event such a welcoming place

Vercel now gives you full flexibility to leverage this faster, more cost-effective runtime… where you need it Sensible defaults are applied. For example, Next.js Middleware is global (and fast when cold) on Vercel by default, just like TLS Start today: https://t.co/gQyuWnG2eH

Also huge credit to the event organizers and the attendees for making it feel so Covid-safe - fantastic mask discipline indoors, and lots of well ventilated socializing outdoors (including all of the conference meals)

Short version: SQLite in its default journal mode starts seeing database locked errors as you increase traffic to it Turn on WAL mode... and the errors straight up vanish

Access 45K bootiful Halloween design assets including 3D illustrations, Lottie animations and more 👻 Witches, ghouls and bats…oh my: https://t.co/6eJBsLw1Ba https://t.co/IAF0NBryNP

GM takes another full-size pickup electric with the 400-mile range GMC Sierra EV https://t.co/YL8kfyThgt by @jaclyntrop and @kirstenkorosec

San Diego travel tip (for people still at #DjangoCon) - ask your cab driver for their favorite taqueria, guaranteed to spark a fun and valuable conversation!

If you think battering Django and SQLite with load tests sounds like fun you're welcome to jump into my repo here and join in https://t.co/6trVLo3KUz

I expected that even WAL mode would fall over as I ramped up the parallel clients (using Locust)... but to my surprise it did not. And running four parallel workers with Gunicorn - which I thought would definitely break things - stubbornly refused to fall over either!

There's still a lot more testing I want to do - in particular my tests so far have just involved writes that increment an integer counter, which isn't representative of a more challenging write load But these initial experiments went a lot smoother than I had expected!

Uils wants to lend LatAm's rideshare drivers cash based on their driving record #Disrupt2022 https://t.co/ha9dSqRFGG by @kyle_l_wiggers

Pillar of the community: How Talkbase plans to power user-led growth for any company #Disrupt2022 https://t.co/zrpGniObOf by @psawers