postgresql database
FmPro Migrator 5.31
FmPro Migrator is released with an aim to quickly and accurately migrate FileMaker Pro database structure and data to MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL, FrontBase, SQLite and Valentina. more>> <<less
JumpBox for the PostgreSQL Relational Database Management System 1.1.5
JumpBox for the PostgreSQL Relational Database Management System is described as a convenient as well as powerful object-relational database system thats been under active development for over 15 years. more>>
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.
Major Benefits:- Self-contained deployment means easy to move or delete - it won't scatter files all over your operating system.
- 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.
- A web-based administration console simplifies the management of your application including SSL certs, email relaying, SSH, backups and more.
- 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.
Navicat Premium 8.1.5
Navicat Premium 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. more>>
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:
- Support of multi-connections to MySQL, PostgreSQL and Oracle servers.
- Support of transferring data between different servers.
- Support of transferring data to a text file with designated SQL format.
- Support of running profiles from different servers in a single schedule job.
tool allowing you to connect to MySQL, PostgreSQL and Oracle databases simultaneously within ... MySQL, Oracle and PostgreSQL databases from a single interface. It combines the functions ofLicense:update/patch
PremiumSoft CyberTech - MySQL, PostgreSQL and Oracle databases simultaneously within a single application, making ... kinds of database so easyLicense:update/patch
Administration tool which lets you connect to MySQL, Oracle and PostgreSQL databases ... single application, making database administration to multiple kinds of database so easyLicense:update/patch
PaperCut NG 9.6 (Build 8924)
PaperCut NG 9.6 (Build 8924) is a powerful software that helps you many properties such as print quota, charging, logging and monitoring tool designed for print management on multi-user networks. more>>
PaperCut NG 9.6 (Build 8924) is a powerful software that helps you many properties such as print quota, charging, logging and monitoring tool designed for print management on multi-user networks. The software has been in use to manage printing in Windows environments since 1999 and this is PaperCut Software's first Mac release. The software works by integrating via CUPS and supports advanced feature such as popup client, share accounts, print job filtering based on document attributes, LDAP integration, and release station for secure printing. The Mac version has all the same features as the successful Windows and Linux versions.
Major Features:
- Innovative 100% web-based administration allowing admin control from anywhere on the network.
- Cross-platform support for both servers and clients. Available for Windows, Mac, Linux, Novell and Unix.
- Differential print charging allowing costs to be defined per printer with varied prices for color, duplex and large form printing.
- Quota internet access by integrating with leading proxy servers such as Microsoft ISA Server and Squid.
- TopUp/PrePaid Cards - ideal for student payment management.
- Print release stations for secure printing, or for pay-per-print usage in public libraries or internet cafes.
- Manage wireless and unauthenticated printing from user-owned devices (Web Print).
- Advanced reporting in PDF, HTML and Excel.
- Charge printing to shared accounts - great for allocating printing costs to departments, faculties or cost centers.
- Import users and groups from Active Directory or an LDAP server like Novell eDirectory or OpenDirectory.
- Scalability up to 100,000+ users with the option to take this further with application server clustering.
- Option to use external databases such as Microsoft SQL Server, Oracle Database, the free Microsoft SQL Server Express or the free/open source PostgreSQL database engine.
- Full support for multiple print servers and monitoring of local desktop printers.
- Error notifications when printers are in error.
- Utilizes the latest development technologies including XML web services and service oriented architecture.
- User tools and client software to allow users to view balance and usage history.
- Self maintaining system requiring minimal administration.
- Open architecture - full documentation and APIs provided to all customers. Source code access available on request.
- Vendor neutral - no hardware vendor or operating system lock-in.
Enhancements:
- New features: New User configuration report providing information about user settings.
- Enhancements:
-
- Improved support for CUPS 1.4 (used in Mac OS 10.6 and up-to-date Linux systems).
- Improved detection and logging of problems when CUPS print jobs fail (Linux and Mac).
- Fixed problem that could cause the incorrect date ranges to be used when running one-click reports.
- Web Print:
-
- Fixed issues with the wizard for users with automatic charging to shared accounts or some of the more unusual account selection settings configured.
- Fixed problem uploading documents to a non-Windows primary server from a Windows workstation using IE6.
- Fixed problems handling jobs with document names that contained non-ASCII Unicode characters.
- Improved detection of Adobe Reader popping up a license agreement window when trying to print a job (can happen after initial configuration if the admin hasn't acknowledged the agreement).
- Corrected "enabled on X printers" text on the Options tab not including virtual queues.
- Fixed problems that can occur when performing edits of users, accounts and printers across multiple browser tabs/windows.
- Fixed an issue on Novell OES Linux where a print queue with hold/release enabled may not be able to accept a backlog of more than three jobs at a time.
- Fixed problem that would allow limited admins without the "edit user" right to use the "Re-apply initial user settings" feature.
- Fixed problem viewing the iPhone user web interface.
Find Database Tables 1.0
Find Database Tables is the right solution if you have a bunch of MySQL tables in your database that you arent sure if you use anymore while finding them can be tough and daunting and youre afraid to delete any because that one obscure script you wrote years ago may still use it. more>>
Find Database Tables 1.0 is the right solution if you have a bunch of MySQL tables in your database that you aren't sure if you use anymore while finding them can be tough and daunting and you're afraid to delete any because that one obscure script you wrote years ago may still use it. Simply log onto your database sever, select your database, select the folder that has your scripts, and let Find Database Tables do the searching for you!
Major Features:
- Fast Searching
- View the table data - make sure if you really want to delete the table or not
- View the scripts where a table was found
- Drop unwanted tables right from the application
- Export the results to a CSV file that can be used in any spreadsheet application
- Can view table data, scripts, and delete tables while the searching is going on
PostgreSQL 8.4.1
PostgreSQL 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. more>>
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:
- Complex queries
- Foreign keys
- Triggers
- Views
- Transactional integrity
- Multiversion concurrency control
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 PostgreSQLLicense:Freeware
collection of graphical tools for using and managing PostgreSQL servers, as well as the server ... collection of graphical tools for using and managing PostgreSQL servers, as well as the serverMarc Ligyanage - PostgreSQL. PostgreSQL is the PostgreSQL database server in a convenient Mac OS Xpackage. PostgreSQL includes support for GNU Readline, JDBC, ODBC, C++,MultibyteMarc Liyanage - PostgreSQL offers users such a beneficial and admirable PostgreSQL database server in a convenient Mac OS X package. PostgreSQL. PostgreSQL 7.3.3 offers users
DbVisualizer 6.5.9
DbVisualizer will make you satisfied because it is designed as a feature rich, intuitive and cross platform database tool for developers and DBAs providing a single powerful interface for a variety of databases. more>>
DbVisualizer 6.5.9 will make you satisfied because it is designed as a feature rich, intuitive and cross platform database tool for developers and DBA's providing a single powerful interface for a variety of databases.
DbVisualizer supports simultaneous database connections, it lets you explore and manage database objects, execute SQL queries, visualize information and a lot more.
Major Features:
- Database Browser
- Tree based navigation through all database objects. Browse object details and invoke management features
- Database Object Management
- Visual support to create, alter and modify characteristics for database objects such as tables. Edit and compile support for procedures, functions, packages and triggers. Extensive database specific support.
- Table Data Management
- Support for editing table data including binary/BLOB and CLOB data types, import from file
- SQL Tools
- SQL editor with support for auto completion, parameterized SQLs, SQL formatter, visual query builder, explain plan, export large result sets
- Database Server Management
- DBA features for managing database instance, storage and security parameters in the database server
- Tools
- Export objects in a database/schema as DDL and table data
- Comprehensive Database & OS Support
- Oracle, Sybase, SQL Server, PostgreSQL, DB2, Mimer, Neoview, MySQL, Informix, JavaDB/Derby
- Windows, Mac OS X, Linux/UNI.
Enhancements:
- Bug: DB Support: PostgreSQL The "Databases" object in the objects tree is empty.
Navicat PostgreSQL Manager Lite 8.1.2
Navicat PostgreSQL Manager Lite is an extremely useful Database administration and development tool for PostgreSQL. more>>
Navicat PostgreSQL Manager Lite 8.1.2 is an extremely useful 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:
- 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
- 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
- Data Viewer and Editor
- Grid 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
- Ability to set number of records showing on each page
- SQL Processing
- Ability to preview SQL before execution
- SQL console
- Backup/Restore
- Backing up/restoring database
- Restoring database with chosen database objects
- Converting backup file into SQL script
- Compressing/Decompressing Backup files
- Backing up database/table to SQL script
- Executing SQL script
- Server Security and Maintenance Services
- Visual user manager to administer users, groups (roles) and privileges
- Analyzing, vacuuming and reindexing tables
- Other Useful Features
- Duplicate/empty/ truncate tables
- Create table/view shortcut on desktop
- Support of docking/tab windows
- Support of virtual grouping: provide logical organization over connections
- 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
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 ManageLicense:Freeware
Navicat Lite 8.1.2
Navicat Lite bring users a full-featured multi-connections Database Administration tool allowing you to connect to MySQL, Oracle and PostgreSQL databases simultaneously within a single application, making database administration to multiple kinds of database so easy. more>>
Navicat Lite 8.1.2 brings users a full-featured multi-connections Database Administration tool allowing you to connect to MySQL, Oracle and PostgreSQL databases simultaneously within a single application, making database administration to multiple kinds of database so easy.
Navicat Premium combines the functions of other Navicat members. With connections established to different database types, Navicat Premium supports data transfer between MySQL, Oracle and PostgreSQL. It supports most of the features in MySQL, Oracle and PostgreSQL including Stored Procedure, Event, Trigger, Function, View, etc.
Navicat Premium enables you to easily and quickly transfer data across various database systems, or to a plain text file with designated SQL format and encoding. 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 database server.
Benefits:
- Multi-connections Database Administration tool: Navicat Premium allows you to perform multiple server administration to MySQL, Oracle and PostgreSQL databases from a single interface. It combines the functions of other Navicat members and supports most of the features in MySQL, Oracle and PostgreSQL including Stored Procedure, Event, Trigger, Function, View, etc. This is a time saver, and beneficial to any administrator managing multiple servers
-
- Latest MySQL Versions Support
-
- Support of MySQL versions from 3.21 or above
- Support all MySQL objects: tables, views, stored procedures/functions and events
- Support all subobjects: fields, indices, foreign keys and triggers
- Support of partitioning
- Support of Unicode / Character Set
- Latest Oracle Versions Support
-
- Supports Oracle Servers 8.1 or above
- Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions
- Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers
- Managing directories, tablespaces, public database links and public synonyms
- Support of physical attributes
- Latest PostgreSQL Versions Support
-
- Supports PostgreSQL Servers 7.3 or above
- Support all PostgreSQL objects: tables, views and functions
- Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers
- Managing tablespace, cast and languages
- Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types
- Support of character set and Unicode
- Cross-servers Data Manipulation Tools
-
- Support of transferring data between servers: 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.
- Export data and create records as INSERT statements in SQL file: 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.
- Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization from different servers: Profiles from different kind of databases can be created in a single batch job, so that you can set schedule and run at a specific time. Batch job can be created for Report Printing, Backup, Query, Data Transfer, Data Synchronization, Import and Export.
- Send notification e-mail and attachment for schedule task: Generate notification e-mails to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule. Also, exported file or printed report can be added to the batch job as mail attachment so that you can share your data easily.
- 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.
- Support of HTTP Tunnel for MySQL and PostgreSQL Server: Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
- Provide auto-reconnection for MySQL and PostgreSQL server: With the option "Keepalive Interval", you can keep connection alive with the server by pinging it.
- Comprehensive Management of Database Objects
-
- Create, edit and drop table's fields, indices, foreign keys and triggers: With Table Designer - the basic Navicat Premium tool for working with tables, you can create, edit and drop table's fields, indices, foreign keys, and much more.
- SQL Preview: The SQL Preview area shows you SQL representation of the oracle objects you are creating. This ability allows you to preview SQL before execution.
- Dump object definition as sql file: Backup object definition and data with ease by dumping as sql file.
- View Database / Schema / Table Structure: Present the database / schema / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.
- Diversified Import and Export Competence
-
- Import data from ODBC: You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.
- Import data from different file formats: 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: XLS, 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.
- Powerful Data Manipulation Tools
-
- Form View: Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.
- 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 Premium allows you to transfer data from one 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 server.
- Support of Backup and Restore MySQL/PostgreSQL databases: Regular backup on database is important to users. Backup/restore tables and records, views, functions, etc for your database using Navicat. You can also schedule backups between databases.
- 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 objects.
- 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.
- Code-Completion for Query, View, Function and other database objects: Experience a quick way in constructing SQL statements in SQL Editor with the Code-completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.
- More great features
-
- Virtual Grouping: Have a better organization over connection and objects in Navicat. You can categorize objects 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 Tab to show and / or modify the properties of your 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.
- Profile System: For most of the tasks, Navicat allows you to save / load profiles to increase convenience. Profile can be applied on Data Transfer, Data / Structure Synchronization, Batch Job, Import / Export etc.
- Shortcut: Navicat premium allows you to drag and drop tables/views to create shortcuts. This feature can save you a lot of time to access your most used table/view, reducing the number of steps to reach them.
Major Features:
- MySQL Objects Management
- Supports MySQL Servers 3.21 or above
- Create / Drop Databases
- Support all MySQL objects: tables, views, procedures/functions and events
- Support all subobjects: fields, indices, foreign keys and triggers
- Support of partitioning
- Support of character set and unicode
- Oracle Objects Management
- Supports Oracle Servers 8.1 or above
- Create/drop schemas
- Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions
- Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers
- Managing directories, tablespaces, public database links and public synonyms
- Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin
- Support of physical attributes
- Support of character set and unicode
- 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
- Connection Management and Navigation
- Multiple local/remote MySQL/Oracle/PostgreSQL server connections
- Support of Oracle Basic Connection
- Support of Oracle TNS Connection
- Connection to MySQL/Oracle/PostgreSQL Server through SSH
- Connection to MySQL/PostgreSQL Server through HTTP
- Support SSL secure connection for MySQL and PostgreSQL 8.4 above
- Customize selected MySQL/PostgreSQL databases to work with
- Data Viewer and Editor
- Grid view
- Text, Hex and BLOB viewer/editor
- Oracle BFile viewer/editor
- Copying and pasting selected records
- Customize display formats
- Incremental search, sorting and formatting table grid
- Ability to show/hide Oracle table ROWID
- Support of raw mode edit: apply MySQL/PostgreSQL built-in function
- Ability to set number of records showing on each page
- SQL Processing
- Ability to create parameter queries
- Multiple SQL editors with syntax highlighted feature
- Ability to preview SQL before execution
- SQL console
- Server Security and Maintenance Services
- Visual user manager to administer users, groups (roles) and privileges
- Maintance database/schema objects tables
- Other Useful Features
- Backing up schema/table to SQL script
- Executing SQL script
- Duplicate/empty/ truncate tables
- Create table/view shortcut on desktop
- Support of docking/tab windows
- 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 "exit", "quit" or "q" command for MySQL server.
- Support quitting the Console window by "q" command for PostgreSQL server
- Improved the stability when running a query.
- Now owners of objects are not compared or transferred in Structure Synchronization and Data Transfer for PostgreSQL server.
- Improved an internal SQL which run slowly in PostgreSQL server.
- Bug Fixes:
-
- Some windows size and position were not saved after closed.
- Recalling multi-line history commands in Console were not displayed properly in MySQL and PostgreSQL server.
- "Copy to Clipboard" did not show host name for MySQL and PostgreSQL server.
- Dump SQL File did not dump the primary key definition for PostgreSQL server.
- Could not recognize the host by host name for PostgreSQL server.
- User defined type fields were not showing the type properly in Table Design (for PostgreSQL server only).
Requirements: Mac OS X 10.4 Tiger or 10.5 Leopard
visual-db 0.5
Database visualization tool for your Mac VisualDB is a tool for visualization of the database as tables with relations between them more>> Database visualization tool for your Mac
VisualDB is a tool for visualization of the database as tables with relations between them. At this point the developmnet focuses on PostgreSQL, but in the future we are planning on supporting other DBMS, such as MySQL, Oracle, SQLite, etc.
Enhancements
- PostgreSQL databases are supported. DB structure visualization was added.
BaseTen 1.7
Cocoa database framework for working with PostgreSQL databases. BaseTen is a freeware, open source database framework created in Cocoa for working with PostgreSQL databases more>> Cocoa database framework for working with PostgreSQL databases.
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.
Open source Cocoa database framework for PostgreSQL databases with familiar, Core Data-like ... PostgreSQL databases. BaseTen has been designed with familiar, Core Data-like semantics andBaseTen - Cocoa database framework for working with PostgreSQL databases. / Xcode data models - Discovers the database schema automatically at runtime, including 1-1, 1Plazma 1.0.4
ERP+CRM solution written in Java based on Spring more>> ERP+CRM solution written in Java based on Spring
Plazma ERP+CRM solution written in Java based on Spring, Hibernate using Oracle, PostgreSQL, MySQL, Firebird, HSQL databases.
Plazma is a business solution for the small and middle businesses.
Main features:
Accounts Management:
- Accumulate all your accounts and opportunities in a single database. Maximize team selling effectiveness by combining all account data in one place. This includes orders, contacts, tasks, emails, files, comment. Segment all your accounts by groups and categories.
Contacts Management:
- Enables management of your contacts effectively with the history of all negotiations, phone calls, tasks, meetings, emails and documents. The Plazma ERP+CRM powerful search engine helps you to track down key information quickly using various characteristics.
Sales Management:
- Capture and reference key information relating to sales opportunities. Forecast revenue and measure sales process effectiveness. Track opportunity status and dates. Analyze sales by manager, product, customer segment. View all actions, mails and documents related to sale.
Tasks Management:
- Manage schedules and keep track of activities and events for multiple users. Track phone calls, meetings, to-dos, events, and literature requests. Monitor the work schedule of your employees. View all tasks per sales opportunity, account or contact.
- Campaigns Management: Plan and track your marketing campaigns. Analyze campaign results. Compare campaigns effectiveness. Optimize your marketing expences.
Products Management:
- Accumulate all your product information providing and maximizing all product sales opportunities. Maximize team selling effectiveness by combining all contacts to products.
Analytical Reports:
- Analyze the effectiveness of your sales team. Generate activity reports. Analyze sales forecast and results. Export data from any grid to PDF, HTML, XLS
MySQL Database Server 5.1.35
MySQL Database Server is a versatile and innovative tool which is designed for enterprise organizations delivering business critical database applications. more>>
MySQL Database Server 5.1.35 is a versatile and innovative tool which is designed for enterprise organizations delivering business critical database applications. It gives corporate developers, DBAs and ISVs an array of new enterprise features to make more productive developing, deploying, and managing industrial strength applications. If you need a GUI for MySQL Database, you can download - NAVICAT (MySQL GUI). It supports to import Oracle, MS SQL, MS Access, Excel, CSV, XML or other formats to MySQL.
MySQL Database Server delivers new enterprise features, including: ACID Transactions to build reliable and secure business critical applications. Stored procedures to improve developer productivity. Triggers to enforce complex business rules at the database level. Views to ensure sensitive information is not compromised. Information schema to provide easy access to metadata. Distributed transactions (XA) to support complex transactions across multiple databases.
tool which is designed for enterprise organizations delivering business critical database ... for MySQL Database, you can download - NAVICAT (MySQL GUI). It supports to import Oracle, MS SQLH2 Database Engine 1.1.113
An SQL database engine written in Java more>> An SQL database engine written in Java
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).
Enhancements
- Shell tool: the built-in commands EXIT, HELP, ?, LIST, and so on didnt work with a semicolon at the end.
- JDK 1.5 is now required to build the jar file. However it is still possible to create a jar file for Java 1.4. For details, see buildRelease.sh and buildRelease.bat. As an alternative, compile using JDK 1.5 or 1.6 and use Retrotranslator to create a Java 1.4 version http://retrotranslator.sourceforge.net/).
- When deleting or updating many rows in a table, the space in the index file was not re-used in the default mode (persistent database, b-tree index, LOG=1). This caused the index file to grow over time. Workarounds were to delete and re-created the index file, alter the table (add a remove a column), or append ;LOG=2 to the database URL. To disable the change, set the system property h2.reuseSpaceBtreeIndex to false.
- Identifiers with a digit and then a dollar sign didnt work. Example: A1$B.
- MS SQL Server compatibility: support for linked tables with NVARCHAR, NCHAR, NCLOB, and LONGNVARCHAR.
- Android: Workaround for a problem when using read-only databases in zip files (skip seems to be implemented incorrectly on the Android system).
- Calling execute() or prepareStatement() with null as the SQL statement now throws an exception.
- Benchmark: the number of executed statements was incorrect. The H2 database was loaded at the beginning of the test to collect results, now it is loaded at the very end. Thanks to Fred Toussi from HSQLDB for reporting those problems. However the changed do not affect the relative performance.
- H2 Console: command line settings are no longer stored in the properties file. They are now only used for the current process, except if they are explicitly saved.
- Cache: support for a second level soft-references cache. To enable it, append ;CACHE_TYPE=SOFT_LRU (or SOFT_TQ) to the database URL, or set the system property h2.cacheTypeDefault to "SOFT_LRU" / "SOFT_TQ". Enabling the second level cache reduces performance for small databases, but speeds up large databases. It makes sense to use it if the available memory size is unknown. Thanks a lot to Jan Kotek!
H2 Database Engine is a web based java database engine. Main features: - Fast database engine - ... Multiple schema support - Compatibility modes for HSQLDB, MySQL and PostgreSQL - Sequence andPostBooks 3.2.2
Free and open source ERP and CRM system, based on the award winning OpenMFG ERP Suite more>> Free and open source ERP and CRM system, based on the award winning OpenMFG ERP Suite
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
