Posts

Investigating Solar Power

Recently BESCOM increased their tariff. But there is no improvement in reliability. This forced me to look for alternatives. Inverter was the obvious choice. But the engineer in me is worried about the electricity wastage. Inverter has around 90% cycle efficiency. There is wastage in charging the battery and converting it into AC power. What if the power supplied was free? That's where Solar power comes in. Components of a Solar system Photo-voltaic (PV) cells Charge controller/ Conditioning Unit/ CCU Battery Inverter There are numerous articles talking in depth about each of these. So I'll just list down the most important things to keep in mind. PV cells are available in mono and poly crystalline models. Mono crystalline is more efficient and hence costs a premium. One can start with a single panel and add more over time as necessary. Less number of panels or less power panel will only increase the charging time. Latest in CCU is Maximum Peak Power Tracking ...

IoT and the Judgement Day

Mahesh Murthy recently  tweeted : Now a proud owner of Audi R8, Tesla S & Ferrari 308. Found this from Google Play: my 2-yr old bought them on Asphalt 8 This might sound like a pardonable innocent act; some might find it cute too. But your HomeOS doing the same - analyzing a vacant parking space in your car, a certain amount of bank balance, based on car your neighbour recently bought, the car pic your cousin recently posted on FB or some darn algorithm that the developer in Google, Apple or MS came up with - can be a terrible nightmare, possibly even leading to a lawsuit. Companies are already shirking off their responsibility blaming the algorithm creating a scene of mistrust with customers. The recent issues with  Uber  is a case in point: We are not setting the price. The market is setting the price. We have algorithms to determine what that market is. My point is IoT is never going to be a master decision maker. At b...

Mood lighting with Raspberry Pi

Image
Mood lighting or ambience lighting refers to using different colors of light to create an ambience reflecting a particular mood. With incandescent or CFL bulbs, mood lighting was very restrictive - color of the light would be restricted to the color of the enclosure of the bulb. However advent of RGB (Red Green Blue) LEDs has opened up a new dimension in mood lighting. A good example is Philips Hue (http://www2.meethue.com/en-xx/). Not only one is not restricted by the color of the enclosure, one gets a choice of colors not previously possible which can be dynamically changed too!! If you don't want to invest in a proprietary solution, here's one way to achieve the same using RGB LED strip and RPi. Hardware A typical RGB strip needs 12V. However, RPi provides only 3.3V at the GPIO pins. Hence we need a bridge between these two circuits. A ULN2803 chip acts as this bridge - it takes TTL input and allows one to drive a high voltage circuit. Software We ...

Can Facebook takeoff as an eCommerce Platform?

In app purchases - video games started this. Gamers could buy super powers or add-ons for their avatars without leaving the game. When games moved from consoles to Facebook, they retained this flavour. Though retailers failed to capitalize on this. Most retailers think of Facebook value as a "Like" button on their website or a "Page" in Facebook. Unless one has read Facebook developer documentation (https://developers.facebook.com/docs/payments/overview), little does one realise that Facebook provides the user management and payment APIs to enable a retailer to sell their products within Facebook app just like those games' in-app purchases. Some service providers like StoreYa.com or storefrontsocial.com are already enabling small retailers to sell online using Facebook. So the question is - will Facebook compete as an eCommerce Platform in near future?

Managing DB evolution with Alembic

Any application evolves over time and so does the entities in the application. To start with, simple DDL scripts are written to create the DB. In each release, a new table is introduced or a current one modified. You are lucky if you can push the same version of application to all your customers. Since in real world this is not possible, soon one feels the need for managing DB for various releases of the application. While for managing code, there are excellent tools available (e.g. git, svn etc.), the same is lacking for DB management. Alembic aims to mitigate this problem. The website introduces Alembic as: Alembic is a lightweight database migration tool for usage with the SQLAlchemy Database Toolkit for Python. This is slightly misleading as it also supports MySQL and pgsql. Asterisk project has started using it for managing Realtime DB tables using MySQL. Though it's still in 0.7.1 version, the progress seems to be very promising. It's very easy to use which you c...

Creating Customer Delight

While reaching out to customer care these days, it's common to go through a series of questions on IVR before one gets to talk to a person. Even then, if it's your follow-up call on an issue, you have to start with several digits of a request number. How about using some technology to ease customer's pain? The IVR software should begin with checking if there is any past record of interaction from the particular telephone number. If not, present the user with normal set of options. If yes, it should directly connect the user to support staff simultaneously pulling up the concerned record on the display for support staff to refer to. What more, in eCommerce scenario most customers call up to find out their order details. Retailers can use this technology to give out order status before asking them if they want to talk to customer care.

IBM Watson Analytics: First impression

Image
Statistics is boring but computationally intensive. Hence for a long time, data warehousing and business intelligence (DWH & BI) was a specialized job. The contradiction being - folks who could understand pattern in data (business users) didn't know how to mine it; on the other hand, folks who could crunch data (engineers) didn't know what to look for.  Needless to say, anybody who could do both were looked up as wizards (Excel wizard!!). People learnt to live with it by compromising on a standard set of reports. IBM Watson Analytics aims to change this. It's a cloud based predictive analytics application. The cloud platform gives it the number crunching prowess resulting in instantaneous feedback. The beautifully designed application brings out the most important information out of humungous data at once. Further analysis can be done using drag-n-drop making analytics a playful exercise. After spending a couple of hours on the beta application, I must admit an...