Normally we see the IP address of our computers is a dotted quad, such as 192.168.2.1. Frequently, IP address is stored in database as integer to save space and provide high performance. How to convert the IP address from a dotted quad to an integer? Let us understand the algorithm of the conversion. Once we [...]
If you are a Twitter user and do business on Twitter, you probably think about how I can target to a group of Twitter users, such as living in certain region or having similar interests. Can we screen Twitter users and target to a given population of Twitter users? Answer is absolutely positive: yes, we [...]
The definition in SQLite official site is the following: “SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.” So, how can we use SQLite engine to develop standalone desktop database application in Windows environments. At SQLite official [...]
Here is a PERL script I developed to automate Twitter update activity. The fundamental thing is you have a database and all updates are stored there. You are sick of sending all Twitter updates manually. As long as you meet these two criteria you can keep reading. Otherwise, stop here. The PERL source code is [...]
What is TwitterGIFT project? GIFT is an acronym of Get Innumerable Followers on Twitter. TwitterGIFT project was started shortly after we registered an account (usbargains) for our business on Twitter. Original GIFT application was a set of PERL scripts running on one of our servers. All proven successful Twitter strategies and tips were incorporated into [...]