hi, yes, user defined function / callback functionality is there. and of course, user defined functions are great! but i think sqlite should also (try to) compete with alternatives.
for some platforms (scripting languages like php) udf may just be (too) slow. i don't mind nor care adding more of those functions, but i think at least 1 encryption function should be available, for an obvious reason: storing passwords in databases. quite often, there is no need to store the password itself, but you just want some verification. next to that, sqlite does not have any mechanism for restricting access, it depends on file privileges. so you have to think twice before storing passwords in plain text in a sqlite DB. what are arguments for this minimalistic approach? in this case not platform compatability, or code size. i can understand that we do not want to end up with 5Mb of executable code, but smallest possible footprint is not (my) major issue. ----- Original Message ----- From: "Michael Roth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 07, 2004 2:04 PM Subject: Re: [sqlite] OK to drop support for legacy file formats? > Rene wrote: > >>Why not remove the feature but create a seperate utility project that > >>converts any version of SQLITE DB to the latest version. > > > > > > i think it's better to let it in. why save a few bytes for removing such > > important functionality. by the way, same for md5, you should add support. > > You need MD5. The nextone needs SHA1. Another one needs CRC16. Some > folks may need a function to count hills in an given area. > > Sqlite is a database library and isn't an universal calculator. A > software package should do one thing and should it do well. A database > should store and retrieve data and shouldn't calculate crypto stuff. > > If you need a special function foo() use the extension api of sqlite. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
