Free postgresql database software for mac

PostBooks is a full-featured, fully-integrated accounting, ERP, and CRM system, based on the award winning OpenMFG ERP Suite.
Built with the open source PostgreSQL database, and the open source Qt framework for C, it provides the ultimate in power and flexibility for a range of businesses and industries.
PostBooks includes the following modules:
- Accounting (general ledger, accounts receivable and payable, bank reconciliation, financial reporting)
- Sales (quotes, order entry, sales reporting, shipping)
- CRM (universal address book, incident management, opportunity management, to-do lists, project management)
- Purchasing (purchase orders, receiving, vendor reporting)
- Product Definition (items, infinite-level bills of material)
- Inventory (multiple locations, other advanced warehouse features)
- Light Manufacturing (work orders, strong support for make-to-order)
- OpenRPT open source report writer
Like all xTuple products, it runs equally well on Mac OS, Windows, Linux - and is fully internationalized (multi-currency, support for multiple tax structures, and multilingual translation packs maintained by our global community).
NOTE: PostBooks is licensed under the CPAL, the OSI-certified Common Public Attribution License.

Enhancements
New Features:
- [All] Added api.itemcost view
- [Accounting] Moved Email Invoice menu item to Accounting module menu
- [Accounting] Enhanced Voucher voiding to also undo distributions
- [Accounting] Added ability to print Checks alphabetically by Vendor Name
- [Accounting] Added ability to Post CMs and Invoices from embedded tab screens in Customer Workbench
- [Accounting] Added new CM button to Credits tab on Receivables WB
- [Accounting] Added option to post from Invoices tab in Customer WB
- [Accounting] Added trigger to close Incident Related to Invoice
- [CRM] Added ability to add new Opportunities from Account screen
- [Inventory] Prevented Shipping recall if Invoice posted
- [Inventory] Added description column on PO and receiving screens
- [Inventory] Added help for users with activate/deactive of Items
- [Inventory] Allowed selection of a new Location default from the Relocate Inventory screen
- [Purchase] Added unique constraint for pohead_number
- [Sales] Added "active" column (Y/N) in Customers by... displays
- [Sales] Included baseline Sales Order acknowledgment form
- [Sales] Added Workbench button to Customer Search screen
- [System] Allowed print to PDF from scripts
- [System] Created package development mode
- [System] Added UPC code cross reference and search to Item cluste
- [System] Provided method to open screen builder screens from other screen builder screens
- [System] Added more navigation info to Alarms
Bug Fixes:
- [All] Fixed compiler warning on xcheckbox.cpp
- [All] Required Main Window to remember its size for the next login
- [Accounting] Fixed issue with List Unposted Invoices total amount not including tax+freight+other
- [Accounting] Fixed issue with the Accounts widget not calling the latest window
- [Accounting] Resolved deadlock scenario when two people distributing to/from the same lot/serial/locations
- [Accounting] Fixed Refund feature for for Authorize.net CC users
- [Accounting] Fixed issue leading to ERROR: null value in column "gltrans_amount" violates not-null constraint
- [Accounting] Fixed issue leading to -8 failure when posting Cash Receipt for Credit Card
- [Accounting] Fixed issue where amending Profit Center numbers did not apply to all Account Numbers
- [Accounting] Updated privileges to allow posting Voucher with only accounting privileges
- [Accounting] Made Invoice displays consistent
- [Accounting] For Fiscal Years, prevented entry of the end date prior to the start date
- [Accounting] Modified Voucher tab sequence to resolve data dependency issues
- [Accounting] Prevented creation of duplicate Tax Selections
- [Batch Manager] Fixed CANCEL button on Configuration Options screen
- [Batch Manager] Fixed SalesHistorybyCustomerGroup report to display data when run through the Batch Manager
- [CRM] Prevented creation of duplicate Titles
- [CRM] Fixed issue leading to error when selecting to delete an Opportunity related with CRM account
- [CRM] Prevented creation of empty records for Tasks
- [Inventory] Filtered recv rows selected by recv_trans_usr_name=CURRENT_USER to avoid problems when multiple users simultaneously receiving the same order
- [Inventory] Fixed issue leading to errors when posting Lot/Serial Count Tags
- [Inventory] Fixed issue leading to error on Query QOH by Location in PostBooks
- [Inventory] Fixed issue with Packing List form not being updated correctly if Ship Via changed after Stock issued
- [Inventory] Fixed issue with List Site locations printing partial information
- [Inventory] Removed obsolete code in postBillingSelection
- [Inventory] Added Alias information to key forms (e.g., Ship Confirmation and Packing List)
- [Manufacture] Restored Item description information on Inventory availability by Work Order screen
- [Manufacture] Fixed issue where Notes and Ref Designators were not copying from one BOM to another
- [Manufacture] Fixed issue leading to error when querying Work Order History by Work Order report
- [Products] Fixed incorrect or missing UOM data in Where Used screen
- [Products] Fixed issue preventing addition of Work Center Labor rates greater than 1,000
- [Purchase] Allowed changing of Purchase Order qty. with only "ChangePurchaseOrderQty" privilege
- [Purchase] Prevented entry of non-Inventory information on Purchase Order Item screen unless Non-Inventory radio button explicitly selected
- [Purchase] Added missing fields to Warehouse info view
- [Products] Fixed issue leading to error when selecting to post Actual Costs
- [Products] Worked to prevent scenario enabling division by zero error if Breeder BOM incomplete
- [Products] Prevented reassignment of blank Product Category patterns
- [Products] Prevented reassignment of blank Class Codes
- [Products] Fixed inconsistent operation of Mass Replace feature
- [Products] BOO can now be edited without saving the item first
- [Reports] Added bomitem_id and ecn to Indented BOM function
- [Reports] Added atShipping information to data source of Packing List
- [Sales] Changed overload functions to call itemCharPrice (rather than itemPrice)
- [Sales] Updated triggers so that when child line items of a Kit have their status changed then parent line item is updated as needed
- [Sales] Improved performance of S/O Line Item List on large databases
- [Sales] Prevented deletion of Sales Orders having linked, in-process Job Item Work Orders
- [Sales] Fixed Running Availability to work from Sales Order Backlog screen
- [Sales] Fixed issue with Backlog by Product Category report displaying Sales Order Number as Currency
- [Sales] Prevented reassignment of blank Customer Type patterns
- [Sales] Added "grace days" information to api.customer view
- [Sales] Enforced update of Unit price on UOM conversion
- [Sales] Prevented editing of Return line items in view mode
- [Schedule] Prevented deletion of Item Sites having active Production Plans
- [System] Fixed issue leading to error when deleting packages
- [System] Fixed issue leading to error when assigning Employees as their own Manager
- [System] Enforced rule that decimal precision in Locales should reflect the actual precision
- [System] Fixed issue leading to error when making changes to Accounting Configuration
- [System] Fixed error encountered when importing data using api.bomitem
- [System] Prevented creation of duplicate Shifts
- [System] Prevented creation of duplicate Locales with same code and details
- [System] Fixed issue leading to error when creating duplicate Employee records

PostgreSQL Database Server for Mac OS X 8.1.4 offers a simple and effective relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, SunOS, Tru64), BeOS, and Windows. If you need a PostgreSQL Database GUI, you can download NAVICAT PostgreSQL GUI.

It supports to import CSV, XML or other formats to PostgreSQL. PostgreSQL is an open-source descendant of this original Berkeley code. It supports a large part of the SQL: 2003 standard and offers many modern features: complex queries, foreign keys, triggers, views, transactional integrity, and multi-version concurrency control. Also, PostgreSQL can be extended by the user in many ways.

Enhancements: May include unspecified updates, enhancements, or bug fixes.

PostgreSQL 8.4.1 is regarded as an innovative and versatile database system which has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, SunOS, Tru64), BeOS, and Windows. PostgreSQL Database server already embedded a useful GUI - PGadmin.

PostgreSQL is an open-source descendant of this original Berkeley code. It supports a large part of the SQL:2003 standard and offers many modern features.

Major Features:

1. Complex queries
2. Foreign keys
3. Triggers
4. Views
5. Transactional integrity
6. Multiversion concurrency control

Navicat Premium 8.1.5 is regarded as a professional and necessary program which allows you to connect to MySQL, PostgreSQL and Oracle databases simultaneously within a single application, making database administration to multiple kinds of database so easy.

Major Features:

1. Support of multi-connections to MySQL, PostgreSQL and Oracle servers.
2. Support of transferring data between different servers.
3. Support of transferring data to a text file with designated SQL format.
4. Support of running profiles from different servers in a single schedule job.

BaseTen is a freeware, open source database framework created in Cocoa for working with PostgreSQL databases. BaseTen has been designed with familiar, Core Data -like semantics and APIs.

Main features:
- BaseTen Assistant imports Core Data / Xcode data models.
- Discovers the database schema automatically at runtime, including 1-1, 1-many and many-many relationships.
- Database changes are propagated to clients automatically, without polling.
- In-memory database objects are uniqued, and objects fetched via relationships are faults by default.
- Support for RDBMS features like database-driven data validation, multi-column primary keys and updateable views.
- Autocommit and manual save/rollback modes, both with NSUndoManager integration.
- A BaseTen-aware NSArrayController subclass automates locking and change propagation.
- Fetches are specified with NSPredicates (the relevant portions of which are evaluated on the database).

System requirements:
-
- AppKit for the optional BXSynchronizedArrayController.
-

Enhancements
BaseTen:
- BaseTens date and time type handling has been significantly overhauled.
- Timestamp and datetime types are now always returned as NSDates.
- NSDates are stored into the database in UTC. When fetching, database values are assigned the UTC time zone, or, if they are qualified with some other time zone on the database, converted to UTC.
- NSCalendar is now used instead of NSCalendarDate when converting NSDates to date strings.
- PostgreSQL "time" types are now handled. On the Cocoa side, they are converted to NSDates with the appropriate time offset from the reference date.
- New and changed data type support
- The XML data type can now be fetched as NSXMLDocument. This happens if the database schema is enforcing document-only values with a constraint such as CHECK(column IS DOCUMENT).
- "bit" and "varbit" fields are now fully supported. They are fetched as NSStrings because they cant easily be represented as octets.
- In additiong to fetching "point" fields as NSPoints, NSPoint values can now be saved into the database.
- Changes to the way BaseTen supports database relationships
- The default key names for to-many relationships have changed to the format "Set". The previous form, "", is now deprecated. Add a symbolic breakpoint to BXDeprecationWarning to find uses of these deprecated keys.
- BaseTen can now extract direction-specific relationship names from a foreign key constraints name. The combined length of these two names can be a maximum of 61 bytes of UTF-8. This facility is used by the updated BaseTen Assistant to import the direction-specific names from Xcode Data Modeler schemas.
- When creating new objects with a field values dictionary, to-one related objects (or their object IDs) can now be specified as an alternative to specifying the values of the foreign key fields. The relationship name is used as the key.
Other changes:
- All text transferred between the database and BaseTen will now be normalized to Unicode normal form D, ie. the format produced by -[NSString decomposedStringWithCanonicalMapping].
- Most locking queries sent by BaseTen can now be disabled, and documentation has been added to describe the locking functionality.
- More of BaseTens internals have now been documented in the reference manual.
- When inserting, updating or deleting rows, BaseTen now notices (and posts notifications of) changes that occur as a result of database triggers or rules firing. The only requirement is that said changes are to entities other than the one being changed by BaseTen; changes to the same entity will still be ignored.
- BXDatabaseObjectID is now documented as thread-safe since it only uses NSURL.
- BXSetProxies are now declared as deriving from NSMutableSet, as the NSCountedSets countability property isnt currently used by BaseTen.
- BaseTen will no longer try to unescape non-"bytea" columns.
- More SSL status codes are now available for determining when SSL is unavailable, automatic SSL certificate verification fails, user clicks Cancel in the certificate trust panel or some other SSL error occurs.
- Worked around potential issues with garbage collection where BaseTen used pointers to objects internal structures.
- KVO willChange notifications sent from -setPrimitiveValue:forKey: are now always called before the update. In certain cases with earlier BaseTen versions, observers might receive the notification after the change had been made.
- Some connection error messages are now more accurate.
BaseTenAppKit:
- BXSynchronizedArrayController can now remove objects even if the content set is bound to another array controller.
- BXSynchronizedArrayControllers property fetchesOnConnect is now called fetchesAutomatically. If its set, a fetch will also be performed when an already-connected database context is assigned to the array controller.
- BaseTenAppKit now embeds the Interface Builder plug-in. Interface Builder loads the plug-in if the framework has been added to a project.
- Fixed a crasher which occurred when connecting to a server with SSL capability in asynchronous mode.
- Fixed awkward user interaction when clicking Cancel in the certificate trust panel.
- Fixed a bug which caused object creation to fail if BXSynchronizedArrayController was instantiated in a nib and hadnt performed a fetch.
BaseTen Assistant:
- BaseTen Assistant can now name both sides of one-to-many and one-to-one relationships with the names entered in the Xcode Data Modeler.
- Optional relationships are now be created as optional and required relationships as required.
- Columns will no longer be created for transient attributes in data models.
- Relationships are now listed in the Inspector and info windows.
- A graphical representation of the database schema can now be created for use with Graphviz or OmniGraffle.
- Temporary information can now be deleted from BaseTen schema.
- Help is now more comprehensive.