On Mon, Jul 20, 2009 at 08:34:52AM -0500, Jay A. Kreibich wrote:
> If someone is going to take the time to refactor the genfkey code
> into a stand-alone piece of code, I would like to suggest it is made
> into it a loadable module, so that it can be used pretty much anywhere.
That sounds like a good idea. One could SELECT genfkey("some table");
and get back a string that has the trigger statement(s) needed, and one
could then exec those statements. Since SQLite3 is re-entrant this
should be possible.
> Also, if the code is written carefully, it is possible to use the same
> code to compile a module (.dll, .so, .dylib, etc.) or to compile
> directly into an SQLite build with very minimal changes (e.g. using
> #defines). That would be provide the most flexibility to the most
> people.
I agree. SQLite3 would remain Lite, yet the genfkey tool would be
available outside of the shell and without having to execute any
external programs.
Nico
--
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
