On 9/6/06, Allan, Mark <[EMAIL PROTECTED]> 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]
-----------------------------------------------------------------------------
