In most cases (but not all - C++,Delphi) yes. A wrapper is a lump of C code that bridges the SQLite environment with your own specific language.
I just did a bit of research for you and found that Frontier uses a scripting language called UserTalk to allow users to interact with it. It also only runs on Windows. With this in mind, you will need to write a UserTalk extension as a DLL (C, C++ or Delphi) to agregate SQLite functionality into a small number of UserTalk verbs e.g. OpenDB, CloseDB and ExecuteDB perhaps. Although I couldn't find it on the Frontier web site, I'm sure there is an extension specification defined somewhere. I did notice that PostgreSQL has a Frontier extension - perhaps that would be a good starting point for some sample code http://spicynoodles.org/projects/postgresql/ Download the http://www.pivotal-solutions.co.uk/downloads/company/pssqlite.zip package for an example of C DLL (VC6) that provides bothe a VB and a Java interface with dynamic binding to 2.8.x and 3.x.x databases. Just change the references to VB/Java specific stuff (data type conversions) and you're almost there. Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Gewirtz Sent: 25 February 2006 05:03 To: sqlite-users@sqlite.org Subject: [RBL] RE: [sqlite] Writing wrappers? Thanks! So, being completely naïve, a wrapper's a chunk of C code, right? It's not some kind of scripty interface into SQLite? So would the docs really be the SQLite API, but with calls from the host language to the SQLite API? -- David -----Original Message----- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: Friday, February 24, 2006 10:07 AM To: sqlite-users@sqlite.org Subject: [RBL] Re: [sqlite] Writing wrappers? David Gewirtz said: > > I've just started to explore SQLite and I've noticed a whole pile of > wrappers for various environments. The environment I'm using (the open > source Frontier Kernel) doesn't have any wrappers, so I'd like to > write one. > Can someone post some pointers to resources on how to get started > writing wrappers? As somebody who has written his own wrapper, the best advice I can give is to see what the needs of your application are first. Your wrapper class effectively becomes the SQLite client program, so make sure that it addresses all of the needs of SQLite such as statement finalization and parameter population. Make sure that the wrapper itself addresses the needs of your program and makes it so that you don't need to make sqlite3_* calls from your code. It's definitely a good idea to be comfortable with writing a couple of C programs that use SQLite first before trying to write a wrapper. The standard C interface to SQLite is pretty good already, and once you become comfortable with it you'll be able to see what you want to do with your wrapper. Clay -- Simple Content Management http://www.ceamus.com
