Presto DB VS PostgreSQL

Presto DB Reviews

PostgreSQL Reviews

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

PostgreSQL mentions (15)

• Perfect Elixir: Environment Setup

  I’m on MacOS and erlang.org, elixir-lang.org, and postgresql.org all suggest installation via Homebrew, which is a very popular package manager for MacOS. - Source: dev.to / about 1 month ago

• Rust & MySQL: connect, execute SQL statements and stored procs using crate sqlx.

  According to the documentation, crate sqlx is implemented in Rust, and it's database agnostic: it supports PostgreSQL, MySQL, SQLite, and MSSQL. - Source: dev.to / 8 months ago

• Really tired. Is PostgreSQL even runnable in Windows 10? pgAdmin4 stucks at Loading whatever I try.

  Solution is just downloading and installilng pgAdmin from official pgAdmin homepage version, not the one that is included in the postgresql.org package. Source: 9 months ago

• Why SQL is right for Infrastructure Management

  SQL immediately stands out here because it was designed for making relational algebra, the other side of the Entity-Relationship model, accessible. There are likely more people who know SQL than any programming language (for IaC) or data format you could choose to represent your cloud infrastructure. Many non-programmers know it, as well, such as data scientists, business analysts, accountants, etc, and there is... - Source: dev.to / about 1 year ago

• Ask HN: Hunting for a Framework

  Vapor[0] based on Swift. Advantage of this is that you don't have to evaluate multiple frameworks for Swift and suffer paralysis by analysis. All the Swift community is behind one framework. The next is Actix[1] based on Rust. There are many frameworks in Rust and most of them have not reached 1.0 And which framework will survive becomes a question. Other not so well-known is Wt[2] based on C++. This actually is... - Source: Hacker News / over 1 year ago