DEV Community

Tobias Mesquita for Quasar Framework Brasil

Posted on

1 2

QPANC - Parte 2 - PostgreSQL

QPANC são as iniciais de Quasar PostgreSQL ASP NET Core.

5 PostgreSQL

O nosso próximo passo, é criar uma adicionar uma instancia do PostgreSQL ao nosso container (docker), para tal, iremos editar o arquivo docker-compose.yml

version: '3.4'

services:
  qpanc.api:
    image: ${DOCKER_REGISTRY-}qpancapi
    build:
      context: .
      dockerfile: QPANC.Api/Dockerfile
    networks:
      - qpanc.network

  qpanc.database:
    image: postgres:latest
    ports:
      - "34514:5432"
    restart: always
    networks:
      - qpanc.network

networks:
  qpanc.network:

então edite o docker-compose.override.yml, adicionando as demais propriedades

services:
  qpanc.api:
    environment:
      - ASPNETCORE_ENVIRONMENT=Development
      - ASPNETCORE_URLS=https://+:443;http://+:80
    ports:
      - "34512:80"
      - "34513:443"
    volumes:
      - ${APPDATA}/Microsoft/UserSecrets:/root/.microsoft/usersecrets:ro
      - ${APPDATA}/ASP.NET/Https:/root/.aspnet/https:ro

  qpanc.database:
    volumes:
      - ./database:/var/lib/postgresql/database
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=keepitsupersecret
      - POSTGRES_DB=postgres

Agora, para testar se o banco de dados está acessível, iremos iniciar a aplicação para que o container seja configurado, então poderemos utilizar o Azure Data Tools para que possamos conectar no PostgreSQL.

Porém, antes de continuamos, verifique se a extensão PostgreSQL está instalada.

PostgreSQL Extension

Então, adicione uma conexão para o PostgreSQL

PostgreSQL Connection
PostgreSQL Connection
PostgreSQL Port

Feito isto, você estará conectado ao PostgreSQL, e poderá executar queries

PostgreSQL Query

Top comments (2)

Collapse
 
franfrlor profile image
franfrLor

Hello,

How can we set up a SQL Server database (localDB) with docker in Visual Studio?

Thank you

Collapse
 
tobymosque profile image
Tobias Mesquita

u'll not be able to use the localDB, but u can use other editions, like Express or Developer ones
hub.docker.com/_/microsoft-mssql-s...

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay