Azure Database for PostgreSQL VS Amazon Athena

I started writing a much longer post, but it really boils down to one thing - just use Azure PostgreSQL. It's great value, well supported by DBT, and an actual DW option. Source: 12 months ago

I have a PostgreSQL database instance running in the Azure Database for PostgreSQL service. I am able to successfully connect and create enterprise geodatabases within. I am also able to successfully register the data store, both via ArcGIS Pro and ArcGIS Server Manager. However, when attempting to share a table in the database as a web layer (right click > Sharing > Share as web layer), it will ultimately fail... Source: about 1 year ago

You are likely wanting something like RDS [1], Azure [2], or even Linode (which I just discovered) [3]. Sure you have to pay a larger premium for it, but these products do allow you to focus on the app than the DBA stuff. - [1] https://aws.amazon.com/rds/ - [2] https://azure.microsoft.com/en-us/services/postgresql/#overview - [3] https://www.linode.com/products/postgresql/. - Source: Hacker News / almost 2 years ago

This app uses the Azure PostgreSQL service, so it best fits in the choose your own adventure category. - Source: dev.to / about 2 years ago

Check this out - https://azure.microsoft.com/en-us/services/postgresql/ You can get free 12 months of Azure as well. Source: over 2 years ago

Prepare GIS data for use with Amazon Athena. This time, we created four types of sample data in QGIS in advance. - Source: dev.to / 5 months ago

If you have not heard about AWS Athena, I encourage you to take a look at this service. You can read more about it here. - Source: dev.to / 6 months ago

Probably S3 Select or Athena? https://aws.amazon.com/athena/ Both can query S3 directly. Source: about 1 year ago

You can use athena to query data out of parquet files in S3. Source: about 1 year ago

Amazon Athena (analytics) Amazon Athena is an interactive query service that you can use to analyze data in Amazon S3 using ANSI SQL. Athena is serverless, so there's no infrastructure to manage. Athena scales automatically and is simple to use, so you can start analyzing your datasets within seconds. Https://aws.amazon.com/athena/. - Source: dev.to / over 1 year ago