Do you think your Twitter profile banner is boring? Do you wish there was something that could rotate your Twitter banner images? Maybe what you want is to brag about your Twitter account statistics on your profile banner to make a unique Twitter profile banner. This article showcases a Go program that does just that.
Retrieve User Statistics from Twitter
We will authenticate with Twitter API using OAuth 2.0 to retrieve the statistics for the given Twitter profile. To achieve this, we need the Go oauth2 package.
You can use UPDATE statement in Structured Query Language (SQL) to modify values in the matching rows. However, only some people know that you can use JOINs in UPDATE queries. For example, by using JOINs we can retrieve additional data from other tables or exclude some rows from our update. Soon you will learn how to write update statements with joins on MariaDB / MySQL.
I am sure every PHP developer has a colleague they hate because he/she coded the application they started maintaining. This is mostly because the code is old. New standards become common, they learn what they used to do was inefficient, unreadable, or complicated. As PHP is a language that changed significantly over the years, code written a few years ago will certainly look outdated.
That being said, this post is not about the old PHP code. This post shows how to be a bad programmer even when following standards. Please don’t be this person.
Country tables are useful when you need a select box containing the countries in your application. It is a must have when you have multiple rows with country fields. ISO-3166 is the standard for 2-letter country codes so this post will show how to import ISO-3166 Country List for MySQL.
I showed every way possible to import the table. Hopefully everyone can benefit from this post.
The default Twitter Follow code, the script loads the like button synchronously. When you add the synchronous Twitter Follow button to your website, Page Speed Online will tell you to prefer asynchronous resources. When I tried to use it on a minimal HTML page score goes down by 8 points. If you are like me and want to get the best score possible in Page Speed you would want to know how to make it asynchronous.
Ever wondered how many people are on your website? Do you think Analytics Real-Time shows all of the visitors? If you don’t have any clicks in 5 minutes (which I believe is the timeout of Analytics Real-Time) you won’t be seeing that user in Analytics Real-Time. Continue reading Analytics Real-Time Alike Real Online Script→
As some of you developers might know when you get the default Facebook Like code, the script loads the like button synchronously. When you add the synchronous Facebook Like button to your website, Page Speed Online will tell you to prefer asynchronous resources. If you are like me and want to get the best score possible in Page Speed you would want to know how to make it asynchronous.