[sqlite] ANN: SQLite ODBC Driver
Version 0.66 of the SQLite ODBC Driver is available on http://www.ch-werner.de/sqliteodbc It supports now SQLite 3.3.4 and 2.8.17. Cheers, Christian
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: 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
[sqlite] Re: experimental explain output
dang it. changes.html, explain query plan. sorry. On 2/24/06, deminix <[EMAIL PROTECTED]> wrote: > > am I crazy or was there an experimental explain output mechanism, that > attemped to output the plan in something closer to english. if there was, i > am unable to find it on the site documentation anymore. was it removed? > did I imagine the whole thing late some night? :) > > --paul >
[sqlite] experimental explain output
am I crazy or was there an experimental explain output mechanism, that attemped to output the plan in something closer to english. if there was, i am unable to find it on the site documentation anymore. was it removed? did I imagine the whole thing late some night? :) --paul
[sqlite] 3.3.4 Build warnings using VC6
Dr H, Are you interested in all the build warnings I get when I build 3.3.4 under VC6? If so, I'll happily email them to you. A majority of them are size issues with assignment from __int64's to ints and __int64's to longs. C
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
[sqlite] Writing wrappers?
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? Thanks! -- David