Skip to Content
Mac OS X Tiger for Unix Geeks, 3rd Edition
book

Mac OS X Tiger for Unix Geeks, 3rd Edition

by Ernest E. Rothman, Brian Jepson
June 2005
Beginner to intermediate
415 pages
11h 27m
English
O'Reilly Media, Inc.
Content preview from Mac OS X Tiger for Unix Geeks, 3rd Edition

Chapter 18. Free Databases

Although there are some great binary distributions for open source databases such as MySQL and PostgreSQL , both build out of the box on Mac OS X. This chapter describes how to install them from source and get them set up so you can start playing with them. Fink is a good first stop for MySQL or PostgreSQL, since you can use it to install a binary build or compile from source.

You can also get MySQL as a binary package from MySQL AB (http://www.mysql.com), as well as Server Logistics (http://www.serverlogistics.com/). Server Logistics offers a selection of open source packages, one of which is Complete MySQL (http://www.serverlogistics.com/mysql.php), which includes the MySQL server, a System Preferences pane for MySQL, ODBC/JDBC drivers, and documentation.

Another database worth considering is already installed on Mac OS X Tiger systems. SQLite , which is one of the key components of Tiger’s Core Data Framework, is a self-contained embeddable SQL engine that’s in the public domain. Since it’s already there, and it’s the simplest of the three, we’ll look at SQLite first.

SQLite

SQLite is a public domain embeddable database that’s implemented as a C library. In Mac OS X, it’s also one of several backends used by the Core Data framework, which also uses XML and binary formats for storing persistent data.

Where to Find SQLite

You can find documentation, source code, and other SQLite resources at http://www.sqlite.org. However, Mac OS X Tiger includes SQLite 3 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Mac OS X Panther for Unix Geeks, Second Edition

Mac OS X Panther for Unix Geeks, Second Edition

Brian Jepson, Ernest E. Rothman
Mac OS X for Unix Geeks

Mac OS X for Unix Geeks

Ernest E. Rothman, Brian Jepson
Mac OS X For Unix Geeks, 4th Edition

Mac OS X For Unix Geeks, 4th Edition

Ernest E. Rothman, Rich Rosen, Brian Jepson
OS X and iOS Kernel Programming

OS X and iOS Kernel Programming

Ole Henry Halvorsen, Douglas Clarke

Publisher Resources

ISBN: 0596009127Errata Page