Energy Access Explorer Database

This is the SQL (PostgreSQL) code for the platform's database.

Naturally, PostgreSQL must be installed and running before starting.

Dependencies

The following must also be installed on the system:

PostgreSQL (+PostgREST) handle authentication and permissions via JWT using pgjwt
UUID's and other checksums are generated via pgcrypto. Which is generally installed with any PostgreSQL server

You should configure the first lines of the makefile to your needs.

If everythingis set up properly, you chould be able to run

$ bmake dbcreate dbbuild

Name		Name	Last commit message	Last commit date
Latest commit History 110 Commits
.gitignore		.gitignore
LICENSE		LICENSE
README.md		README.md
categories-rls.sql		categories-rls.sql
categories.sql		categories.sql
database.mk		database.mk
datasets-rls.sql		datasets-rls.sql
datasets.sql		datasets.sql
db.sql		db.sql
follows-rls.sql		follows-rls.sql
follows.sql		follows.sql
geographies-rls.sql		geographies-rls.sql
geographies.sql		geographies.sql
makefile		makefile
sessions-rls.sql		sessions-rls.sql
sessions.sql		sessions.sql
snapshots-rls.sql		snapshots-rls.sql
snapshots.sql		snapshots.sql
sql-files.txt		sql-files.txt
tablegrants.sql		tablegrants.sql