Database Archives

MySql

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

By Tito, 3 years11 March 2022 ago

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, 4 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, 4 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, 4 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, 4 years18 March 2021 ago

Database

Welcome to 644 blog