Prahlad Yeri

The most typical advice you get when it comes to improving site performance these days is purely technical things like using CDNs or other serving optimization, using X hosting mechanism instead of Y, going serverless, cache optimization, etc. I'm not talking about those things, I'm talking about the old school … Read More

Most senior managers and sales people in the 80s and 90s used to wear suits or blazers like this one while going to work. And while t-shirts and jeans have become the norm today (some IT firms even allow bermuda shorts from what I've heard!), it's important to understand that … Read More

Apps tend to become very complex beasts, especially when they start to scale. Part of the complexity is due to the fact that the users could be a diverse set of people with multitude of tastes and preferences which could all be conflicting. A classic example here is this recent … Read More

If you're an introvert who is suffering from both sleeplessness and also low self-esteem or impostor syndrome, I want to suggest you this therapy which I recently landed upon myself and seen many people recover from their insomnia or sleeplessness problem using it, and leading much happier and energized days … Read More

A common need you often face in PHP scripting these days is writing a long-polling endpoint for things like sending notifications or other kinds of responses back to the client. While using something dedicated like node, cometd or websocket makes ideal sense for such things, there are use-cases when you … Read More

Of late, I've found that a lot of unnecessary time and effort is being wasted on keyword-research activity by most new bloggers. Most bloggers do keyword research primarily for finding a niche i.e. they try to find a (relatively low-competition) topic related to their own where opportunity to rank … Read More

My earlier article dealt with multi-query issues of MySQL, this one is dedicated to SQLITE. Multi-queries are often discouraged to begin with but there are times when you find yourself using them. One typical use case is populating the database initially when it's empty. You do this by running an … Read More

Userscripts are a very useful and handy tool in the hands of power users. Just like customized garnishing, salt and pepper, etc. we put on our food before we eat, we can add custom javascript tweaks on the websites we visit. For example, you may want Reddit to automatically highlight … Read More

The most typical way people set default values to mysql date fields is by using the CURRENT_TIMESTAMP constant as follows: create table ledger_entries ( id int(11) not null auto_increment, entry_date datetime default CURRENT_TIMESTAMP ); This will obviously work if you need both date and time parts in the value. But in … Read More

Multi-queries are often discouraged with mysqli functions but there are times when you must use them. One obvious use case is initializing the database. One of the first things your app must do is determine if the database tables exist or not, and then run an initializing SQL script if … Read More