Akhmad Salafudin axmad386

Real Credentials Setup & Integration Testing Guide

Status: Setup required before production deployment
Date: December 31, 2025
Version: 1.0

📋 Table of Contents

Directory Structure

|-- traefik
|---|-- docker.compose.yml
|---|-- domains
|---|---| main.yml
|---|---| foo.myapp.com.yml --> all generated subdomain will be here
|---|-- traefik.yml

Pagination Helper

This is simple helper for dynamic pagination using drizzle-orm using basic limit offset. The result is fully typed.

import { db } from "../yourdbinstance";
import { sql } from "drizzle-orm";
import type { PgSelect } from "drizzle-orm/pg-core";

interface PaginateParam {
  limit: number;
 page: number;

CREATE OR REPLACE FUNCTION reset_all_sequences()
RETURNS VOID AS $$
DECLARE
    table_name_var TEXT;
    column_name TEXT;
BEGIN
    -- Loop through all tables in the database
    FOR table_name_var IN (SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_type = 'BASE TABLE') LOOP
 -- Find the name of the sequence associated with the auto-increment column

List all available wifi, you will see all available wifi with SSID and signal strength

nmcli dev wifi

Connect to wifi:

nmcli dev wifi connect "SSID name" password "wifi password"

public getUrl(location: string): string {
  const {
    endpoint: configEndpoint,
    bucket,
    forcePathStyle,
    region,
  } = this.$config;
  const awsHost = region ? `s3.${region}.amazonaws.com` : "s3.amazonaws.com";
let endpoint = (configEndpoint as string) || `https:${awsHost}`;

Pastikan rust dan dependencynya sudah terinstall

curl --proto '=https' --tlsv1.2 -sSf https://sh.rustup.rs | sh

Jika keluar No package dbus-1 found install package tersebut
```
sudo apt install libdbus-1-dev pkg-config
```
Jika keluar error terkait openssl install package berikut

buat atau copy kode di bawah di file ~/.config/nvim/init.vim

lua require('plugins')

call plug#begin('~/.vim/plugged')

Plug 'preservim/nerdtree'

Plug 'junegunn/limelight.vim'

	server {
	listen 80;
	server_name ~^(?<subdomain>.+)\.domain\.com domain.com;

	# Location block for path that threated as assets
	location ~* ^/(?<asset>image\|css\|js\|fonts\|@vite\|node_modules)/(.*) {
	proxy_pass http://127.0.0.1:3000/$asset/$2;
	proxy_set_header Host $host;
	proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
	proxy_http_version 1.1;

	FROM alpine:edge AS base
	# install node
	RUN apk add --no-cache nodejs npm tini
	# set working directory
	WORKDIR /var/www
	#install pnpm
	RUN npm install -g pnpm
	# Set tini as entrypoint
	ENTRYPOINT ["/sbin/tini", "--"]
	# copy project file