Singer Reviews

Presto DB Reviews

Singer mentions (7)

• Why do companies still build data ingestion tooling instead of using a third-party tool like Airbyte?

  Coincidently, I saw a presentation today on a nice half-way-house solution: using embeddable Python libraries like Sling and dlt - both open-source. See https://www.youtube.com/watch?v=gAqOLgG2iYY There is also singer.io which is more of a protocol than a library, but can also be installed although it looks like it is a true community effort and not so well maintained. Source: 6 months ago

• Data sources episode 2: AWS S3 to Postgres Data Sync using Singer

  Singer is an open-source framework for data ingestion, which provides a standardized way to move data between various data sources and destinations (such as databases, APIs, and data warehouses). Singer offers a modular approach to data extraction and loading by leveraging two main components: Taps (data extractors) and Targets (data loaders). This design makes it an attractive option for data ingestion for... - Source: dev.to / about 1 year ago

• CDC (Change Data Capture) with 3rd party APIs

  Or you could build your own such system and run it on Airflow, Prefect, Dagster, etc. Check out the Singer project for a suite of Python packages designed for such a task. Quality varies greatly, though. Source: over 1 year ago

• Looking to build a database for BI reports

  This is good advice and I think Airbyte created a great product here. I tried singer.io and pipewise but Airbyte is much better in my opinion and I love the UI. Source: almost 3 years ago

• Recommendation for approach for populating and refreshing new data lake

  Suspect my question should have been regarding FREE systems, rather than BUYING a system. Sounds like singer.io will do what I need. Source: about 3 years ago

Presto DB mentions (6)

• Parsing logs from multiple data sources with Ahana and Cube

  Presto is an open-source distributed SQL query engine, originally developed at Facebook, now hosted under the Linux Foundation. It connects to multiple databases or other data sources (for example, Amazon S3). We can use a Presto cluster as a single compute engine for an entire data lake. - Source: dev.to / almost 2 years ago

• Can a data warehouse be skipped?

  Fair point, but I am talking about Athena (not SQL Server), which under the hood uses a distributed query engine. It is capable to deal with huge amounts of data, if the storage is in the right shape. You can read more about the underlying technology here: https://prestodb.io/. Source: about 2 years ago

• why use Redshift if we can use S3 to store data and can connect with Quicksight for dashboarding?

  So there is Presto, which is a distributed SQL engine created by Facebook. Source: about 2 years ago

• Understanding AWS Athena 101

  You can use Athena to run data analytics, with just standard SQL (Presto). - Source: dev.to / over 2 years ago

• ETL tool for query building across multiple databases in Mongo DB

  Presto does this, but I'm honestly uncertain how performant it is. In my experience, centralizing data is the superior approach to attempting to query multiple sources in place. Source: almost 3 years ago