SQL

Cheatsheet

Bash Convention and Libraries Assembler 80186 and higher HTTP Status Codes Python Cheatsheet - Olivier La Flamme Data Wrangling with pandas Cheat Sheet OWASP Key Management Cheat Sheet Python Cheatsheet SQL Stuff by @yosracodes Security Infographics Kubectl Cheat Sheet for Kubernetes Admins SED Oneliners Boll PaloAlto THC’s favourite Tips, Tricks & Hacks (Cheat Sheet) Bash scripting cheatsheet Serious Shell Programming Vim cheatsheet MySQL cheatsheet FortiOS 6.2 FortiAnalyzer PHPStorm KeyMap sha256: ad72a87fe96318464cfde45c8d92e0d517aae0f1730ac69cc6c39cf09785f9d4

Sqlite

Do you like SQLite ? just started using it a bit more often … https://www.sqlitetutorial.net/ Query sqlite3 /path/to/db “select date,time,ip from table where ip=‘1.2.3.4’ limit 100; .schema show the database schema and indexes sqlite> .schema CREATE TABLE attack( "date" TEXT, "time" TEXT, "ip" TEXT, "asnr" TEXT, "ascountry" TEXT, "asdesc" TEXT, "port" TEXT, "proto" TEXT, "server" TEXT, "type" TEXT, "method" TEXT, "pass" TEXT, "user" TEXT, "ver" TEXT ); CREATE UNIQUE INDEX id on attack(date,time,ip,user,pass); Insert INSERT INTO table (column1,column2 ,.