Embedded Database Ubiquitous DeviceSQL Compact and High-Speed database for embedded devices

Development environment

Development language
  • DeviceSQL language (Industry standard Oracle PL / SQL compliant)
  • C / C ++ (Embedded SQL API / Native API)
Tool
  • DeviceSQL Compiler
  • Sample application (StarterSamples)
  • DeviceSQL SQLProbe
Development host OS
  • Windows 7/8/10
  • Linux

Target environment (Runtime)

Footprint
  • 50KB ~. Depends on configuration and compiler type
DB type
  • Library type
Data model
  • Relational
  • Data stream
Maximum database size
  • 4TB (4096GB)
Maximum number
of tables/ database
  • 2048
Maximum records / table
  • Unlimited (depends on available resource size such as memory)
Data format & encoding
  • Unicode UTF-8, UTF-16, ASCII
  • "Instant-On" paged index / storage format
Data type INT, SHORT, LONG, FLOAT, DOUBLE, VARCHAR, NVARCHAR, TIMESTAMP, DATE, BINARY, BIT8, BIT16, BIT32, INT8, INT16, INT32, INT64, UINT8, UNIT16, UINT32, UINT64, FLOAT64, POINTER, PHONECHAR, RECORD, STREAM, VECTOR_*type*, TABLE, POINT_I, POINT_IZ, POINT_D, POINT_DZ
Index service
  • Hash, AVL-Tree, B-Tree
  • R*-Tree (spatial search), N-gram (full text search)
Storage support
  • stream
  • In-Memory
  • Memory Mapped Storage
    FlashROM, HDD, SD / MMC etc.
  • Device direct storage (Paged Storage)
    FlashROM, HDD, SD / MMC etc.
Data sharing
  • Multi-process (Paged Storage)
  • Multithread
Remote access Accessing remote DeviceSQL DB files
(*Depends on platform)
Cloud collaboration Supported by communication libraries provided by various IoT cloud platforms
Support CPU Compatible with 32bits and 64bits CPUs
Support OS μITRON (TOPPERS-PRO and eForce μC3 etc.), Linux, Windows CE, FreeRTOS,
Symbian, VxWorks, QNX, ThreadX, In house OS, etc.

Find a Product