SQLite Forum

User Defined Functions
Login
Given that C/C++ is not in my skills set, I need some help/guidance on two issues:

<b>A.</b> When should I use sqlite3_create_function as opposed to building an SQLite extension and loading it? 

As far as I can see, both options are connection bound and evaporate on the connection being closed and I realise that building an extension is a neater way when creating many functions


<b>B.</b> Anyone has a worked example (of something simple, like adding a number to an existing column in a table in the current connection) of using sqlite3_create_function? <i>I can adapt the template for my purposes.</i>