Skip to content

Instantly share code, notes, and snippets.

View richin13's full-sized avatar
:shipit:
@ the terminal

Ricardo Madriz richin13

:shipit:
@ the terminal
View GitHub Profile

Writing Style Prompt

  • Focus on clarity: Make your message really easy to understand.
    • Example: "Please send the file by Monday."
  • Be direct and concise: Get to the point; remove unnecessary words.
    • Example: "We should meet tomorrow."
  • Use simple language: Write plainly with short sentences.
    • Example: "I need help with this issue."
  • Stay away from fluff: Avoid unnecessary adjectives and adverbs.
  • Example: "We finished the task."
-- Basic Selection
SELECT data FROM artifacts; -- Whole JSONB object
SELECT data->>'name' FROM artifacts; -- Get string value (->>')
SELECT data->'details' FROM artifacts; -- Get JSON value (->)
-- Checking for existence/values
SELECT * FROM artifacts WHERE data ? 'name'; -- Has key 'name'?
SELECT * FROM artifacts WHERE data @> '{"type": "weapon"}'; -- Contains this JSON?
SELECT * FROM artifacts WHERE data->>'status' = 'active'; -- Exact value match
@richin13
richin13 / change-mac.bash
Created November 7, 2023 23:43
Useful bash scripts compiled during my ethical hacking learning journey
#!/usr/bin/env bash
# Change the MAC address of a given interface.
# Usage: sudo ./change-mac.bash <interface name> [<new mac address>]
# Example: sudo ./change-mac.bash wlan0 11:99:22:88:33:77
# Author: @richin13
if [ "$#" -lt 1 ]; then
echo "Usage: $0 <interface name> [mac address]"
exit 1
fi
@richin13
richin13 / feriados-cr.csv
Created August 31, 2022 01:20
Feriados Costa Rica 2022-2024
Date Holiday Name
2022-01-01 Año Nuevo
2022-04-11 Batalla de Rivas
2022-04-14 Jueves Santo
2022-04-15 Viernes Santo
2022-05-01 Día del Trabajador
2022-07-25 Anexión del Partido de Nicoya
2022-08-02 Día de la Virgen de los Ángeles
2022-08-15 Día de la Madre
2022-09-04 Día de la Persona Negra y la Cultura Afro-Costarricense
@richin13
richin13 / administrative-divisions-cr-2018.json
Created February 5, 2018 16:43
JSON-formatted administrative divisions of Costa Rica updated to 2018
{
"San José": {
"San José": [
"San José",
"Merced",
"Hospital",
"Catedral",
"Zapote",
"San Francisco de Dos Ríos",
"Uruca",
@richin13
richin13 / PostgresSetupArchLinux.md
Last active May 17, 2017 16:27
Simple steps to have a new user with a database in PostgreSQL/ArchLinux

PostgreSQL setup in ArchLinux

Login as postgres user

$ sudo -u postgres -i

Create PostgreSQL user with login, password and permissions to create new databases

accinfo.php?cartId=
acclogin.php?cartID=
add.php?bookid=
add_cart.php?num=
addcart.php?
addItem.php
add-to-cart.php?ID=
addToCart.php?idProduct=
addtomylist.php?ProdId=
adminEditProductFields.php?intProdID=