SQL

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 ,.