Multiple test databases in Bitbucket Pipelines
Reading Time: 2 minutes If you have to use unlimited multiple databases on Bitbucket Pipelines for your testing, you have to be creative. Here’s how I solved it. Read More …
Tag: MySQL
Use HeidiSQL with your vagrant box
Reading Time: < 1 minute I already discussed how to use HeidiSQL with a remote server in a former post. I now switched to use a local Vagrant VM instead of a remote VM. Of course I still wanted to Read More …
Display content of blob column as plain text
Reading Time: < 1 minute Sometimes it can be useful to have the content of MySQL blob columns displayed as plain text. There’s a pretty easy way to do this: [sql]SELECT CONVERT(my_blob_column USING utf8) AS plain_text_from_blob FROM my_table; [/sql] Yes, Read More …
Helpful MySQL shell tricks
Reading Time: < 1 minute Although I’m Windows user most of the time, I have to take care of some projects on Linux boxes, so it’s good to have at least a little knowledge of what you’re doing there. The Read More …
Neor Profile SQL
Reading Time: < 1 minute Recently I discovered a free and easy to use SQL Profiler for Windows, Mac and Linux: www.profilesql.com It works as proxy between the Application and MySQL itself, so basically all you need to do is Read More …
