Sign inSign up

nimblex/memfiredb

By nimblex

•Updated over 2 years ago

A PostgreSQL-based database, with popular extensions like pgvector postgis age timescaledb

Image
2

2.0K

nimblex/memfiredb repository overview

A PostgreSQL-based database, with popular extensions like pgvector postgis age timescaledb

psql (15.5 (Ubuntu 15.5-1.pgdg20.04+1), server 15.1 (Ubuntu 15.1-1.pgdg20.04+1))
Type "help" for help.

postgres=# \dx
                                            List of installed extensions
        Name        | Version |   Schema   |                              Description
--------------------+---------+------------+------------------------------------------------------------------------
 age                | 1.5.0   | ag_catalog | AGE database extension
 pg_graphql         | 1.5.0   | graphql    | pg_graphql: GraphQL support
 pg_stat_statements | 1.10    | extensions | track planning and execution statistics of all SQL statements executed
 pgcrypto           | 1.3     | extensions | cryptographic functions
 pgjwt              | 0.2.0   | extensions | JSON Web Token API for Postgresql
 pgsodium           | 3.1.8   | pgsodium   | Pgsodium is a modern cryptography library for Postgres.
 plpgsql            | 1.0     | pg_catalog | PL/pgSQL procedural language
 postgis            | 3.3.2   | public     | PostGIS geometry and geography spatial types and functions
 supabase_vault     | 0.2.8   | vault      | Supabase Vault Extension
 timescaledb        | 2.9.1   | public     | Enables scalable inserts and complex queries for time-series data
 uuid-ossp          | 1.1     | extensions | generate universally unique identifiers (UUIDs)
 vector             | 0.6.0   | public     | vector data type and ivfflat and hnsw access methods
(12 rows)

⁠usage

docker run --name memfiredb -p 5432:5432 -e POSTGRES_PASSWORD=memfiredb -d nimblex/memfiredb

Default user/password: postgres/postgres,env POSTGRES_PASSWORD can be used to change the default password.

⁠extensions: age

https://github.com/apache/age⁠

CREATE EXTENSION age;
LOAD 'age';
SET search_path = ag_catalog, "$user", public;
⁠extensions: pgvector
create extension vector;
⁠extensions: postgis

https://github.com/postgis/postgis⁠

create extension postgis;

Tag summary

Content type

Image

Digest

sha256:66ad3ef95…

Size

517.7 MB

Last updated

over 2 years ago

docker pull nimblex/memfiredb