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.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behaviour or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.