I"m a big fan of a table / table_history combo. Meaning, if you have a
person and that person can have different states that change frequently,
you can do something like this:
create table people(
person_id
person_name
)
create table people_state_history(
person_id references people,
effective t
You can use the postgis extension:
create extension postgis;
Then you can create a geography coulmn
location geography( point, 4326)
and insert a lat /long as a point like this:
ST_GeographyFromText('SRID=4326;POINT(%(longitude)s %(latitude)s)'),
On Tue, Oct 8, 2019 at 1:30 PM Andreas Kret
