eXtremeSQL Python Runtime Libraries

The Python wrapper supports a SQL engine and a SQL server that operate on eXtremeDB databases. No additional libraries need to be specified on the call to exdb.Init_runtime().The main parts of this SQL server interface are the SqlEngine and SqlServer classes. SqlEngine parses SQL queries, binds parameters if needed, executes the queries against the eXtremeDB database, and displays the results. SqlServer provides network support and allows a remote client to connect to SqlEngine using TCP/IP and the eXtremeSQL Remote SQL protocol.

SqlEngine can create a database in memory, using a set of parameters passed as an instance of the SqlOpenParameters class. For any opened database, there is an implicitly created SqlEngine object. It can be accessed via the engine attribute of the Connection object. (For an example of how to create and use a SQL server from python, please refer to sample “samples/python/sql/sqlserver.py” in the eXtremeDB SDK.)

To start working with the eXtremeDB Python Wrapper the Python interpreter needs to be started with the PYTHONPATH environment variable correctly defined. By default, the eXtremeDB Python Wrapper will be installed in the eXtremeDB SDK directory target/bin/python (not in the Python system-wide packages directory).

Python DB API support

The Python wrapper also supports the DB API interface using the eXtremeSQL interface, including the sequence extensions to SQL.