MySQL Function for Making URL Names

Thursday, 03 September 2020

This function takes a text like "I Can't Cope with Socialists!" and transforms it to "i-cant-cope-with-socialists", suitable for URL names and similar. Preserves only letters (A-Z) and digits, removes double hyphens and makes everything lowercase.

CREATE FUNCTION mangle_name (str VARCHAR(255)) RETURNS...

> Keep reading

Ergonomics for Developers

Tuesday, 11 August 2020

...or, how I got rid of pain and kept hacking for another decade

Sitting in front of a computer and working until the wee hours of the morning is nothing unheard of for developers, and we've all gotten used to...

> Keep reading

SQL Server BCP reference

Tuesday, 11 August 2020

bcp Database.dbo.TableName out savefile.bcp -S server -T -N -k

Exports data from a certain server and table to a savefile. -T means trusted connection (using Windows authentication), -N uses the database's native storage with Unicode values (specifically designed for server-to-server copy),...

> Keep reading

Short Story: Seli & Naliam

Wednesday, 05 August 2020 · 1


Seli lay on top of the embankment and looked out over the plain ahead of him in the gray morning. It was cold and he was freezing; spring had not yet progressed into its usual warmth, and the air was...

> Keep reading

I Fell in Love with Spring

Tuesday, 12 May 2020

I fell in love with spring
With budding trees, and warmth and flowers
The grass that grows and birds that sing;
And its occasional blustery showers.

I fell in love with summer
With still, warm nights and longer days
Mixed with rains, and distant thunder -

> Keep reading

Spring in Maine

Monday, 30 March 2020

Spring, when are you coming
With your warmth and sunny days?
I see tiny buds outside
Ready to burst forth
Waiting for warm, sunny rays.
But snow lies still on grass and lawn
Slowly melting in the rain.
A cold wind blows today -
It is spring in...

> Keep reading

Michaelangelo and Queen Arabella

Monday, 24 February 2020

Listen -

I now will tell you a story fair,
Of queen Arabella in distant land
Her wisdom as great as her golden hair
That playfully flowed over shoulders bare -
Like sunrays glittered every strand.
Her knowledge had no discernful bound;
Every problem graceful answer found

> Keep reading

Ufw (firewall) Reference

Sunday, 26 January 2020

Enable or disable the firewall:

ufw enable ufw disable

Allow all incoming HTTP traffic and reject telnet globally (normally 'deny' is used but 'reject' will explicitly reject a connection):

ufw allow in http ufw reject telnet comment 'telnet is not encrypted'


> Keep reading

Docker Reference

Wednesday, 13 November 2019

Command/option | Description ----------------------------------- | ----------------   | Containers | Containers are light-weight virtual machines docker create image [cmd] | Create container from image docker rename container newname | Rename container docker rm container | Remove a container    -f | Force    -v | Also delete volumes   | `docker...

> Keep reading

sed and awk Reference

Thursday, 10 October 2019

Argument | Description -- | -   | awk '{print $1}' | Print 1st word from lines separated by space awk -F: '{print $1}' | Print 1st word from lines separated by colons   | sed -n | Don't display input lines in output sed '5d'...

> Keep reading