Should I expect Python sqlite3 user defined functions to persist in a SQLite database?

Question

I register a user defined function:

conn.create_function("geocode", 4, geocode)

The function is used in a trigger, and the trigger fires correctly after an insert, but the function isn't found:

sqlite3.OperationalError: no such function: geocode

My understanding of this usage pattern may be wrong, is it possible to persist Python functions in the database?

CL. · Accepted Answer · 2018-04-18 21:03:18Z

3

If an application uses more than one database connection then application-defined SQL functions must be added to each database connection separately.

And how could your Python code persist when you can open the same database file later on some other machine?

answered Apr 18, 2018 at 21:03

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1