Linux: How to configure logrotate: A mongodb example
Log files can quickly become very large and take up a lot of disk space. This can cause performance issues and can even lead to system……
$ grep -rn "#Databases" ./posts
csvkit: query csv files using SQL from the command line
csv is the most common file format that you will use when you deal with data; all major spreadsheets like Excel or Libre Office Calc……
SQL: inner, left and self join examples
Learn how to work with SQL joins to create amazing reports…
sqlite3 : How to import csv files to tables from bash
Recently i had a situation where a report needs data from two different databases that do not communicate each other in other to join……
Python: SQLite tutorial
What is SQLite?…
How to import a csv file to influxdb
Recently i needed a way to import csv file to influxdb, of course there was always the option to create something custom, but this would……
influxdb: How To Compact your Database files
If your series are created or deleted very often it might be necessary to compact the series files in order to reduce their size on disk……