AWS PostgreSQL guides for Fastah IP geolocation

What's New

New guides: Amazon RDS for PostgreSQL | Amazon Aurora PostgreSQL and DSQL

We added AWS PostgreSQL deployment guides that show how to store Fastah IP geolocation responses using native data types and extensions.

Details

• Compare Amazon Aurora PostgreSQL and Aurora DSQL for Fastah workloads, including support for inet, cidr, PostGIS, and timezone-aware timestamps.
• Follow copy-pasteable SQL examples to model and index IP addresses and subnets using inet/cidr and GiST indexes.
• Enable PostGIS on supported AWS PostgreSQL engines and store locationData coordinates as SRID 4326 geometry points.
• Store timezone-aware timestamps using TIMESTAMPTZ together with Fastah's locationData.tz value.

Example Usage

-- RDS or Aurora PostgreSQL: store Fastah IP geolocation results
CREATE EXTENSION IF NOT EXISTS postgis;

CREATE TABLE ip_locations (
  source_ip inet PRIMARY KEY,
  approximate_geo geometry(Point, 4326),
  created_at timestamptz NOT NULL DEFAULT now()
);

INSERT INTO ip_locations (source_ip, approximate_geo)
VALUES
  ('14.1.72.1', ST_SetSRID(ST_MakePoint(144.94, -37.84), 4326));