Three survival tools for an inhospitable (production) environment

As a web developer, you may need to deal with your client’s production environment. Sometimes it’s not the easiest environment to work with, like in a shared hosting or a limited

I already worked with some clients that I wasn’t able to remote connect to the database. Others didn’t allow me to connect to a regular FTP service, all files had to be transferred one by one via a Web FTP.

Over the years I’ve put together some tools to help me with those situations.Other than small snippets and scripts, here are three of the tools that I must used in the last eight years.

Adminer (formerly phpMinAdmin)

Adminer is a single file database management tool written in PHP that can handle MySQL, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB. Useful since most of the free database GUI tools doesn’t offer Tunneling connections.

MySQL BigDump

BigDump allows you to import massive and large MySQL dumps. It works well very limited servers.

phpFileManager

phpFileManager can help you when you don’t have FTP access to the hosting. It’s multi-uploader and compress/extract are very convenient.

Conclusion

I know that the use of such hostings are decreasingly over the years. But we, as developers, must be prepared to such sittuations. I hope my tips here can help you someway.

Modifying my cheap guitar – Part II – The Appearance

Continuing to the first part, I will now tell about how I modified the look of my guitar. I considered doing swirl painting or buying a customized pickguard online, but none of those options got me excited.

The Pickguard

After some time thinking and incubating ideas I started the composition by picking trippy and psychedelic elements, being Alice in Wonderland a huge influence as well as the line “The rabbit is just a monkey in disguise” of the song Organ Grinder by Marilyn Manson.

Unfortunately, visual arts are not part of my skill set. I contacted a friend artist (Daniel de Carvalho) with the ideas and soon he started to present me some sketches. Some months and some drawings later he started to work on the pickguard.

He developed the art using acrylic paint and India ink. Check out more photos of the process and other works on his page, Daniel is a very experienced, talented and passionate professional.

Pickup Selector

While assembling the guitar pickguard with Daniel, we come up with the idea of a mushroom pickup selector. I really liked the concept and resolve to try it out.

I used a recipe of cold porcelain. To my surprise it’s a very cheap and easy to use material, I have some leftover and consider using it on other projects. I regret choosing nail polish for painting, it’s too thin and inconvenient to use.

Discoveries of the Month – November/2016

Wow! My second DotM post!
Turns out that the biggest discovery of this month is that NaNoWriMo is not easy at all. Next year I will prepare myself and try again.
Well, let’s get to the point of the post:

Web Development

Microjs: A selection of small footprint JavaScript micro-libraries and micro-frameworks for all sort of things.

Tech

PythonTutor: Visualize your code in execution, kinda like a debugger. It now has support to Python, Java, JavaScript, TypeScript, Ruby, C, and C++. Fun project and may help you understand how programming languages work.
Detexify: Struggling to find a symbol for LaTeX? Just draw it!

Music

Paranoia: Crossover/Thrash Metal band from the late eighties. They released just one album though.
Hellbenders: Stoner rock band from Goiânia/Brazil.
My Life with the Thrill Kill Kult: Industrial rock band from the late eighties. Been listening to industrial since my teenage years and, strangely, never heard of them before.
Eloy: (German) Progressive Rock band. Underrated in my opinion.
Shackles: Death/Thrash Metal band perfect for headbangin’. It’s a shame they split up.
Electric OctopusPsychedelic/Jazz/Experimental… there is not enough genres to tag these guys.
Brunt: Instrumental stoner rock with a mix of trippy clean tones and heavy fuzz guitars.
Lee Van Cleef: (not to be confused with Lee Van Cleef) Psychedelic acid rock from Italy.
Sasquatch: Another stoner rock band. Great sound and they are really a bastardized version of GFR as they claim. Should be on the regular playlist of any fan of the genre.

YouTube Channels:

The Art of Weapons: An U.K. teenager run this channel since he was around 13 years old. Focused on crossbows and slingshots, but has a lot of DIY information for HDPE plastic, wood lathe and even forging aluminium.
Stoned Meadow of DoomChannel posting albums from underground stoner/sludge/doom bands. Some of the bands presented here I found on the channel.