r10815: 11 Nov 2005 Kevin Rosenberg <kevin@rosenberg.net>

        * Version 3.4: Add MySQL 5 support
        * db-mysql/mysql-client-info.lisp: Recognize MySQL 5
        * db-mysql/mysql-sql.lisp: Add support for views in MySQL 5
        * doc/mysql-macosx-notes.txt: New document from Martin Brooks

diff --git a/ChangeLog b/ChangeLog
index 1c9a372236657c28c345d4eead2f75bba4fe1683..29a649694f72db3e1e33ace79cdfad0caa66ddb6 100644 (file)
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,6 +1,8 @@
 11 Nov 2005  Kevin Rosenberg <kevin@rosenberg.net>
 11 Nov 2005  Kevin Rosenberg <kevin@rosenberg.net>

+       * Version 3.4: Add MySQL 5 support

        * db-mysql/mysql-client-info.lisp: Recognize MySQL 5
        * db-mysql/mysql-sql.lisp: Add support for views in MySQL 5
        * db-mysql/mysql-client-info.lisp: Recognize MySQL 5
        * db-mysql/mysql-sql.lisp: Add support for views in MySQL 5

+       * doc/mysql-macosx-notes.txt: New document from Martin Brooks

        
 7 Nov 2005  Kevin Rosenberg <kevin@rosenberg.net>
        * src/time.lisp: Apply patch from Aleksandar Bakic for ROLL
        
 7 Nov 2005  Kevin Rosenberg <kevin@rosenberg.net>
        * src/time.lisp: Apply patch from Aleksandar Bakic for ROLL

diff --git a/doc/mysql-macosx-notes.txt b/doc/mysql-macosx-notes.txt
new file mode 100644 (file)
index 0000000..9687f1d
--- /dev/null
+++ b/doc/mysql-macosx-notes.txt
@@ -0,0 +1,60 @@
+Instructions:
+
+----------------
+1. Install MySQL from Fink, not from mysql.com
+
+It is sufficient to install the binaries from Fink.
+CLSQL requires the MySQL library libmysqlclient.dylib; this library  
+is not provided with the mysql binary install.
+This library is in /sw/lib/mysql . However, it is actually called  
+libmysqlclient.14.0.0.dylib .
+-----------------
+2. After installing MySQL, do the following at the shell.
+(Assuming that you do not want to have to load CLSQL as root user  
+every time you use it.)
+
+2a. Create a symbolic link from libmysqlclient.14.0.0.dylib to the  
+name libmysqlclient.dylib .
+2b. Change ownership to yourself along the path /sw/lib/mysql/ 
+libmysqlclient.dylib .
+-----------------
+3. Either install CocoaMySQL or download the source of MySQL (e.g.  
+5.0) from mysql.com.
+
+CLSQL requires MySQL's header files. These files are not provided  
+with Fink's binary MySQL install.
+In CocoaMySQL the headers are found at: /Applications/CocoaMySQL.app/ 
+Contents/Frameworks/SMySQL.framework/Versions/A/Headers
+In MySQL 5.0 sources, the headers are found at: ~/Desktop/ 
+mysql-5.0.15/include
+
+3a. Copy the directory full of headers to /sw/include/mysql
+3b. Make yourself the owner of these files.
+
+You may now dispose of CocoaMySQL or the MySQL sources, if you desire.
+-----------------
+4. In the CLSQL sources, modify db-mysql/makefile to read as follows:
+
+...  CFLAGS="-I /sw/include/mysql" LDFLAGS=" -L/sw/lib/mysql/   ...
+
+-----------------
+5. In Lisp, do the following:
+
+Assuming asdf and the CLSQL & UFFI sources are in the same directory;  
+substitute the appropriate path for ~ .
+The code below is right out of the CLSQL docs, but note particularly  
+the commented expression.
+
+(load "~/asdf.lisp")
+
+(progn
+       (push "~/uffi-1.5.5/" asdf:*central-registry*)
+       (asdf:operate 'asdf:load-op :uffi)
+       (push "~/clsql-3.3.4/" asdf:*central-registry*)
+       (asdf:operate 'asdf:load-op :clsql))
+
+(progn
+       (in-package :clsql)
+       (setf *default-database-type* :mysql)
+       (clsql:push-library-path "/sw/lib/mysql/")  ;  !!
+       (asdf:operate 'asdf:load-op 'clsql-mysql))