Here is a freebie for MacOSX users... BiggerSQL is a postgresql
browser and more. Only tested on MacOS X 10.3.2 and Postgresql 7.4.1.
Cocoa source is part of the package. I understand that BiggerSQL
might need to be rebuilt if your backend is not compatible with
the 7.4 release. The program links with libpg for most of the
dirty work.
Feedback and suggestions welcomed...
BiggerSQL Version History.
Available at: http://homepage.mac.com/levanj/Cocoa
Feb 29, 2004
Version 1.0 released. Features include an info drawer which
shows info about the tables that the user owns, support for
execution of selections or individual lines in the editor window
and support for reasonably formated PL/pgSQL definitions. On line
help for SQL commands and running the program
Mar 4, 2004
Version 1.1 released. This version added drag and drop of
text files to the editor window.
Mar 7, 2004
Version 1.2 released. Added all viewable tables and views to
the info outline view. Double clicking on a table/view in the
info drawer will clear the editor window and execute a
"select * from <selected table>" command.
This facilitates browsing the database.
Two major memory leaks were discovered and plugged. This revealed a
major problem with how the info panel was being refreshed.
Hopefully this bug has been squashed.
Mar 8, 2004
Version 1.2.1 released. I decided that showing all of the
system tables all the time was a bit much, so I added a
menu item to the 'File' menu to enable/disable the display
of the tables in the pg_catalog and information_schema schemas.
Mar 9, 2004
Version 1.2.2 released. This version adds a script menu.
During startup BiggerSQL looks for the directory ~/Library/BiggerSQL.
If it is not present the directory is created. If the directory
exists it is scanned and any file ending with ".sql" will generate
a menu item having the file's name in the Scripts menu. The user
is encouraged to save their favorite sql scripts in this folder.
Selecting such an item will cause the editor window to be replaced
with the contents of the file. The first item in the Scripts menu
is "Open Script Folder". Choosing this item will cause the scripts
folder located in the users Library directory to be opened by the
Finder and made the front most window. The user could then drag
files from this window onto the editor window.
--Jerry
