Skip to main content

Python developers

Overview for using FairCom products as a Python developer

Installation and error codes

The General information section provides information that applies to all products.

Section	Description
Install FairCom products	Quick and advanced installation guides.
Error codes	Complete list of FairCom error codes.

JSON APIs for Python

FairCom's JSON DB APIis optimized for easy development of microservices and n-tier applications.

Section	Description
JSON DB concepts	Guide for using the JSON DB API.
JSON DB API	Reference guide to use the JSON DB API.

SQL for Python

FairCom's SQL engine is ANSI-standard. It makes it easy and fast to modify and query data.

Section	Description
Python quick start	Tutorials for using SQL with FairCom DB.
SQLAlchemy API	Guide for using SQL with FairCom DB.
SQL reference	Language elements that are common to many FairCom DBSQL statements.
Full text search	Guide for using the full-text search.
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.
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.

FairCom's JSON DB API is optimized for microservices and n-tier applications, making database interactions fast and efficient for Python developers. JSON API Overview: JSON DB Concepts – Guide to understanding and working with the JSON DB API. JSON DB API Reference – Detailed documentation for leveraging JSON-based database operations. JSON DB API Tutorial – Originally designed for Java developers, but applicable for understanding core functionality. SQL for Python Developers: FairCom’s SQL engine follows ANSI standards, ensuring ease of use for querying and modifying data. Python Quick Start – Tutorials for integrating SQL with FairCom DB. SQLAlchemy API – Guide for Python developers working with FairCom DB SQL. SQL Reference – Overview of common SQL language elements. Full-Text Search – Instructions for implementing advanced text search. ISQL Tutorial & CLI – Guides for using FairCom’s interactive SQL command-line utility. ODBC Configuration – Steps for setting up ODBC for FairCom DB SQL. SQL Operations – Advanced SQL features, utilities, and optimizations. SQL Error Codes – Comprehensive list of FairCom SQL error codes.

JSON DB API: Microservices, n-tier applications, structured queries, schema-less data handling jsonAction API: Core API pattern for database operations and data integration SQL for Python: SQLAlchemy, SQL queries, stored procedures, triggers Database Management: FairCom DB, indexing, full-text search, SQL optimization Installation & Troubleshooting: FairCom installation guides, SQL error codes, performance tuning