Tootfinder

The depth of testing behind sqlite is insane: https://www.sqlite.org/testing.html

TIl With SQLite you can write the results of queries directly to files. It also supports many different formats.
```
.headers [on|off]
.mode line
.output filename
SELECT * …
.output stdout
```
#sqlite

Been trying to get gud at #sqlite by moving some of the post-processing of data in Claw into SQLDelight queries themselves and I'm pleasantly surprised on the daily by how capable SQLite is. Sorting rows by a date column and then grouping them by month was less lines in SQLite than Kotlin and actually ended up being faster too.

I set up Gitea on my local file server and it was really easy (though it tries to talk you in to setting up mysql but I insisted on using sqlite). It works really well! I didn't think I'd use a self hosted git server, but it turns out I'm using it a lot. Definitely recommend https://about.gitea.com<…

Gitea Official Website
Gitea - Git with a cup of tea! Painless self-hosted all-in-one software development service, including Git hosting, code review, team collaboration, package registry and CI/CD

The Untold Story of SQLite
https://chtbl.com/track/7D91G/traffic.libsyn.com/corecursive/066-sqlite.mp3

Ever wanted to do something with the #stackoverflow data dumps but found their multi gigabyte XML files too hard to deal with?
SEqlite's for you! It's the info from the dumps you probably care about, preprocessed into SQLite databases with indexes.
The 2024-04-01 version is now up at

SEqlite

Trying out SQLx in the #rustlang stack in #RustRover. The mapping to tuples is neat and the presence of connection pools is cool.
The docs say SQLx is NOT an ORM. It's a query API.

Me: opens Xcode
Me: “ok nerds, watch and learn”
Me: chat.OpenAI.com
“How do I remove duplicate rows from a table where the id matches in swift using the c SQLite api”

Been trying to get gud at #sqlite by moving some of the post-processing of data in Claw into SQLDelight queries themselves and I'm pleasantly surprised on the daily by how capable SQLite is. Sorting rows by a date column and then grouping them by month was less lines in SQLite than Kotlin and actually ended up being faster too.