Importing lots of data (SQL, etc.) into App Engine Datastore

Create a task queue with Cloud Tasks and a task handler in you app engine app which inserts the items in the database, then run a script on your local machine which reads the database and adds items into the task queue for insertion.

The queue can be configured, so your app engine app can handle the rate of tasks given to it.

Solution for ERROR: gcloud crashed (LookupError): unknown encoding: cp65001

I found that in the same command prompt where this worked before, suddenly I get this error.

If I close the command prompt and start a new one then it works again.

Point subdomain only to appengine app

• go to appengine app settings, custom domains
• use main domain
• in the box type the subdomain
• if you want to point only the subdomain then ignore the A and AAAA records and add only the CNAME record :

subdomain  points to  server given by google

CPanel Domains vs. Add On Domains difference

They are just different views. Domains show all kind of domains (alias, sub, add on) in one place while the Add On domains panel only shows add ons.

Adding Putty SSH key to Github

If you get an error then try this:

Here are some steps that are not at all clear when copy/pasting your public key. (For the record, I used Putty Key Generator for my keys.)

• On the first line, enter ssh-rsa.
• Make sure you add one space after ssh-rsa
• When you copy/paste the key into the Key textbox it should preserve the \n characters (x0A). If you are using Notepad on Windows, you won't see these new lines until you copy the text to Github.

Notice on this screenshot, there's a space after ssh-rsa (See the cursor.) The public key text also includes three \n characters, so you can see the public key text bumps down to the next line three times in the textbox.

source: https://stackoverflow.com/a/17051410

That's why Vimium shows two or three character link hints when selecting links

In Vimium options only certain characters are allowed for link hints, which seriously limit the number of single character link hints. Allow more characters in the options.

XAMPP suddenly stops working, cannot connect

If there is no apparaent reason, no other program runs on the same port, there are no errors in the error log, XAMPP starts properly, etc. then try restarting your router if you have one. Sometimes my router gets confused or something and stops routing localhost traffic for some reason.