Load MacPorts SQLite3 when using RSQLite library
I have a user defined function in SQLite (an aggregator that calculates the product) and it works fine outside R. But I'm on a Mac some of the time, which requires the MacPorts version of SQLite3 if you'd like to add your own functions/extensions.

Can I pick which SQLite3 that RSQLite loads? I don't see anything in the SQLite documentation.

Also, MacPorts appears to change my `sqlite3` link to the MacPorts installed SQLite3:

    mbp:~ richard$ which sqlite3
    /opt/local/bin/sqlite3

But if I want to load the extension in SQLite3, I have to explicitly can the MacPorts version, like this:

    mbp:~ richard$ /opt/local/bin/sqlite3 temp.sqlite

Is writing my own SQLite functions and combining them with R a lost cause? Thanks!
Load MacPorts SQLite3 when using RSQLite library
===

I have a user defined function in SQLite (an aggregator that calculates the product) and it works fine outside R. But I'm on a Mac some of the time, which requires the MacPorts version of SQLite3 if you'd like to add your own functions/extensions.

Can I pick which SQLite3 that RSQLite loads? I don't see anything in the SQLite documentation.

Also, MacPorts appears to change my `sqlite3` link to the MacPorts installed SQLite3:

    mbp:~ richard$ which sqlite3
    /opt/local/bin/sqlite3

But if I want to load the extension in SQLite3, I have to explicitly can the MacPorts version, like this:

    mbp:~ richard$ /opt/local/bin/sqlite3 temp.sqlite

Is writing my own SQLite functions and combining them with R a lost cause? Thanks!