Thread: ANN: PgBrowse 1.4
PgBrowse ver 1.4 is a generic Postgresql database browser that works on Windows, Macintosh and Linux platforms that is written in Tcl/Tk. A Starpack is available for Linux/x86 and an application bundle is available for MacOSX. What is new in 1.4? o Fixed a bug where fields greater than 200 characters could not be edited. o Added the ability to insert or update bytea fields in the editor. If the edit buffer contains the unquoted word BYTEA for the value of a column then when an UPDATE or INSERT is done the program will allow the user to select a file to be used as the contents of the field. A couple of features that help differentiate this (free) tool. 1) No postresql software is actually needed on the client. 2) PgBrowser can display graphical images stored in the database as bytea or large objects (via the Img package). 3) PgBrower supports SQL libraries of your favorite queries. At startup PgBrowser looks for "~/SQLScripts" and builds a menu of all members of the directory that end in ".sql". Subdirectories will generate the appropriate submenu. Selecting a menu item will load the SQL window with the query. 4) PgBrowser supports a "history" of queries/commands passed to the backend. Previous commands can be easily recalled from the keyboard. Gracefully exiting the program will cause the history to be stored in "~/SQLScripts" as HiStOrY.tcl. This file will be "sourced" at program startup to recover the command history. 5) If PgBrowser is running on a Mac or Linux system that has "psql" located in a standard location, it is possible to execute "psql" commands from within PgBrowser. 6) Individual fields can be extracted and saved to user specified files. This includes bytea and large object fields. 7) A simple grid based table editor is now available to make changes in the database. For more information and download visit: http://homepage.mac.com/levanj/TclTk Suggestions for improvements and bug fixes gladly accepted. Thanks, Jerry
Jerry LeVan wrote: > PgBrowse ver 1.4 is a generic Postgresql database browser that works on > Windows, Macintosh and Linux platforms that is written in Tcl/Tk. > A Starpack is available for Linux/x86 and an application bundle > is available for MacOSX. Sounds interesting. In the future please send announcements to pgsql-announce. Sincerely, Joshua D. Drake -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PLphp, PLperl - http://www.commandprompt.com/