pgAdmin tool can be downloaded and setup on Windows machine to view and manage the databases and tables by downloading the executable file from here: https://www.pgadmin.org/download/ Make sure to check the Postgres version and compatible version of the pgAdmin tool.
Now, for applications running on private & internal LAN setup, a password less access to the the postgres database is required. To allow login into the database without a password, a simple modification to the pg_hba.conf file is required.
Skype, one of the most used VOIP client software for communication inside organizations. One problem with this software is that: by default you can’t remove chat history for a specific contact. To delete chat history of a particular user/contact in your Skype, you have to use a DB browser software( sqlitebrowser ) to read the local DB files and make the changes. Follow the steps below to remove any history for a specific user from your system.
This removes the history form your local system; not from the other side of the Skype contact. So, he/she can see those from his/her computer.
Take backup of main.db file before implementing anything from these steps.
Replace ‘skype_username’ with your skype user name in the above path.
Extract and run the sqlitebrowser software and open the Skype DB file(main.db) located here:
C:Users’windows_username’AppDataRoamingSkype’skype_username’main.db Replace ‘skype_username’ with your skype user name in the above path.
— Click on the browse data tab. Here you can have all the tables that are being used to store history data in Skype.
— Search the records by the particular user and delete those records. Mainly the chat related records reside inside ‘Chats’, ‘Messages. table.
— Go to Browse data tab -> select table Messages -> click on find icon ->
select author -> contains -> skype profile name of user you are searching for ->
click on one of the last results in the list and you will see the row.
— Select the records and click on ‘Delete Record’ button.
At last don’t forget to click on the save changes icon.
Update: There is one free & open source software available for achieving all of the above manual trick. Skyperious: Skyperious is a Skype database viewer and merger, written in Python. You can open local Skype SQLite databases and look at their contents:
search across all messages and contacts
browse chat history and export as HTML, see chat statistics
import contacts from a CSV file to your Skype contacts