Support for custom SQL functions

Pokrewne:

Cytat:

jgodfrey - Wto Sie 07, 2007 4:00 pm
" />Hi Googie,

I'd really like to see SQLiteStudio support User-defined SQL functions. I have a Tcl-based application that uses 3 separate SQLite databases. Those databases contain some queries that leverage some of my own custom SQL functions (again, Tcl based).

It'd be nice when, opening a new database, if I could not only specify the database name and file but also a file to be loaded *with* the database that contains the custom functions used by that database.

I know that'd probably be a Tcl only solution - which works great for me, though I don't know how (or if) this could be handled more universally.

Currently, when I try to access a view containing a custom function, it's not properly handled. I'll report that in a separate thread.

Thanks,

Jeff

Googie - Wto Sie 07, 2007 4:31 pm
" />Well, I was playing with custom functions. In next beta release there will be predefined tcl() function to call Tcl code in separated Tcl interpreter (the only new feature, I'm trying to stabilize the code).

I'll think about adding some interface for creating own functions, but it meets some security issues to be handled, so I don't think it's going to be included in stable 1.0.0. Probably I'll push it into 1.1.0 (which I'll work as a next after 1.0.0).

Googie - Nie Lis 16, 2008 10:03 pm
" />Implemented in 1.1.0.

Darmowy hosting zapewnia PRV.PL