My SQL success

My blog was under a brute spam attack. The reason being – I had turned off my spam filter plugins while setting up WordPress Multisite (in case you didn’t know, I now have an add-on site thedamsel[dot]in – which will be launching soon) and forgot to turn them on when done! I thought the spam comments were manageable, when they were just 300. Then the number skyrocketed to 10s of thousands…

I had to do something!

I was in-between countries…My dear blog got sidelined because of my helplessness – what with setting up a home here in the UAE and brushing up my professional skills, as I will soon start looking for a job.

Last week, I logged in to check out the new version of WordPress edit page and the number of spam comments (now filtered, and the previously unfiltered) caught my eye. I had had enough. Today, I sat down to clean up my blog once and for all and make up for all the time I couldn’t give it in the last 3 months.

images

I knew there had to be a way to collectively separate and delete the spam from the ‘Approved’ comments section. So I asked Google and was directed to a very helpful thread. I did not use the bulk query, instead I spent time analysing how many spam comments were from the same IP and then deleted them.

images (1)

SQL is something which I have always shied away from. I am an Electronics and Telecommunications Engineer, so I was not exposed to Databases and Programming Languages (other than C) in the syllabus. I had a hard time grasping Oracle and JAVA in my programming class at SEED Infotech (which I took out of desperation to find a job after college). I would be lying if I said I don’t know databases. I have designed DB Schema for many complex apps. I do have working knowledge of SQLite – the database used in most mobile apps. However, I have always been reluctant in naming SQL as a skill I possess. Why? Because I have never worked on it hands-on. Yes, I have used queries when I worked as a developer, but I still have to read-up on Databases.

So, now that I had the chance to tinker with my own server’s database, I happily took it. Today I feel that the money I spent all these years on my Hostgator subscription has been well utilised and hopefully, I will start using it for the main purpose that I bought it – to learn server side programming!

Here’s to programming! Long live the developer in us!

So long spammers!

images (2)

4G is here and it is just a Tweet away! #GetAirtel4G

I have seen the iPhone since iPhone 3G and debated whether the iPad will catch up or not. Yes, I am that old in the tech industry.

Most of us know the pre-internet era, the net cafe emergence, the dial-up connections, mobiles with internet Edge, then 2G, then 3G – in that order…

Well, we witness a start of one more era brought to India by Airtel – the 4G.

If you were in awe of the no buffering experience provided by 3G, you will be all the more delighted with the real time experience of 4G.

It’s like the difference between iPhone 3G and iPhone 5. Or that leap Samsung made in S2 to S3 transition.

As important as the technology leap is, 4G is all about a wider coverage across India, including the interiors. In the first Phase, Airtel has rolled out the service in 296 cities panning Kashmir to Kanyakumari.

He got me an iPhone 6 last year. I am all too excited to get the magical 4G, looking at this ad which caught my eye yesterday :

That reminds me of us travelling in a train near my town. A group of teenage boys were trying to load Raju Shrivastav’s comedy video. One said Arey buffing nai ho raha yaar. (He meant buffering.)

Now those boys will not have to wait for “buffing” ūüôā

A li’l birdie told me this is as easy as chirping, err tweeting…

* Get an LTE (4G) enabled phone.
* If you are on Twitter, tweet with the hashtag #GETAIRTEL4G to @AirtelIndia
* An Airtel rep will get in touch with you immediately and you will get a FREE 4G SIM delivered at your doorstep!

So what are you waiting for, tweet and get the fastest network ever!

Please note that you must be an existing Airtel user to avail the above express service.

Not on Twitter? Well, don’t be sad, go to¬†www.airtel.in/4G and raise a SIM exchange request.

Kya aapne 4G ke liye tweet kiya?! Maine bhi kiya!

airtel-4g

 

 

The Zen of low-light photography : Asus Zenfone 2

zenfone2-624x351

 

Asus has always preferred to be a low-profile player in the mobile field, even when it has built the hardware for the most successful smartphones from the traditional Android makers like Samsung.

The Asus Zenfone 2 is the result of the continued research in bettering the smartphone experience for budget and high-end smartphone users alike. It caters to both the audiences seamlessly. It is bound to put Asus in focus with actual word-of-mouth publicity from its users. You cannot be low-profile anymore Asus!

The prime reason is its attractive price, which is pegged at an estimated Rs. 19,990 in India. The Zenfone 2 is the most awaited phone in 2015 for its advanced PixelMaster Camera(Best low light features) which is the brainchild of the research team at Asus.

Low quality photographs are not always a result in case of low-light because of a phone’s low battery. I have had moments at candle-light dinners where a perfectly charged premium smartphone could not click a well-defined picture despite being flash enabled.

This is bugging for serious photographers who do not have a DSLR handy at the moment. The Zenfone 2, which is also hailed for its ergonomic arc design, ensures that the photographer in you is appeased and pleased at all times Рespecially when taking pictures in low-light. The PixelMaster technology is going to give the Lumia a serious run for its money in the low-light photography feature. The technology is validated by the Malaysian mobile critique site SoyaCincau.

The combination of 4GB RAM with a 64-bit super quad core Intel Atom Processor is going to make your phone run smooth like butter, not to mention the speed and quality of the photographs you take. The 5.5 inch HD screen coupled with the famous ZenUI is guaranteed to leave you gaping at your own photography!

You can view the full specifications on Flipkart (and even pre-order it). Check out what the savvy customers have to say about the Zen of Zenfones here.

What are you waiting for? Start your phoneography now! Your pocket DSLR is here!

 

Z