mycli is a MySQL / MariaDB / Pecona database command line client with syntax highlighting and auto-completion. Have a look at some of the screenshots and documentation for features.
Found via this StackOverflow discussion.
Tag: command line
croc – simple and secure cross-platform file transfer
croc is a very simple but super useful utility, which helps with occasional file transfers between two computers. When you need to send a few files to a friend on another computer or in another country – this might just be the easiest way. No need to setup HTTP or FTP servers, Samba or NFS shares, or register at one of the million web services that provide such functionality.
croc is written in Go and is compiled for a variety of operating systems, include Linux, Windows, and macOS. It even has a simple GUI for those who wants it.
up – the Ultimate Plumber
The Ultimate Plumber, or up for short, is an excellent interactive tool for anyone who is building complex command sequences for processing text on the Linux command line. If you are a frequent user of grep, sort, cut, awk, sed, and other similar commands, have a look at this demo. I’m sure up will save a tonne of time once you get a hang of it.
Vim tweaks and updates
Over the last few weeks, I have significantly changed and updated my Vim configuration. I’ve been using the editor for decades, and yet I every time I revisit my setup, I am amazed at how far the editor progressed and how wisdom the Vim community shares via themes, plugins, configuration tweaks, etc.
Here are some of the highlights this time around:
- Switched from Pathogen plugin manager (and Ansible bits) to Vundle.
- Added vim-devicons plugin and a patched font that supports them.
- Switched from Syntastic to ALE for faster and better syntax checks.
- Improved the code completion configuration, tags, and such.
- Added a whole bunch of plugins for developers.
I am still getting used to some new shortcuts, catching up on the documentation, and trying things out. But if it’s been a while since you’ve looked at your own Vim configuration, I suggest you do so. Things are moving and evolving faster than you might think.
forget-db – a simple GDPR inspired tool to anonymise confidential database data
A simple(ish) command line tool written in PHP 7.1 using Laravel Zero and Faker to help you anonymise/pseudonymise data within your database to support protecting either sensitive information, or peoples right to be forgotten with GDPR compliance.
The tool allows you to connect to either mysql, postgres, sqlite or sqlserver and replace defined information with random data to allow you to keep statistics/relationships/audit of actions etc.
It uses a simple yaml configuration file to define the conditions for overwriting, which fields you want to overwrite, and what to overwrite them with.