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.
Category: Programming
A big part of my work has to do with code. I’ve worked as system administrator – installing, patching, and configuring someone else’s code. I’ve worked as independent programmer, writing code on my own. I also programmed as part of the team. And on top of that, I worked as Team Leader and Project Manager, where I had to interact a lot with programmers. Programming world on its own is as huge as the universe. There is always something to learn. When I find something worthy or something that I understand enough to write about, I share it in this category.
SOAR – SQL Optimizer And Rewriter
SOAR is an SQL Optimizer and Rewriter. It can help analyse, optimize, and rewrite SQL queries. Don’t get offset by the Chinese documentation as default – there is an English translation.
Here are some of the features:
- Cross-platform support, such as Linux, Mac, and Windows
- Support Heuristic Rules Suggestion
- Support Complicate SQL Indexing Optimize
- Support EXPLAIN analyze for query plan
- Support SQL fingerprint, compress and built-in pretty print
- Support merge multi ALTER query into one SQL
- Support self-config rewrite rules from SQL Rewrite
- Suggestions were written in Chinese. But SOAR also gives many tools, which can be used without understanding Chinese.
And if you are familiar with the other tools that provide similar functionality, here’s how SOAR compares to them:
33 concepts every JavaScript developer should know
“33 concepts every JavaScript developer should know” is an excellent collection of articles and video tutorials for anybody who wants to start learning JavaScript or improve their current knowledge. The list categorized into concepts which make it even easier to skip parts and only focus on the parts that you are interested in.
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.
The Illustrated TLS Connection
“The Illustrated TLS Connection” is an interactive guide to the TLS connection, explaining every byte with code, comments, annotations, and more. If you ever wanted to know the details of how this works, I can’t think of a better resource to direct you to. And if you find any issues or can suggest a better explanation, there’s a GitHub repository for you to contribute.