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”

@Migueldeicaza unfortunate (or funny, depending on point of view) autocorrect TLD change.
@Migueldeicaza real talk: I’ve been using ChatGPT to write Microsoft.data.sqlite code so I can get rid of dapper and go full native AOT, works well!

@Migueldeicaza If it helps, there’s this project which makes SQLite ”swifty”: https://github.com/stephencelis/SQLite.swift

Unless you want to avoid a third-party library for it.

GitHub - stephencelis/SQLite.swift: A type-safe, Swift-language layer over SQLite3.

A type-safe, Swift-language layer over SQLite3. Contribute to stephencelis/SQLite.swift development by creating an account on GitHub.

GitHub
@Arcticulate it turns out to be too big for the process I need it on. I am running with almost no ram
@Migueldeicaza Oh, interesting. Yeah, I guess there are good reasons why C is popular in memory-constrained situations … as long as memory leaks are avoided, of course, hehe.
@Arcticulate I am still using swift, but not larger libraries