Linux, WebDev and other…


Convert single mysql insert statements to one statement with multiple VALUES lists

I needed to convert multiple mysql insert statements to statements with multiple VALUE lists to insert several rows at a time. I have not found any tool for that, so I wrote this script in Python. Thankfully I found a non-validating SQL parser module for Python, so this task became very easy. You must install […]


Google Maps – handling huge amount of markers

Problem We have a huge amount of markers and we want to display it to user using google maps. ┬áSolution use ajax requests to fetch markers only for area visible by user display message “please zoom in”, if we have too many markers (let’s say that limit is 500) use MarkerClustererPlus to display fetched markers […]

, , ,

Mysql Workbench is unstable on Ubuntu 12.04 LTS

Problem I use elementary OS, which is based on ubuntu 12.04 LTS. Mysql Workbench from default repository (mysql-workbench_5.2.38+dfsg-3_amd64.deb) is very unstable. If you try to open model and then create a new one, it will crash with:

Related bug report is here.

, , ,

MySQL backup bash script

Simple script for cron jobs. It makes backup of all available mysql databases except for IgnoredDatabases array. Dump is compressed on the fly. Backups older than 30 days are deleted.

, , ,