SQLite
SoftwareWikipedia
199
MENTIONS
73
EPISODES
60
PODCASTS
Search complete. 199 mentions across 73 episodes found for "SQLite".
Sep 11, 2026
Chris OliverHOST
And that's kind of how the email... works out too like everybody's like yeah we're in it with you too like you run our stuff and we'd be paying triple if we're on heroku still so yeah you could even charge us double and we're still paying less than heroku so keep going we're developers first and like write code but realizing yeah the more conversations you can have with people, the better.
Chris OliverHOST
There's constantly like, yeah, why did we never have SQLite database backups? I just never thought about it for whatever reason.
Chris OliverHOST
Somebody emailed in like a month ago and I was like, what? We don't have that.
Chris OliverHOST
Let me go do that tonight.
Chris OliverHOST
And like shipped it the next day and was like, here you go.
Chris OliverHOST
And also everybody else was like, when we announced it, yeah, why didn't you have that? It never crossed my mind, but I just didn't think about it.
Ryan CastilloGUEST
Yeah, and that's another feature, right? That's another reason why people don't go to Heroku because they're like, hey, how do I deploy with just SQLite? Yeah.
Ryan CastilloGUEST
And how do I do? That's supposed to be removing that barrier of setting up Postgres or MySQL, just having a database file on your directory and deploying that.
Artificial IntelligenceNARRATOR
For 24 tracks with one integer and one struct each, is perfectly adequate.
Artificial IntelligenceNARRATOR
No reason to reach for core data or SQLite.
Artificial IntelligenceNARRATOR
Voice control.
Artificial IntelligenceNARRATOR
Assigning a loop to a track is done by voice.
Louis PilfoldGUEST
This is more for sort of like intermediate to advanced programmers.
Louis PilfoldGUEST
It challenges you to make systems like Redis or SQLite or Git, but in a new language.
Louis PilfoldGUEST
And it gives you a lovely framework for developing and testing it.
Louis PilfoldGUEST
And if you want to do that and support Gleam, there is a, on our documentation page, there is a link, there's a referral link for that.
CleoHOST
Why does the software suddenly care if I'm running Node 26? What is actually breaking under the hood on older versions?
DevHOST
The primary culprit is a dangerous SQLite text truncation risk on unsupported runtimes.
CleoHOST
Text truncation.
DevHOST
Right.
Pedro HolandaGUEST
And maybe just to add, the color format also allows you to do vectorized query execution.
Pedro HolandaGUEST
The basic idea of vectorized query execution is that you can actually have batches of your data going through your query plan uh in one go right unless you have a pipeline breaker like a join or something like this but usually you can go through the whole query in one go and because you have these batches are sufficiently small they just get cash on your cpu and then you don't have to constantly go through memory to fetch the data anymore while in a tuple uh wise execution which is like what sqlite does and it was created more like when memory was small so you want to like to to just have a little bit of your data in memory, like from the 90s.
Pedro HolandaGUEST
You just go and execute through the query plan, tuple by tuple, right? So this causes a bunch of cache misses.
Pedro HolandaGUEST
You frequently have to go to memory to fetch the next tuple and so on.
Guillermo Sanchez-DionisGUEST
I think the DuckDB experience was always very nice to run on a laptop, right? Or to basically, if you wanted to run like an EDL pipeline, let's say, on an EC2 machine, DuckDB was a great tool.
Guillermo Sanchez-DionisGUEST
But I think at least with the original .db file format, there was this sort of limitation around one writer grabbing the log over the file and then no readers can connect to it.
Guillermo Sanchez-DionisGUEST
And I think that is not a limitation, of course, if you're running .db in your laptop, but it is a limitation if you want to share a dark db storage with a broader audience quack indeed is something that solves this problem right but then that means of course that you go into the client server kind of architecture i think sqlite does this a little bit different where even on a On a single machine with a single file, you can still have writers and readers at the same time.
Guillermo Sanchez-DionisGUEST
But, Greg, if I'm wrong, I want to share about this.
Jake BennettHOST
MariaDB inherits that MySQL grammar, so it works there too.
Jake BennettHOST
Postgres, SQLite, and SQL Server will throw a runtime exception, however, matching how where like handles case-sensitive lookups on engines that already compare case-sensitively.
Jake BennettHOST
So be on the lookout for that.
Jake BennettHOST
I will say one area where you might use this is in the case that you're using some sort of hash So if you're generating some unique hash and you want to immediately double the available options to you, if you're using case-sensitive options versus case-insensitive options, you have another 26 characters per space, essentially.
5 MINS LATER
Jake BennettHOST
In version 2.6.0, the database query will execute queries inside a database enforced read-only transactions.
Jake BennettHOST
So on MySQL and MariaDB, Boost issues a set transaction read only before starting.
Jake BennettHOST
There's a couple of different implementation details for Postgres and SQLite as well.
Jake BennettHOST
Boost will then always roll back the transaction when the query finishes, ensuring that the database engine rejects those modifications, even if a query was to bypass any sort of lexical parsing there.
Dillon MulroyGUEST
And I'll jump back to the beginning of the conversation where there's no context.
Dillon MulroyGUEST
And they'll be like, how do you use durable objects for SQLite storage? What are the APIs? So I basically build up its understanding of the technologies and the patterns I want it using, and then I have these tiny, concise summarizations of the things it worked itself to, and I bring those back to the main line, and then I start iterating with Planetator to build up a tech spec, which is another interesting thing I think I do maybe a little bit differently than most people.
Dillon MulroyGUEST
My tech specs don't look like PRDs.
Dillon MulroyGUEST
My tech specs look like code.
Jan-Niklas WortmannHOST
So Talk me a little bit through that tree concept a little bit more, because there you lost me for a minute.
Jan-Niklas WortmannHOST
So how is that? How do you get back from, so I assume you have like kind of like a couple tree or like branches and leaves at some point then where it's like, okay, this is how Hona works.
Jan-Niklas WortmannHOST
This is how SQLite works.
Jan-Niklas WortmannHOST
This is how, I don't know, we do testing on the project, right? Like isolated, very isolated context and shared understanding in that space.
Brian DouglasHOST
But like there's someone who's listening like, oh yeah, we did that like twice last week.
Brian DouglasHOST
Like, these, like, massive, like, migrations and rewrites and, like, forking projects and, like, rewriting SQLite into Rust yet again.
Brian DouglasHOST
Like, nobody asked for it.
Brian DouglasHOST
But actually, the analogy that I was thinking through when you're talking about this, like, with the, like, agents being built on, like, Bash and stuff like that.
28 MINS LATER
John McBrideHOST
This guy on Blue Sky who I follow, and I use his feed, the For You feed on Blue Sky.
John McBrideHOST
Blue Sky is kind of unique where you can actually subscribe to specific feeds since the whole firehose of data is an open protocol, essentially an open standard in the AT Proto, but For you, I'm just shocked by this.
John McBrideHOST
He kind of chronicles how he uses SQLite for this whole thing.
John McBrideHOST
That's probably ingesting I mean, what does he say? 20 million likes per day.
Stacey EldridgeHOST
And, you know, did you just get a new version on the phone? Have the tools caught up? Are the tools parsing it out all correctly? I know in a recent presentation I attended, they said that The Snapchat data is very complex.
Stacey EldridgeHOST
There's something like apparently 26 different SQLite databases associated with it, around 33 different property lists, 85 different directories, and there's a lot of encryption involved.
Stacey EldridgeHOST
obviously your mileage is going to vary based on what Snapchat version you're examining, but there's a ton of different places to look for that data.
Stacey EldridgeHOST
It's more difficult because encryption is at play at two.
Herman PoppleberryHOST
Which is? A thin native shell over a user-defined schema, not a full app build.
Herman PoppleberryHOST
A single Android app that does one thing, you describe what you want to track, it generates a local SQLite schema, gives you a simple form for each metric, stores everything on device, and exports to CSV or JSON.
Herman PoppleberryHOST
The schema generation could be a local LLM call or even a rule-based system.
Herman PoppleberryHOST
No cloud, no accounts, no
63 more episodes mention SQLite.
Create an account to see the whole feed, search across every transcript, and follow the entities you care about.