You Need More than SQLite
Upgrade to Actian Zen
Keep the SQL embedded footprint and add Speed, Scale, Security, and Server Capability
Bringing the IoT to ERP: One Stop Shopping for Global Shop Solutions
Global Shop extends its use of Actian Zen Enterprise Server in its ERP software to shop floor IoT with Actian Zen Core.
“With the evolution of the Zen architecture, we can now deploy a small footprint/IoT-enabled database that can run in a serverless mode with just client libraries. That opens up whole new opportunities for customers to put inexpensive IoT-enabled devices into settings that used to require expensive PLC devices.”
Four Key Areas Where Zen is Far Superior to SQLite
“With Actian Zen data management products, we’ve been able to extend our integrated solutions in the classroom and across campuses to better track and manage students and institutional assets, extending our capabilities to IoT and mobile devices.”
– André Beauchamp, CEO, Plurilogic
Architected for the Entire Range of IoT and Enterprise Applications
SQLite’s popularity is largely a function of its widespead use as a web browser and mobile application data cache. Outside of single-user or low-speed transactional use cases, SQLite struggles and is unsuitable for the coming wave of Edge data processing and analytics.
Actian Zen provides full ANSI SQL, embeddable in all popular programming and scripting languages. Zen supports your entire range of devices and projects, replacing SQLite as a serverless client in under 5 MB but also supports peer-to-peer, local network, cloud or mixed environment as a client-server within a 200MB footprint. With Actian Zen, there’s no need for separate time-series, document store, traditional or serveless SQL databases.
SQLite is NOT Free
SQLite is Open Source and therefore initially free as is Actian Zen Core. Actian Zen Core is over 100X faster than SQLite when using its NoSQL API. Further, SQLite’s serverless architecture limits its unaltered use to low-speed devices without multiple functions, data streams or applications – all commonplace use cases in IoT. Any of these necessitates coding of add-on functionality already available out of the box with Actian Zen Edge, the client-server version of Actian Zen Core.
SQLite requires add-on components for security, command line queries and other functionality that again, is built into Actian Zen Edge and Enterprise. All of this has a significant price tag associated with it: hours for development, additional test and validation, and long term support costs. It also increases the cost of your field applications and any underlying hardware that is part of the product you deliver to your employees, partners and customers. While Actian client-server versions have nominal up-front perpetual license or subscription fees, they are supported for 5 – 7 years and are backward compatible for upgrade for far longer.
SQLite Exacerbates Database Sprawl
In many IoT and complex equipment product portfolios, platform resources range from threadbare to well-endowned. SQLite is a best fit for the lower end of any given product line or set of application data management needs. High-speed data or complex functionality within these systems increasingly means advanced analytics and different data types that have historiaclly been beyond SQLite’s reach. Generally, product engineers and developers have rightfully responded with a best-of-breed approach, selecting other client-server, document store, and time-series centric solutions to complement or replace SQLite.
With Actian Zen you can integrate with or replace all of these – SQLite, InfluxDB, MongoDB, Microsoft SQL Server, etc. – with a single architecture that provides best-of-breed performance yet removes integration costs, security vulnerabilities associated with data transformations between disparate databasaes, and reduces procurement complexity of sourcing and servicing as well.