sql-migrate VS cockroach

Compare sql-migrate vs cockroach and see what are their differences.

sql-migrate

SQL schema migration tool for Go. (by rubenv)

cockroach

CockroachDB - the open source, cloud-native distributed SQL database. (by cockroachdb)
Our great sponsors
  • Scout APM - Less time debugging, more time building
  • SonarLint - Clean code begins in your IDE with SonarLint
  • SaaSHub - Software Alternatives and Reviews
sql-migrate cockroach
5 52
2,501 24,983
- 1.3%
4.7 10.0
27 days ago 6 days ago
Go Go
MIT License GNU General Public License v3.0 or later
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

sql-migrate

Posts with mentions or reviews of sql-migrate. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-06-08.

cockroach

Posts with mentions or reviews of cockroach. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-06-25.
  • Would NextJS and MongoDB Realm be a good idea for a large-scale fullstack Web app?
    1 project | reddit.com/r/webdev | 28 Jun 2022
    There are relational options like Planetscale, CockroachDB, Alloy DB, and Aurora that can provide the same benefit without having to manage Postgres scaling.
  • PostgreSQL Upgrades Are Hard
    4 projects | news.ycombinator.com | 25 Jun 2022
    I don't know about how postgres compares to others, but if you're looking for an easy-to-manage relational DB, there are a handful of new cloud-native databases that have come out in the last few years. The ones I know of are Planetscale and Cockroach DB.

    https://planetscale.com/

    https://www.cockroachlabs.com/

  • Jamstack in Action
    8 projects | dev.to | 16 Jun 2022
  • AMD outperforms Intel in 2022 Cloud Report
    1 project | news.ycombinator.com | 16 Jun 2022
    Explained why they don't produce official, supported builds.

    https://github.com/cockroachdb/cockroach/issues/62903#issuec...

  • Open Source Databases in Go
    52 projects | reddit.com/r/golang | 8 Jun 2022
    CockroachDB
    52 projects | reddit.com/r/golang | 8 Jun 2022
    cockroach - Scalable, Geo-Replicated, Transactional Datastore.
    52 projects | reddit.com/r/golang | 8 Jun 2022
  • DeWitt Clause, or Can You Benchmark %DATABASE% and Get Away With It
    21 projects | dev.to | 2 Jun 2022
    CockroachDB (licensed under BSL, not OSI-approved)
  • Neon – Serverless Postgres
    11 projects | news.ycombinator.com | 27 May 2022
    Just yesterday I was comparing managed serverless postgres offers and was sad to temporarily end my investigation with a compromise of using managed aws RDS for development, hoping that a fully serverless postgres with a nice free tier would pop up before going to production, and here we are!

    Congrats to the team for what feels like an amazing product. Signed up for the early access, can't wait to get my hands on this!

    For anyone interested, these ere the DB offers I looked into:

    * DO managed postgres, no free tier but price scaling was not too aggressive, the issue is that it's not natively serverless and we're gonna get 100s of ephemeral connections.

    * Cockroach, was the best option for our use case but it doesn't support triggers and stored procedures, so we can't use it right now (closely following https://github.com/cockroachdb/cockroach/issues/28296)

    * Fly.io price scaling is too aggressive 6$ -> 33 -> 154 -> 1000s a month and no free tier that I could find.

    * Aurora serverless v2 is only for aws internal access and we are using gcp.

    * Aurora v1 was what we were gonna go with, but a lot of people online have showed their negative opinion around slow scaling. I didn't investigate enough but I'm thinking we'd need to setup RDS proxy for it handle all our connections, which would've bumped up the price by a good amount. Also no free tier.

    * Alloydb looked promising but also no free tier and starting price is a bit much for our current phase of development, but it was definitely something we'd look into in the future.

    And now Neon, natively serverless with a (hopefully) good free tier to test things out and some hints about cross region data replication, amazing stuff!

  • How we built a cost-based SQL optimizer
    1 project | reddit.com/r/programming | 29 Apr 2022
    CRDB implements the algorithm described in a 2013 paper called "On the correct and complete enumeration of the core search space". It is a bottom-up DP approach that is able to handle inner, left, anti, semi, full, etc. joins (many papers only cover inner joins). In addition, CRDB extends it in a few ways that enable reorderings in some important practical cases that the paper doesn't cover (a full description can be found here). As a result, it's able to reorder in a number of cases that other optimizers don't even consider.

What are some alternatives?

When comparing sql-migrate and cockroach you can also consider the following projects:

vitess - Vitess is a database clustering system for horizontal scaling of MySQL.

tidb - TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try free: https://tidbcloud.com/free-trial

goose

Trino - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)

yugabyte-db - The high-performance distributed SQL database for global, internet-scale apps.

rqlite - The lightweight, distributed relational database built on SQLite

dgraph - Native GraphQL Database with graph backend

InfluxDB - Scalable datastore for metrics, events, and real-time analytics

Redis - Redis is an in-memory database that persists on disk. The data model is key-value, but many different kind of values are supported: Strings, Lists, Sets, Sorted Sets, Hashes, Streams, HyperLogLogs, Bitmaps.

go-memdb - Golang in-memory database built on immutable radix trees

snowflake - Snowflake is a network service for generating unique ID numbers at high scale with some simple guarantees.

edgedb - A next-generation graph-relational database.