The SQL support in solidDB® is comparable to any advanced SQL-based system; solidDB® offers the most commonly expected features and a set of useful extensions employing solidDB®-specific (nonstandard) SQL syntax. Procedural SQL extensions such as stored procedures, stored functions, and triggers enable moving parts of the application logic into the database. These extensions help reduce network traffic, thus improving performance.
solidDB® also supports both internal and external user-defined stored functions and procedures. External functions and procedures can be written in C programming language and used as migration tools; missing functionality can be added at the cost of writing a C program.
Note External functions and procedures are supported in shared memory access (SMA) and linked library access (LLA) setups.