RE: [sqlite] Problem loading extension in Delphi (FTS2)
DISQLite3 does not use SQLite.NET. As I read Sam, he did not say so. He just compared the two to support his argument that "loadable extensions are not required to create custom functions and having access to source is not required for custom functions either". Ralf >I was not aware that DISQLite3 uses SQLite.NET. > >--- "Samuel R. Neff" <[EMAIL PROTECTED]> wrote: >> >> loadable extensions are not required to create custom functions, and having >> access to source is not required for custom functions either. SQLite.NET >> provides very clean support for custom functions written in any .NET >> language and they are loaded automatically by the wrapper from any DLL >> present in the application--they don't have to be added to the SQLite.NET >> codebase. >> >> Sam - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem loading extension in Delphi (FTS2)
Hello Zlatko Matic, >How about Lazarus version of DISQLite3? :) DISQLite3 is Delphi only at the moment, maybe later! ;-) Ralf - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Problem loading extension in Delphi (FTS2)
I was not aware that DISQLite3 uses SQLite.NET. thanks. --- "Samuel R. Neff" <[EMAIL PROTECTED]> wrote: > > loadable extensions are not required to create custom functions, and having > access to source is not required for custom functions either. SQLite.NET > provides very clean support for custom functions written in any .NET > language and they are loaded automatically by the wrapper from any DLL > present in the application--they don't have to be added to the SQLite.NET > codebase. > > Sam > > > --- > We're Hiring! Seeking a passionate developer to join our team building > products. Position is in the Washington D.C. metro area. If interested > contact [EMAIL PROTECTED] > > -Original Message- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 16, 2007 9:34 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Problem loading extension in Delphi (FTS2) > > --- Ralf Junker <[EMAIL PROTECTED]> wrote: > > >Your product is not useful to a few users like me who require custom > > >sqlite functions for their databases. > > > > I am not sure I understand currectly. Only loadable extensions are > currently omited from > > DISQLite3. > > > > sqlite3_create_function() is very well available in DISQLite3 Pro to > create custom SQL > > functions. > > I assumed that people would want to load their custom functions from sqlite > extension shared libraries. But if your customers get source code, I suppose > they can work around this. > > I prefer to have a separate sqlite3 shared library so it can be customized > and upgraded independently of the host application. Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem loading extension in Delphi (FTS2)
Ralf, How about Lazarus version of DISQLite3?:) Regards, Zlatko - Original Message - From: "Ralf Junker" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Thursday, August 16, 2007 11:54 AM Subject: Re: [sqlite] Problem loading extension in Delphi (FTS2) Hello Joe Wilson, Your product is not useful to a few users like me who require custom sqlite functions for their databases. I am not sure I understand currectly. Only loadable extensions are currently omited from DISQLite3. sqlite3_create_function() is very well available in DISQLite3 Pro to create custom SQL functions. DISQLite3 also includes units with ready-made function extensions: * REGEXP regular expression support provided by DIRegEx in DISQLite3RegExp.pas. * Mathematical utility functions [(acos(), asin(), atan(), atan(), atan2(), ceil(), ceiling(), cos(), cot(), degrees(), exp(), floor(), ln(), log(), log(), log2(), log10(), mod(), pi(), pow(), radians(), sign(), sin(), sqrt(), tan(), truncate()] in DISQLite3Functions.pas. Ralf - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Problem loading extension in Delphi (FTS2)
loadable extensions are not required to create custom functions, and having access to source is not required for custom functions either. SQLite.NET provides very clean support for custom functions written in any .NET language and they are loaded automatically by the wrapper from any DLL present in the application--they don't have to be added to the SQLite.NET codebase. Sam --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 16, 2007 9:34 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Problem loading extension in Delphi (FTS2) --- Ralf Junker <[EMAIL PROTECTED]> wrote: > >Your product is not useful to a few users like me who require custom > >sqlite functions for their databases. > > I am not sure I understand currectly. Only loadable extensions are currently omited from > DISQLite3. > > sqlite3_create_function() is very well available in DISQLite3 Pro to create custom SQL > functions. I assumed that people would want to load their custom functions from sqlite extension shared libraries. But if your customers get source code, I suppose they can work around this. I prefer to have a separate sqlite3 shared library so it can be customized and upgraded independently of the host application. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem loading extension in Delphi (FTS2)
--- Ralf Junker <[EMAIL PROTECTED]> wrote: > >Your product is not useful to a few users like me who require custom > >sqlite functions for their databases. > > I am not sure I understand currectly. Only loadable extensions are currently > omited from > DISQLite3. > > sqlite3_create_function() is very well available in DISQLite3 Pro to create > custom SQL > functions. I assumed that people would want to load their custom functions from sqlite extension shared libraries. But if your customers get source code, I suppose they can work around this. I prefer to have a separate sqlite3 shared library so it can be customized and upgraded independently of the host application. Pinpoint customers who are looking for what you sell. http://searchmarketing.yahoo.com/ - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem loading extension in Delphi (FTS2)
Hello Joe Wilson, >Your product is not useful to a few users like me who require custom >sqlite functions for their databases. I am not sure I understand currectly. Only loadable extensions are currently omited from DISQLite3. sqlite3_create_function() is very well available in DISQLite3 Pro to create custom SQL functions. DISQLite3 also includes units with ready-made function extensions: * REGEXP regular expression support provided by DIRegEx in DISQLite3RegExp.pas. * Mathematical utility functions [(acos(), asin(), atan(), atan(), atan2(), ceil(), ceiling(), cos(), cot(), degrees(), exp(), floor(), ln(), log(), log(), log2(), log10(), mod(), pi(), pow(), radians(), sign(), sin(), sqrt(), tan(), truncate()] in DISQLite3Functions.pas. Ralf - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem loading extension in Delphi (FTS2)
--- Ralf Junker <[EMAIL PROTECTED]> wrote: > >Does it support external sqlite loadable extensions? > > Loadable extensions are currently omitted. FTS1 and FTS2 extensions are > provided as built-in > modules. User-aware collations sequences using the Windows sorting functions > are provided in > place of the ICU extension. Full functionality is therefore available. Your product is not useful to a few users like me who require custom sqlite functions for their databases. Of course such users are in the minority. But it's something to think about. Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. http://tv.yahoo.com/ - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem loading extension in Delphi (FTS2)
Hello Joe Wilson, >Does it support external sqlite loadable extensions? Loadable extensions are currently omitted. FTS1 and FTS2 extensions are provided as built-in modules. User-aware collations sequences using the Windows sorting functions are provided in place of the ICU extension. Full functionality is therefore available. >The register calling convention may be a problem there. It can remapped so cdecl extensions could be used. Ralf - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem loading extension in Delphi (FTS2)
Hello Roberto, >Might be a typo, but your declaration defines the calling convention as >'stdcall' (instead of 'cdecl'), was your sqlite3.dll custom built with this >calling convention? I don't think much of sqlite would work with stdcall. DISQLite3 intentionally uses the 'register' calling convention, internally and externally. Delphi prefers 'register' over 'stdcall' or 'cdecl' as the most efficient, since it usually avoids creation of a stack frame. This results in a measurable performance improvement compared to sqlite3.dll. >The problem with DISQLite3 is that it is not free and the sources for the >component is not available. DISQLite3 Personal is free for non-commercial use. Source code is available after registering DISQLite3 Pro. Both editions benefit from 'register' calling conventions, include full text search (FTS1 and FTS2) as well as ample Delphi additions like class wrappers and convenience functions. Ralf - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Problem loading extension in Delphi (FTS2)
No it is all cdecl, which is what I am seeing in the message? :) -Original Message- From: Roberto [mailto:[EMAIL PROTECTED] Sent: 13 August 2007 04:42 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Problem loading extension in Delphi (FTS2) Might be a typo, but your declaration defines the calling convention as 'stdcall' (instead of 'cdecl'), was your sqlite3.dll custom built with this calling convention? I don't think much of sqlite would work with stdcall. On 13/08/07, Andre du Plessis <[EMAIL PROTECTED]> wrote: > > sqlite3_enable_load_extension : function (sqlite3_value: Pointer; AOnOff: > Integer): Integer; cdecl; > sqlite3_load_extension : function (sqlite3_value: Pointer; AFileName, > AProcedure : PChar; > var AErrorMsg : PChar): Integer; cdecl; > > var > Error : Pchar; > ConnectionHandle : Pointer; // Handle you got from call to sqlite3_open > begin > sqlite3_load_extension(ConnectionHandle, 'fts2.dll', nil, Error)); > > This all worked very well for me. > > the problem as you say is that Aducom component does not expose this property > for you, but as far as I know you get the source for the component is > available so it's a small change for you to expose it. > > The problem with DISQLite3 is that it is not free and the sources for the > component is not available. > > Where fts and sqlite is and there are good documentation for fts. > > > -Original Message- > From: Ralf Junker [mailto:[EMAIL PROTECTED] > Sent: 10 August 2007 03:14 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Problem loading extension in Delphi (FTS2) > > Hello Henrik Ræder, > > >I'm trying to load the FTS2 extension in Delphi, using the Aducom > >components. Am really close, but still stuck, and thinking it's a problem > >with the parameter to sqlite3_enable_load_extension(). > > DISQLite3 (http://www.yunqa.de/delphi/sqlite3/) does not expose such problems. > > Look at the full text search demo project which incorporates both FTS1 and > FTS2 into a single *.exe application, with _no_ DLLs or external files needed. > > The new customizable tokenizer interface will be demonstrated by a > Unicode-aware Pascal tokenizer with the upcoming version of DISQLite3 as soon > as the FTS vacuum fix is official released. > > Ralf > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem loading extension in Delphi (FTS2)
Might be a typo, but your declaration defines the calling convention as 'stdcall' (instead of 'cdecl'), was your sqlite3.dll custom built with this calling convention? I don't think much of sqlite would work with stdcall. On 13/08/07, Andre du Plessis <[EMAIL PROTECTED]> wrote: > > sqlite3_enable_load_extension : function (sqlite3_value: Pointer; AOnOff: > Integer): Integer; cdecl; > sqlite3_load_extension : function (sqlite3_value: Pointer; AFileName, > AProcedure : PChar; > var AErrorMsg : PChar): Integer; cdecl; > > var > Error : Pchar; > ConnectionHandle : Pointer; // Handle you got from call to sqlite3_open > begin > sqlite3_load_extension(ConnectionHandle, 'fts2.dll', nil, Error)); > > This all worked very well for me. > > the problem as you say is that Aducom component does not expose this property > for you, but as far as I know you get the source for the component is > available so it's a small change for you to expose it. > > The problem with DISQLite3 is that it is not free and the sources for the > component is not available. > > Where fts and sqlite is and there are good documentation for fts. > > > -Original Message- > From: Ralf Junker [mailto:[EMAIL PROTECTED] > Sent: 10 August 2007 03:14 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Problem loading extension in Delphi (FTS2) > > Hello Henrik Ræder, > > >I'm trying to load the FTS2 extension in Delphi, using the Aducom > >components. Am really close, but still stuck, and thinking it's a problem > >with the parameter to sqlite3_enable_load_extension(). > > DISQLite3 (http://www.yunqa.de/delphi/sqlite3/) does not expose such problems. > > Look at the full text search demo project which incorporates both FTS1 and > FTS2 into a single *.exe application, with _no_ DLLs or external files needed. > > The new customizable tokenizer interface will be demonstrated by a > Unicode-aware Pascal tokenizer with the upcoming version of DISQLite3 as soon > as the FTS vacuum fix is official released. > > Ralf > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > >
RE: [sqlite] Problem loading extension in Delphi (FTS2)
sqlite3_enable_load_extension : function (sqlite3_value: Pointer; AOnOff: Integer): Integer; cdecl; sqlite3_load_extension : function (sqlite3_value: Pointer; AFileName, AProcedure : PChar; var AErrorMsg : PChar): Integer; cdecl; var Error : Pchar; ConnectionHandle : Pointer; // Handle you got from call to sqlite3_open begin sqlite3_load_extension(ConnectionHandle, 'fts2.dll', nil, Error)); This all worked very well for me. the problem as you say is that Aducom component does not expose this property for you, but as far as I know you get the source for the component is available so it's a small change for you to expose it. The problem with DISQLite3 is that it is not free and the sources for the component is not available. Where fts and sqlite is and there are good documentation for fts. -Original Message- From: Ralf Junker [mailto:[EMAIL PROTECTED] Sent: 10 August 2007 03:14 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Problem loading extension in Delphi (FTS2) Hello Henrik Ræder, >I'm trying to load the FTS2 extension in Delphi, using the Aducom >components. Am really close, but still stuck, and thinking it's a problem >with the parameter to sqlite3_enable_load_extension(). DISQLite3 (http://www.yunqa.de/delphi/sqlite3/) does not expose such problems. Look at the full text search demo project which incorporates both FTS1 and FTS2 into a single *.exe application, with _no_ DLLs or external files needed. The new customizable tokenizer interface will be demonstrated by a Unicode-aware Pascal tokenizer with the upcoming version of DISQLite3 as soon as the FTS vacuum fix is official released. Ralf - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem loading extension in Delphi (FTS2)
Hi Ralf Thanks for the tip. I checked it out, and it's a bit complex, but looks very clean. I'll probably update to that component set at a later date. -Henrik 2007/8/10, Ralf Junker <[EMAIL PROTECTED]>: > > Hello Henrik Ræder, > > >I'm trying to load the FTS2 extension in Delphi, using the Aducom > >components. Am really close, but still stuck, and thinking it's a problem > >with the parameter to sqlite3_enable_load_extension(). > > DISQLite3 (http://www.yunqa.de/delphi/sqlite3/) does not expose such > problems. > > Look at the full text search demo project which incorporates both FTS1 and > FTS2 into a single *.exe application, with _no_ DLLs or external files > needed. > > The new customizable tokenizer interface will be demonstrated by a > Unicode-aware Pascal tokenizer with the upcoming version of DISQLite3 as > soon as the FTS vacuum fix is official released. > > Ralf > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > -- Henrik Ræder Clausen CD-rom editor Komputer for alle Jidoka Development Hougårdsvej 29 8220 Brabrand DenmarkTlf +45 6186 0442
Re: [sqlite] Problem loading extension in Delphi (FTS2)
Hello Henrik Ræder, >I'm trying to load the FTS2 extension in Delphi, using the Aducom >components. Am really close, but still stuck, and thinking it's a problem >with the parameter to sqlite3_enable_load_extension(). DISQLite3 (http://www.yunqa.de/delphi/sqlite3/) does not expose such problems. Look at the full text search demo project which incorporates both FTS1 and FTS2 into a single *.exe application, with _no_ DLLs or external files needed. The new customizable tokenizer interface will be demonstrated by a Unicode-aware Pascal tokenizer with the upcoming version of DISQLite3 as soon as the FTS vacuum fix is official released. Ralf - To unsubscribe, send email to [EMAIL PROTECTED] -
