This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Producer messages | |
kafka-console-producer --topic <name_topic> --bootstrap-server <host>:<port> | |
# Consumer messages | |
kafka-console-consumer --topic <name_topic> --bootstrap-server <host>:<port> | |
# -> --group <name_group> | |
# List consumers groups | |
kafka-consumer-groups --list --bootstrap-server <host>:<port> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- recupera a chave -> | |
-- recupera o texto da chave ->> | |
-- recupera valor dentro do array #> | |
-- indice do array '{0}' | |
-- {"um_campo_array_dentro_do_json": [{"chave_dentro_do_array": 1}]} | |
coluna_json -> 'um_campo_array_dentro_do_json' #> '{0}' -> 'chave_dentro_do_array' | |
-- {"object_dentro_json": {"chave_dentro_object": 1}} | |
coluna_json -> 'object_dentro_json' ->> 'chave_dentro_object' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
## Backend em REST e Graphql | |
backend | |
*** Pasta types para guardar novas tipagens do TypeScript *** | |
|__ @types | |
*** Adicionar nova tipagem para a lib do express na request *** | |
|__ express.d.ts | |
*** Pasta de configuração de serviços *** | |
|__ config | |
*** Arquivo de configuração para a autenticação *** | |
|__ auth.ts |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Docker 23 + Traefik v2.9.10 and v1.7 + Let's Encrypt + Github Registry V2 ghcr.io + Updated on 12 April 2023 | |
Content: | |
- Ubuntu 22.04 | |
- Docker Engine 23.0.3 | |
- Docker Compose 2.17.2 | |
- Traefik v1.7.18 with dnsChallenge | |
- Traefik v2.9.9 with httpChallenge | |
-- | |
- Github Registry V2 ghcr.io |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Para saber o tamanho de todas as bases de dados: | |
SELECT pg_database.datname, pg_size_pretty(pg_database_size(pg_database.datname)) AS size FROM pg_database; |