Back to Cheat Sheets Index

tmux help

Select excerpts from man, windows & panes using vi-mode and my tmux.conf file

Tmux Cheat Sheet

Table of Contents

1. tmux Configuration

2. Commands

3. Windows & Panes

Header 1 – 44px

Header 2 – 40px

Header 3 – 32px

Header 4 – 28px

Header 5 – 26px

Header 6 – 24px

Kid, I’ve flown from one side of this galaxy to the other. I’ve seen a lot of strange stuff, but I’ve never seen anything to make me believe there’s one all-powerful Force controlling everything. There’s no mystical energy field that controls my destiny. It’s all a lot of simple tricks and nonsense.

The more you tighten your grip, Tarkin, the more star systems will slip through your fingers. I call it luck. Ye-ha! I call it luck.

I suggest you try it again, Luke. This time, let go your conscious self and act on instinct. I want to come with you to Alderaan. There’s nothing for me here now. I want to learn the ways of the Force and be a Jedi, like my father before me.

In my experience, there is no such thing as luck.

I can’t get involved! I’ve got work to do! It’s not that I like the Empire, I hate it, but there’s nothing I can do about it right now. It’s such a long way from here. Obi-Wan is here. The Force is with him.

1. Red Five standing by.
2. I call it luck.
3. She must have hidden the plans in the escape pod. Send a detachment down to retrieve them, and see to it personally, Commander. There’ll be no one to stop us this time!

Hey, Luke! May the Force be with you.

What good is a reward if you ain’t around to use it? Besides, attacking that battle station ain’t my idea of courage. It’s more like…suicide. Your eyes can deceive you. Don’t trust them. The Force is strong with this one. I have you now.

• I suggest you try it again, Luke. This time, let go your conscious self and act on instinct.
• Partially, but it also obeys your commands.
• Kid, I’ve flown from one side of this galaxy to the other. I’ve seen a lot of strange stuff, but I’ve never seen anything to make me believe there’s one all-powerful Force controlling everything. There’s no mystical energy field that controls my destiny. It’s all a lot of simple tricks and nonsense.

Dantooine. They’re on Dantooine. Oh God, my uncle. How am I ever gonna explain this? Hey, Luke! May the Force be with you. No! Alderaan is peaceful. We have no weapons. You can’t possibly… I suggest you try it again, Luke. This time, let go your conscious self and act on instinct.

What?! I’m trying not to, kid. Still, she’s got a lot of spirit. I don’t know, what do you think? Don’t act so surprised, Your Highness. You weren’t on any mercy mission this time. Several transmissions were beamed to this ship by Rebel spies. I want to know what happened to the plans they sent you.

CopyQ help

help generated by copyq -h

Usage: copyq [COMMAND] Actions:

Vim Cheat Sheet

Table of Contents

1. Ctrl+W Assignments

2. Leader Assignments

3. Keyboard Shortcuts

4. Cursor Movement

5. Insert Mode - ways to commence editing

6. Editing

7. NERDtree

8. Working with Multiple Files

9. Tabs

10. Marking text (visual mode)

11. Visual Commands

12. Marks

13. Cut and Paste

14. Registers

15. Search & Replace

16. Environment/Interface

17. Exiting

wmctrl help

help generated by wmctrl -h
Actions:

( add | remove | toggle),prop1 [,prop2 ]

wmctrl -b toggle,shaded -r 'Notes - Zim'

Options:

wmctrl -ir 0x06600031 -T "D78"

Index of Projects migrated from ZimWiki

1. CopyQ
2. Regular Expressions
3. Vim/gVim
4. wmctrl
5. youtube-dl

If you are accustomed to using a graphical user interface you don’t see all of the changes that take place when a USB device is connected to a computer. Each time a Keyboard Video Mouse switch is used to activate input to a system, it is like connecting the device for the first time that day.

This discovery might fly in the face of the premise these connections are supposed to bring to a modern operating system environment. Back in the days before USB, any changes to hooking up a peripheral device such as a keyboard, mouse, printer or scanner required shutting down the machine before making such a change. After two crashes in the midst of the process the system was unpacking and applying the new packages, having a system crash in the middle of an upgrade process can not be seen as a fluke. It should not surprise me really. USB demos have been crashing since the days of Windows 98.

Maybe it is just the model of my KVM switch or the fact mine is USB as opposed to the old PS/2 connections, but heed the warning: Using a KVM switch during upgrade to a new version of Ubuntu through the update manager can make you scream, “NOOOOOOO!”

This tutorial assumes you know the basics such as layers, text tool, paint bucket and working with selections.

Photoshop solution

1. In the area you want text to appear use the Text tool and create the text you wish to outline.
2. Move your mouse over to the Layers panel and click on the text layer to make sure it is the layer selected. Then, execute the combination on Ctrl-Click, Click being the left mouse button. This will select all of your text.
3. Move your mouse to the menu and choose Select > Modify > Expand
4. This will bring up the dialog to specify how many pixels to expand the selection. For this example, we’ll specify 2 pixels
5. From the Toolbar, choose the Paint Bucket tool and select a foreground colour. For this example, I chose red.
6. This next step is important to understand. Up to this point, it was possible to resize the text. Clicking the area selected to fill-in with the chosen outline colour, you will be prompted to convert the text to a rasterized layer. This means the text will no longer be text and as such can not be edited. Click OK to proceed.
7. Using the Paint Bucket tool, fill-in the gaps between the black and the expanded selections. For letters like R and O, don’t forget to fill-in inner areas.
8. Save your work.

GIMP solution

1. In the area you want text to appear use the Text tool and create the text you wish to outline.
2. Once your text is complete, return to the Toolbox panel and click on Path from Text.
3. Move your mouse pointer to the Select menu and choose From path This will select your text.
4. Click on the Select menu once more and chose Grow…
5. For this example, grow the selection by 2 pixels. Click OK.
6. From the Toolbox menu, choose the Bucket Fill Tool and a foreground colour. For this example, red was chosen.
7. Using the Paint Bucket tool, fill-in the gaps between the black and the expanded selections. For letters like R and O, don’t forget to fill-in inner areas.
8. Save your work.

If you have a spreadsheet software like Microsoft Excel or OpenOffice Calc, have you considered the power of that program to prepare data? Before you think about finding software to convert spreadsheets to MySQL, Postgre SQL or other database tables for web applications, have a look at this how-to for creating SQL INSERT statements.

Spreadsheet Tools to Prepare Data for SQL

In the above screenshot we have a simple table of employee information in a spreadsheet. How do we insert those in a database table? To work in MySQL, each of those rows has to resemble an insert statement like these:

Using string concatenation it is possible to create statements to insert each of those rows to a MySQL table. How does each one of those statements differ? All that is distinct are the values for id, fname, lname and city. If we can come up with a text equation to change those values for each of the rows, the task of creating an insert statement for each row of data will be so much easier.

Breaking Down a Text Equation

There are two main components for text equations in spreadsheets:

• text that is entered by the keyboard
  • this data is wrapped in double-quotes (“) with an equal sign (=) at the beginning
• data that is picked-up from cells in the spreadsheet
  • to instruct the software that data from cells is being called, the ampersand (&) is used to mark the beginning and end of such data

The screenshot below illustrates the text equation that results in the SQL expression:

Expressed another way, the text illustration of the SQL statement highlights the variable parts of the text equation in white on black whereas the constant parts of the equation are in blue on grey.

Once the equation is returning desired results, copy and paste from the first row to all other rows in the spreadsheet.

Gee, this is great… Now what do I do?

With all the queries formed and reviewed by you as correct – yes, check your work – the next steps are fairly simple.

1. As shown in the above screenshot, select all the rows with the query statements. Only those with the statements, not the data to the left of them.
2. Copy and paste to a simple text editor like Notepad, Gedit, Notepad ++, etc.
3. Save the document with a txt or sql extension. For this example, we’ll call the file inserts.sql

Using MySQL at the command-line enter a command such as:

With the appropriate user name and password submitted, MySQL will execute the statements in the inserts.sql file.

Feel free to download a copy of the sample spreadsheet so you can try this on your own.

Sample Excel (xls) file in ZIP: employee_insert_demo.zip MD5 hash: a1e1d878d68be2b3975a8f211dd0dfe9