SQLite or PostgreSQL? It's Complicated

Re:SQLite or PostgreSQL? It's Complicated by sixbrx on Wednesday June 29, 2022 @08:53AM (#31919460)

Another cool thing is you can initialize the Postgres db when it starts the container with your own SQL (or sh) scripts to create your schemas, tables, views etc by just copying the scripts into /docker-entrypoint-initdb.d/.

Like:

FROM postgres:14.3

COPY pg/pg-config.sql /docker-entrypoint-initdb.d/000-pg-config.sql

COPY pg/schemas.sql /docker-entrypoint-initdb.d/010-schemas.sql

COPY pg/meddra-tables.sql /docker-entrypoint-initdb.d/020-meddra-tables.sql

# ...

RUN chmod a+r /docker-entrypoint-initdb.d/*

ENV POSTGRES_USER=myapp

ENV POSTGRES_PASSWORD=xxx

ENV POSTGRES_DB=mydb

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by physicsguy on Wednesday June 29, 2022 @09:57AM (#31920150)

I tend to do things like (after launching container):

docker exec postgres psql -h localhost -p 5432 -U ${DBADMINUSER} -c "some SQL statement"

[ Parent | on HN ]