README
1Interface to the MySQL database server
2--------------------------------------
3
4This directory provides a C interface to the MySQL relational database
5server. Using this interface, you can communicate with and control
6this database server from Moscow ML programs. The interaction uses
7the standard query language SQL, which is not described here. The
8many books about relational database management systems (RDBMS), and
9the MySQL documentation, describe SQL.
10
11The MySQL interface was implemented by Thomas Iversen on the basis of
12the Postgres interface written by Peter Sestoft.
13
14Note:
15
16 - MySQL does not compute cmdtuples correctly after an SQL delete
17 - MySQL 3.22.21 does not implement the bool type: the parser
18 accepts the type name bool but implements it as int, and the
19 literals false and true both map to the integer 0
20
21The interface consists of the following files:
22
23 mmysql.c Implements the dynamic library libmmysql.so which
24 interfaces Moscow ML to the MySQL library.
25
26You must have the following components:
27
28 MySQL Can be found many places on the Internet, such as
29 http://www.mysql.com
30
31 Dynlib The Moscow ML foreign (C) function interface.
32 Supported for Linux, Solaris, MS Win32, MacOS,
33 Digital Unix, and HP-UX in mosml 1.44
34
35The runtime system must be compiled with support for dynamic linking
36of foreign functions (edit mosml/src/Makefile.inc to achieve this).
37
381. Edit the mmysql/Makefile to make MYSQLLIBDIR and MYSQLINCDIR point
39to the directories contain the MySQL runtime library and the MySQL
40include files.
41
422. Compile mmysql.c:
43
44 make
45
463. Install libmmysql.so in the directory determined by BINDIR in
47 src/Makefile.inc:
48
49 make install
50
514. Set your LD_LIBRARY_PATH to point to the BINDIR directory.
52
53 For tcsh: setenv LD_LIBRARY_PATH $BINDIR
54 For bash: export LD_LIBRARY_PATH=$BINDIR
55
565. Test the library:
57
58 mosml testmysql.sml
59
60-----------------------------------------------------------------------
61File mosml/src/dynlibs/mmysql/README * sestoft@dina.kvl.dk * 1999-08-07
62