CockroachDB vs LocalDB comparison

Cancel
You must select at least 2 products to compare!
Cockroach Logo
4,160 views|2,803 comparisons
80% willing to recommend
Microsoft Logo
3,924 views|3,364 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between CockroachDB and LocalDB based on real PeerSpot user reviews.

Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed CockroachDB vs. LocalDB Report (Updated: March 2024).
768,578 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I use CockroachDB to test big data samples and to create the best structure for databases. We have four users and required 10 people for deployment and maintenance.""The availability and the easy to use feature is the most valuable. The documentation is also good.""CockroachDB is highly reliable.""The initial setup and deployment are simple.""The product has valuable security features.""The best feature of CockroachDB is the ability to keep the nodes in different locations.""The subset of SQL that my client is using is completely supported.""The most valuable features of the solution are its resiliency features and the geo-partitioning capabilities."

More CockroachDB Pros →

"The initial setup was simple.""The initial setup is very straightforward. The guidelines are very easy to follow. Maintenance is very easy and requires very little manpower.""The most valuable feature of LocalDBis the connection between the application and DB.""The solution is fast."

More LocalDB Pros →

Cons
"We are looking for more features to support distributed high availability and geo-partitioning.""The product must improve its disaster recovery features.""Cockroach does not support all types of protocols. I need to improve it myself to support a CouchDB on my network.""The closer they can make CockroachDB to being completely compatible with Postgres, the better. It's almost compatible, but not completely. If it was, it would be nice to just be able to use Postgres libraries without any fiddling.""The initial setup and pricing could be improved.""CockroachDB needs to improve store processes.""The platform could be more extensible.""I find the serverless offer a bit confusing."

More CockroachDB Cons →

"The ALM features can be improved, but the database by itself is reliable.""The internal connection features of LocalDB could improve.""The solution needs to create a management tool. Right now, the solution has tools for creating a local installation, but it's too simplistic. We need something that's a bit more complex so that we can extend the tools with our scripts.""The initial setup is complex and requires a skilled person."

More LocalDB Cons →

Pricing and Cost Advice
  • "I've used CockroachDB at a small scale on the free accounts because we are only testing."
  • "The pricing is good but can be made cheaper. I would rate the pricing a five out of ten."
  • "The platform is affordable even for the enterprise version. It provides value for investment in terms of performance."
  • "The product's price depends on the user's company and the contract model they enter into with CockroachDB. Depending on the contract model one enters into with CockroachDB, the product may or may not be expensive."
  • More CockroachDB Pricing and Cost Advice →

  • "The licensing cost is too high for LocalDB."
  • "The fees are fair."
  • More LocalDB Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
    768,578 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The subset of SQL that my client is using is completely supported.
    Top Answer:I find the serverless offer a bit confusing. The price is a function of the maximum database size. A single SELECT can use a number of request units, for example. If the throughput is high enough, you… more »
    Top Answer:Cockroach nodes were installed in the following: 1. Single host, triple nodes (containers): for evaluation on a low-end PC. 2. Single host, triple nodes (process): to test applications against a… more »
    Top Answer:We pay an annual fee for the license. The fees are fair.
    Top Answer:I would like to have more integration.
    Ranking
    Views
    4,160
    Comparisons
    2,803
    Reviews
    8
    Average Words per Review
    416
    Rating
    8.5
    Views
    3,924
    Comparisons
    3,364
    Reviews
    2
    Average Words per Review
    202
    Rating
    8.5
    Comparisons
    Oracle Database logo
    Compared 28% of the time.
    MySQL logo
    Compared 19% of the time.
    Citus Data logo
    Compared 15% of the time.
    Amazon Aurora logo
    Compared 12% of the time.
    SQL Server logo
    Compared 7% of the time.
    SQL Server logo
    Compared 88% of the time.
    MySQL logo
    Compared 7% of the time.
    Oracle Database logo
    Compared 1% of the time.
    Infobright DB logo
    Compared 1% of the time.
    Learn More
    Overview

    CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.

    CockroachDB is inspired by Google’s Spanner and F1 technologies, and it’s completely open source.

    LocalDB is a lightweight version of the SQL Server Express Database Engine that is targeted for program development. LocalDB starts on demand and runs in user mode, so there is no complex configuration.
    Sample Customers
    Baidu, Kindred, Tierion, Heroic Labs, Gorgias
    AstraZeneca, Kienzle Automotive GmbH, Kodak Alaris, Unilever, Floatel International and Kongsberg Maritime, MyHero
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm39%
    Computer Software Company13%
    Retailer5%
    Manufacturing Company4%
    VISITORS READING REVIEWS
    Computer Software Company13%
    Financial Services Firm11%
    Comms Service Provider10%
    Government9%
    Company Size
    REVIEWERS
    Small Business60%
    Large Enterprise40%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise13%
    Large Enterprise73%
    VISITORS READING REVIEWS
    Small Business25%
    Midsize Enterprise14%
    Large Enterprise60%
    Buyer's Guide
    CockroachDB vs. LocalDB
    March 2024
    Find out what your peers are saying about CockroachDB vs. LocalDB and other solutions. Updated: March 2024.
    768,578 professionals have used our research since 2012.

    CockroachDB is ranked 9th in Relational Databases Tools with 10 reviews while LocalDB is ranked 15th in Relational Databases Tools with 5 reviews. CockroachDB is rated 8.0, while LocalDB is rated 9.0. The top reviewer of CockroachDB writes "Open source with extensive documentation and a University for training". On the other hand, the top reviewer of LocalDB writes "Good for the development process, generally stable, and easy to set up". CockroachDB is most compared with Oracle Database, MySQL, Citus Data, Amazon Aurora and SQL Server, whereas LocalDB is most compared with SQL Server, MySQL, Oracle Database In-Memory, Oracle Database and Infobright DB. See our CockroachDB vs. LocalDB report.

    See our list of best Relational Databases Tools vendors.

    We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.