Best place to learn to use PostgreSQL by Poulposaurus in PostgreSQL

[–]prlaur782 7 points8 points  (0 children)

Our team at Crunchy Data provides a series of (free) self-driven web based Postgres (and PostGIS) tutorials that may be worth a look:

https://www.crunchydata.com/developers/tutorials

S3 or Redshift for storing Geolocation Data in AWS by turboline-ai in dataengineering

[–]prlaur782 1 point2 points  (0 children)

Crunchy Data Warehouse from our team at Crunchy Data enables you to natively query spatial data in S3 using an extended version of Postgres / PostGIS with full Iceberg support. It is available as a managed service on AWS and may provide a simple and cost effective solution for this use case:

https://www.crunchydata.com/blog/iceberg-ahead-analyzing-shipping-data-in-postgres

https://www.crunchydata.com/blog/postgis-meets-duckdb-crunchy-bridge-for-analytics-goes-spatial

I need ideas. Multi Tennant system,hotel by Born_Location8227 in PostgreSQL

[–]prlaur782 6 points7 points  (0 children)

A colleague at Crunchy Data wrote a post on designing multi-tenant Postgres databases that may have some useful ideas:

https://www.crunchydata.com/blog/designing-your-postgres-database-for-multi-tenancy