Skip to content

Instantly share code, notes, and snippets.

@leefordjudes
leefordjudes / pgsql-json-convert-case.txt
Created August 11, 2025 05:52
pgsql json convert case using pg heck
Dockerfile
--------------
COPY pg_heck-v0.1.deb ./pg_heck.deb
RUN dpkg -i /pg_heck.deb
within postgres database, use below command:
--------------------------------------------
create schema heck;
create extension pg_heck with schema heck;
@leefordjudes
leefordjudes / erp-client-updater.json
Last active August 6, 2025 07:11
erp client updater for tauri wrapper application for auditplus ui
{
"version": "v0.1.0",
"notes": "Initial Version",
"pub_date": "2025-08-06T05:11:00Z",
"platforms": {
"linux-x86_64": {
"signature": "dW50cnVzdGVkIGNvbW1lbnQ6IHNpZ25hdHVyZSBmcm9tIHRhdXJpIHNlY3JldCBrZXkKUlVRVmdlK2x2cjk2OXJlbFVadnVkWlRpbm5tcFNyekFGUkxtUy82VnNZV25sOURYeG1qTXJCQmFlWGsvVUpwSTdSdU5kZ3VEcXBiQjZlNkdCQ2xLK0VDbGZ5S0NDeXdyK0FZPQp0cnVzdGVkIGNvbW1lbnQ6IHRpbWVzdGFtcDoxNzU0NDY0MTE1CWZpbGU6QXVkaXRwbHVzRVJQQ2xpZW50XzAuMS4wX3g2NC1zZXR1cC5leGUKa051VEwyUGFaNXExckl0cXRva3huUCtUTWx0VnhJQzhSNll1WU5FUUUxeWdieEw4aC9yUGI4c0ZwMmZTRlR6VWxtTUtGYk01WVNrSnJFZ3h6Sk1hQ3c9PQo=",
"url": "https://auditplus-desktop-releases.s3.ap-south-1.amazonaws.com/AuditplusERPClient_0.1.0_x64-setup.bin"
},
"windows-x86_64": {
@leefordjudes
leefordjudes / multiple_postgres_instance
Created May 12, 2025 09:48 — forked from ramauditplus/parallel_postgres_instance
Creating a new parallel instance of postgres server locally.
"C:\PostgreSQL\15\bin\initdb.exe" -D "C:\pgdata1"
C:\pgdata1\postgresql.conf → port = 5433
edit pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all scram-sha-256
# IPv4 local connections:
@leefordjudes
leefordjudes / desktop-pos-0.1.8.txt
Created April 30, 2025 11:03
desktop pos 0.1.8
tiny url
https://tinyurl.com/aplus-pos
dropbox:
https://www.dropbox.com/scl/fi/irff5xacokuue81w6dfc9/POS-0.1.8.msi?rlkey=85nn31ownr60tdyps5mp677sf&st=kgyuvoh6&dl=0
@leefordjudes
leefordjudes / BalsamiqForever.py
Created April 11, 2025 15:31 — forked from HoussemNasri/BalsamiqForever.py
Extend your trial period for Balsamiq Wireframes on Windows and macOS Forever!
import json
import os
import time
import webbrowser
import sys
import re
def handleWindows(extra_seconds):
print("OS : Windows")
@leefordjudes
leefordjudes / multiple-git-account.txt
Created February 17, 2025 17:25
mutltiple git account
You can use multiple GitHub accounts on the same computer by using SSH keys and configuring your SSH agent. Here's a general outline of the steps involved:  
Generate SSH Keys for Each Account
Open your terminal and navigate to your .ssh directory (usually ~/.ssh).
Use the ssh-keygen command to generate a new SSH key for each GitHub account. Make sure to give each key a unique filename (e.g., id_rsa_personal, id_rsa_work).
Create a file named config in your .ssh directory.
@leefordjudes
leefordjudes / android-app-bundle.txt
Created February 16, 2025 16:20
create android app bundle in flutter project
step 1: create key signed keystore file
----------------------------------------
PS C:\WF\project> keytool -genkeypair -v -keystore project-name-key.keystore -keypass keypassword -storepass storepassword -keyalg RSA -keysize 2048 -validity 10000 -alias projectalias
What is your first and last name?
[project or org name]:
What is the name of your organizational unit?
[development]: development
What is the name of your organization?
[org name]:
@leefordjudes
leefordjudes / youtube-video-download-using-ytd.txt
Last active March 30, 2025 11:15
youtube video download using ytd
To download youtube video locally,
1.first instll get-cookiestxt-locally extension to your chrome browser
https://chromewebstore.google.com/detail/get-cookiestxt-locally/cclelndahbckbenkjhflpdbgdldlbecc
and install ffmpeg using the command
choco install ffmpeg-full
or
use custom build by ytd and add path
https://github.com/yt-dlp/FFmpeg-Builds/releases
@leefordjudes
leefordjudes / rustdesk-setup.txt
Created January 27, 2025 03:53
rustdesk setup
create folder
rustdesk
under rustdesk, create two folder
hbbr
hbbs
from the same path, create docker-compose.yml
----------------------------------------------
services:
@leefordjudes
leefordjudes / auditplus-ui-fix-1.22.txt
Last active November 30, 2024 10:13
auditplus ui fix
https://auditplus-desktop-releases.s3.ap-south-1.amazonaws.com/auditplus_ui-fix-1.22.0%2B1-windows-setup.exe