Free postgresql software for mac

igSQL is a PostgreSQL client (not unlike psql). It enables the user to send SQL to a server and display the result.

Requirements:

• Mac OS X 10.3 or later
• Postgresql 7.4 or later.

Whether you want to learn SQL or need a tool to look at the inner working (see the "Log" on the screen shot below) of the PostgreSQL server while you program a client application for it, EduPhant will be the answer.

You can use EduPhant regardless of your language or favorite operating system since it supports any text encoding PostgreSQL supports and works on Mac OS 8 and 9, OS X, Windows, and we have an experimental build for Linux too now.

Most other SQL clients dumbly enter data in PostgreSQL in their operating systems default text encoding, regardless of the encoding in which your database has been defined. This results in corrupted data that isnt usable cross-platform or with other clients that do respect the text encodings like EduPhant. The corruption is most noticable with non-ASCII characters like an accented "e."

EduPhants SQL query templates will allow the novices to quickly pick up the SQL syntax and logic, or they will jog the memory of the more advanced users. Plus they make it a breeze to rapidly construct your SQL queries. When you click on cells or headers of the query results table or of the database overview table, you enter their content into your query -- another very practical feature to reduce typing (and typos). You can also store your own custom SQL templates.

H2 is an SQL database engine written in Java (but also available as a native binary). JDBC and ODBC APIs are supported. Embedded and server modes are available. A Web console application is included. Clustering is supported. H2 Database Engine is a web based java database engine.
Main features:
- Fast database engine
- Free, source code is included
- Supports standard SQL
- Written in Java
- Disk based or in-memory databases
- Browser base Console application
- JDBC API
- Limited ODBC support
- Embedded and client/server (network) mode
- High availablility support (clustering / failover)
- Wide range of data types including large objects (BLOB/CLOB)
- Strong security features (SSL, users, roles, encrypted files)
- Multiple connections, table level locking
- Cost based optimizer, using a genetic algorithm for complex queries
- Transaction support (serializable transaction isolation)
- Zero-administration, automatic recovery
- Large resultset, external sorting
- Scrollable and updatable resultset support
- Read only views and inline views
- Inner and outer joins, subqueries
- Many functions already built-in
- Triggers and Java functions / stored procedures
- Referential integrity / foreign key constraints with cascade, check constraints
- Multiple schema support
- Compatibility modes for HSQLDB, MySQL and PostgreSQL
- Sequence and autoincrement columns
- Well tested (high code coverage, randomized stress tests)
- Small footprint (smaller than 1 MB)
- Uses a small number of database files
- Can be compiled to native code using GCJ
- Primary keys, multiple index types (b-tree, linear hash, tree, hash)
- ORDER BY, GROUP BY, HAVING, UNION, LIMIT
- Information Schema
- Multiple connections
- Collation support
- EXPLAIN PLAN support
- The database can generate SQL script files
- Support for linked tables, and a built-in virtual range table
- Automatic re-compilation of prepared statements
- Sophisticated trace options
- Low memory requirements
- Easy to understand exception messages
- Standard handling of NULL values
- Multilanguage console application (at this time, English and German).

Rekall is a database front-end, somewhat in the style of Microsoft Access(tm). However, Rekall is not itself a database, and does not include a database. By this we mean that data is stored somewhere else in an SQL server, and Rekall is fundementaly just a tool to extract, display and update that data (of course, it does lots more than that, it does forms and reports and scripting and .... you get the idea). It is database agnostic, and does not have any preferred database.
Main features:
- Rekall can do lots of the things that you would expect of a database front-end (or if it cant, let us know!).
- You can design and use forms and reports, you can construct database queries, and you can import and export data (actually, you can copy data, import is just copy file to table, and export is just copy table to file).
- You can also create reusable components which you can use in forms and reports, to reduce application development time.
- Rekall can be scripted using the the Python language. You can arrange that a script is executed when various events occur (for instance, when the user changes the value of a control). Scripts can be associated directly with the event, but you can also store scripts in script modules for more general use. And, of course, you have full access to all the modules that are available for Python.
- Plus, Rekall has an integrated Python debugger with syntax highlighting.
Enhancements:
- Rekall RunTime application included
- drivers for xbase/xbaseSQL, mySQL and PostgreSQL.

pgAdmin III is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. The application may be used on Linux, FreeBSD, Solaris, Mac OSX and Windows platforms to manage PostgreSQL 7.3 and above running on any platform, as well as commercial versions of PostgreSQL such as Pervasive Postgres, EnterpriseDB, Mammoth Replicator and SRA PowerGres.

pgAdmin III is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more. Server connection may be made using TCP/IP or Unix Domain Sockets (on *nix platforms), and may be SSL encrypted for security. No additional drivers are required to communicate with the database server.

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.
Rather than having one window to view table information, one window to view data and another for executing SQL, PGnJ provides a single, uncluttered window for a single connection.

Main features:
- Supports PostgreSQL and MySQL.
- Connection bookmarks.
- Database tree and column inspector.
- Query editor.
- Syntax highlighting and error suggestion.
- Table data viewer and editor.
- SQL execution history with quick navigation from editor.
- Export data in SQL, XML, CSV, HTML and TSV.
- Automatic software update.

Enhancements
- [NEW] Oracle support added.
- [NEW] SQLite support added.
- [NEW] Tab completion support for table and column names added to the query editor.
- [NEW] A Script Library for managing SQL scripts added (:variables supported).
- [NEW] A template system for generating DDL SQL templates.
- [NEW] A common toolbar has been added to the Query Editor and Script Library views.
- [NEW] A filter bar (CMD+F to focus) to filter and order data with SQL added in the DataBrowser.
- [NEW] The bookmark manager can now remember connection passwords.
- [NEW] The execution engine has been completely rebuilt from scratch to better handle multiple queries regardless of type.
- [NEW] The database tree now automatically refreshes when DDL is detected.
- [NEW] The database trees state is now recalled when the database is refreshed (expanded nodes remain expanded, selected node remains selected).
- [NEW] SQL can now be executed directly from a file without first loading it into the query editor (for larger scripts).
- [NEW] It is now possible to drop one more files directly onto the query editors input area to load sql.
- [NEW] Right clicking on a result set now reveals a pop-up menu that allows copying the content of either a single cell or the entire row in CSV format to the clipboard.
- [NEW] The bookmark manager now remembers the last selected database type to ease the task of adding bookmarks.
- [NEW] Table details are now pre-fetched in a background thread after connection to database is established.
- [NEW] A drag handle has been added to the bottom left action bar to make resizing the sidebar easier.
- [NEW] PGnJ can now remain running without any windows open (like standard Cocoa applications).
- [NEW] Experimental horizontal scroll wheel support added (use preference to toggle).
- [NEW] Added preference to convert all zero datetimes in MySQL to NULL (on by default; off causes exception).
- [NEW] Added menu items and keyboard shortcuts to navigate the table details at the bottom of the sidebar.
- [NEW] A shortcut (CMD+T) to focus on the database tree in the sidebar has been added.
- [NEW] A shortcut (CMD+W) to close the preferences window when it is visible has been added.
- [NEW] When started, PGnJ now specifically asks if its okay to check for updates rather than defaulting to autochecking.
- [CHANGE] CSV Export no longer wraps integers, floats and booleans in quotes.
- [CHANGE] The connection sheet and bookmark manager are now fully keyboard navigable.
- [CHANGE] The connection sheet now cancels on escape.
- [CHANGE] The keyboard shortcut CMD+E and menu item Database > Execute SQL now executes SQL when the QueryEditor is visible and reloads the DataBrowser when the DataBrowser is visible.
- [CHANGE] Altered the row selection behavior on the database tree so that clicking on an expand/collapse arrow doesnt highlight that row unless the currently selected row is a child of that row.
- [CHANGE] When using CMD-UP/CMD-DOWN quick history from the Query Editor, if there is SQL currently in the Editor, it is added to the history so that it isnt lost.
- [CHANGE] The history browser (CMD-SHIFT-H) no longer automatically executes a SQL statement after selecting it and appropriately cleans up the query editor before loading the selected SQL.
- [CHANGE] Connection sheets are now correctly document modal.
- [CHANGE] Menu items are now properly enabled or disabled based on the context of the application.
- [CHANGE] Where necessary, tooltips are assigned to disabled menu items to explain how they can be enabled.
- [CHANGE] All tables are now borderless to be more in line with current trends in OS X application design.
- [CHANGE] The background color of the sidebar has been darkened slightly to better resemble the sidebar background colors of other OS X applications.
- [CHANGE] Polished dialogs with more appropriate copy and icons.
- [CHANGE] The QueryEditor now receives focus upon a successful connection to a bookmark.
- [CHANGE] When resizing the window, the sidebar now only grows the area containing the database tree rather than the table details section at the bottom.
- [CHANGE] Updated Quaqua LAF to version 5.0.1.
- [FIX] Now able to issue ALTER, CREATE and DROP statements to MySQL databases.
- [FIX] When a new bookmark is setup to connect to, it is now only added if the connection is successful.
- [FIX] The AutoCheckForUpdates preference is no longer (accidently) ignored.
- [FIX] Style changes in the query editor are no longer registered in the undo/redo history.
- [FIX] When loading a sql file, the QueryEditor properly replaces the current view.
- [FIX] Dialogs (sheets) now correctly gain focus, enabling keyboard interaction.
- [FIX] Columns of a table no longer sporadically appear multiple times in the table details area.

With Mac OSX Unix port (Darwin) it is posible to use software like PostgreSQL, Apache or Tomcat.
I sometimes use these kinds of software and wanted to get rid of opening the Terminal and type in the start and stop commands each time. Some of them like mysql come packaged with installers and have PreferencePanels. But I wanted something that is able to deal with multiple programs at a time. And there the idea of Cocser was born.
To bring it to the point, Cocser is a Cocoa tool for calling terminal applications or scripts with displaying the stdout and stderr streams. Application Set entries get saved and loaded on startup.
It should run on Mac OSX Tiger, 10.3.x. For Jaguar (10.2.x) it should work as well but this is untested.
Enhancements:
- Added native Intel-Mac support.