One of the strengths of SQLite is having the flexability to hook it up to any language you like. But it would make life easier for everyone if there was some sort of standard built-in simple scripting language to create stored procedures and custom functions within the standard SQLite distro to avoid exactly this sort of compatability problem. Maybe some sort of simplififed PL/SQL or Transact/SQL with the scripts autoloaded from an sqlite system table. Or perhaps a standard SQLite convention to register a language with it and have stored procs and functions of that language autoload when the database is first attached. Anyone could easily write such an extension, but having it as a standard in the distro is the key.
--- Dennis Cote <[EMAIL PROTECTED]> wrote: > Jeff Godfrey wrote: > > I'm curious how others handle this. > > > > A. You don't need or use any custom SQL functionality > > B. You don't use a 3rd party SQLite management tool > > C. Something else I haven't thought of? > > > Jeff, > > I think it is mostly A, or B, or at least it alternates between A and B > depending on the database. > > Part of the problem is that the loadable extensions are not portable > between platforms, so you can't count on having an extension available. > Without certainty that the extensions will be available, you can't use > them in the schema of your database (like trigger statements or views). > > For a custom application you can add code that creates the required > extensions when you open the database, so they will always be available > from within that application, but that precludes the use of 3rd party > tools since there is no standard way to tell a 3rd party tool which > extensions it should load when it opens a database. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
