postgresql trial software / shareware for mac

Navicat for PostgreSQL 8.0.7 is an effective java tool which provides extensive functionality for managing and developing PostgreSQL database. Navicat is sophisticated enough for professional developers, yet easy to learn for new users. It is also available for Windows.

Enhancements:

• Release notes unavailable.
  

Navicat PostgreSQL Manager 8.1.2 is a full-featured Database administration and development tool for PostgreSQL. It works with any PostgreSQL Database Server from version 8.0 or above, and supports most of the latest PostgreSQL features including Trigger, Function, View, and Manage User, etc. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to PostgreSQL.

With Navicat well-designed Graphical User Interface (GUI), Navicat for PostgreSQL lets you quickly and easily create, organize, access and share information in a secure and easy way, taking PostgreSQL administration to the next level

Benefits:

• Latest PostgreSQL Versions Support: Navicat PostgreSQL a powerful PostgreSQL Database Server administration and development tool. Highlights of supported features:
• • Support of PostgreSQL versions from 8.0 or above
  • Support of Multiple Connections to local or remote PostgreSQL Server
  • Support of Unicode / Character Set
  • Support of PostgreSQL Views and Functions creation
  • Support of Triggers
  • Support of Foreign Keys
• Additional Connection Options
• • Support of SSH Tunnel: Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts. The authentication method can use a password or public / private key pair.
  • Support of HTTP Tunnel: Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their PostgreSQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a PostgreSQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
• Comprehensive Management of PostgreSQL objects
• • Create, edit and drop table's fields, indexes, foreign keys, uniques, checks, rules, triggers and privileges: With Table Designer the basic Navicat PostgreSQL tool for working with tables, you can create, edit and drop table's fields, indexes, foreign keys, checks, rules, triggers, privileges and much more.
  • Dump object definition as sql file: Backup object definition and data with ease by dumping as sql file.
  • View Database / Table Structure: Present the database / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.
• Diversified Import and Export Competence
• • Import data up to 5 most popular formats including XLS, CSV, TXT, DBF and XML
  • Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.
  • Export Data to different file formats: TXT, CSV, DBF and XML
  • Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.
  • Export data and create records as INSERT statements in sql file
  • During Data Transfer, you can choose to export data as sql file with record options like complete insert statements etc.
• Powerful Data Manipulation Tools
• • Support of Foreign Key Data Selection: With the GUI tool Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!
  • Data and Structure Synchronization: Navicat for PostgreSQL allows you to transfer data from one PostgreSQL database to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target database can be on the same server as the source database or on another PostgreSQL server.
  • Support of Data Transfer between local / remote PostgreSQL databases: Transfer tables / views / functions from one PostgreSQL database to another PostgreSQL database, or to a plain text file.
  • Support of Backup and Restore PostgreSQL databases: Regular backup on database is important to users. Backup / restore all tables and records, views and functions for your PostgreSQL database using Navicat. You can also schedule backups between databases.
  • Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization: Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Backup, Data Transfer, Data Synchronization, Import and Export.
• Powerful Security Management
• • Visual User Manager: Navicat provides users a visual tool for user management. You can easily add, duplicate, delete users, and edit global user privileges, and grant privileges on the selected databases, schemas, tables / views and tablespaces / functions.
• Well-Designed Visual Builder / Editor
• • Visual Query / View Builder: Visual Query / View Builder which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.
  • Query Editor: It allows you to create and edit SQL text for a query, prepare and execute selected queries.
  • Support of Parameter Query: Set query parameters to add variable values to a query each time you run it.
• More great features
• • Virtual Grouping: Have a better organization over connections in Navicat. You can categorize them into groups with the Virtual Grouping feature.
  • Server Monitor: Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status icon to show and / or modify the properties of PostgreSQL servers.
  • SQL Console: To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
  • Tabbed Windows: Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.
  • Text / Blob View: Navicat provides Text / Blob Viewer and Editor to view and edit TEXT / BLOB fields content. The editor allows you to view, update, insert or delete data in a table.

Major Features:

1. PostgreSQL Objects Management
   • Supports PostgreSQL Servers 7.3 or above
   • Create /drop databases and schemas
   • Support all PostgreSQL objects: tables, views and functions
   • Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers
   • Managing tablespace
   • Managing cast and languages
   • Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types
   • Support of character set and unicode
2. Connection Management and Navigation
   • Multiple local/remote PostgreSQL server connections
   • Connection to PostgreSQL Server through SSH
   • Connection to PostgreSQL Server through HTTP
   • Support SSL secure connection
   • Customize selected databases to work with
3. Data Viewer and Editor
   • Grid view
   • Form view
   • Text, Hex and BLOB viewer/editor
   • Copying and pasting selected records
   • Customize display formats
   • Incremental search, sorting and formatting table grid
   • Support of raw mode edit: apply PostgreSQL built-in function
   • Support of foreign key data selection: locate the available values from the reference table
   • Filtering Records
   • Ability to set number of records showing on each page
4. SQL Processing
   • Visual query/view builder to facilitate the process of building complicated queries
   • Ability to create parameter queries
   • Multiple SQL editors with syntax highlighted feature
   • Code completion for SQL editors
   • Ability to preview SQL before execution
   • SQL console
5. Diversified Import and Export Competence
   • Importing data from ODBC: MSSQL, Oracle etc
   • Importing data from MS Excel
   • Importing data from other file formats : TXT, CSV, XML, DBF etc
   • Exporting data to MS Excel
   • Exporting data to most popular formats: TXT, CSV, XML, DBF etc
6. Other Data Manipulation Tools
   • Data transfer
   • Transfering data to SQL script as INSERT statement
   • Transferring data to a SQL file with designated SQL format and encoding
   • Data synchronization
   • Structure synchronization
7. Backup/Restore
   • Backing up/restoring database
   • Converting backup file into SQL script
   • Backing up database/table to SQL script
   • Executing SQL script
8. Schedule for Batch Job
   • Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization
   • Sending notification e-mail for schedule task
   • Ability to attach Export Wizard/Report result files in Batch Job notification email
9. Server Security and Maintenance Services
   • Visual user manager to administer users, groups (roles) and privileges
   • Analyzing, vacuuming and reindexing tables
   • Server Monitor to view system variables and server status information
10. Other Useful Features
    • Duplicate/empty/ truncate tables
    • Create table/view shortcut on desktop
    • Print database/schema/table Structure
    • Support of docking/tab windows
    • Support of virtual grouping: provide logical organization over connections
    • Ability to run profile from command line
    • Log files: keep track on the actions have been performed in Navicat
    • Ability to copy Connection Information into Clipboard

Enhancements:

• Improvements:
• • Support quitting the Console window by "q" command.
  • Now owners of objects are not compared or transferred in Structure Synchronization and Data Transfer.
  • Improved the stability when running a query.
  • Improved an internal SQL which run slowly in the past.
• Bug Fixes:
• • Some windows size and position were not saved after closed.
  • Recalling multi-line history commands in Console were not displayed properly.
  • "Copy to Clipboard" did not show host name.
  • Dump SQL File did not dump the primary key definition.
  • Could not recognize the host by host name.
  • User defined type fields were not showing the type properly in Table Design.

Requirements: Mac OS X 10.4 Tiger or 10.5 Leopard

Migrates CSV files to Oracle and MySQLMigrates TAB delimited files to Oracle and MySQLHost FileMaker Pro databases at any ISP supporting MySQLDocuments FileMaker Pro database structureMigration of large text fields and image data to OracleProcessing of up to 50 open FileMaker Pro databases. FmPro Migrator also supports FileMaker Pro stand-alone solution files.

Major Features:

1. FmPro Migrator Developer Edition includes all of the features of FmPro Migrator, but also includes a Table Consolidation feature which performs the automated copying of Tables/Fields, Table Occurrences, Relationships, ScriptMaker scripts and Layouts between FileMaker 8, 8.5 and 9 database files on Mac OS X and Windows.
2. Utilize the New FileMaker 7 Security Model - Consolidating multiple database files into a single FileMaker 7 database file enables developers to utilize the new FileMaker 7 security model. FileMaker solutions can be developed in less time and with better security by utilizing the new FileMaker 7 security model.
3. Migrate SQL Server databases to FileMaker 7, 8, 9 - FmPro Migrator makes a direct ODBC connection to SQL Server databases to automate the mapping of SQL Server columns to FileMaker fields, perform column name to field name conversions and creates the tables in the FileMaker database. When using FileMaker Advanced, FmPro Migrator can put the table definition XML code onto the clipboard for easy pasting directly into FileMaker Advanced. On MacOS X, FmPro Migrator utilizes the Actual ODBC Driver for SQL Server from Actual Technologies to make a direct connection to SQL Server databases (purchased separately). On Windows, FmPro Migrator utilizes the SQL Server ODBC driver supplied by Microsoft in order to make a direct connection to the SQL Server database.
4. Automated Reporting from SQL Server Data - FileMaker 9 enables the creation of economical SQL reporting solutions compared to alternative products, using the new External SQL Sources feature. FileMaker also provides enhanced exporting capabilities including the direct creation of Excel spreadsheets and Adobe PDF files. FileMaker 9 Advanced can be used to create royalty-free FileMaker stand-alone solution packages for distribution to multiple desktops.
5. Migrate Access databases to FileMaker 7, 8, 9 - [FmPro Migrator for Windows and MacOS X Feature] - Using FmPro Migrator, Access databases can be migrated to FileMaker 7 in order to take advantage of FileMakers legendary ease of use and increased data management capacity. Migrated Access databases can now grow to the maximum 8TB file size offered by FileMaker 7 and can be run on MacOS X and Windows.
6. Migrate FileMaker Repeating Fields - FmPro Migrator migrates data within FileMaker repeating fields as related records within a new table for all databases. This feature converts previously non-relational data into relational database structured format for compatibility with destination database. Previously, this type of work had to be performed via time consuming manual procedures, but this task is now automated by FmPro Migrator. [When migrating FileMaker 7 databases, FmPro Migrator generates ScriptMaker data transformation scripts, which can be pasted into FileMaker via the clipboard. This feature overcomes the lack of repeating fields support within new versions of the FileMaker ODBC driver. Repeating fields data can now be transferred to SQL databases and used with the new External SQL Sources feature incorporated within FileMaker 9].
7. Container Field Export Feature - The container field export feature supports the 22 container field data types available within FileMaker 7, 8, 9 database files including: EMBO, EMF , EPS, FILE, FPix, FORK, GIFf, JPEG, JP2, META, METO, moov, PDF, PICT, PNGf, PNTG, qtif.SGI, snd, TIFF, TPIC, XMLO, 8BPS.
8. Scale Up FileMaker Pro to Enterprise Class Capacity - Running out of performance with your FileMaker solution? FmPro Migrator enables quick and accurate migration of your database structure and data to highly scalable enterprise class servers. Oracle and MySQL databases also provide enhanced transaction control and recoverability beyond the capabilities of FileMaker Pro.
9. Prototype and Test Database Web Implementations - Use FileMaker Pro to prototype and test web-based database solutions prior to implementation on enterprise class databases. FmPro Migrator permits quick prototyping of database applications once the structure has been developed in FileMaker Pro.
10. Save Thousands of Dollars with Generated Perl CGI Scripts - FmPro Migrator instantly generates robust Perl CGI scripts allowing insert, query, update and delete of migrated data for each migrated database. IT departments can save thousands of dollars and weeks of development/debugging effort over manually created scripts.
11. Save money on ODBC drivers for UNIX web servers - Perl CGI scripts generated for Access and SQL Server databases for Linux/UNIX/MacOS X web servers utilize the open source Perl DBI:Proxy software eliminating the need for ODBC drivers to be installed on the web server. This means that IT departments can typically save $3500 to $10,000 per web server which would normally be required in order to license ODBC drivers for UNIX servers.
12. Host FileMaker Pro Data at Virtually Any ISP - The MySQL database is the most popular open-source database available today. Virtually every ISP offers inexpensive MySQL database hosting with their hosting plans. Some ISPs even offer free MySQL database hosting after payment of a minimal setup fee. By migrating data to a MySQL database you have a wider choice of database hosting providers compared to looking for FileMaker Pro hosting providers.
13. Transfer Structure and Data - FmPro Migrator directly creates each table in the destination database at the click of a button. Even if you have never previously worked with one of these database servers, you can let FmPro Migrator effortlessly create the basic SQL code required to create the destination database table to hold your data. FmPro Migrator will also automatically attempt to identify and implement a unique primary key for your new database table and will create the appropriate trigger and incrementing sequence too (Oracle databases).
14. Process Images via the Web With Ease - The Perl CGI scripts generated by FmPro Migrator automatically provide support for insert/update/view/delete of GIF/JPEG images via a web-based interface. The generated Perl CGI scripts automatically perform special processing for all FileMaker Pro container fields in order to enable web users to work with image data within the migrated database. Non-image data (such as pdf, wav, MS Word and binary data) can also be processed with no programming changes to the generated files. These specialized data types are stored within the appropriate BLOB/LongBLOB column type within the destination database.
15. Improve Accuracy, Avoid Manual Data Entry - Database data is accurately migrated into the exact format required by the destination database. No manual processing or re-keying of data is required! These files are produced by FmPro Migrator within a few seconds at the press of a button, instead of the hours or days of work typically required for a DBA to write, test and debug these scripts manually.
16. No syntax errors - FmPro Migrator for MacOS X uses Apple Events via AppleScript (on MacOS X), FileMaker table definition XML code from the clipboard, ODBC connections to databases or the direct reading of FileMaker binary files to to query and document the structure of each FileMaker Pro database.
17. Stand-Alone FileMaker Solutions Supported - FmPro Migrator includes the ability to document and generate migration scripts for stand-alone FileMaker Pro solutions. Documenting or migrating a stand-alone solution file could be critical to business continuity needs. You could spend $300 - $500 just for competing documentation tools for FileMaker Pro.
18. Economical Infrastructure - The Perl CGI scripts generated by FmPro Migrator leverage popular industry-standard open source software including Apache (Linux/UNIX/MacOS X/Windows), Perl 5.6, MySQL, PostgreSQL, DBI/DBD and CGI.pm. IT departments can save thousands or even tens of thousands of dollars utilizing these scripts with an open source infrastructure instead of purchasing high-cost application server software.
19. Transfer Large Text Fields and Images - FmPro Migrator automatically facilitate the migration of large text fields and image data within FileMaker Pro container fields. FileMaker text fields containing more than 255 characters will be migrated to large text type columns in the destination database table. This determination is made automatically and is based upon reading the data gathered during the Step #2 Get Fieldsize step. FileMaker container fields are migrated and transferred into the appropriate BLOB/IMAGE type column in the destination database.
20. Support for a Wide Range of Databases - FmPro Migrator incorporates unmatched versatility compared to other FileMaker migration tools. FmPro Migrator includes support for migrating FileMaker to MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL and FrontBase.
21. Save Your Configuration - FmPro Migrator automatically saves your configuration information into its own MigrationProcess.db3 SQLite file within the output directory. You can re-open and reuse this information at any time in the future to continue or update an existing migration project..
22. DBA Can Review/Modify Generated Scripts - FmPro Migrator permits the DBA to review and customize table creation SQL scripts which will be sent to the database server.
23. Iterative Process - Because FmPro Migrator makes the process so efficient, you can quickly update and re-run a migration process based upon changes made to your FileMaker databases.
24. Context Sensitive Help - Clicking a table name in the Migration Process window displays instructions and troubleshooting info which is specific to the type of migration currently being performed.
25. Use FmPro Migrator To Document Existing Databases - FmPro Migrator can be used to produce documentation files for existing FileMaker Pro databases and stand-alone solutions files. This documentation can be used to make up for information which was omitted by the original developer or consultant. This documentation is written in a few seconds for every FileMaker database/table for which information has been gathered. The ability to produce high quality documentation on demand can be vital to passing an IT audit by a potential investor or new business partner.
26. Follow Security Best Practices for Perl CGI Programming - The Perl CGI scripts generated by FmPro Migrator are designed to follow industry standard best practices regarding web form processing. Denial of service attacks are prevented by preventing file uploads unless images/BLOB data is being submitted by the form. Critical web form processing parameters are hard-coded within each script instead of being accepted via POST or GET operations - thus preventing web form hijacking. Web attackers cannot view sensitive data by guessing at and passing in their own database column names for processing. The record deletion script carefully checks the referrer of submission requests in order to insure that the request was submitted via a trusted web server URL. Attempts by an attacker to submit to this form from other web servers will fail. Security is further enhanced by insuring that the functionality of record deletion is incorporated within a separate series of scripts which can be omitted from installation on publicly accessible web servers.
27. Perl CGI Scripts Follow FileMaker Layout Structure for Improved Security - It is a common FileMaker database development technique to use layouts to limit the information which is accessible by different groups of users. FmPro Migrator generates different sets of Perl CGI scripts for each layout within the FileMaker database in order to enhance the security of migrated web-based applications. Each Perl CGI script generated by FmPro Migrator makes use of hard-coded database column names and input parameters in order to insure that a web attacker cannot compromise security.

Enhancements:

• Added support for migrating Firebird database Tables/Fields, Relationships and data into FileMaker Pro database files.
• Fixed issue with external file references not being removed from scripts in some situations, during Step #5 of the Table Consolidation process
• Fixed an issue with displaying Destination DB Username upon first launch.
• Converted FileMaker comment characters to Visual Basic comment characters during FmPro to Access script conversions.
• Fixed cosmetic issue with TOs list field title.
• Fixed issue with processing of scripts to demo limit during FmPro to Access script conversions.
• Fixed issue when clicking Step #2 button during Table Consolidation projects, the Layouts screen now opens instead of Value Lists screen. Updated dialog text to refer to batch importing of Layouts from DDR XML files.
• Fixed issue when clicking Step #3 button during Table Consolidation projects, the Scripts screen now opens instead of the CFs screen.
• Updated Instructions text Layouts screen to to refer to batch importing of Layouts from DDR XML files.
• Corrected TO remapping during Table Consolidation projects to use same case characters in XML replacement text within scripts and layout XML. This doesn't affect FileMaker, but external XML processing tools/programming languages will be happier with this change.
• Fixed issue updating TO File Reference fields on TOs tab.
• Updated WinAutomation Jobs and QuicKeys shortcuts to click OK button when deleting/pasting layouts containing TAB panel objects during layout processing Pass#2.
• Updated layout DDR XML importing code with special processing for XML attributes/tags: ,,tableViewVisibility in order to reconcile differences between layout XML code in DDR file with Clipboard.
• Known Issue:Some TAB Panels may not paste correctly if they were imported from a DDR XML file. These layouts should be copied and pasted manually if there are only a small number of layouts having TAB panels, otherwise the layouts should be copied into FmPro Migrter Developer Edition using the automated clipboard importing method.

Enhancements:

• Brings more than a dozen bug fixes to the geographic information system.

Requirements:

• Mac OS X 10.2 or later.