The best way to learn how to use the Hyper API is to look at the sample code. The Hyper API provides samples in your programming language of choice that create extract files and then show how you can read, insert, update, and delete data from the files.
When you download the Hyper API for your programming language, you can find the example code in the
examples folder. We recommend the following steps:
Download the Hyper API
.zip file from Hyper API - Products Release and Download for your programming language and platform of choice.
Examine the source code in the
Build the examples. For information about building and running the the samples, follow the instructions for your programming language of choice, see Install the Hyper API.
Use the example code as a starting point for your own applications.
.hyperfiles using the Hyper API and Python, see Create and Update Hyper Files.
Demonstrates how you can use the Hyper SQL COPY command to quickly populate a table in the
.hyper file from the contents of a comma-separated value (CSV) file. This technique is the fastest way to bring data into an extract, as Hyper is reading data directly from the CSV file.
Demonstrates how you can use the Hyper SQL DELETE command to remove data from a table in the
This example shows how you can create and insert data into a
.hyper file that contains multiple tables. Uses the
Inserter class to add data to the tables and a Hyper SQL query to report the number of rows in the tables.
Demonstrates how you to add data to a single table named
Extract that uses the
Extract schema. Uses the
Inserter class to add data to the table and a Hyper SQL query to report the number of rows in the table.
Demonstrates how to read data from an existing
.hyper file and print the output to the console.
This example demonstrates how you can use the Hyper SQL UPDATE command to change values in a
This example demonstrates how to insert spatial data (WKT) to a
This examples shows how you can use SQL expressions in Hyper API Inserter to transform or compute data on the fly during data insertion