This page includes a list of SQL APIs and Guides for a variety of developers, programming languages, and environments. SQL is available in all FairCom products that include the FairCom database engine.
SQL developer guides
| Section | Description |
|---|---|
| ISQL tutorial | Tutorials for using FairCom's interactive SQL command line utility (iSQL). |
| ISQL CLI | Guide for automating database operations using FairCom's iSQL command line utility and for importing and exporting data using variable-length and fixed-length flat files — such as CSV. |
| SQL reference | FairCom DBSQL language reference guide. |
| Full text search | Guide for using the full-text search. |
| SQL stored procedures | Guide for using Java and C# to implement SQL stored procedures and triggers. |
| Java stored procedures | Tutorial for using Java to implement SQL stored procedures and triggers in . |
| C# stored procedures | Tutorial for using the C# to implement SQL stored procedures in FairCom DB. |
| JDBC quick start | Tutorials for using FairCom's JDBC driver in Java. |
| JDBC developer guide | Guide for using the JDBC driver with FairCom DBSQL in order to use SQL in Java applications (ideal for client-server applications that run in the same data center as the database). |
| ODBC quick start | Tutorials for using FairCom's Windows and Linux ODBC driver with FairCom DBSQL. |
| Direct SQL | Guidelines for FairCom DBDirect SQL developers. |
| SQL API actions | The "getRecordsUsingSQL" and "runSqlStatements" actions embed SQL in JSON Action calls over HTTPS and return results as JSON. |
| ODBC configuration | Explanation for configuring and troubleshooting ODBC for FairCom DBSQL. |
| SQL operations | Advanced FairCom SQL features, options, and utilities. |
| SQL error codes | Complete list of SQL error codes. |
SQL guides for C and C++ programmers
| Section | Description |
|---|---|
| Direct SQL | Guidelines for FairCom DBDirect SQL developers. |
| SQL API actions | The "getRecordsUsingSQL" and "runSqlStatements" actions embed SQL in JSON Action calls over HTTPS and return results as JSON. |
| SQL operations | Advanced FairCom SQL features, options, and utilities. |
SQL guides for Java developers
| Section | Description |
|---|---|
| JDBC quick start | Tutorials for using FairCom's JDBC driver in Java. |
| JDBC developer guide | Guide for using the JDBC driver with FairCom DBSQL in order to use SQL in Java applications (ideal for client-server applications that run in the same data center as the database). |
| SQL API actions | The "getRecordsUsingSQL" and "runSqlStatements" actions embed SQL in JSON Action calls over HTTPS and return results as JSON. |
| Java stored procedures | Tutorial for using Java to implement SQL stored procedures and triggers in . |
| SQL operations | Advanced FairCom SQL features, options, and utilities. |
SQL guides for C# and Visual Basic developers
| Section | Description |
|---|---|
| ODBC quick start | Tutorials for using FairCom's Windows and Linux (Unix) ODBC driver with FairCom DB. |
| ADO.NET API | Guide for using SQL with FairCom DB. |
| SQL API actions | The "getRecordsUsingSQL" and "runSqlStatements" actions embed SQL in JSON Action calls over HTTPS and return results as JSON. |
| C# stored procedures | Tutorial for using the C# to implement SQL stored procedures in FairCom DB. |
| SQL stored procedures | Guide for using Java and C# to implement SQL stored procedures and triggers. |
| ODBC configuration | Explanation for configuring and troubleshooting ODBC for FairCom DBSQL. |
| SQL operations | Advanced FairCom SQL features, options, and utilities. |
SQL guides for Python developers
| Section | Description |
|---|---|
| Python quick start | Tutorials for using SQL with FairCom DB. |
| SQLAlchemy API | Guide for using SQL with FairCom DB. |
| ODBC configuration | Explanation for configuring and troubleshooting ODBC for FairCom DBSQL. |
| SQL API actions | The "getRecordsUsingSQL" and "runSqlStatements" actions embed SQL in JSON Action calls over HTTPS and return results as JSON. |
SQL guides for PHP developers
| Section | Description |
|---|---|
| PDO quick start | Tutorials for using PHP PDO with FairCom DB. |
| ODBC configuration | Explanation for configuring and troubleshooting ODBC for FairCom DBSQL. |
| SQL API actions | The "getRecordsUsingSQL" and "runSqlStatements" actions embed SQL in JSON Action calls over HTTPS and return results as JSON. |