<< Before You Start - TOC - SQLAPI >>
Writing Client Application
This Section gives an overview of how to create a client application that will work with CSQL
What is a client?
A client is a program that makes service requests (SQL Queries) to the server and gets results back from the server. A client and Server is two different programs and in many cases client is running on a separate computer. The client program cannot call functions in server directly; it uses shared memory communication mechanisms to communicate with the server. A specific library file need to link to application so that application can communicate with the server.
Passing query to the server
Mainly queries are written using SQL language. The client program sends the required queries to the server and after processing the server returns results back to the client. For example, Suppose the below query is send to the server by client
SELECT name FROM EMP WHERE eid=1001;
And server responses and send back the string “Sumuthi.jain”
Communication between client and server is usually done via a Driver, Such as ODBC Driver and JDBC Driver. If client program follows the ODBC conventions, then the client program will be able to talk with Database server that follows the same conventions. Programs written in the C and C++ programming language generally use the ODBC standard. And in the same manner the JAVA applications use JDBC Driver to connect to the database server that follows the JDBC Conventions. In the section 4 and 5, the ODBC and JDBC have been discussed in detail.
Supported Interfaces
The following is a list of interfaces currently supported by CSQL.
- SQL API (Proprietary Interface)
- ODBC Driver
- JDBC Driver
- PHP Driver
These interfaces enable applications to establish connections and process SQL statements simultaneously. In the above four APIs, SQL API is the Proprietary Interface. ODBC, JDBC and PHP are standard interfaces supported by CSQL.
ODBC and JDBC drivers are available in windows platform to connect to csql server running in Linux Platform.
<< Before You Start-TOC - SQLAPI >>