pastty VS pgsink

Compare pastty vs pgsink and see what are their differences.

pastty

Copy and paste across devices (by Shafin098)

pgsink

Logically replicate data out of Postgres into sinks (files, Google BigQuery, etc) (by lawrencejones)
SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
surveyjs.io
featured
InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
pastty pgsink
3 5
3 76
- -
0.0 0.0
over 3 years ago about 1 year ago
JavaScript Go
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.

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.

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.

What are some alternatives?

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

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

dupver - Deduplicating VCS for large binary files in Go

woof - an ad-hoc single file webserver

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

PipeScore - A web-based bagpipe notation app.

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

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

xact - Model based design for developers

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

dbt-metabase - dbt + Metabase integration

NoSQL - A NoSQL implementation DBMS using LSM Trees

thgtoa - The Hitchhiker’s Guide to Online Anonymity