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