Stylus 🦉 is a user on octodon.social. You can follow them or interact with them if you have an account anywhere in the fediverse. If you don't, you can sign up here.

Anyone who does super basic db stuff in python want to tell me whether I'm committing some heinous sin? I mean, it looks good to me, based on this thing I found. tootplanet.space/media/7-D7OwH

Stylus 🦉 @stylus

@InspectorCaracal As for how Python's DB API handles query parameters, ugh, they allowed each database to make its own choice. Using "?" is one valid choice, and sqlite chose that one. But some other implementation might choose another :(

>>> sqlite3.paramstyle
'qmark'

python.org/dev/peps/pep-0249/#

· Web · 0 · 0

@stylus I'll have to remember that! I'm aiming at using sqlite at the moment since I heard it plays nicely with python