If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > PostgreSQL > PocketLOG - debugging SQL

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-07-10, 15:49
immek immek is offline
Registered User
 
Join Date: Jun 2010
Posts: 2
Exclamation PocketLOG - debugging SQL

Hi,
My name is David. I would like to present you my idea for debugging SQL applications - I've called it PocketLOG.

PocketLog is a program that captures and analyses TCP/IP traffic (queries, data and noticies) between PostgreSQL database and any other application (connected without SSL encryption to a non-localhost server).

I've written it for my own use and it has diametrically changed quality of debugging database applications.
I think it's worth sharing and evolving. If you agree with me and You'd like to get the full version, please support my work with a small donation =).

Features:
  • capturing queries
  • executing queries (using PGAdmin configuration)
  • capturing data (query results)
  • capturing notices
  • SQL beautifuler
  • filters with regular expressions

You can download PocketLOG from here.
To run the program you will also need the WinPCap library.

I've created a small tutorial to show you how to start.

NOTE: You have to remember that this version is still in eeeearly beta phase and it has a few (more or less important) bugs

I hope You'll like the idea
Reply With Quote
  #2 (permalink)  
Old 07-08-10, 11:53
artacus72 artacus72 is offline
Registered User
 
Join Date: Aug 2009
Location: Olympia, WA
Posts: 337
Is that a pocketlog or are you happy to see me?
Reply With Quote
  #3 (permalink)  
Old 07-08-10, 12:39
immek immek is offline
Registered User
 
Join Date: Jun 2010
Posts: 2
a bit of both, i guess

Last edited by immek; 07-08-10 at 12:43.
Reply With Quote
Reply

Tags
debug, pocketlog, postgres, sql

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On