October 30, 2016

Best BI Software

JasperSoft Pentaho Watson Analytics *** Very Poor (even cancelled the trial) *** Microsoft Power BI AWS Quick Sight *** Still on Trial *** DELL – Boomi *** […]
October 20, 2016

Mautic: Clear Cache from Application

root@ubuntu:~# php /var/www/mautic/app/console cache:clear Note that after clearing Cache the App is Stuck because there is a Permissions problem (Mautic cannot write the Cache Folder) so […]
October 10, 2016

Ubuntu: Server Size

ncdu /  
October 10, 2016

PostgreSQL: Table Sizes

SELECT *, pg_size_pretty(total_bytes) AS total , pg_size_pretty(index_bytes) AS INDEX , pg_size_pretty(toast_bytes) AS toast , pg_size_pretty(table_bytes) AS TABLE FROM ( SELECT *, total_bytes-index_bytes-COALESCE(toast_bytes,0) AS table_bytes FROM ( […]
October 4, 2016

Import CSV to DB

http://stackoverflow.com/questions/11448307/importing-csv-data-using-php-mysql
October 4, 2016

MySQL: Enable Logging

mysql> show variables like '%log%'; Recreate the log files I deleted by mistake. It appears the MySQL does not recreate them automatically. touch /var/log/mysql.log chown mysql:adm […]