<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-1678601896864190463</id><updated>2024-09-07T00:36:42.826+05:30</updated><category term="Javascript"/><category term="Andorid Apps"/><category term="Android"/><category term="Javascript Plugin"/><category term="NoSql"/><category term="SQL server"/><category term="TextSearch"/><category term="angularjs"/><category term="mongodb"/><category term="nodejs"/><category term="realtime"/><category term="socket.io"/><category term="sqlite"/><title type='text'>tekpot blogs</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://tekpot.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://tekpot.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Balasubramanian Shanmugam</name><uri>http://www.blogger.com/profile/13187295003202608339</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>8</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-1678601896864190463.post-267500554158085211</id><published>2017-07-25T01:15:00.001+05:30</published><updated>2018-08-28T21:11:38.622+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="angularjs"/><category scheme="http://www.blogger.com/atom/ns#" term="Javascript"/><category scheme="http://www.blogger.com/atom/ns#" term="nodejs"/><category scheme="http://www.blogger.com/atom/ns#" term="realtime"/><category scheme="http://www.blogger.com/atom/ns#" term="socket.io"/><title type='text'>Build a real-time data application using NodeJs, Socket.io</title><summary type="text">
In older days real-time data updates was achieved by having a timer to refresh a page or sending an Ajax request to the server to get the new data. Sometimes it makes requests&amp;nbsp;unnecessarily to server even though no data updates.&amp;nbsp;This concept&amp;nbsp;is called polling. 
Alternatively,&amp;nbsp;Real-time data update is when&amp;nbsp;data is updated&amp;nbsp;on&amp;nbsp;server,&amp;nbsp;clients get notified for</summary><link rel='replies' type='text/html' href='http://tekpot.blogspot.com/2017/07/using-Nodejs-socketio-realtime-data-updates.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/267500554158085211'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/267500554158085211'/><link rel='alternate' type='text/html' href='http://tekpot.blogspot.com/2017/07/using-Nodejs-socketio-realtime-data-updates.html' title='Build a real-time data application using NodeJs, Socket.io'/><author><name>Balasubramanian Shanmugam</name><uri>http://www.blogger.com/profile/13187295003202608339</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1678601896864190463.post-6437348067590548516</id><published>2017-06-29T02:44:00.001+05:30</published><updated>2017-06-29T02:44:08.736+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Javascript"/><category scheme="http://www.blogger.com/atom/ns#" term="mongodb"/><category scheme="http://www.blogger.com/atom/ns#" term="NoSql"/><category scheme="http://www.blogger.com/atom/ns#" term="TextSearch"/><title type='text'>MongoDB - Using Aggreagte and Text Search to compare and map records from two different datasets collections</title><summary type="text">

Recently I had a scenario to compare two different data sets&amp;nbsp;to find the matched records based on a text fields. The challenge is&amp;nbsp;cant&amp;nbsp;do it&amp;nbsp;exact matching.

For Example
DataSet1 contains a record with field as 
&#39;Name : ABC Company&#39;

DataSet2 may contains records as 
Name : &#39;ABC Company Ltd.&#39;

So decided to find the match based on ranking system. 
Take every record in </summary><link rel='replies' type='text/html' href='http://tekpot.blogspot.com/2017/06/mongodb-using-aggreagte-and-text-search.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/6437348067590548516'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/6437348067590548516'/><link rel='alternate' type='text/html' href='http://tekpot.blogspot.com/2017/06/mongodb-using-aggreagte-and-text-search.html' title='MongoDB - Using Aggreagte and Text Search to compare and map records from two different datasets collections'/><author><name>Balasubramanian Shanmugam</name><uri>http://www.blogger.com/profile/13187295003202608339</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1678601896864190463.post-7159713923443725322</id><published>2013-02-22T23:36:00.002+05:30</published><updated>2013-03-11T23:27:59.444+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL server"/><title type='text'>SQL server - Sync two SQL tables with same schema </title><summary type="text">
Sync data in two tables with same schema in generic way explained here.
Recently I had a requirement in one of our project that need to sync two different database with few common master data tables. Since I don&#39;t have control&amp;nbsp; in source database, I could not use replication or trigger concept. So I got this logic doing Google, and customized it for insert and update records.

Here I have </summary><link rel='replies' type='text/html' href='http://tekpot.blogspot.com/2013/02/sql-server-sync-two-sql-tables-with.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/7159713923443725322'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/7159713923443725322'/><link rel='alternate' type='text/html' href='http://tekpot.blogspot.com/2013/02/sql-server-sync-two-sql-tables-with.html' title='SQL server - Sync two SQL tables with same schema '/><author><name>Balasubramanian Shanmugam</name><uri>http://www.blogger.com/profile/13187295003202608339</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1678601896864190463.post-3612477557756160189</id><published>2012-12-31T19:13:00.000+05:30</published><updated>2018-08-28T21:13:08.643+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Andorid Apps"/><category scheme="http://www.blogger.com/atom/ns#" term="Javascript"/><title type='text'>Build an Android app using JQuery and HTML</title><summary type="text">
In this post, I am going to explain how to create&amp;nbsp;a simple android application using&amp;nbsp;Html and javascript as grphical interface. Basic concept is loading html file in Webview object using Web Client in Android.

Assuming Eclipse environment for developing Android applications is ready.

What we are going to do sample?
Create a html file which contains few&amp;nbsp;hard coded contacts&amp;nbsp;</summary><link rel='replies' type='text/html' href='http://tekpot.blogspot.com/2012/12/android-application-using-jquery-and.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/3612477557756160189'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/3612477557756160189'/><link rel='alternate' type='text/html' href='http://tekpot.blogspot.com/2012/12/android-application-using-jquery-and.html' title='Build an Android app using JQuery and HTML'/><author><name>Balasubramanian Shanmugam</name><uri>http://www.blogger.com/profile/13187295003202608339</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii68r6UnticjFRKSctIwhCD8-wEdHNOZfhrKKnTcDk4jVDuhnT5A4hmY5ZoDiU5f1rcP3MoNeug-o9_Ryng9LIs2MerGffu6AT61ImJLN2BtexP6Kl9Zi0qyvsEvJjF6F_jvQpwKlB9rH2/s72-c/Android_Jquery.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1678601896864190463.post-3605393662933820072</id><published>2012-09-11T15:24:00.002+05:30</published><updated>2017-06-08T02:26:30.853+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Javascript"/><category scheme="http://www.blogger.com/atom/ns#" term="Javascript Plugin"/><title type='text'>Javascript Pivot Library</title><summary type="text">

Arikai - Javascript Pivot Library - Niral Aakkam

A new version of Arikai - a simple javascript pivot library is released. Easy, simple, client side pivot table report generator using Jquery. Arikai supports SUM, AVG, MIN, MAX and COUNT aggregate functions.&amp;nbsp;




Arikai online demo - Niral Aakkam



Edit Layout button offers user to change the report dynamically. New fields can be added &amp;</summary><link rel='replies' type='text/html' href='http://tekpot.blogspot.com/2012/09/javascript-pivot-library.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/3605393662933820072'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/3605393662933820072'/><link rel='alternate' type='text/html' href='http://tekpot.blogspot.com/2012/09/javascript-pivot-library.html' title='Javascript Pivot Library'/><author><name>Balasubramanian Shanmugam</name><uri>http://www.blogger.com/profile/13187295003202608339</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuQDPFfyDnT4GS_2dzpuWlBlc4ow-bzTv4zFAm4Lq_VbZgE8z78Ol39NepBcvwVdZTZpqwK3Mv23Fs5DP8GzCchyKN08yRod1zn0oZ4SO5cacPq8IEIyU9JWqZgcoSWP78fVAqfnHTiCx/s72-c/Niral_Aakkam_Arikai_onlineDemo.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1678601896864190463.post-4327915524881649534</id><published>2012-09-07T13:05:00.000+05:30</published><updated>2012-09-11T15:14:19.840+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Android"/><title type='text'>Location using GPS in Android programming</title><summary type="text">

GPS Location in Android
Find current latitude and longitude location by using GPS

No need&amp;nbsp;GPRS or Internet connection

We need to add permission for accessing GPS. So put following tag in Android manifest file

&amp;lt;uses-permission android:name=&quot;android.permission.ACCESS_FINE_LOCATION&quot;&amp;gt;&amp;lt;/uses-permission&amp;gt;  

Import the necessary libraries

 import android.location.Location;  
 </summary><link rel='replies' type='text/html' href='http://tekpot.blogspot.com/2012/09/location-using-gps-in-android.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/4327915524881649534'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/4327915524881649534'/><link rel='alternate' type='text/html' href='http://tekpot.blogspot.com/2012/09/location-using-gps-in-android.html' title='Location using GPS in Android programming'/><author><name>Balasubramanian Shanmugam</name><uri>http://www.blogger.com/profile/13187295003202608339</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1678601896864190463.post-8075685965823525107</id><published>2012-08-11T00:49:00.000+05:30</published><updated>2012-08-13T14:11:35.937+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Andorid Apps"/><category scheme="http://www.blogger.com/atom/ns#" term="Android"/><title type='text'>Android AutoCompleteTextView data binding based on another AutoCompleteTextView selection</title><summary type="text">

Android - Bind data to an AutoCompleteTextView based on another AutoCompleteTextView selection


Hi friends, here I am going to explain how to load an AutoCompleteTextView based on the selection of another AutoCompleteTextView in Android.


Create screen layout xml file


Add following in layout xml file as station_input.xml





&amp;lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&amp;gt;

&amp;lt;LinearLayout </summary><link rel='replies' type='text/html' href='http://tekpot.blogspot.com/2012/08/android-load-autocompletetextview-based.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/8075685965823525107'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/8075685965823525107'/><link rel='alternate' type='text/html' href='http://tekpot.blogspot.com/2012/08/android-load-autocompletetextview-based.html' title='Android AutoCompleteTextView data binding based on another AutoCompleteTextView selection'/><author><name>Balasubramanian Shanmugam</name><uri>http://www.blogger.com/profile/13187295003202608339</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1678601896864190463.post-8267795507119383433</id><published>2012-08-03T16:57:00.001+05:30</published><updated>2012-08-13T13:05:27.771+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Andorid Apps"/><category scheme="http://www.blogger.com/atom/ns#" term="Android"/><category scheme="http://www.blogger.com/atom/ns#" term="sqlite"/><title type='text'>Build an Android app using existing SQLite database</title><summary type="text">

Step by step guide to use existing sqlite database file in Android application.


Step 1.
Prepare the SqLite database file


Step 2.
Create a table android_metadata in the database,

CREATE TABLE &quot;android_metadata&quot; (&quot;locale&quot; TEXT DEFAULT &#39;en_US&#39;)
Insert a record as follows

INSERT INTO &quot;android_metadata&quot; VALUES (&#39;en_US&#39;)
Step 3.
Rename primary Id fields of existing tables as _Id. So that </summary><link rel='replies' type='text/html' href='http://tekpot.blogspot.com/2012/08/step-by-step-guide-to-use-existing.html#comment-form' title='3 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/8267795507119383433'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1678601896864190463/posts/default/8267795507119383433'/><link rel='alternate' type='text/html' href='http://tekpot.blogspot.com/2012/08/step-by-step-guide-to-use-existing.html' title='Build an Android app using existing SQLite database'/><author><name>Balasubramanian Shanmugam</name><uri>http://www.blogger.com/profile/13187295003202608339</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>3</thr:total></entry></feed>