Install Postgres database on Windows and allow password less access

Install Postgres Database on Windows and allow password less access for the database to be used in various applications.

  1. Install Postgres database on Windows machine by downloading the executable file from here: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
  2. 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.
  3. phpPgAdmin can be downloaded and setup on Apache server to manage the databases from a web based enviornment. http://phppgadmin.sourceforge.net/doku.php?id=download

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.

  1. Edit postgre configuration file: C:\Program Files\PostgreSQL\9.2\data\pg_hba.conf
  2. Change all configuration access to:
  3. Restart the postgres server. Go to Control Panel > Administrative Tools > Services > Restart the Postgres service.

How to delete chat history of a particular user/contact in Skype [Solved]

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.

Note:
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.

Caution:
Take backup of main.db file before implementing anything from these steps.

Steps:

  • Download the DB Browser( SQLite Browser ). Its free and open source.
    You can get it from here: http://sourceforge.net/projects/sqlitebrowser/
  • Signout and Quit your Skype.
  • Go to the directory below and take a backup of the file main.db file. Just copy the directory itself or the file and keep it somewhere else for safety.

    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.

Open Skype and see the changes… Enjoy 🙂

sqlitebrowser[ Download sqlitebrowser: http://sourceforge.net/projects/sqlitebrowser/ ]

main_db_path

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
  • view any database table and and export their data
  • change, add or delete data in any table
  • execute direct SQL queries