h4ckm03d

------------------
-- Rules
------------------
select *
from rules
where rule_name in (
    'Early_Bird_7.7_3Jul_6Jul24'
);
----------------
INSERT INTO public.rules (

h4ckm03d

from employees
filter start_date > @2021-01-01

h4ckm03d

aws --profile localstack s3 mb s3://wht-pdf-bucket aws --profile localstack sqs create-queue --queue-name whtPdfQueue aws --profile localstack sqs get-queue-attributes --queue-url http://sqs.ap-southeast-1.localhost.localstack.cloud:4566/000000000000/whtPdfQueue --attribute-names QueueArn aws --profile localstack lambda create-event-source-mapping --function-name wht-cert-generator-local-main --batch-size 10 --event-source-arn arn:aws:sqs:ap-southeast-1:000000000000:whtPdfQueue

aws --profile localstack sqs send-message --queue-url http://sqs.ap-southeast-1.localhost.localstack.cloud:4566/000000000000/whtPdfQueue --message-body "Hello, Gwen!"

h4ckm03d

Zeals
- STAR
- Prepare 3 questions

- q: Why do you want to work for X company?
  s:
  t:
  a:
  r:
- q: Why do you want to leave your current/last company?

h4ckm03d

CREATE TABLE
  transactions (
    id BIGSERIAL NOT NULL,
    datetime TIMESTAMPTZ NOT NULL,
    amount numeric(6, 2) NOT NULL,
    PRIMARY KEY(wallet, datetime)
  );

SELECT

h4ckm03d

-> Graceful shutdown qore console

Background

Qore console is doing everything related to deployment and long process tasks in the background. The problem is when qore console still doing something in the background then the pods service got a termination signal or SIGTERM, it should wait for processing till done. Currently, it will shut down immediately after getting SIGTERM

Proposal

Add graceful shutdown to prevent immediate pod termination if any long process still occurs. List waiting process:

• Clone the environment before applying deploy
• Migration to a new environment
• To be added more if any long process that must include.

h4ckm03d

• get latest release log issue

test migrate qore apps
import { deployApps } from "../../src/app/infra/app_migrator";

describe("migrate", () => {
    test("returns ok", async () => {
 try {

h4ckm03d

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

h4ckm03d

RFC Template

Feature Name: (fill me in with a unique identity, myawesomefeature)

Type: (feature, enhancement)

Start Date: (fill me in with today's date, YYYY-MM-DD)

Author: (your names)

h4ckm03d

Unit Testing + Benchmark + CLI Apps

Unit test

• https://lumochift.org/posts/golang-unit-test/
• https://lumochift.org/posts/tips-trik-unit-test-golang/
• https://quii.gitbook.io/learn-go-with-tests/

Benchmark