Free relational software for mac

JumpBox for the PostgreSQL Relational Database Management System 1.1.5 is described as a convenient as well as powerful object-relational database system that's been under active development for over 15 years.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL has a SQL implementation that strongly conforms to the ANSI-SQL 92/99 standards.

It has full support for subqueries (including subselects in the FROM clause), read-committed and serializable transaction isolation levels. This JumpBox includes PostgreSQL 8 along with PHPPgAdmin setup and ready to run. The PostgreSQL server is network accessible and provides a great storage engine for a broad array of applications.

Deploying an application as a JumpBox provides a dramatically-reduced path to getting started with the software. Aside from installation benefits it yields other advantages such as portability across computing environments and simplified ongoing maintenance of the application.

This JumpBox is free so there's no risk in trying it out. Download it today and experience for yourself a whole new way of working with server software.

1. Self-contained deployment means easy to move or delete - it won't scatter files all over your operating system.
2. New versions of the JumpBox contain updates to each component in the software stack so there's no patching web servers, application servers, databases, dependencies, etc.
3. A web-based administration console simplifies the management of your application including SSL certs, email relaying, SSH, backups and more.
4. Once you know how to install a JumpBox you can deploy any of 50+ other JumpBoxes and take advantage of a growing library of conveniently-packaged Open Source software.

iList Data 3.8.0 is created to be an effective and helpful database software which can be used for the Macintosh. Create databases for daily use at home, educational use at school, and business use at work.

Major Features:

1. Ten database templates: Create your first database in seconds
2. User designed windows for creating, editing, and finding data
3. Ten find modes including find on field, find by value, and find parent
4. Support for text, number, date, and time fields plus integrated support for boolean, path, URL, color, JPEG, and calculation values
5. Built-in relational support for searching and displaying data across tables
6. Mac OS X compliant interface controls including date and time fields, color swatches, and image canvases
7. On-the-fly calculations and column summaries
8. Dynamic reports: Retrieve both the data and shell of a report from the database itself
9. Nine window sets: Save and recall custom interface setups with one click
10. Search history and bookmarks
11. Four batch editing modes including multi edit and auto number
12. Inline editing and pop-up editing of fields via keyword lists
13. Inline and summary graphing. View dot, line, bar, and fill graphs inline with your data
14. Advanced SQL editing for experienced users and built-in help by example support for novices
15. A built in resizable image viewer and full screen slideshow mode
16. A dedicated thumbnail palette for viewing JPEG and other web-based images
17. Speech synthesis
18. Apple iLife integration: Send images to iPhoto 5 with one click
19. Microsoft Office X and 2004 integration: Send record lists to Excel and Word with one click
    

All you need is the FormReturn Application (download here), a printer and a document scanner and you will be able to process hundreds of forms within minutes! Think of the time and money you will save.

Major Features:

1. It is the only decent software based OMR solution made for Mac OSX. It is also designed for Windows and Linux. You can share FormReturn files between all platforms.
2. It is a fully integrated OMR form editor, database and OMR form processing solution. Most other OMR software solutions require a seperate word processor and database. They also require the installation of OMR and barcode fonts. FormReturn is much more advanced as it creates its own vector based barcodes and OMR mark areas.
3. When editing an OMR form in form editor, when you create checkboxes (bubbles), you supply both the values, fieldnames and marks allocated when creating it on the page. Other OMR software systems require you to design the checkboxes in a word processor with special OMR fonts, print the forms out, scan the forms in, select the checkboxes in the scanned image and add the values. All the extra steps can be very tedious and time consuming with other OMR software solutions. If you update an existing form in FormReturn, you don't have to go through the whole process of re-training forms. There is no need to "train" forms in FormReturn.
4. If you want to personalize forms with custom names taken from records in a database (such as firstname and lastname), you don't need to do a mail merge. FormReturn can do this very easily using its special system called Template Variable Replacement (TVR). Furthermore, you can use database data to create custom barcodes of all different types, sizes and placements on each form.
5. FormReturn uses automatic form ID generation (placed as form ID barcodes) to track and automatically process form pages. You can have more than one page per form. Other OMR software solutions only allow one page for auto ID generation as they never factored in needing more than one page for a form.
6. What are some of the technical features of FormReturn?
   • Java Swing Application - Runs on Windows, Mac and Linux.
   • Barcode creator - Support for 1D barcodes (Code128, EAN13).
   • Barcode reader - Support for 1D barcodes (Code128).
   • SVG (Scalable Vector Graphic) support - Can embed vector graphics for high quality printing.
   • Raster image support - Can embed PNG, JPG, GIF files.
   • Truetype font support - Supports truetype fonts.
   • PDF export - Exports forms and previews as PDF files.
   • Embedded, networkable database - JDBC compliant embedded database.
   • Image deskew - Form images can be deskewed automatically.
   • Form template editor - An integrated template editor that allows you to publish personalised forms.
   • Sub-forms (segments) - When publishing, multiple sub-forms can be included depending on the data provided.
   • Template variable replacement - Templates that contain variables such as eg. become John Smith, Joe Smith, Jane Doe etc when they are placed in a form and then published.
7. What makes FormReturn different from traditional (hardware based) OMR systems? No need for expensive hardware or pre-printed answer sheets - You can use an ordinary scanner to scan answer sheets and an ordinary printer to print answer sheets.
   • Customised answer sheets - You can completely customise and personalise answer sheets. You can also have more than one page.
   • What makes FormReturn different from other (software based) OMR applications?
   • While FormReturn can work the same way other OMR programs do with two separate pages (a question sheet and a mark sheet), one of its greatest advantages is that you can combine both using only the one form.
   • One Form for Marks and Questions - FormReturn forms can combine both the questions and mark area together. The design of the forms is entirely up to you.
   • Automation - Shares processed data with other third party applications the instant a form is processed (via its database).
   • Form ID generation & record reconciliation - Automatically link source records to completed answer sheet mark data.
   • No third party applications required - The template editor creates answer sheets and the built in database stores results.
   • No need for mail merging - FormReturn has its own built-in relational database and template editor to create customised/personalised answer sheets.
   • Mac OS X support - Unlike most other OMR programs, FormReturn is one of the very limited number of OMR applications available for Mac OS X. This is particularly important for the education industry.
   • Cross platform - Works on all major operating systems (Windows, Mac, Linux).
   • Image Deskew - If Completed marksheets are not fed into scanners "straight", the automatic deskew function will turn the image to the correct angle.
   • Image Compression Compensation - If the image scanning mechanism compresses the image horizontally or vertically, it should not affect the detection of the mark area.
   • Simplicity - A single application to create custom answer sheets, automatically linking source records to answer sheet mark data.

Enhancements:

• New Features:
• • When making a scribble mark inside of an OMR box, it no longer needs to touch the edges of the omr box. Eg. a dot in the center of an OMR box will count towards it as being recognized as a mark. This improves the detection of marks in many ways. The improved mark detection algorithm in 0.8.0b has made this change possible.
  • In the source data record import area, you can now select the import CSV format as either tab or comma separators, and quotes, double quotes or no quotes.
  • The application has new icons and a new logo!
    
  • Now detects forms that are scanned upside down. If a form is scanned upside down, FormReturn will automatically rotate the form 180 degrees if it cannot find any Form ID barcodes where it will then check again.
  • More screenshots appearing in the help guide.
  • Beta trial period extended to 31 August, 2009.
• Bug Fixes:
• • Software update had a bug in it, couldn't figure out the versions correctly. Now fixed.
  • Major bug fix - When publishing a form with more than 1 page in versions prior to 0.8.1b, the mark area detection boxes would overlap between pages. Found bug and fixed it. However, you need to re-publish forms in order for these changes to take effect.
  • The processing queue's unprocessed images preview now works properly. Impliments the new image preview with zoom functionality.

Requirements:

• Mac OS X 10.5 or above.
• Mac computer with an Intel,
• PowerPC G5, or G4 processor.
• 512 MB RAM.
• 10 GB free storage space.
  

PostgreSQL Database Server 8.3.0 is a program functioning as an open source 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. PostgreSQL Database server already embedded a useful GUI - PGadmin. If you want to import MS Access or other formats to PostgreSQL, you can install a Mac OS X GUI Navicat PostgreSQL

PostgreSQL is an open-source descendant of this original Berkeley code. Also, PostgreSQL can be extended by the user in many ways.

It supports a large part of the SQL:2003 standard and offers many modern features:

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

Plone is a content management system for web publishing and the Zope application server.
The system provides pre-configured security and roles, a set of content types, and multi-lingual support, among other features. Plone is available under both GPL and commercial licenses.

Main features:
- Plone is flexible and powerful. It is ideal as an intranet and extranet server, as a document publishing system, a portal server and as a groupware tool for collaboration between separately located entities.
- Plone is easy to use. The Plone Team includes usability experts who have made Plone easy and attractive for content managers to add, update, and maintain content.
- Plone is easy to install. You can install Plone with a click-and-run installer, and have a content management system running on your computer in just a few minutes.
- Plone is international. The Plone interface has more than 50 language translations, and tools for managing multilingual content.
- Plone is supported. There are close to a hundred developers in the Plone Development Team around the world, and hundreds of companies specializing in Plone development and support.
- Plone is standard. Plone carefully follows standards for usability and accessibility. Plone pages are compliant with US Section 508, and the W3Cs AA rating for accessibility, in addition to using best-practice web standards like XHTML and CSS.
- Plone is Open Source. Plone is licensed under the GNU General Public License, the same license Linux uses. This gives you the right to use Plone without a license fee, and to improve upon the product.
- Plone is extensible. There are many add-on products for Plone that add new features and content types. In addition, Plone can be scripted using web standard solutions and Open Source languages.
- Plone is technology neutral. Plone can interoperate with most relational database systems, open source and commercial, and runs on a vast array of platforms, including Linux, Windows, Mac OS X, Solaris and BSD.
- Plone is protected. The nonprofit Plone Foundation was formed in 2004 to promote the use of Plone around the world and protect the Plone IP and trademarks.

Enhancements
- This is not a final release. Experimental releases should only be used for testing and development. Do not use these on production sites, and make sure you have proper backups before installing.
- After Plone 3.2 (which focused on packaging/installer improvements), this is a minor release that adds some new features. It does not include any major changes: all products that work with Plone 3.0, 3.1 & 3.2 should also work in Plone 3.3. The upgrade from Plone 3.x is simple and non-invasive, ensuring a smooth upgrade experience.
Feature enhancements in this release:
Link type should automatically redirect when accessed directly:
- Links should be capable of doing automatic redirection.
Resource Registries Improvements:
- Allow Resource Registries to use conditional comments for CSS to bring the IEFixes.css into the registry and allow external references to resources for all registries.
Standardizing our use of INavigationRoot:
- Plone has the INavigationRoot marker interface which supports rooting your tabs, navigation, breadcrumbs, sitemaps and searches to a specific container inside of a portal which itself is a INavigationRoot. Some areas of this need to be cleaned up and standardized to follow a consistent convention.
Minor i18n upgrades:
- Include PloneLanguageTool 3.0 and PTS 1.5.
Disable inline editing by default:
- The current inline editing behaviour as introduced in Plone 3 was a mistake: it is a cool technology to show off, but in practice accidental clicks very frequently lead to unwanted edit-screens.
Adapterise the Extensible Indexable Object Wrapper:
- Make it easier to register ExtensibleIndexableObjectWrapper attributes with adapters
Improve locking configurability:
- This PLIP proposes to a) make it harder to accidentally leave content items in a locked state, and b) make it easier to adjust the lock timeout or disable locking entirely.
Clean up auto-sort, auto-order code:
- Clean up, i.e. remove all code related to auto-sorting / auto-ordering folder contents as this feature was implemented for Plone 2.1, but never got enabled. Basically this proposes to revert http://plone.org/products/atcontenttypes/roadmap/3
Replace workflow history viewlet with content history viewlet:
- Plone stores both workflow history and versioning history for objects. Only workflow history is shown in a viewlet in current Plone versions. I propose to show all history data.
View for rendering events as an iCalendar file:
- Make it possible to subscribe to Plone events in the standard iCalendar format.
Automate ZCML Loading for Plone Plug-ins:
- Enable automatic plugins for Plone with z3c.autoinclude