SQL Tips & Quirks

1. PL/SQL Anonymous block sample with DBMS_APPLICATION_INFO.set_module example & PL/SQL procedure invocation

Gangtok Tour

1. Rumtek Monastery 
2. Tsomgo or Changu Lake 
3. Ropeway: Awesome Cable Car Ride 
4. Ranka Monastery
5. Ban Jhakri Waterfall 
6. Hanuman Tok 
7. Saramsa Garden 
8. Ganesh Tok 
9. Do-Drul Chorten Stupa 
10. Tashi View Point
11. Enchey Monastery 
12. Bakthang Waterfall
13. Khangchendzonga Biosphere Reserve

References

1. https://www.darjeeling-tourism.com/darj_000101.htm

2. http://www.transindiatravels.com/sikkim/gangtok/tourist-places-to-visit-in-gangtok/

JS add on's in developing Single Page Applications

Below are the common additional JS utilities, plugins or functionalities you may need while developing Single Page Applications:

jsPDF

A very handy utility to generate PDF's at client side. 
Support for image types jpg and png is included.

fromHTML plugin does not render images which are part of table cells. You can  use jsPDF fork https://github.com/Flamenco/jsPDF to address the same.

Android Development Tips

1. How to access app files from internal storage
• adb shell
• run-as com.yourapp.package-name
• Now you can navigate to the app_<app_name> folder and go through the files.
2. Copy file from desktop to device sdcard
• adb push d:\temp\delnow\console.log /sdcard
3. Move file from sdcard to internal storage
• adb shell
• run-as com.sanjith.carcare
• mv /sdcard/console.log ./app_CarCare/.
4. Application log viewing
• adb logcat | findstr "com.example.app"
• adb -d logcat | findstr "com.example.app" > C:\file-path
5. Next

JAX-RS REST API Caching

How to use Scala along with Spark for a Java Developer

Below are tips and tricks I have learnt about Spark with Scala

1. How to create dataset of custom objects

   import spark.implicits._ class MyObj(val i: Int) // ... val d = spark.createDataset(Seq(new MyObj(1),new MyObj(2),new MyObj(3)))

   Will give you error, so instead use kyro encoder

   import spark.implicits._ class MyObj(val i: Int) implicit val myObjEncoder = org.apache.spark.sql.Encoders.kryo[MyObj]

   // ...
   

   val d = spark.createDataset(Seq(new MyObj(1),new MyObj(2),new MyObj(3)))

2. 
   
3. 
   

Health Benefits of Kefir I have seen personally!

Disclaimer: This is not any medical advice or prescription, please consult doctor for any health issues. These are authors personal observations.

1. Kefir drink is rich in B vitamins, enzymes which are essential for healthy individual.
2. Kefir drink is very beneficial for dental health  as the root cause of dental decay or any other dental problems are bad bacteria. Regular intake of water Kefir fermented with lemon or ginger improves the dental health a lot and also removes the bad breath from mouth.
3. Candida infections are cleared. Kefir is instrumental in removing candida infections by drinking regular water Kefir. It removes candida infections in mouth, private parts.
4. Tendency towards Alcohol is gone. Sugar craving is reduced and improved the responsible living attitude, I mean taking care of personal health.
5. Brightens the skin by regular application on skin.
6. Anti depressant, it inhibits the feel good feeling by boosting the serotonin production.
7. Solves several gut issues ranging from indigestion, acidity, constipation etc.
8. Diabetic patients need to be careful while using water kefir, as it may contain more sugars if not reduced by doing second fermentation. In my case regular drinking of second fermented drink has brought down my sugar levels to normal range.