sql server for mac os x snow lapard 32 bit

#Sql server for mac os x snow lapard 32 bit install#
#Sql server for mac os x snow lapard 32 bit 64 Bit#
#Sql server for mac os x snow lapard 32 bit driver#
#Sql server for mac os x snow lapard 32 bit registration#

Next, make sure that the bin folder is in your path. For a good MacPort installation walkthrough, check this article. Note that 8.4 is out, but some recommend using the same version that Heroku uses, namely 8.3.

#Sql server for mac os x snow lapard 32 bit install#

sudo port install postgresql83 postgresql83-server

#Sql server for mac os x snow lapard 32 bit 64 Bit#

Something about 64 bit ruby, 32 bit gems - anyway the MacPorts method works for me on Snow Leopard. Update: Turns out I had problems with this package. Alternatively, you might want to use MacPorts. This is nice because I don't plan on using PostgreSQL all the time, only when I work on some projects.įirst, download the Precompiled 8.4 binary for Mac OS X 10.4+ from the Postgres website. Why? Because it installs a nice management console into your Applications folder along with some quick shortcuts to Start & Stop your server. There are numerous ways of installing it on Mac OS X, (including a nice & easy MacPorts installer) however I opted for the easier Mac installer. One such reason is if you plan on using Geokit, all of the geo math is done at the database level and thus not available on Sqlite. If you're doing any serious Rails work with Heroku you'll eventually want to run the same database server they are, namely PostgreSQL. To do that, open php.10 June 2010 / rails Installing PostgreSQL for Rails on Mac OS X Once done, it will ask you to enable the extension in your PHP configuration. Once entered, PECL will compile and build OCI8. If it were we would respond with the path to Oracle's installation directory. We are doing this because Oracle is not installed on our local machine. Use 'instantclient,/path/to/instant/client/lib' if you're compiling with Oracle Instant Client : Please provide the path to the ORACLE_HOME directory. OCI8 will download and will eventually give you the prompt: Now, to install OCI8, which we will install from the PECL repository. Exit SQL*Plus by entering quit or simply Ctrl+C. To test, open another terminal window or tab, and try to run Oracle's SQL*Plus tool using Sudo ln -s libclntsh.dylib.10.1 libclntsh.dylib Now move to the /usr/lib directory and create the following link: Sudo cp instantclient_10_2/*.dylib.* /usr/lib Sudo cp instantclient_10_2/*.dylib /usr/lib Sudo cp instantclient_10_2/sqlplus /usr/bin Sudo cp instantclient_10_2/sdk/include /*.h /usr/include Open a terminal window and go to the directory above the one you created containing all the files you unzipped. The next step is to copy the necessary files into your OS X dynamic library and bin directories ( as described here).

Now, create a separate directory (which I called instantclient_10_2) and copy the contents of all the files included in these subfolders into it, which will look something like this: Once downloaded, unzip all three files, which will look like this on your file system

#Sql server for mac os x snow lapard 32 bit registration#

Registration is required for all downloads. For most intents and purposes download the 64-bit version of the following files under the title ' Version 10.2.0.4 (64-bit)': OCI8 relies on OS X having several client libraries and tools from Oracle installed on OS X. I also assume that you enabled PHP in your Apache configuration ( /etc/apache2/nf) and have a /etc/php.ini by copying it from /etc/. Oracle Express was installed on a separate Windows machine as it cannot run or be installed on Snow Leopard. I was using Oracle Express, a limited capability, free-ish version of Oracle's database. It took me some time and research to get it up and running.

#Sql server for mac os x snow lapard 32 bit driver#

As a Mac user I was looking to use OS X's built-in Apache and PHP setup, which like many PHP installations does not have the Oracle OCI8 driver installed or enabled.

Oracle apparently embraces PHP warmly and as such supports an open source database driver for the environment called OCI8. My current project involves using PHP with an Oracle database.