Skip to content

Instantly share code, notes, and snippets.

View lukaszhanusik's full-sized avatar
✨👁️🖤👁️✨ ⚡️

Lukasz Hanusik lukaszhanusik

✨👁️🖤👁️✨ ⚡️
View GitHub Profile
How To Power Up SFDX-CLI with VS Code Remote - SSH, Windows Edition
by Vernon Keenan
from SalesforceDevops.net
Youtube: https://youtu.be/vdwM2WOUBuk
Change these values for your environment:
devops = DNS hostname of remote SSH server
vern = Linux username on remote server
@lukaszhanusik
lukaszhanusik / customers-and-loans.sql
Created May 10, 2024 21:58 — forked from Bilbottom/customers-and-loans.sql
Mermaid + DuckDB for generating customer hierarchy diagrams
/*
Mermaid + DuckDB for generating customer hierarchy diagrams
DuckDB version: 0.10.2
Bill Wallis, 2024-05-09
*/
select version();
@lukaszhanusik
lukaszhanusik / er-diagram.mermaid
Created May 10, 2024 21:57 — forked from Bilbottom/er-diagram.mermaid
Mermaid + DuckDB for generating entity-relationship diagrams
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@lukaszhanusik
lukaszhanusik / nerd_fonts.sh
Created January 1, 2023 14:12 — forked from davidteren/nerd_fonts.md
Install Nerd Fonts via Homebrew [updated & fixed]
# Nerd Fonts for your IDE
# https://www.nerdfonts.com/font-downloads
brew tap homebrew/cask-fonts && brew install --cask font-3270-nerd-font
brew tap homebrew/cask-fonts && brew install --cask font-fira-mono-nerd-font
brew tap homebrew/cask-fonts && brew install --cask font-inconsolata-go-nerd-font
brew tap homebrew/cask-fonts && brew install --cask font-inconsolata-lgc-nerd-font
brew tap homebrew/cask-fonts && brew install --cask font-inconsolata-nerd-font
brew tap homebrew/cask-fonts && brew install --cask font-monofur-nerd-font
brew tap homebrew/cask-fonts && brew install --cask font-overpass-nerd-font

Octo Notebook

  • Works with Gist
DELETE ME - Must create a new gist with an initial file
obsidian://advanced-uri?vault=obsidian-docs-vault&filepath=MANIFEST.mdobsidian://advanced-uri?vault=obsidian-docs-vault&filepath=MANIFEST.md
title tags
Generating fake data using SQL
data fake db postgres sql

Fake data are very useful in development environment for testing your application or some query performances for example. In this Blog Post I’ll share how I created a simple SQL script for PostgreSQL 🐘 to generate some fake data. Enjoy!

Intro

I started this idea when I was testing some query changes and performance improvements on a PostgreSQL database. On the very first attempt my query failed miserably because the data that I had was not enough, and creating all the data with relations was so time consuming. I’ve done some research and finally I got some amazing scripts.

title tags
Querying Postgres Tables Directly From DuckDB
data analytics postgres duckdb mds olap

TLDR: DuckDB can now directly query queries stored in PostgreSQL and speed up complex analytical queries without duplicating data.

@lukaszhanusik
lukaszhanusik / content.md
Created September 12, 2022 18:17
Gist from Drafts

Gather is a command line tool that’s simple to run from the Terminal once you’ve set it up. For example, a command like

gather https://www.macstories.net/news/next-gen-airpods-pro-the-macstories-overview/ -c