Mark, If you looking for accessibility to your SQLITE DB from within other windows applications (That support ODBC) then there is an ODBC driver for SQLITE which is probably the most common manner to access databases. Take a look at the following link. http://www.ch-werner.de/sqliteodbc/ Cheers Wayne
P Kishor <[EMAIL PROTECTED]> wrote: On 9/6/06, Allan, Mark wrote: > Hi, > > After successfully using SQLite on an embedded device, we are now thinking of > using SQLite in a PC application. > > This would be used in place of an MS Access database on a local/network > disk. I believe that SQLite should be quicker for both transactions and > queries than Access. The one draw back that comes to mind maybe portability > (i.e. accessing data outside of the application), although the data would be > portable across machines (PC, Mac, Unix, etc) should we ever need it to be > in the future. > well, you could write your application in a platform-neutral language, and it will be portable everywhere. You could choose any of the popular ones (Perl, Python, Tcl). If you desire a gui, you could write a web application, and your gui framework -- the browser -- would be automatically pre-installed on every personal (and not so personal) computer on the planet. Or, you could cleanly decouple your backend from the gui, and rewrite only the gui part in the OS-specific framework (beautiful Cocoa with its SQLite-based core-data is already present on every Mac OS X 10.4.x onward, and whatever it is that is used on PCs and non-Mac Unix). -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/ Open Source Geospatial Foundation https://edu.osgeo.org/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
