ITTIA DB SQL develops, manufactures, licenses, and supports data management software products and provides related services. ITTIA DB SQL brings robust data management facilities to bear on the tough data management problems now faced by embedded developers, in a package that is lightweight, cross-platform, fast, and easy to use. With ITTIA DB SQL, intelligent devices and embedded systems have access to full data management capabilities even when disconnected.
ITTIA DB SQL for Device Data Management includes an interactive SQL utility named ittiasql and demos such as ITTIA Device Database Microgrid demo that stores sensor data stored on the device in flash SQL database and enables the data visualization online.
The following Computer on Modules are supported:
While you can use a wide variety of displays and monitors, additional configuration may be required for a specific setup.
A section in the end of this guide provide instructions about display configuration.
This partner demo image is meant for the evaluation of the technology. It is not suitable for development or production.
This section provides instructions for you to quickly get started with ITTIA DB SQL for Device Data Management.
Installing ITTIA DB SQL for Device Data Management using the Toradex Easy Installer (click to enlarge)
When the installation ends, power-cycle the board and wait until you see a desktop environment. You can verify the stored data into your web browser, using the board's IP, e.g. if your board's IP is 10.22.1.42 one can navigate into the Microgrid demo by typing 10.22.1.42 in the web browser.
The dashboard shown is updated with real-time data and complete history of sensor records.
You can create queries to access and analyze data on the device. To do so, run the ittiasql utility using the following command line
Open one of the database files located at /home/root, e.g.
Look at the tables in the given database
Execute queries in the tables
In your target module, run the utility ittiasql. To create a new database file, use the command .create according to the instructions below. The database file is created in the current working directory by default.
The arguments are described
|database-name||a local filename or remote database URL:
|storage||"file" (default) or "memory".|
|password||database authorization password|
|page_size||file storage page size (default 4KiB)|
|buffer_count||number of page buffers to allocate|
|mem_size||number of bytes to allocate for memory tables|
|mem_page_size||memory storage page size (default 2KiB)|
|cipher_type||"none" (default), "AES128" or "AES256"|
|cipher_data||file storage encryption key|
As an example,
Create a table using
To insert rows, use the following
Execute queries in the tables from your database
And save the changes with commit
Check your database statistics with stats
For further information, please visit ITTIA DB SQL for Device Data Management.
Displays and Monitors used in Embedded Systems are available in a myriad of configuration possibilities - resistive, capacitive or without touch, single or multi touch, different resolution, density of pixels, pin-out and clock frequency are some examples.
To make things easy for you, Toradex provides specific instructions on how to use its display offerings as well as comprehensive information about how to interface your custom display or monitor to Toradex modules. Please refer to the table below:
|Display||Display Resolution||Touch Screen Support||Touch Screen Calibration|
|Resistive Touch Display 7" Parallel||First Steps with Parallel Resistive Touch Display - Resolution||Supported out-of-the-box||Touch Screen Calibration (Linux)|
|Capacitive Touch Display 7" Parallel||First Steps with Capacitive Touch Display 7 Inch Parallel - Resolution||First Steps with Capacitive Touch Display 7 Inch Parallel - Touch Screen||Touch Screen Calibration (Linux)|
|VGA monitor||Display Output, Resolution and Timings||USB HID touch screen works out-of-the-box||Touch Screen Calibration (Linux)|
|DVI/HDMI monitor||Display Output, Resolution and Timings||USB HID touch screen works out-of-the-box||Touch Screen Calibration (Linux)|
|• For additional comprehensive information
• If you use another display/monitor
|Display Output, Resolution and Timings||• Compile the specific kernel driver: Build Linux kernel
• Enable it in the device-tree: Device Tree Customization
|Touch Screen Calibration (Linux)|