On Nov 19, 2018, at 07:58, Charles Hudson 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. I don't need network connectivity as this would > be limited to a single machine. > > I am pursuing this mostly out of curiosity; a learning experience for > investigating the capabilities of the Mac. > > Rather than sign up for your mailing list I thought I might ask this one > question: Which, if any, versions of SQLite might be suitable for this > task?
You would probably have an easier time getting SQLite working on that hardware by installing a UNIX-like operating system. Classic Mac OS (Mac OS 9 and earlier) are not related to UNIX at all and SQLite is not designed for it, but Mac OS X (which was subsequently renamed to OS X and now macOS) is a BSD-derived UNIX operating system, and an old version of Mac OS X could be installed on your G3. Which version depends on which model of G3 you have. Blue & white Power Macintosh G3s can run up to Mac OS X 10.4 Tiger. Beige Power Macintosh G3s may need a RAM upgrade but can run up to Mac OS X 10.2 Jaguar officially, and 10.4 can be installed with XPostFacto. Those versions of Mac OS X already come with an old version of SQLite; you may be able to compile a newer version if needed. If you're running at least Mac OS X 10.4, you can use MacPorts to install a newer SQLite for you. (Mac OS X 10.5 and later do not run on PowerPC G3 processors.) You can keep your Mac OS 9 installation if you want, either on the same partition or on a separate partition or separate disk. You can run your Mac OS 9 programs within Mac OS X by using the "Classic" application, or you can reboot into Mac OS 9. Alternately, you might be able to install another UNIX-like operating system, such as a Linux distribution or one of the other BSD variants. Installing Mac OS X or any other UNIX-like system would also make it more likely that you could install other common SQL databases like MySQL/MariaDB and PostgreSQL. Or if you just need a database and don't need it to be SQL, FileMaker Pro is a database system that was available for Mac OS 9 and is still available for Mac OS X. Even HyperCard for Mac OS 9 and earlier can be used as a simple database and was pretty fun. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
