On 19 Nov 2018, at 1:58pm, Charles Hudson <charles...@twc.com> wrote:

> I come from an ANSI SQL client / server background (Oracle, MS SQL) but am 
> interested in finding a SQL database to install on an old Macintosh G3 Power 
> PC that is running OS 9.2.

OS 9 is dead dead dead.  The last release was in 1999 and support for it ended 
in February 2002.  What you are doing is not programming, it's experimental 
archeology.

In 1999, SQlite was not released yet.  Version 1.0 of SQLite was released 
August 2000.  By February 2003, SQlite had reached version 2.3.0.

Version 2.x of SQLite uses a different file format to version 3.x of SQLite.  
So you're going to have to decide whether you want to use a version of SQLite 
that might have been in use at the time of that OS or a modern version never 
intended to run on it.

>  Which, if any, versions of SQLite might be suitable for this
> task?

SQLite is not a program, it's a programmer's library.  The version you should 
use is the latest version that your development environment supports.  So the 
answer depends on which programming language, compiler, and other libraries 
you're using, and whether you can call C functions from your programming 
language.  And on how good you are at working around compiler warnings and 
errors.

It's possible that even the current version of SQLite is compatible with 
whatever you're using.  But probably not.  You might like to try it with your 
development environment, and tell us what error message gets generated.  Or you 
might like to ask on a forum which discusses whatever compiler you use for your 
target platform.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to