DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > 4D vs. CockroachDB vs. Faircom EDGE vs. Google Cloud Datastore

System Properties Comparison 4D vs. CockroachDB vs. Faircom EDGE vs. Google Cloud Datastore

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name4D infoformer name: 4th Dimension  Xexclude from comparisonCockroachDB  Xexclude from comparisonFaircom EDGE infoformerly c-treeEDGE  Xexclude from comparisonGoogle Cloud Datastore  Xexclude from comparison
DescriptionApplication development environment with integrated database management systemCockroachDB is a distributed database architected for modern cloud applications. It is wire compatible with PostgreSQL and backed by a Key-Value Store, which is either RocksDB or a purpose-built derivative, called Pebble.FairCom EDGE is an Industry 4.0 solution built to integrate, collect, aggregate and synchronize mission-critical data in edge computing environmentsAutomatically scaling NoSQL Database as a Service (DBaaS) on the Google Cloud Platform
Primary database modelRelational DBMSRelational DBMSKey-value store
Relational DBMS
Document store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.27
Rank#112  Overall
#54  Relational DBMS
Score4.85
Rank#64  Overall
#36  Relational DBMS
Score0.02
Rank#366  Overall
#55  Key-value stores
#155  Relational DBMS
Score4.04
Rank#71  Overall
#12  Document stores
Websitewww.4d.comwww.cockroachlabs.comwww.faircom.com/­products/­faircom-edgecloud.google.com/­datastore
Technical documentationdeveloper.4d.comwww.cockroachlabs.com/­docsdocs.faircom.com/­docs/­en/­UUID-23d4f1fd-d213-f6d5-b92e-9b7475baa14e.htmlcloud.google.com/­datastore/­docs
Developer4D, IncCockroach LabsFairCom CorporationGoogle
Initial release1984201519792008
Current releasev20, April 202324.1.0, May 2024V3, October 2020
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0, commercial license availablecommercial infoRestricted, free version availablecommercial
Cloud-based only infoOnly available as a cloud servicenononoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageGoANSI C, C++
Server operating systemsOS X
Windows
Linux
macOS
Windows
Android
Linux infoARM, x86
Raspbian
Windows
hosted
Data schemeyesdynamic schemaFlexible Schema (defined schema, partial schema, schema free)schema-free
Typing infopredefined data types such as float or dateyesyesyes, ANSI Standard SQL Typesyes, details here
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yesnoyesno
Secondary indexesyesyesyesyes
SQL infoSupport of SQLyes infoclose to SQL 92yes, wire compatible with PostgreSQLyes infoANSI SQL queriesSQL-like query language (GQL)
APIs and other access methodsODBC
RESTful HTTP API infoby using 4D Mobile
SOAP webservices
JDBCADO.NET
Direct SQL
IoT Microservice layer
JDBC
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
gRPC (using protocol buffers) API
RESTful HTTP/JSON API
Supported programming languages4D proprietary IDE
PHP
C#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
C
C#
C++
Java
JavaScript
PHP
Python
VB.Net
.Net
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Server-side scripts infoStored proceduresyesnoyes info.Net, JavaScript, C/C++using Google App Engine
TriggersyesnoyesCallbacks using the Google Apps Engine
Partitioning methods infoMethods for storing different data on different nodesnonehorizontal partitioning (by key range) infoall tables are translated to an ordered KV store and then broken down into 64MB ranges, which are then used as replicas in RAFTFile partitioning infoCustomizable business rules for partitioningSharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationMulti-source replication using RAFTyes infoSynchronous and asynchronous realtime replication based on transaction logsMulti-source replication using Paxos
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononoyes infousing Google Cloud Dataflow
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Tunable Consistency
Immediate Consistency or Eventual Consistency depending on type of query and configuration infoStrong Consistency is default for entity lookups and queries within an Entity Group (but can instead be made eventually consistent). Other queries are always eventual consistent.
Foreign keys infoReferential integrityyesyesyes infowhen using SQLyes infovia ReferenceProperties or Ancestor paths
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACIDACID infoSerializable Isolation within Transactions, Read Committed outside of Transactions
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoacross SQL and NoSQLyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyesno
User concepts infoAccess controlUsers and groupsRole-based access controlFine grained user, group and file access rights managed across SQL (per ANSI standard) and NoSQL.Access rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
4D infoformer name: 4th DimensionCockroachDBFaircom EDGE infoformerly c-treeEDGEGoogle Cloud Datastore
DB-Engines blog posts

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Recent citations in the news

Cockroach Labs shakes up its licensing to force bigger companies to pay
15 August 2024, TechCrunch

CockroachDB scuttles away from open source Core offering
19 August 2024, The Register

Now CockroachDB Ditches Open-Source License
20 August 2024, It's FOSS News

CockroachDB retires self-hosted Core offering, makes Enterprise version free for companies under $10M in annual revenue
15 August 2024, SDTimes.com

Cockroach Labs Shifts from Open Core to Single Enterprise Model
19 August 2024, Datanami

provided by Google News

Data Technology Company FairCom Expands The Edge with 2 New Releases of its Edge Computing Products
19 April 2023, Business Wire

Brokers, Protocols, Platform Move Manufacturing Data
26 July 2023, EE Times

Winners of the 2021 IoT Evolution Product of the Year Awards Announced
6 July 2021, IoT Evolution World

How To Collect, Store, and Query IoT Data With MQTT + SQL
16 June 2022, IoT For All

Trend-Setting Products in Data and Information Management for 2023
8 December 2022, Database Trends and Applications

provided by Google News

What Is Google Cloud? Platform, Benefits & More Explained
17 October 2024, Cloudwards

Best cloud storage of 2024
16 October 2024, TechRadar

Google Gets Rid of Fees To Transfer Data Out of Cloud Platform
12 January 2024, Spiceworks News and Insights

Google App Engine
26 April 2024, TechTarget

17 Top Cloud Storage Companies to Know
9 April 2024, Built In

provided by Google News



Share this page

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Present your product here