How to Open/Browse sqlite files in Linux?

What is sqlite?
As per "wikipedia"
    SQLite is a relational database management system contained in a C programming library. In contrast to other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program.
   
Where it is used?
    Browsers,
    Mobile Operating systems
    Mobile Apps,
    Web Frame Works like Django, Ruby on Rails etc.,
   
In (Debian based)Linux (am Using BOSS GNU/Linux) there are many GUI/CUI applications available to work with sqlite. Few of them are
CUI:
    sqlite
    sqlite3
   
GUI:
    sqlitebrowser (Now renamed as  "SQLite Database Browser" or simply DB browser)
    sqliteman (Download from here http://sqliteman.yarpen.cz/)
    sqlitestudio (Download from here http://sqlitestudio.pl/)
   

How to install chrome extensions/plugins/add-ons from unofficial sites?

By default google-chrome browser allows to install the extensions that are got from google's chrome webstore only.  So, what if you not find a useful extension in chrome's web store but available/downloadable with some third party website...?   How to install those extensions(.crx files)?

* Basically the google-chrome's extensions are .crx files.
* The extensions that available with chrome webstore be installed directly
* To install these third party extensions do the following.

1. Open your chrome browser -> Click on the  symbol(at the right top, just below the close,minimize buttons of the browser window) -> Tools -> "Extensions"
2. Now open the directory where you have your third party chrome extensions(.crx files), then drag and drop the .crx file into the chrome browser tab where the "Extensions" is open.
3. Now google-chrome browser will prompt you with "cancel" & "add" button.  Click on the "add" button the extension will be added to the browser.

How to view tamil(or any regional language) websites, blogspots in android phones without installing fonts?

1. Install opera mini from google play
2. Launch the opera mini browser in your mobile
3. In the address bar type "opera:config" [without quotes]
4. Scroll to the end of the page & search for "use bitmap font for complex scripts" and enable(yes) it.

Thats all... :) now open any tamil web page that will be looks properly.

Note:
1. Remember with this method you can only view the web pages in tamil(or any other language) and you can't write.  But one is not needed to install any fonts.
2. With this method, actually the browser shows the full web page as a bitmap image.  So, regardless of language all the webpages will be rendered properly.

How to know your gmail friend is chatting(keyboard not video) from his android mobile or from browser?

Nowadays Smartphone user base is increased in multi-fold manner.  So while we chatting we don't know whether the person at the other end is chatting with you is using his browser and keyboard are he is chatting from his android mobile.

Picture 1. - Gmail gear

Here is the simple solution,
You just need to enable the google labs' Green Robot! 
So, how to do that
1. Login to you gmail account

2. Click on settings
    Your gmail setting is at the right top of the gmail window with the gear symbol(see picture1 gmail settings).  Click on that now you will get a drop down menu with options like settings, themes, help etc.  Select settings

3. Now gmail will load the settings page with options like General, Chat, Filters, Labs, Mail Forwarding etc(see picture 2 - gmail settings options).

Picture 2 - Gmail settings options

4.  Select labs and search for Green Robot! then enable it.  Thats all... :) !


Now in your chat window you can see a small Green/Red/Orange(according to active/idle/busy) Robot icon to some of your friends who are online but from their mobile.

How to install extensions of google chrome? / "Add to chrome" button missing/not shown.

First is first..
1.  Why i write this blog post.
  Previously i have google chrome browser (version details are in the following image)

google-chrome old version

When i try to install the chrome extensions in this browser.. i can search, view, read about the extension, can see the review and so.. but the problem is there is no "Add to chrome" button anywhere in the extension detail.. :(

I spent 10 minutes to find the solution but.. no fruitful information is found.  So, atlast i reinstalled my google chrome browser with the newer version(details in the following image).  Now when i browse for the extensions, it shows "Add to chrome" button also.  So, i can easily install the extensions now.

google-chrome new version

2.  How to steps
2.1 Go to the google chorme extensions website
* Click on the wrench -> Tools -> Extensions -> Get more extensions (or)
* Directly going to the chrome's webstore.
* Open new tab, at bottom you can see a label named "Apps" click on that, then click on chrome web store
2.2 Browse the extension in the "search the store" text field and finalize which extension you want
2.3 Click on the extension, there you can see a "Add to chrome" button, just click on it.. Your extension is installed.

Link to the Dictionary extension.

How to restore the last session(auto open previously opened pages) in google chrome?

The default setting of google chrome is not set to restore the previous session.  So how to let it to restore the previous session

1. Click on the wrench symbol in the chrome browser or press Alt + f key

2. Select or click the "Preferences".  This will open a new tab in your chrome browser.

3. Now Click on the "Basics" label from the left side

4. Now select the radio button with the value "Reopen the pages that were open last" thats all. 

How to fix "Missing plugin error in google-chrome in linux" when open/download pdf file?

I tried to download a pdf file using google-chrome, when i do so google-chrome tries to open it in browser itself and shows the "Missing plug-in" error as shown in the following image.

The solution is as follows.

1. Open a new google-chrome brower window.

2. In address bar type "about:plugins" without quotes and hit enter. Now you will see the following details in you

r browser. The following image shows it.

3. Now click on the disable button of "MozPlugger 1.14.1 handles Quick

Time and Windows Media Player Plugin"

Thats all now you can download pdf files as like any other files, now chrome won't try to open it in browser itself, instead it prompts you to give filename for saving it.

give your comments & feedbacks, bouquets & brickbats.. that will let me give the blogposts with more and exact information needed by others.