isDipesh

#!/bin/bash

set -e

echo "📦 Installing recommended Devanagari fonts..."
sudo pacman -S --needed noto-fonts noto-fonts-cjk noto-fonts-extra --noconfirm

echo "🛠 Creating Fontconfig override for Hindi and Nepali..."
mkdir -p ~/.config/fontconfig

isDipesh

sudo tee /usr/share/applications/google-chrome.desktop > /dev/null << 'EOF'
[Desktop Entry]
Version=1.0
Name=Google Chrome
GenericName=Web Browser
Comment=Access the Internet
StartupWMClass=Google-chrome
Exec=/usr/bin/google-chrome-stable  --ozone-platform=x11 %U
StartupNotify=true
Terminal=false

isDipesh

# If postgis is used
yay -S postgis-old-upgrade
sudo su
systemctl stop postgresql
mv /var/lib/postgres/data /var/lib/postgres/olddata
mkdir /var/lib/postgres/data /var/lib/postgres/tmp
chown postgres:postgres /var/lib/postgres/data /var/lib/postgres/tmp
sudo su postgres
cd /var/lib/postgres/tmp
# Use --no-data-checksums if pg was initialized without page checksums

isDipesh

import type { H3Event } from 'h3'
import { count } from 'drizzle-orm'

const DEFAULT_PAGE_SIZE = 20
const MAX_PAGE_SIZE = 200

type PaginateableQuery<TQuery> = {
  limit: (limit: number | undefined) => PaginateableQuery<TQuery>
  offset: (offset: number | undefined) => PaginateableQuery<TQuery>
  orderBy: (orderBy: string) => PaginateableQuery<TQuery>

isDipesh

import { count } from 'drizzle-orm'

const DEFAULT_PAGE_SIZE = 20
const MAX_PAGE_SIZE = 200

type PaginateableQuery<TQuery> = {
  limit: (limit: number | undefined) => PaginateableQuery<TQuery>
  offset: (offset: number | undefined) => PaginateableQuery<TQuery>
  orderBy: (orderBy: string) => PaginateableQuery<TQuery>
}

isDipesh

Importing SQLite to Cloudflare D1

Dump SQLite to Sql

sqlite3 -escape off server/db/db.sqlite .dump > db.sql

Escape off prevents unistr in newer versions of sqlite, which D1 does not support.

Cleanup SQL Dump

• Remove BEGIN TRANSACTION; and COMMIT; from the file