Re: [sqlite] how to add extensions to amalgamation

2008-04-08 Thread D. Richard Hipp

On Apr 8, 2008, at 8:22 AM, P Kishor wrote:
> I want to add an extension or two to the amalgamation so I don't have
> to load the extension manually. Can someone kindly explain or point me
> to a clear tutorial on how to do so? Be gentle in your explanation as
> I am not too C-savvy but can blunder my way around. (am reading a
> basic C tutorial right now).
>

You might be interested in sqlite3_auto_extension
http://www.sqlite.org/c3ref/auto_extension.html

D. Richard Hipp
[EMAIL PROTECTED]



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] how to add extensions to amalgamation

2008-04-08 Thread Jay A. Kreibich
On Tue, Apr 08, 2008 at 08:22:38AM -0400, P Kishor scratched on the wall:
> I want to add an extension or two to the amalgamation so I don't have
> to load the extension manually. Can someone kindly explain or point me
> to a clear tutorial on how to do so?

  Depends on what you're trying to add.  If you want to add your own
  user functions or aggregation functions, search for the function
  "sqlite3RegisterBuiltinFunctions()" (and other
  sqlite3Register*Functions() functions).  If you're looking to add a
  collation, search for the function "openDatabase()" and scroll down a
  bit to see where the NOCASE collation is registered.

  If you want to have a custom build with your own functions, just add
  the correct lines to the setup structs in these areas.  Depending on
  how you want to setup your headers and source files, you can add the
  actual C function to the amalgamation file or keep them in your own
  source files and let the linker figure things out.  I guess which you
  do depends on if you want maximum ease of compiling or minimum changes
  to the amalgamation (which makes it easier to replicate the changes
  if/when you need to upgrade).

   -j


-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"'People who live in bamboo houses should not throw pandas.' Jesus said that."
   - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006"
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] how to add extensions to amalgamation

2008-04-08 Thread P Kishor
I want to add an extension or two to the amalgamation so I don't have
to load the extension manually. Can someone kindly explain or point me
to a clear tutorial on how to do so? Be gentle in your explanation as
I am not too C-savvy but can blunder my way around. (am reading a
basic C tutorial right now).

-- 
Puneet Kishor
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users