DBMS > Lovefield vs. Snowflake vs. SQLite
System Properties Comparison Lovefield vs. Snowflake vs. SQLite
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Lovefield Xexclude from comparison||Snowflake Xexclude from comparison||SQLite Xexclude from comparison|
|Primary database model||Relational DBMS||Relational DBMS||Relational DBMS|
|Developer||Snowflake Computing Inc.||Dwayne Richard Hipp|
|Current release||2.1.12, February 2017||3.38.5 (6 May 2022), May 2022|
|License Commercial or Open Source||Open Source Apache 2.0||commercial||Open Source Public Domain|
|Cloud-based only Only available as a cloud service||no||yes||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Data scheme||yes||yes support of semi-structured data formats (JSON, XML, Avro)||yes dynamic column types|
|Typing predefined data types such as float or date||yes||yes||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.||no||yes||no|
|APIs and other access methods||CLI Client|
|ADO.NET inofficial driver|
JDBC inofficial driver
ODBC inofficial driver
|Server-side scripts Stored procedures||no||user defined functions||no|
|Triggers||Using read-only observers||no similar concept for controling cloud resources||yes|
|Partitioning methods Methods for storing different data on different nodes||none||yes||none|
|Replication methods Methods for redundantly storing data on multiple nodes||none||yes||none|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes via file-system locks|
|Durability Support for making data persistent||yes, by using IndexedDB or the cloud service Firebase Realtime Database||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes using MemoryDB||no||yes|
|User concepts Access control||no||Users with fine-grained authorization concept, user roles and pluggable authentication||no|
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|
|3rd parties||CData: Connect to Big Data & NoSQL through standard Drivers.|
SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
|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|