Mac DownloadsDevelopmentEditorsPGnJ 0.6

PGnJ 0.6


PGnJ is an application, written in Java, for managing PostgreSQL databases.
Developer:   Thomas Mango
      more software by author →
Price:  0.00
License:   Freeware
File size:   1974K
Language:   
OS:   
Rating:   0 /5 (0 votes)
Your vote:  
enlarge screenshot


PGnJ is an application, written in Java, for managing PostgreSQL databases. Unlike many database management applications, PGnJ provides (and will continue to provide more) extended functionality and information by generating and running SQL statements. By doing this, it is easy to create a unified interface rather than having, for instance, one window to view table information, one window to view data and another completely separate window for running arbitrary SQL statements. PGnJ provides a single, un-congested window for a single connection. I feel that this interface design is much cleaner and generally more enjoyable to use than other implementations of database management applications.

Here are some key features of "PGnJ":
  • Connect from connection bookmarks
  • Create new connection bookmarks
  • Table list loaded when connection established
  • View table data by double clicking a table
  • Get column names, types and primary keys
  • Execute arbitrary SQL statements
  • Open multiple browser windows
  • Load SQL from file
  • Save SQL to file
  • Export data to CSV and HTML.

    What's New:
  • Table details are now lazy loaded rather than fetching them on connect. This makes connecting to databases almost instantaneous.
  • Added support for sequences when using PostgreSQL. Double click a sequence to open the alter sequence wizard.
  • Added ability to double click a view and bring it up the pageable table data editor in non-editable mode - thanks, Mark!
  • Added a window manager that cleanly closes database connections of all windows before disposing each window.
  • Added a cancel button to the query editor to stop a query from executing.
  • Added a cancel button to the data browser to stop table data from loading.
  • Added a cancel button to the connection sheet to stop a hanging connecton.
  • Error checking added to bookmark manager / connector to prevent corruption of the bookmarks.xml file - thanks, Lorgio!
  • Sheets no longer displayed when SQLException gets thrown. Exception only displays in status bar (tool tip available).
  • Password field is now disabled while trying to connect.
  • Table Data Editor now displays total row count of entire table instead of the number of rows showing.
  • Updated Quaqua LAF to version 3.6.6.
    tags table data  sql statements  cancel button  connection bookmarks  double click  arbitrary sql  data editor  view table  pgnj provides  management applications  rather than  one window  database management  


    Download PGnJ 0.6


     http://www.trikenit.com/files/PGnJ/PGnJ_0.6.dmg.zip


    Authors software

    PGnJ 0.6 (by Thomas Mango)
    PGnJ is an application, written in Java, for managing PostgreSQL databases.

    Piki 1.0rc1 (by Thomas Mango)
    Piki is very simple and lightweight Wiki software meant for personal use.


    Similar software

    PGnJ 0.6 (by Thomas Mango)
    PGnJ is an application, written in Java, for managing PostgreSQL databases.

    Interrogate 0.7.5 (by Ex-Spectator Software)
    Interrogate is an open-Source, MySQL database manager.

    SQLGrinder 2.0.4 (by Advenio, LLC)
    SQLGrinder is a native Mac OS X SQL editor and developer tool.

    YourSQL 1.8.0e (by Magister Ludi)
    YourSQL is a client application that allows you to remotely connect to MySQL databases for management through a graphical interface.

    Music Assistant 1.0 (by Custom Solutions of Maryland)
    Music Assistant was developed to help set a tempo and tune your instruments.

    Froq 1.2 (by Alwin Troost)
    Froq is still a work in progress, but now available to the public as a PUBLIC BETA, to allow for public testing.

    SQL4X Manager J 3.5 (by InterServices New Media)
    SQL4X Manager J is the professional tool to access and manage your database server with Mac OS X.

    SQLiteManager 2.5 (by SQLabs)
    SQLiteManager is a database manager for SQLite databases.

    Databrid 1.0 (by Datarid)
    Databrid is a browsing, retrieval and manipulation tool designed for the
    novice to the expert user.

    CocoaMySQL 0.5 (by Lorenz Textor)
    CocoaMySQL is an application to manage MySQL databases (locally or over internet).


    Other software in this category

    Rezilla 1.0.8 (by Bernard Desgraupes)
    Rezilla is a resource forks editor for the Macintosh.

    SQLEditor 1.3 (by MalcolmHardie Company)
    SQLEditor is a tool that allows you to create SQL databases graphically.

    Chipmunk BASIC 3.6.3b1 (by Ron Nicholson)
    Chipmunk Basic for Mac OS is an old fashioned Basic interpreter which runs on almost all Macs.

    AppHack 1.1 (by Sveinbjorn Thordarson)
    AppHack is a powerful developer and theming tool to alter, replace or extract the property lists or icons of Mac OS X application bundle packages.

    CRiSP 9.0.5b (by Pacemaker Software)
    What started as a Software Programmer’s Editor has now developed into an extremely sophisticated cross-platform File Editing Environment.

  •     search


    Featured Software

    Picture Address Book 6.0.5
    Apimac Address Book is a practical telephone and address program for Mac that allows you to quickly and easily manage addresses, phone numbers, URLs and Email addresses.

    Textris 1.0
    Textris is an attempt to combine aspects of both these games into one fast paced test of your lexicon.

    iMagine Photo 2.1.4
    iMagine Photo adds imaging and drawing functionality to AppleScript.


    Subscribe in Rojo
    Google Reader
    Add to My Yahoo!

    Add to My AOL
    Subscribe with Bloglines
    Subscribe in NewsGator Online
    Add 'rbytes.net free downloads' to Newsburst from CNET News.com
    del.icio.us rbytes.net free downloads


    Top tags

    modem drivers   dvd player   sound keys   keys   apple   server   midi   dashboard widgets   slimserver   checksum