Cyrille Giquello - informatique:sgbd

duckdb

anonymous@undisclosed.example.com (Anonymous) — Fri, 18 Nov 2022 16:32:39 +0000

DuckDB Tips Auto increment * CREATE SEQUENCE seq_persons_id START 1; CREATE TABLE persons ( id integer primary key default nextval('seq_persons_id'), name varchar(255) not null, );

mariadb

anonymous@undisclosed.example.com (Anonymous) — Tue, 07 Jun 2022 08:28:55 +0000

MariaDB => MySQL Tips Change root password sudo systemctl stop mariadb.service sudo mysqld_safe --skip-grant-tables mysql -u root # Important to avoid without grant table error ! MariaDB [(none)]> FLUSH PRIVILEGES; ALTER USER 'root'@'localhost' identified by 'secret' ;

mysql

anonymous@undisclosed.example.com (Anonymous) — Mon, 31 Oct 2022 17:37:15 +0000

MySQL * mariadb * sql Books High Performance MySQL Optimization, Backups, Replication, and More (Paperback) Tools Myterm Myterm: Extensible mysql command line client with pipe chaining “Tail -f table with myterm” Ever found yourself running the same query over and over again to see if a table has got new content, just waiting for that magic row to appear? The tail command will watch for new lines in a table, just like you might tail a log file in Linux.

redis

anonymous@undisclosed.example.com (Anonymous) — Sat, 18 Oct 2025 08:13:26 +0000

Redis * How fast is Redis? (doc latest) * Looking at Redis (2009) Alternatives: * Valkey * Le fork de Redis. Ils disent qu'il est plus performant. 😉 Tools *