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, updateand
DDL Statements eXtremeSQL DDL statements
create table, create index, drop table, drop indexand
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
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