Category: SHITECODE

SQLite: Find NOT NULL empty records

Posted on 2025-03-172025-03-17 by Jarlath

SQLIte: Table joins

Posted on 2025-03-172025-03-17 by Jarlath

SQLite: Remove duplicate rows

Posted on 2025-03-172025-03-17 by Jarlath

RUST: Delete sqlite records

Posted on 2025-03-172025-03-17 by Jarlath

RUST: Delete postgres records

Posted on 2025-03-172025-03-17 by Jarlath

RUST: Insert postgres record with sqlx

Posted on 2025-03-172025-03-17 by Jarlath

RUST: Insert sqlite record with sqlx

Posted on 2025-03-172025-03-17 by Jarlath

RUST: Insert character to -Nth position

Posted on 2025-03-162025-03-17 by Jarlath

RUST: Reverse a String

Posted on 2025-03-162025-03-18 by Jarlath

RUST: CAS number validation checker

Posted on 2025-03-162025-03-21 by Jarlath

RUST: Format chemIDplus to valid CAS

Posted on 2025-03-162025-03-16 by Jarlath

BASH: Solve file encoding issues

Posted on 2025-03-162025-03-16 by Jarlath

AWK: Swap columns

Posted on 2025-03-152025-03-15 by Jarlath

NGINX: Generate ssl certificate

Posted on 2025-03-152025-03-15 by Jarlath

SQLite: Create database and import data

Posted on 2025-03-142025-03-17 by Jarlath

GREP: GNU grep tutorial

Posted on 2025-03-142025-03-14 by Jarlath

https://www.gnu.org/software/grep/manual/grep.html

AWK: Effective AWK programming

Posted on 2025-03-142025-03-14 by Jarlath

https://www.gnu.org/software/gawk/manual/gawk.html

SED: A stream editor tutorial

Posted on 2025-03-142025-03-14 by Jarlath

htthttps://www.gnu.org/software/sed/manual/sed.html

RUST: Generate a random string

Posted on 2025-03-142025-03-14 by Jarlath

REGEX: Expression builder

Posted on 2025-03-142025-03-14 by Jarlath

https://regex101.com

AWK: Add a primary key column

Posted on 2025-03-142025-03-14 by Jarlath

POSTGRES: Load delimited file into table

Posted on 2025-03-142025-03-14 by Jarlath

POSTGRES: Add or delete columns

Posted on 2025-03-142025-03-14 by Jarlath

POSTGRES: Create a new database

Posted on 2025-03-142025-03-14 by Jarlath

SED: Delete specified lines from input file

Posted on 2025-03-132025-03-14 by Jarlath

RUST: Function with multiple return values

Posted on 2025-03-132025-03-14 by Jarlath

RUST: A half-hour to learn Rust

Posted on 2025-03-132025-03-14 by Jarlath

https://fasterthanli.me/articles/a-half-hour-to-learn-rust

RUST: Web scraping template

Posted on 2025-03-112025-03-14 by Jarlath

RUST: Ownership & Borrowing

Posted on 2025-03-112025-03-30 by Jarlath

PHP: Hide category post in WordPress

Posted on 2025-03-112025-03-14 by Jarlath

BASH: System benchmarking script

Posted on 2025-03-102025-03-14 by Jarlath

BASH: Index directory to HTML file

Posted on 2025-03-102025-03-14 by Jarlath

RUBY: Extract text from pdf

Posted on 2025-03-102025-03-14 by Jarlath

RUBY: Recursive search and replace

Posted on 2025-03-102025-03-14 by Jarlath

RUBY: Delimited data – text file processing

Posted on 2025-03-102025-03-14 by Jarlath

RUBY: Validate chemical identifiers

Posted on 2025-03-102025-03-14 by Jarlath

RUBY: Open file modes

Posted on 2025-03-092025-03-14 by Jarlath

RUBY: Open file, read it, put lines into array

Posted on 2025-03-092025-03-14 by Jarlath

BASH: Rsync between servers

Posted on 2025-03-092025-03-14 by Jarlath

Pull from a remote server: Push to a remote server: