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/)