/usr/share/doc/cl-sql/html/appendix.html is in cl-sql 6.5.0-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | <?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>Appendix A. Database Back-ends</title><meta name="generator" content="DocBook XSL Stylesheets V1.78.1" /><link rel="home" href="index.html" title="CLSQL Users' Guide" /><link rel="up" href="index.html" title="CLSQL Users' Guide" /><link rel="prev" href="clsql-index.html" title="Alphabetical Index for package CLSQL" /><link rel="next" href="postgresql.html" title="PostgreSQL" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Appendix A. Database Back-ends</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="clsql-index.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="postgresql.html">Next</a></td></tr></table><hr /></div><div class="appendix"><div class="titlepage"><div><div><h1 class="title"><a id="appendix"></a>Appendix A. Database Back-ends</h1></div></div></div><div class="toc"><p><strong>Table of Contents</strong></p><dl class="toc"><dt><span class="sect1"><a href="appendix.html#foreignlibs">How CLSQL finds and loads foreign libraries</a></span></dt><dt><span class="sect1"><a href="postgresql.html">PostgreSQL</a></span></dt><dd><dl><dt><span class="sect2"><a href="postgresql.html#idp59486656">Libraries</a></span></dt><dt><span class="sect2"><a href="postgresql.html#idp64667360">Initialization</a></span></dt><dt><span class="sect2"><a href="postgresql.html#idp64669920">Connection Specification</a></span></dt><dt><span class="sect2"><a href="postgresql.html#idp65702480">Notes</a></span></dt></dl></dd><dt><span class="sect1"><a href="postgresql-socket.html">PostgreSQL Socket</a></span></dt><dd><dl><dt><span class="sect2"><a href="postgresql-socket.html#idp65704864">Libraries</a></span></dt><dt><span class="sect2"><a href="postgresql-socket.html#idp65706928">Initialization</a></span></dt><dt><span class="sect2"><a href="postgresql-socket.html#idp65709504">Connection Specification</a></span></dt><dt><span class="sect2"><a href="postgresql-socket.html#idp65237872">Notes</a></span></dt></dl></dd><dt><span class="sect1"><a href="mysql.html">MySQL</a></span></dt><dd><dl><dt><span class="sect2"><a href="mysql.html#idp65240256">Libraries</a></span></dt><dt><span class="sect2"><a href="mysql.html#idp65246544">Initialization</a></span></dt><dt><span class="sect2"><a href="mysql.html#idp65249712">Connection Specification</a></span></dt><dt><span class="sect2"><a href="mysql.html#idp65268720">Notes</a></span></dt></dl></dd><dt><span class="sect1"><a href="odbc.html"><span class="application">ODBC</span></a></span></dt><dd><dl><dt><span class="sect2"><a href="odbc.html#idp65297952">Libraries</a></span></dt><dt><span class="sect2"><a href="odbc.html#idp65306576">Initialization</a></span></dt><dt><span class="sect2"><a href="odbc.html#idp65310512">Connection Specification</a></span></dt><dt><span class="sect2"><a href="odbc.html#idp65324976">Notes</a></span></dt><dt><span class="sect2"><a href="odbc.html#idp65328624">Connect Examples</a></span></dt></dl></dd><dt><span class="sect1"><a href="aodbc.html"><span class="application">AODBC</span></a></span></dt><dd><dl><dt><span class="sect2"><a href="aodbc.html#idp65333696">Libraries</a></span></dt><dt><span class="sect2"><a href="aodbc.html#idp65337824">Initialization</a></span></dt><dt><span class="sect2"><a href="aodbc.html#idp65341840">Connection Specification</a></span></dt><dt><span class="sect2"><a href="aodbc.html#idp65353648">Notes</a></span></dt></dl></dd><dt><span class="sect1"><a href="sqlite.html"><span class="application">SQLite version 2</span></a></span></dt><dd><dl><dt><span class="sect2"><a href="sqlite.html#idp65356432">Libraries</a></span></dt><dt><span class="sect2"><a href="sqlite.html#idp65359920">Initialization</a></span></dt><dt><span class="sect2"><a href="sqlite.html#idp65363856">Connection Specification</a></span></dt><dt><span class="sect2"><a href="sqlite.html#idp65371088">Notes</a></span></dt></dl></dd><dt><span class="sect1"><a href="sqlite3.html"><span class="application">SQLite version 3</span></a></span></dt><dd><dl><dt><span class="sect2"><a href="sqlite3.html#idp65390496">Libraries</a></span></dt><dt><span class="sect2"><a href="sqlite3.html#idp65393984">Initialization</a></span></dt><dt><span class="sect2"><a href="sqlite3.html#idp65397920">Connection Specification</a></span></dt><dt><span class="sect2"><a href="sqlite3.html#idp65412672">Notes</a></span></dt></dl></dd><dt><span class="sect1"><a href="oracle.html">Oracle</a></span></dt><dd><dl><dt><span class="sect2"><a href="oracle.html#idp65431680">Libraries</a></span></dt><dt><span class="sect2"><a href="oracle.html#idp65435664">Library Versions</a></span></dt><dt><span class="sect2"><a href="oracle.html#idp65441200">Initialization</a></span></dt><dt><span class="sect2"><a href="oracle.html#idp65444448">Connection Specification</a></span></dt><dt><span class="sect2"><a href="oracle.html#idp65456464">Notes</a></span></dt></dl></dd></dl></div><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="foreignlibs"></a>How CLSQL finds and loads foreign libraries</h2></div></div></div><p>
For some database types CLSQL has to load external foreign
libaries. These are usually searched for in the standard
locations the operating system uses but you can tell <span class="application"><span class="emphasis"><em>CLSQL</em></span></span> to
look into other directories as well by using the function
<code class="function">CLSQL:PUSH-LIBRARY-PATH</code> or by directly
manipulating the special variable
<code class="varname">CLSQL:*FOREIGN-LIBRARY-SEARCH-PATHS*</code>. If,
say, the shared library libpq.so needed for PostgreSQL support
is located in the directory <code class="filename">/opt/foo/</code> on
your machine you'd use
</p><pre class="screen">
(clsql:push-library-path "/opt/foo/")
</pre><p>
before loading the CLSQL-POSTGRESQL module. (Note the trailing
slash above!)
If you want to combine this with fully automatic loading of
libraries via ASDF a technique like the following works:
</p><pre class="screen">
(defmethod asdf:perform :after ((o asdf:load-op)
(c (eql (asdf:find-system 'clsql))))
(funcall (find-symbol (symbol-name '#:push-library-path)
(find-package 'clsql))
#p"/opt/foo/"))
</pre><p>
</p><p>
Additionally, site-specific initialization can be done using an
initialization file. If the file <code class="filename">/etc/clsql-init.lisp</code>
exists, this file will be read after the <span class="application"><span class="emphasis"><em>CLSQL</em></span></span> ASDF system is loaded.
This file can contain forms to set site-specific paths as well as change
<span class="application"><span class="emphasis"><em>CLSQL</em></span></span> default values.
</p></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="clsql-index.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="postgresql.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Alphabetical Index for package CLSQL </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> PostgreSQL</td></tr></table></div></body></html>
|