Skip to content

Instantly share code, notes, and snippets.

@niquola

niquola/jsonb-master-class.md

Last active April 28, 2023 14:27
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save niquola/bcc90d57425b2a6c3324ea38ad6bc5b0 to your computer and use it in GitHub Desktop.
Save niquola/bcc90d57425b2a6c3324ea38ad6bc5b0 to your computer and use it in GitHub Desktop.
Download ZIP
JSONB master class
Raw
jsonb-master-class.md

Prerequisites

Install docker & docker-compose

Pull postgres image

docker pull aidbox/db:11.1.0-3-g7a1dab6

Install psql or any sql terminal\editor

sudo apt-get install -y postgresql-client depend on your OS
# or
brew install postgresql@11

https://www.pgadmin.org/ https://dbeaver.io/

Clone https://github.com/fhirbase/master-class repository

Run

git clone https://github.com/fhirbase/master-class
cd master-class
source .env
docker-compose up -d

Test connection to database

source .env
psql

Load test data set:

curl https://storage.googleapis.com/aidbox-public/masterclass_dataset.sql.tar.gz | gunzip | psql

If not docker - install PostgreSQL 11 & jsquery on your laptop.

Any questions @ https://t.me/joinchat/CePjzxT-RKX0SzuNUTzVag

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment