Just my blog

Blog about everything, mostly about tech stuff I made. Here is the list of stuff I'm using at my blog. Feel free to ask me about implementations.

My Github My LinkedIn

Soft I recommend

Mobaxterm SSH RDP FTP...
Thunderbird Email client
Filezilla FTP client/server
Nirsoft Win utils
Sysinternals Win utils
Pi-Hole AD block by DNS
NUT UPS manager
Rpi MON Raspberry monitoring
Free CAD 3D modelling
Free Commander Far-like filemanager
Bitwarden Password manager

There are no referral links!

Py lib I recommend

Django web framework
celery multi-tasking
celery-beat Celery + Django
celery-results Celery + Django
Pillow Python image lib
wsgi mod Apache + Python
requests best in WEB requests
openpyxl make Excell docs
p4python Perforce + Python
paramiko SSH + Python
pyvmomi ESXi Vcenter + Python

I'm using these libraries so you can ask me about them.

There are no referral links!

MySQL how to Alter multiple schema tables

To MyISAM from all InnoDB:

SET @DATABASE_NAME = 'db_name';
SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=MyISAM;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'InnoDB'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;

Modified: 2024 April 21 (Sun) 17:35

Alex 2015 March 25 (Wed) 23:22 SQL DB