I would like to be able to use the DBI::Shell (or from the command line dbish) with sqlite AND have access to functions that I have writen in perl.
I'm not sure how to go about this. Do I:
1) write a perl program that connects to sqlite, registers a function using perl code:
Then somehow call up the interactive shell?
2) enter the shell using dbish at the command line then use the /perl command to create and register the new function from inside the shell.
I had just a bit of success with method one, I could hald the perl program and get the shell prompt but I couldn't see any output. Note I entered the dbish by using `dbish:SQLite:name_of_db`
Specifcally I would like to access to the sqrt function while having all the niceness of the dbi interactive shell.