On: First Contact with SQLite

[qazxcvbnm]

How do you typically deal with "missing features" from SQLite (e.g. stored procedures)? Do you use extensions like https://github.com/nalgeon/sqlean in production?

[me_bx → qazxcvbnm]

Don't Application-Defined SQL functions fulfill the role of stored procedures?

https://www.sqlite.org/appfunc.html

[qazxcvbnm → me_bx]

Yes, but you have to write C; I am more confident in SQL, and SQL fits better with the rest of my data stack.