0%

Anyone who’s spent more than 5 minutes on the MySQL documentation will realise it leaves a lot to be desired. The same goes for many of the 3rd party apps latched onto this platform which offer mediocre functionality and anything beyind the basic comes at a huge premium.

Well here’s a set of 20 resources, tools, articles that hope to break that and bring it all under one roof. Enjoy.

Design & Administration Tools

  • Adminier - A really simple PHPMyAdmin alternative. I find it useful as a basic database administration panel during development of new web-based projects.
  • MyDB Studio - Makes a useful administration app for MySQL and also has some design capabilities such as the SELECT wizard to help with overly complicated queries.
  • HeidiSql - Provides an excellent GUI for administrating you MySQL database and can be used in Linux via WINE.
  • AutoMySQLBackup - Why go to the special effort of producing scripts to backup when you can use this.
  • PHPMyAdmin - Been around for years and still going strong. Its not the most speedy when handling large sets of data (try offline apps such as SQLYog or MyDB) but its got every functionality you can shake a stick at.
  • DBeaver - Similar to HeidiSQL but with better features and works on multiple platforms including Linux.

Security Tools

SQLIer - A SQL injection tool which you provide a URL to and it does all it can to perform SQL injection. You’ll often find this installed by default on security distros like Kali or ParrotOS Security.
SQLMap - A blind SQL injection tool thats a veteran with a plethora of features that makes SQLIer look like a Hello World app in comparison. It provides support for PostgreSQL, MSSQL as well as MySQL. Absolutely essential for people performing pen testing against a server. Will often be installed by default on Kali Linux, Black Arch, ParrotOD, etc.
Absinthe - An application which is available on Linux and Windows. It provides blind MySQL injection brute forcing but with more features than SQLIer.
SQID - SQL Injection Digger was created in Ruby as a command-line tool for brute force SQL injection testing. Can scrape Googl for potential targets as well as using Tor as a means to hide the identity of the attacker. More of a black hat tool than some of the others here.

Optimising MySQL

MySQL Performace Blog - By the masters of high performance MySQL at Percona.
MySQL Percona Toolkit - a ton of tools to help with tweaking your MySQL database for the best performance.
101 Tips on MySQL Perormance - a 2019 blog post with a lot packed into a small space.
Exclusive MySQL Performance Tuning Tips - They just keep on trucking with those optimisation tips.

Knowledge

SQLZoo - The basics of SQL.
10 Essential MySQL Performance Tips - some basic tips on keeping your MySQL database performing at max.
MySQL Cheat Sheet - Provided by devhints.io.
10 Common Mistakes of MySQL Design - Learn what not to do!
MySQL Clustering How-To - Digital Ocean is a great resource for documentation and tutorials. They’ve also startedd making some pretty good in-roads into providing simple cloud hosting.
MySQL Master-to-Master Replication - Another great Digital Ocean tutorial but this time covering master-master replication.
MySQL vs. PostgreSQL - One of many comparisons of the 2 major RDBMS databases.

Books

I guess these could go under knowledge but these you have to buy so they get their own section.

If you think I’ve missed anything off then leave a note in the comments and I’ll make the list grow.

Coursera Logo

This review is coming pretty late since I completed the course last year but having found out its still an option on Coursera, and there’s been a huge proliferation of Google Cloud Platform (GCP) courses since, I wanted people to know how great this one was.

You can get to the course here.

As a “Specialisation” on Coursera that means it is part of multiple courses and Coursera offer a monthly charge for all courses. So there’s an economical reason to finish the courses in good time and not laze about - as the course does allow you lose deadlines.

So I completed all the 4 courses in the 1 month suggested without any deadline extensions receiving distinction in all of them.

Courses

Coursera Logo

As mentioned previously the specialisation contains multiple related courses which - if you wanted - you could complete individually and pick n mix them to your hearts content. But choosing the specialisation path ensures you get a good grounding in the subject offered:

You can get information on the individual courses at Coursera.

Features

Free Qwiklabs access was a huge boon to this course as it allows you free access to the Google Cloud console and services for a limited time to do with as you please giving you teh opportunity to learn practically with the actual tools you would be using.

Every course in the series including the first intro course had some lab or another in Qwiklabs with some offering several. The tasks weren’t massively difficult but for the price and considering it was offered alongside lectures and notes it was a great addition to the course.

Basically the courses had everything you could want: lectures, notes, documentation, forums to ask questions and finally practical lab based work. It actually felt a lot like some of my university courses and if you were dedicated and made use of it all you would get out of it what you put in.

Criticisms

As a web developer by trade I was disappointed that a GCP course with the words “Developing Applications” in the title had absolutely ZERO development. It was all the techniques and technology needed and surrounding development on the Google Cloud platform. I don’t so much as remember even doing a single "Hello World in Node or Python for one of the Qwiklabs. It was a major, major failing of the course and they should probably rename it as the course’s rating of 4.6 is probably due to it lacking the development aspect and its also the reason that since doing that course I’ve been put off doing any Coursera course since.

Yes, its a great course. Yes, you get a ton of content. Yes, I felt happy with what I got. But NO - don’t call a course “Developing Applications” then have zero development in it. It was a real slap in the face and as I came to the end of the course I wanted to ask for my money back but couldn’t see any recourse to get it.

So be warned. If you want to do this course thinking you’ll get the chance to develop a small cloud-based web app. Don’t. You won’t. It tells you about containers, pulling code, pushing it. Moving it around, monitoring it. Everything surrounding development. But no actual development.

One of the things this criticism made me realise is that the cloud is a complex place that involves a lot of work to get programs working. So much so an entire 1 month course split in 4 doesn’t even have any programming in it. Its entirely dedicated to showing you the basics of getting code to the point it’ll work.

Conclusion

I’ve always hated it when reviews end with an indecisive comment aht could be trotted out by anyone about anything. So I aim to do the opposite.
The course was excellent but it wasn’t what I expected. If you’re expecting to program like the title says you won’t be doing. You’ll be doing everything involved in getting programs to work on the cloud.

The cloud isn’t for hte faint of heart. If you want to learn cloud technology I suggest you pick one and get to know it well as they’re all becoming increasingly complex as time goes on.

Gridsome

I’ve recently been getting into Gridsome while looking for a way to create a long planned project to create an
MP Search Service (more info on that soon hopefully with a full tutorial on setting up your Gridsome site from a REST API).

I’ve considered other options such as Hexo and NuxtJS but I was keen to take advantage of Gridsomes claimed ability to hook into multiple content providers and API’s and create a GraphQL data layer to query this data for creating pages.

Obviously when you’re planning a new site you start thinking about the look & feel.
I opted to use the TailwindCSS plugin to create a very utilitarian theme.

But I thought it’d be a good idea to help anyone out there on the look out for ready made themes.
Gridsome isn’t like other static site generators so doesn’t really have a theme library like Hexo but there’s
a number of great starter projects and other options you can use to get a good looking site.

1. Gridsome Starters

Probably the best place to start as this isn’t just themes its a whole site dedicated to finding the right starting project for your site. As mentioned previously Gridsome can be bent to any whim you fancy so it can work from Markdown files as easily as it can work from a new articles API.

Gridsome starters aims to help people find the right type of site first ythen gives you a simple theme to start off from there.

Gridsome Starters

2. JAMStack Gridsome Themes

A small list of themes provided by JAMstack who also have numerous other themes for other static site generators. Most of these themes are quite basic and some work like the starters like the above with some being built with Netlify CMS in mind or Airtable.

JAMStack Gridsome Themes

3. Gridsome Profile Starter

This is a single theme but made for people wanting a profile site - excellant for web designers, developers or creative types.

Gridsome Profile Starter

4. VueThemes

It’s worth remembering that Gridsome is a wholly VueJS framework. So anything buiult with Vue in mind is compatible with Gridsome. So this site dedicated to VueThemes is well worth a look as they can all be installed and used within your Gridsome website/app.

VueThemes

They do have 2 specifically designed for Gridsome but like I say they’ll all work.

It’s a short list but as can be seen in the Gridsome issues discussing themes
it’s not considered a priority beyond the current starter projects which provide much of the capability that themes offer.

If you know of any other themes since this post please get in touch.

Fuzzy Finder There’s 2 simple ways for integrating fzf into your ZShell configuration. The first is shown on the README of the git repo. Whereby you enter the
the shown functions and variables into your bashrc or in this case zshrc. However, if you have the ability to install fzf via your package manager (Apt, Pacman, Yum) then fzf should have let you with 2 files to source in your
.zshrc file.

The two files you need to source are dependent on your distro but on Arch Linux based distros the files are located at

  • /usr/share/fzf/key-bindings.zsh
  • /usr/share/fzf/completion.zsh

After a reload of your configuration with threse two sourced files you will get the default fzf functionality. E.g.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
# Files under current directory
# - You can select multiple items with TAB key
vim **<TAB>

# Files under parent directory
vim ../**<TAB>

# Files under parent directory that match `fzf`
vim ../fzf**<TAB>

# Files under your home directory
vim ~/**<TAB>


# Directories under current directory (single-selection)
cd **<TAB>

# Directories under ~/github that match `fzf`
cd ~/github/fzf**<TAB>

By pressing after a double asterisk you get a fuzzy finder menu appear under your prompt giving you the most likely possibilities for what you want to open based on your history and location context.

If you’re not sure if you have the above files you can do a quick find on the command line:

sudo find ./ -name key-bindings.zsh

This may sshow you other plugins but if you just look out for fzf in the path those will be your files.

Portapack HackRF One devices have become increasingly popular with them popping up in droves as clones on AliExpress and BangGood.com lately.

If you’re buying one - even one claiming to be “Havoc 2 2020” edition then you’ll be surprised to learn Havoc has been discontinued. Its no longer supported. Neither Havoc 1 the original or Havoc 2 which was a fork.

So if you’re wanting to get the latest firmware with the greatest features incluidng many that weren’t yet implemented in the ‘latest’ Havoc firmware then look up Mayhem firmware which you can find at the link.

It comes with many great upgrades and a very active and helpful maintainer.

At the moment its the only alternatives you can get for HackRF One Portapack editions but it is compatibe with most of the editions that have been released including touch screen versions. They also release nightlyies as well
as numerous versions depending on what features you’re portapack needs and comes with.

Be sure to check out Mayhem firmware. Its a simple copy across of a firmware.bin file to upgrade to the latest version then reset.

Mayhem Firmware: https://github.com/eried/portapack-mayhem