Sqlite Is Getting So Good

Recorded live on twitch, GET IN
### Article

## support me via the link

### My Stream

### Best Way To Support Me
Become a backend engineer. Its my favorite site

This is also the best way to support me is to support yourself becoming a better backend engineer.

MY MAIN YT CHANNEL: Has well edited engineering videos

Discord

[LiveType]

Sqlite is godly. I started using it instead of json files for small projects. Somehow it's faster for tiny datasets. Didn't expect that.

[KevinInPhoenix]

I came here for Sqlite but the presentation just mentioned it and then took a hard turn to Rust and deadlocks.

[JohnLovell-FTW]

Fun fact: I referenced a video of yours about SQLite for a NotebookLM generated podcast. The "host's" now call SQLite "Squeel Lite" now. Thanks for nothing pal! :)

[stephan]

1:07 Reinventing the wheel is a fantastic way to understand the _wheel_ more broadly.

[JeremyKolassa]

"Blame the tools."

I literally LOL'd. Perfect delivery.

[giorgos-]

Imagine when Prime discovers formal methods and starts writing specifications

[ryanrobbins]

🔥 love the sponsorship Acknowledgement straight out of the gate.

[uuu]

I use SQLite for my beginner projects whenever I start a new programming language, typically a TODO list (yes, technically reinventing wheel, no I dont care that there's alot, its for learning, people should reinvent the wheel to learn), and its amazing

[seanwoods]

The expert system I maintain (IRM) is actually one of the original applications that Sqlite was developed for.

[EmilioBPedrollo]

DST is the acronym for STD in my native language. Listening to this video was an experience.

[remrevo]

7:30 When you hold a non-async safe lock across an async boundary, the executor might suspend the task for an unknown amount of time.
During that time another task that waits on the same mutex might be woken up and then wait until the first task lets go of the mutex, which will block the executor from continuing to execute the first task, which leads to a deadlock where all threads of the executor are all blocked by the mutex.

[_tsu_]

Rawdogging sync rust is indeed the way the lord intended it. But i am using Embassy, which is async and i am loving it. Calling await on a physical pin that resolves when there is physically 3.3v on it is wild.

[canoozie]

The way you do aggregates (or rather a way), is to use an external cache, something like a redis or whatnot, to save the per-user metrics you want to aggregate, and then work on the cache when it comes to finalizing the numbers.

[interdimensionalsailboat]

Petition to actually change it to squeel.

[mattymattffs]

I work with multi-tenant databases. The issues usually come from not balancing the load correctly. In our testing we found pretty much every version of standard squeal postgres Microsoft whatever to be faster than squeal light

[JonathanFraser-ih]

Don't run aggregate jobs across the databases, run it across your event log. Give every user a mutable DB that stores the live data, but pool all the user events for aggregation.

[omar_benaidy]

so funny to see an idea you thought of on the throne the day before being discussed in a youtube video, I love it

[JoshMillikan]

i love that every point in the conclusion of why spells out "borrow checker" aka thats the whole reason why.

[scotmcpherson]

I love SQLite. It’s so versatile and fast as hell.

[JohnKerbaugh]

Did they reinvent the wheel?
Or did they make of their own wheel so that they could have the wheel that they need?
I just feel like this saying inappropriately used sometimes.