pgsink VS pastty

Compare pgsink vs pastty and see what are their differences.

pgsink

Logically replicate data out of Postgres into sinks (files, Google BigQuery, etc) (by lawrencejones)

pastty

Copy and paste across devices (by Shafin098)
Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
pgsink pastty
5 3
76 3
- -
0.0 0.0
about 1 year ago over 3 years ago
Go JavaScript
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.

pgsink

Posts with mentions or reviews of pgsink. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-01-10.
  • GitHub - go-jet/jet: Type safe SQL builder with code generation and automatic query result data mapping
    2 projects | /r/golang | 10 Jan 2023
    This is a really awesome project. I’ve used it on https://github.com/lawrencejones/pgsink to generate type safe bindings to the Postgres catalog tables, along with a few of the tables the project maintains itself.
  • Trade-offs from using ULIDs at incident.io
    2 projects | /r/programming | 3 Jan 2023
    pgx is really good: it's what I used to write logical decoders in https://github.com/lawrencejones/pgsink
  • A modern data stack for startups
    4 projects | dev.to | 21 Apr 2022
    It used to be that companies would write their own hacky scripts to perform this extraction - I've had terrible incidents caused by ETL database triggers in the past, and even built a few generic ETL tools myself.
  • Sync Postgres to BigQuery, possible? How?
    3 projects | /r/bigquery | 5 Apr 2021
  • Ask HN: Show me your Half Baked project
    154 projects | news.ycombinator.com | 9 Jan 2021
    Postgres change-capture device that supports high-throughput and low-latency capture to a variety of sinks (at first release, just Google BigQuery):

    https://github.com/lawrencejones/pgsink

    I know there's debezium and Netflix's dblog, but this project aims to be much simpler.

    Forget about kafka and any other dependency: just point it at Postgres, and your data will be pushed into BigQuery. And for people with highly-performance-sensitive databases, the read workload has been designed with Postgres efficiency in mind.

    I'm hoping pgsink could be a gateway drug to get small companies up and running with a data warehouse. If your datastore of choice is Postgres, it's a huge help to replicate everything into an analytics datastore. A similar tool has helped my company extract expensive work out of our primary database, which is super useful for scaling.

    The project is 90% there, about 10hrs and some testing away from being useable. Once there, I'll be hitting up some start-up friends and seeing if they want to give it a whirl.

pastty

Posts with mentions or reviews of pastty. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-01-09.

What are some alternatives?

When comparing pgsink and pastty you can also consider the following projects:

dupver - Deduplicating VCS for large binary files in Go

pegao - Pegao is a community about lists of links on topics of interest.

DataflowTemplates - Cloud Dataflow Google-provided templates for solving in-Cloud data tasks

mymusic-dl - Download music using web scraping and youtube-dl no API keys required

debezium-examples - Examples for running Debezium (Configuration, Docker Compose files etc.)

PipeScore - A web-based bagpipe notation app.

xact - Model based design for developers

woof - an ad-hoc single file webserver

dbt-metabase - dbt + Metabase integration

logan - Use log files to trigger events or perform functional testing

thgtoa - The Hitchhiker’s Guide to Online Anonymity

NoSQL - A NoSQL implementation DBMS using LSM Trees