DBMS > FatDB vs. SQLite
System Properties Comparison FatDB vs. SQLite
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines
|FatDB Xexclude from comparison
|SQLite Xexclude from comparison
|FatDB/FatCloud has ceased operations as a company with February 2014. FatDB is discontinued and excluded from the ranking.
|A .NET NoSQL DBMS that can integrate with and extend SQL Server.
|Widely used embeddable, in-process RDBMS
|Primary database model
|Dwayne Richard Hipp
|3.45.0 (15 January 2024), January 2024
|License Commercial or Open Source
|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.
|SQL Support of SQL
|no Via inetgration in SQL Server
|yes SQL-92 is not fully supported
|APIs and other access methods
|.NET Client API
RESTful HTTP API
Windows WCF Bindings
|ADO.NET inofficial driver
JDBC inofficial driver
ODBC inofficial driver
|Supported programming languages
|Server-side scripts Stored procedures
|yes via applications
|yes via applications
|Partitioning methods Methods for storing different data on different nodes
|Replication methods Methods for redundantly storing data on multiple nodes
|selectable replication factor
|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
|Concurrency Support for concurrent manipulation of data
|yes via file-system locks
|Durability Support for making data persistent
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.
|User concepts Access control
|no Can implement custom security layer via applications
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
Big gains for Relational Database Management Systems in DB-Engines Ranking 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
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