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

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay