DBMS > LokiJS vs. Lovefield vs. SQLite
System Properties Comparison LokiJS vs. Lovefield vs. SQLite
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines
|LokiJS Xexclude from comparison
|Lovefield Xexclude from comparison
|SQLite Xexclude from comparison
|Widely used embeddable, in-process RDBMS
|Primary database model
|Dwayne Richard Hipp
|2.1.12, February 2017
|3.45.0 (15 January 2024), January 2024
|License Commercial or Open Source
|Open Source Apache 2.0
|Open Source Public Domain
|Cloud-based only Only available as a cloud service
|DBaaS offerings (sponsored links) Database as a Service
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems
|yes dynamic column types
|Typing predefined data types such as float or date
|yes not rigid because of 'dynamic typing' concept.
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.
|yes via views
|SQL Support of SQL
|yes SQL-92 is not fully supported
|APIs and other access methods
|ADO.NET inofficial driver
JDBC inofficial driver
ODBC inofficial driver
|Supported programming languages
|Server-side scripts Stored procedures
|Using read-only observers
|Partitioning methods Methods for storing different data on different nodes
|Replication methods Methods for redundantly storing data on multiple nodes
|MapReduce Offers an API for user-defined Map/Reduce methods
|Consistency concepts Methods to ensure consistency in a distributed system
|Foreign keys Referential integrity
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data
|no atomic operations within a single collection possible
|Concurrency Support for concurrent manipulation of data
|yes via file-system locks
|Durability Support for making data persistent
|yes Serialization of a DB in a Node.JS/Cordova/PhoneGap environment. Usage of the IndexedDB-API in a browser.
|yes, by using IndexedDB or the cloud service Firebase Realtime Database
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.
|yes using MemoryDB
|User concepts Access control
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services
|Navicat for SQLite is a powerful and comprehensive SQLite GUI that provides a complete set of functions for database management and development.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts
provided by Google News
Stanchion Turns SQLite Into A Column Store
SQLite Lands JSONB For Much Faster JSON Functions
A Closer Look at the Top 3 Embedded Databases: SQLite, RocksDB, and DuckDB
Steampipe unbundled: From cloud APIs to your database
SQLite's new support for binary JSON is similar but different from a PostgreSQL feature • DEVCLASS
provided by Google News
Share this page