🎵 Megalith by Julian Lachniet 🎵

Bandcamp: http://bit.ly/35C7T4p
Streaming: http://bit.ly/36K12aK

Megalith Cover

Music by Julian Lachniet
Lyrics by Julian Lachniet and Simon Kwilinski

Vocals by Julian Lachniet, Henry Zayko, Nathaniel Holcomb, Simon Kwilinski, Zachary Lovejoy, and Mythreyi Parameswaran

Produced by Julian Lachniet

Featuring Get Out of the Boat by Ron Wilson

Music and Lyrics by Ron Wilson and David Palmer
Vocals by Ron Wilson
Drums by Steve Simpson
Keyboards by Ron Wilson and David Palmer
Engineering by Mike Fox and Tim Houser

Connecting a MySQL Database on NameCheap to IntelliJ or PhpStorm

This page shows you how to add remote SQL connections for PuTTY. But, this doesn’t exactly transfer to the same configuration in JetBrains. Here’s exactly what you need to put into IntelliJ or PhpStorm to connect them to your MySQL database hosted on Namecheap.

On the General tab:

  • Host:
  • Port: 3306
  • User & Password: your cPanel login
  • Database: your database name
  • The URL is automatically generated for you.

On the SSH/SSL tab:

  • Enable Use SSH tunnel
  • Create a new SSH configuration
    • Host: your servers dedicated URL, found in the email Namecheap sends you or also found in cPanel
    • Port: 21098
    • User name: your cPanel login
    • Authentication type: Password (you can optionally add an SSH key)
    • Password: your cPanel password

You may get an error that the timezone is not set. Simply change the value of serverTimezone on the Advanced tab to UTC.

And that’s it! Test your connection and start querying.

Hosting a GitHub repository on a web server (Auto deployment)

If you’ve ever hosted a website before, FTP is nice, but can be cumbersome when trying to add or remove many files at once or trying to configure servers and credentials. A good alternative to this is to auto deploy a GitHub repository to the www directory of your web server, so that any changes that are made the repository are automatically pulled and go live immediately with no extra steps. 🤯

Make a GitHub Repository

To begin, you’ll need a GitHub repository where you’ll keep all the files for your site. You can go to github.com and create a repository there. This will work on public and private repositories.

Making and Managing a Deploy Key

Once you have made your repository, you will need to access your remote web server. We will be using an SSH key to provide access to the repo. You can generate one with the command ( ⚠️ replacing respective values):

$ ssh-keygen -t rsa -b 4096 -C "your email address here"

When prompted for a location, you can press Enter to use the default location. You may optionally add a passphrase in this setup. Just ensure you write it down.

You can now run the command to view the public key:

$ cat ~/.ssh/id_rsa.pub

Copy the result from the terminal.

Next, open your repository’s GitHub page and go to Settings → Deploy Keys. Here, click Add Deploy Key. For Title, choose as you please. Paste the previously copied key into the Key field. You will want to check Allow write access. Hit Add key.

Initializing GitHub Repository

Back in the terminal, navigate to your site files (or where you want them to appear). Run these commands ( ⚠️ replace values respectively):

$ git config --global user.email "you@example.com"
$ git config --global user.name "Your Name"

The next step depends on whether you have your files here already, or you don’t.

I already have my files on the server! Great! Run these commands ( ⚠️ ensure you replace user and repo with their respective values):

$ git init
$ git add *
$ git commit -m "add site files" 
$ git remote add origin git@github.com:{user}/{repo}.git
$ git push -u origin master 

I don’t have my files on the server! Great! Run these commands ( ⚠️ ensure you replace user and repo with their respective values):

$ echo "# a fancy title" >> README.md
$ git init
$ git add README.md
$ git commit -m "first commit"
$ git remote add origin git@github.com:{user}/{repo}.git 
$ git push -u origin master

Great! Check your GitHub page to see your file(s).


Ooh… this is the scary part. 👻 You’ll need PHP and be able to make a shell_exec command. In your www directory, run this command:

$ nano gitpull.php

And paste the following code (⚠️ adjust the path if necessary):

echo shell_exec("cd ~/public_html && git pull origin master 2>&1");

You could expand this code to require a key, if you deem necessary.

Then press Ctrl+O, Enter, then Ctrl+X to save. This PHP script will pull from the master branch of the repository when called and return the response of the git command.

Final steps!!1 Head back to the GitHub repository page and hit Actions, then Setup a workflow yourself. Copy and paste the below code ( ⚠️ replacing respective values):

name: auto-deploy-amazingness
     branches: [ master ]
     branches: [ master ]
     runs-on: ubuntu-latest
     - uses: actions/checkout@v2
     - name: Git pull via GET
       run: |
         curl -i -H "Accept: application/json" -H "Content-Type: application/json" https://{yourdomain}/gitpull.php

Then, hit Start Commit, then Commit new file.

Phew, all done! 🎉 You’ll notice either a green check mark next to the latest commit on the GitHub repository page if it has processed, or a yellow circle if it is still processing. This will automatically deploy your GitHub repository on every commit. 😎👏

Julian’s Unscientific Snow Day Calculator

There are many websites and apps that claim that they can “scientifically” calculate the chance of there being a snow day. Students across the world eagerly put in weather information to receive a percentage, which they quickly share with their friends.

But where does this percentage come from? It turns out that it’s mostly just based on what the programmer of the site thought was kind of accurate.

And that’s why I decided to do the exact same thing.

The source code is available on GitHub:

The CubeSolver Electric

In our latest product, the CubeSolver Electric, the device can solve your cube in approximately 10 seconds, flawlessly. It uses a simple timer on your phone with the device to change the color of the stickers with electricity.

Don’t believe it works? Watch the full video for a mathematical proof. It uses calculus to accurately define the way the CubeSolver Electric works.

The Procedurally Generated Cha Cha Slide

To the right now!
Right foot, let’s stomp!
One hop this time!
Left foot, let’s stomp!

These are lyrics came from the hit dance single, The Cha Cha Slide, beloved by elementary school gym teachers.

Or did they?

Those lyrics come from a procedurally generated version of The Cha Cha Slide. It’s the first few lines of a painful 56 minutes of our new hit song, The Procedurally Generated Cha Cha Slide. The song is completely computer generated, using small audio segments from the original song. We wrote some simple Python code to combine clips in the appropriate order. This allowed us to generate as much audio as we wanted. Listen to the track in its entirety, and you’ll notice that our track is far less structured than the original.

You can see all of the source code used to create the audio on GitHub: https://github.com/wyskoj/Procedurally-Generated-Cha-Cha-Slide