Last updated December 20, 2024



Location  |  Firebase Realtimeread more |  Tursoread more |  Firebase Firestoreread more | |||
|---|---|---|---|---|---|---|
Cold Query  | Hot Query  | Cold Query  | Hot Query  | Cold Query  | Hot Query  | |
FAQ
Compare the features of the Serverless Database to help you choose the right one for your needs.
Feature  |  Firebase Realtime |  Turso |  Firebase Firestore | |
|---|---|---|---|---|
Infrastructure, Underlying technology Cloud Infrastructure, database system and underlying egine  | Nodejs, Google Cloud, Scala  | N/A  | N/A  | |
Serverless Support Serverless and Edge computing support  | ||||
API  | REST API  | N/A  | N/A  | |
Edge Functions Serverless functions that run closer to the user, reducing latency and improving performance.  | Cloud functions  | N/A  | N/A  | |
Developer Experience  | ||||
Database type  | OLTP, OLAP  | N/A  | N/A  | |
Data model Databases store data in models, such as Relational, Columnar or Document based  | Document based, NoSQL  | N/A  | N/A  | |
CLI Command Line Interface tools that allow developers to perform tasks and manage the tool via the command line.  | Firebase CLI  | N/A  | N/A  | |
Languages, APIs The languages supporting the database and API interface for inter-process communication   | JavaScript, Swift, Kotlin, Java, C++, Objective-C  | N/A  | N/A  | |
Query language Supported query language such as SQL, MQL, PartiQL,   | JSON  | N/A  | N/A  | |
ACID compliant ACID  is a set of properties of database transactions intended to guarantee data validity despite errors, power failures, and other mishaps  | N/A  | N/A  | ||
Self-hosting Support for self-hosted Database instance  | Doesn't have support  | N/A  | N/A  | |
Backups  | N/A  | N/A  | ||
Security & Compliance Offerings  | ||||
SOC2 Service Organization Control 2 compliance for managing customer data.  | Apart from App indexing   | N/A  | N/A  | |
Multi-factor authentication Support of the cloud-histed database for multi-factor authentication  | N/A  | N/A  | ||
Encryption Cryptographic security at rest and on transportation level  | HTTPS, TLS  | N/A  | N/A  | |
SSO  | SAML-based SSO solution  | N/A  | N/A  | |
Monitoring and analytics  | ||||
Log retention Query log retention usually keeps lofs of operations for debugging and replication purposes  | Document level history 30 days retention  | N/A  | N/A  | |
Statistics Tools and APIs for analysing and monitoring of Database performance  | Web based monitoring tools  | N/A  | N/A  | |
Scalability  | ||||
Replication and Partitioning  | Region groups  | N/A  | N/A  | |