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 typeINT, 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 accessAccessing remote DeviceSQL DB files
(*Depends on platform)
Cloud collaborationSupported by communication libraries provided by various IoT cloud platforms
Support CPUCompatible 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