Database Archives

Bash

Redis CLI Reference

Connection & Info Key Operations String Operations The atomic unit. Max 512 MB per value. Hash Operations The natural fit for structured objects. More memory-efficient than a JSON string when fields are accessed individually. List Operations Backed by a doubly-linked list (or listpack for small sizes). Set Operations Unordered collection Read more…

By Tito, 8 months23 October 2025 ago

Bash

MySql

Connection and basic operations Create user Grant privileges Execute script from file

By Tito, 4 years11 March 2022 ago

Bash

Robo 3t – Small font – Linux

In some cases the program Robo3t, the useful user interface for Mongo DB, it displays by default really small fonts that make it almost useless. In my case I fix it creating a bash script (in the robo3t root installation folder) that launch the following command. In this case I Read more…

By Tito, 5 years4 May 2021 ago

Bash

Mongo DB

Here some useful commands Add rows into a collection Export a collection Find/Count occurrences that match a size Update many Get, manipulate and replace

By Tito, 5 years24 March 2021 ago

Database

SQL server

Select query for production (nolock) Table lock simulation Backup Command line database backup using SqlCmd tool (localhost database) Restore Command line database restore using SqlCmd tool (localhost database) Link tablespace to filegroup Get active connection Try catch block Ram by database Ram by tables Shrink database Table count and dimensions Read more…

By Tito, 5 years18 March 2021 ago

Database

Postgres

Clone a database with an existing local one Connect to the database with a user with proper right and make sure that the sourcedb does not have opened connection. Database dump Database restore Get table fields Try catch block

By Tito, 5 years18 March 2021 ago

Database

Welcome to 644 blog