blog@Yantrajaal

The Google App Suite ( or G-Suite) of products is a powerful and free alternative to the traditional Office Suite and includes among others Docs, Sheets and Slides. Google Sheets offers full spreadsheet functionality and in this post and sample, we show how data stored in Google Sheets spreadsheets can be accessed with SQL. This post assumes that the reader is familar with standard spreadsheet terms like sheet, range and functions. Google Script The primary programming language used here is Google App Script, a javascript look alike that can be used to enhance and extend G-Suite products. Google script can also be interleaved with traditional HTML / CSS / JavaScript to create an elegant user interface as is shown in this example. A Google Script project sits in the Google Drive just like any other Sheet, Doc or Slides and consists of code in a code.gs file along with html files for the interface. Google Script functionality can be built into other Google products but in this exam...

While hanging the rapist or castrating him may cause smug justification to society at large, it is of little value to the victim and the immense anguish that she has to suffer. Here is an idea that uses the technology that almost every woman has in her hands to help prevent rapes in the first place. It is based on a mobile app that can be used with a phone equipped with GPS, a data connection and camera -- things that are not too difficult to find on modern smart phones. The app -- Save Your Sister (SYS) -- has three major functions, namely (a) to identify the users current position, (b) to alert others  of where she if she is in danger and (c) to take and transmit photographs of the attacker should an assault actually happen -- and it could work like this. In the "dormant" state when the woman is under no apparent threat, the SYSapp simply keeps a record of the current position of the phone ( and the woman carrying it) and makes sure that both GPS and data transfer is...

I have been a laggard with smartphones but last month I finally bought an Android phone and within days I got a tidy return on my small investment -- two extra hours on the upper berth of an overnight train ! How ? If you are travelling alone at night, in an AC compartment then you have no way to knowing where you are at any point in time and the need to climb down every now and then to check the station that you are passing through is painful. Instead what I did was to lie on the bunk and switch on Google Maps on my GPS enabled Android phone and watched the blue arrow that showed me (and the train) as it snaked across the countryside. Only after passing the last station before my destination, did I finally get down from bunk feeling rather smug about this new technology. This simple technology can be used to track the movement of all trains across the entire country. How ? Every Android phone is associated with a specific Gmail ID and using this Gmail ID one can “check-in” i...