eXtremeSQL User's Guide

McObject 's eXtremeSQL is a high-performance implementation of the SQL programming language for interfacing with eXtremeDB databases. The SQL Introduction and Product Overview pages provide a detailed introduction to eXtremeSQL features.

The eXtremeSQL API is implemented as a C language library as well as a rich set of C++, Java, Python and C# wrapper classes. So the SQL statement interface can be embedded within your choice of programming language. The process of developing eXtremeSQL applications consists of incrementally defining or modifying the database schema then implementing related application-specific database operations using static APIs as well as the schema-specific APIs that vary as the schema changes.

For developers unfamiliar with the implementation of eXtremeSQL applications this quick start guide is recommended to understand the basic application structure. Also building and running the SDK samples is an excellent way to gain familiarity with specific eXtremeSQL capabilities.

The eXtremeSQL APIs are described in the Programming with eXtremeDB pages.

Please use the links below to view detailed explanation of the topics of interest:

xSQL xSQL User's Guide: an interactive tool for processing SQL statements
Language Reference eXtremeSQL SQL Language Reference
DML Statements eXtremeSQL DML statements select, insert, update and delete
DDL Statements eXtremeSQL DDL statements create table, create index, drop table, drop index and alter table
SQL Features Various eXtremeSQL features and implementation details
Implementation Details Implementation details for User-defined Functions (Stored Procedures), Dynamic Memory Allocation, Views, Virtual Tables, Remote SQL applications and Security Measures
Managing Transactions Managing transactions with eXtremeSQL
Distributed SQL Engine Support for database sharding with the Distributed SQL Engine
Query_Result_Processing Detailed explanations and examples of the methods for query result processing
Query Optimization How to optimize query performance and control the eXtremeSQL rule-based query optimizer

Data Export and Import

Online backup of persistent databases, saving and loading database snapshots, metadata and dictionaries

Using Sequences Using Sequences in SQL
Optimizations Techniques and tips for optimizing eXtremeSQL application performance
ODBC The eXtremeSQL ODBC API
JDBC The eXtremeSQL JDBC API
DBeaver Support eXtremeSQL support for the DBeaver third-party GUI Tool