1 #include <infodrom.style>
2 #include <projects.style>
4 <projectpg project="sqllib">
6 <h3>The SQL Library</h3>
8 This library provides a lightwind programming interface to SQL
9 databases. We have recognized that it is very easy to write programs
10 using SQL in Perl since the DBD/DBI driver is very easy to use and is
11 able to connect to any SQL database. However, when using C you're
12 lost and need to write your application specifically for one SQL
13 database, losing the possibility to switch the backend database. <p>
15 The benefit of using this library instead of connecting to a given
16 database directly shouldn't need to be pointed out. By using it you
17 would be free to exchange the underlying database without changing
18 all your applications. All you would have to do is to add
19 "SQL=<ab>" to your Makefile and recompile it. <p>
21 <ab> is the abbreviation of the database in question. It is
23 from the DBD/DBI interface: <p>
31 Since this interface is very small and easy to handle please find
32 documentation for all routines in the sql.h header file. It only
33 covers a small subset of what each specific database provides, but
34 this way they are exchangable. <p>
36 There is still work to be done. Some queries aren't compatible
37 through the SQL databases since they come with their own additions.
38 For example, mSQL provides "CLIKE" for case-insensitive LIKE
39 statements while PostgreSQL uses the "*~" operator. It would be
40 quite nice if noc_sql_query() would translate the query into the