• The primary website
• Voting software that handled millions of web page votes in under 30 seconds, which was first deployed during the Gala Artis, a Québécois Television Award Show
• A complete suite of control software for the stage manager to push audience content to two gigantic stage monitors and the monitors embedded in the artist’s piano
• Mobile compatible web pages for the audience to answer live questions and send chat messages to the artist during the performance to help shape the show
• Mobile compatible web pages for the audience to order drinks during the show, and for the staff to manage the drink orders

This project has 2 parts. The first pulls all of the Item and Recipe info for Guild Wars 2 into a database. The second is a client side only recipe management interface (no server processing).

I threw this together for a friend in 8 hours, as some of its functionality coincided with stuff I needed for another one of my projects. It was not meant to be pretty, so the interface is a bit spartan, and the code comments are a bit lacking. It also doesn’t check user input very thoroughly :-) .

• Set multiple paths to include/exclude
• Overlay image on top of current screen
• Select translucency of window
• Ignoring user input when form is not selected (and quickly access form through shortcut key)
• Sort images by (File): Path, Name, Modified Date, Created Date, Random
• Choose where to display the image on the screen
• Constrain image proportions (for all or only larger than screen) to fit screen
• Display file name and save to clipboard
• Set image cycling time and pause cycling
• Global and local shortcut keys for most options
• See Configuration Options for more options

• This takes a single VirtualHost domain and will install certificates for all VirtualHosts on the same IP (or if requested, just the given VirtualHost)
• This script can be run through both a bash command line (CLI), and as a web page. Parameter names use a different format for the two
• While this script was originally designed for cPanel, it should work with any apache configuration, given the correct parameters

My best friend in college told me about a keyboard that allowed you to type with only one hand by remapping both halves of the keyboard to the other side (swapping when a toggle key is held down), so that it had a backwards QWERTY layout. So, essentially, you could reach the whole keyboard with either the right or left hand.

It will soon be expanded to instead remap keys based upon a configurable ini file so it could be used for other purposes.

Translation strings are held, per language, in text files (either YAML or JSON), and compile into .gtr or .gtr.gz (gzip compressed) files.

Translations can be referenced in Go code either by an index, or a namespace and translation ID. Referencing by index is the fastest, most efficient, and what this library was built for. Indexes are stored as constants in generated Go dictionary files by namespace, and are also held in the dictionary.

See the github page for full documentation.

The flaw in the native library scanning process is its repetitive and time-consuming type determination for each row scan. It must match each field’s type with its native counterpart before converting the data string (byte array). Furthermore, the requirement to specify each individual field for scanning is tedious.

GoFasterSQL instead precalculates string-to-type conversions for each field, utilizing pointers to dedicated conversion functions. This approach eliminates the need for type lookups during scanning, vastly improving performance. The library offers a 2 to 2.5 times speed increase compared to native scan methods (5*+ vs sqlx), a boost that varies with the number of items in each scan. Moreover, its automatic structure determination feature is a significant time-saver during coding.

See the github page for full documentation.

I’ve found using php’s included MySQL functions to be cumbersome, take a lot more code than necessary, and create code that is not very readable. I am also not completely happy with PDO, so DSQL is my solution to this problem. I use it heavily in all of my professional web projects.

The classes in this library are written generically so they could easily be converted to any other database software.