mysql

[RELEASE] Bootstrap CRUD Generator

  • Posted on: 30 March 2016
  • By: davis

Go to the CRUD Generator

I'm pleased to announce that I've developed a Bootstrap CRUD application generator. Tired of manually building forms for basic SQL events? Use my tool to generate CRUD pages for your tables.

A painless way to create PHP/MySQL/Bootstrap CRUD apps

Generate a basic Bootstrap-themed CRUD (Create, Read, Update, Delete) application based on your MySQL SELECT, UPDATE, or CREATE query.

[FIX] MySQL Workbench 6.3 CE - SSHException: Incompatible ssh peer (no acceptable kex algorithm)

  • Posted on: 28 March 2016
  • By: davis

If you're getting the following error in MySQL Workbench after upgrading ssh, don't worry, there's a fix.

SSHException: Incompatible ssh peer (no acceptable kex algorithm)
[INF][     SSH tunnel]: TunnelManager.wait_connection authentication error: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details
[ERR][     SSH tunnel]: Authentication error opening SSH tunnel: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details

Download python-ecsda and paramiko

Install them to MySQL\MySQL Workbench 6.3 CE\python\site-packages

Splitting .csv files that exceed Excel's row limit

  • Posted on: 29 May 2015
  • By: davis

Best tool for the job I've found: Open Source CSV File Splitter (OSV)

Very quick and easy to use. Specify lines per chunk file and you're good to go.

Keep in mind many office suites (OpenOffice/LibreOffice) have row limits around 65k (pre 3.3.3: limit is 65,536 rows | 3.3.3 and later: 1,048,576 rows)

In Excel 2010, the maximum worksheet size is 1,048,576 rows.