https://github.com/Florents-Tselai/spat
To quickly get a Spat instance up and running, pull and run the latest Docker image:
docker run --name spat -e POSTGRES_PASSWORD=password florents/spat
This will start a Spat instance with default user postgres and password password. You can then connect to the database using psql:
docker exec -it spat psql -U postgres
Then, install the extension.
CREATE EXTENSION spat;
Start using it
SELECT SPSET('key', 'value');
SELECT SPGET('key'); -- value
SELECT LPUSH('list1', 'elem1');
SELECT LPUSH('list1', 'elem2');
SELECT LPOP('list1'); -- elem2
SELECT SADD('set1', 'elem1', 'elem2');
SELECT SISMEMBER('set1', 'elem1'); -- t
SELECT HSET('h1', 'f1', 'Hello');
SELECT HGET('h1', 'f1'); -- Hello
Content type
Image
Digest
sha256:43fc369b5…
Size
175.6 MB
Last updated
over 1 year ago
docker pull florents/spat