Thank you for your reply. I have SQLite running on a dual-boot Win7/Fedora28 machine, and I have already investigated FMPro v.2,3 and 5. I have not tried installing any version of OS X, however; that will be my next avenue of exploration.
Thanks once again for your assistance. -CH- On Tue, 2018-12-04 at 17:40 -0600, Ryan Schmidt wrote: > 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. > -- -CH- _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
