rom-sql VS pgsync

Compare rom-sql vs pgsync and see what are their differences.

pgsync

Sync data from one Postgres database to another (by ankane)
Our great sponsors
  • PopRuby - Clothing and Accessories for Ruby Developers
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
rom-sql pgsync
1 5
219 2,922
0.9% -
5.9 5.8
3 months ago about 1 month ago
Ruby Ruby
MIT License MIT License
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.

rom-sql

Posts with mentions or reviews of rom-sql. We have used some of these posts to build our list of alternatives and similar projects.

We haven't tracked posts mentioning rom-sql yet.
Tracking mentions began in Dec 2020.

pgsync

Posts with mentions or reviews of pgsync. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-02-17.
  • Greenmask: PostgreSQL Dump and Obfuscation Tool
    5 projects | news.ycombinator.com | 17 Feb 2024
    I‘m using https://github.com/ankane/pgsync for that, it has a very easy config yaml and you can just define queries that get pulled from the db.

    I have a simple one like „base_tables“ that just pulls me all the fixtures into my local db, then entity specific ones that pull an entity with a specific id + all related entries in other tables for debugging but as long as you can query it you can set up everything very easily.

What are some alternatives?

When comparing rom-sql and pgsync you can also consider the following projects:

pg_search - pg_search builds ActiveRecord named scopes that take advantage of PostgreSQL’s full text search

Sequelize - Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.

vscode-sqltools - Database management for VSCode

Mobility - Pluggable Ruby translation framework

knex-tree - Query hierarchical data structures in sql with knex

decafsucks - Rebuilding decafsucks.com as an OSS Hanami 2.0 example app

sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.

HeidiSQL - A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi

Discourse - A platform for community discussion. Free, open, simple.

dbsnapper - Easy database snapshots for development and testing

Backup - Easy full stack backup operations on UNIX-like systems.

LINQ to DB - Linq to database provider.