In-Memory vs. On-Disk

Developers of applications for embedded systems and devices often ask us whether they should consider On-Disk or In-Memory database engines. My answer is: select a Hybrid database, which offers the best of the both worlds. With In-Memory, you use memory tables for high-performance including frequent updates and small-table select. On the other hand, with On-Disk, you can use disk tables to insert at high throughput and effeciently select from very large tables. ITTIA DB SQL is a hybrid database; memory and disk tables are interchangeable and you benefit from learning one API, transaction rollback and shared access.