postgresql
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
MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL, FrontBase, SQLite and Valentina. Major Features: Converts Microsoft Access Tables/Fields, Forms/Reports, RelationshipsLicense:update/patch
com Solutions Inc. - MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL, FrontBase, SQLite and Valentina. FmPro Migrator. FmPro Migrator 5.25 can showLicense:update/patch
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.
JumpBox for LAPP Deployment 1.1.5
JumpBox for LAPP Deployment is described as a reliable and handy utility system which enables you to easily deploy applications where a tailored JumpBox may not exist. more>>
JumpBox for LAPP Deployment 1.1.5 is described as a reliable and handy utility system which enables you to easily deploy applications where a tailored JumpBox may not exist.
It contains PostgreSQL plus PHP, Perl, Ruby and Python along with phpPgAdmin to help you manage the database. Using the JumpBox for LAPP Deployment you can easily deploy many popular PHP applications as well as CGI based Perl, Ruby and Python 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 a single application, making database administration to multiple kinds of database so easy. NavicatLicense:update/patch
Navicat Premium is a smart and easy-to-use tool which lets you connect to MySQL, PostgreSQL and Oracle databases simultaneously within a single application, making database administrationLicense:update/patch
Administration tool which lets you connect to MySQL, Oracle and PostgreSQL databases simultaneously within a single application, making database administration to multiple kinds of databaseLicense:update/patch
Web Help Desk Free 9.2.2.1
Web Help Desk Free offers you a free help desk software edition of Web Help Desk for Mac OS X server installation offering an industry leading web-based help desk software feature set more>>
Web Help Desk Free 9.2.2.1 offers you a free help desk software edition of Web Help Desk for Mac OS X server installation offering an industomer service requests with ease, all through an intuitive web-based technician interface, cMajor Benefits:
- General:
-
- Mac OS X Help Desk Software Solution
- Web-based Client UI
- Zero Footprint
- C
Enhancements:
- Fixed: Issue ca
- Apple Mac OS X Server 10.4 or later
- Microsoft Windows 2000 or later
- Red Hat Linux
- Debian Linux
- Sun Solaris 8 or later
- Database Support:
-
- MySQL 5 or later
- Microsoft SQL Server 2000 or later
- Oracle 8i or later
- OpenBase SQL
- PostgreSQL 8 or later
- FrontBase 4 or later - An embedded FrontBase database is included for Mac OS X and Windows installations for instance functionality.
- The application and database are not required to run on the same server or operating system, so feel free to mix and match hardware and operating systems to best suit your needs.
- Fixed: Issue ca
<<less
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 is designed to be an user-friendly and reliable database system which has more than 15 years of active development and a proven architecture thatLicense:Freeware
PostgreSQL for Mac is a collection of graphical tools for using and managing PostgreSQL servers, as well as the server itself installable on any Mac runningMarc Ligyanage - PostgreSQL - SQL database server. PostgreSQL. PostgreSQL is the PostgreSQL database server in a convenient Mac OS XpackageMarc Liyanage - PostgreSQL offers users such a beneficial and admirable PostgreSQL database server in a convenient Mac OS X package
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.
databases including Oracle, Sybase, DB2, MySQL, Informix, SQL Server, PostgreSQL, Cloudscape, McKoi, SAP DB, Mimer and InstantDB. System requirements: - - 10-30 MB disk space depending onLicense:Freeware
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
License: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
Bugzilla 3.4
Bugzilla is considered as the leading open-source/free software bug tracking system which comprises the high-profile installations at mozilla.org (250,000 entries), Gnome, Red Hat and NASA, among others. more>>
Bugzilla 3.4.3 is considered as the leading open-source/free software bug tracking system which comprises the high-profile installations at mozilla.org (250,000 entries), Gnome, Red Hat and NASA, among others. It features a comprehensive set of fields, attachment management, inter-bug dependencies, email notification of changes, a powerful query interface, reporting, and web, xml, email and console interfaces. It can be managed entirely using a web-based UI. The user UI is customisable using templates.
Bugzilla is developing rapidly, and has a strong developer and support community in its newsgroup and IRC channel.
Bugzilla also has comprehensive documentation. Bugzilla is a server application, you must be using your Mac OS X box as a webserver to make use of it.
Major Benefits:
- Improve communication
- Increase product quality
- Improve customer satisfaction
- Ensure accountability
- Increase productivity
- Bugzilla can adapt to multiple situations
Major Features:
- For Users
- Advanced Search Capabilities
- Email Notifications Controlled By User Preferences
- Bug Lists in Multiple Formats (Atom, iCal, etc.)
- Scheduled Reports (Daily, Weekly, Hourly, etc.) by Email
- Reports and Charts
- File/Modify Bugs By Email
- Time Tracking
- Request System
- Private Attachments and Comments
- Automatic Username Completion or Drop-Down User Lists
- Patch Viewer
- "Watch" Other Users
- Move Bugs Between Installs
- Save and Share Searches
- For Administrators
- Excellent Security
- Highly Customizable
- Custom Fields
- Full Unicode Support
- Localization
- mod_perl Support for Excellent Performance
- Webservices (XML-RPC) Interface
- Control Bug Visibility/Editing with Groups
- Impersonate Users
- Multiple Authentication Methods
- Support for Multiple Database Engines
- Sanity Check
Enhancements:
- Minimum Requirements
-
- Perl
- For MySQL Users
- For PostgreSQL Users
- For Oracle Users
- Required Perl Modules
- Optional Perl Modules
- New Features and Improvements
-
- Simple Bug Filing
- New Home Page
- Email Addresses Hidden From Logged-Out Users
- Shorter Search URLs
- Asynchronous Email Sending
- Dates and Times Displayed In User's Time Zone
- Custom Fields That Only Appear When Another Field Has a Particular Value
- Custom Fields Whose List of Values Change Depending on the Value of Another Field
- New Custom Field Type: Bug ID
- "See Also" Field
- Re-order Columns in Search Results
- Search Descriptions
- Other Enhancements and Changes
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.
MK&C - Open source Cocoa database framework for PostgreSQL databases with familiar, Core Data-like semantics and APIs. BaseTen. A new, open source Cocoa databaseMarko Karppinen & Co. LLC - BaseTen - Cocoa database framework for working with PostgreSQL databases. BaseTen. BaseTen is a freeware, open source databaseweb2py 1.64.1
A full-stack Enterprise Web Framework for agile development of secure database-driven web-based applications. more>> A full-stack Enterprise Web Framework for agile development of secure database-driven web-based applications.
web2py is an open source full-stack Enterprise Web Framework for agile development of secure database-driven web-based applications, written and programmable in Python.
There are many web frameworks today including Ruby on Rails, Django, Pylons and Turbo Gears, so why another one?
web2py was developed with the following goals in mind:
- As similar as possible to Rails, but in Python, so that it is more solid and much faster
- All-in-one package with no installation, no configuration and no shell scripting required
- Be super easy to teach
Main features:
- Runs on Mac, Linux, Windows, Windows Mobile, and on the Google App Engine
- Requires no installation and can run off a USB drive
- Has no configuration files. You just unzip it and click on it
- Includes a multi-threaded wsgi-compliant web-server (also works with Apache and others)
- Includes a transaction-safe relational database (sqlite)
- Includes a web-based integrated development environment (demo)
- Includes a ticketing system to help you debug deployed applications
- Includes a sophisticated Database Abstraction Layer that can handle joins, left joins, nested selects, aggregates, transactions and distributed transactions. Writes SQL code for you, transparently and in real time, for SQLite, PostgreSQL, MySQL, MSSQL, FireBird, Oracle and IBM DB2 (since 1.58)
- Automatically generates a web-based database administrative interface for your applications
- Prevents the most common types of vulnerabilities: Cross Site Scripting, Injection Flaws, and Malicious File Execution
- Enforces good Software Engineer practices (Model-View-Controller design, Server-side form validation, postbacks)
- Includes internationalization support and a web based translation interface
- Includes functions for caching in ram, disk, memcache and combinations thereof
- Includes libraries for Authentication (login, logout, registration, change password, etc.)
- Includes libraries for Authorization (Role Based Access Control)
- Includes libraries to generate and process Create/Update forms directly from a database
- Includes libraries to handle HTML, ATOM, RSS, RTF, JSON, AJAX, XML-RPC, CSV, REST, WIKI
- Works with Flash/Flex via PyAMF and Google Web Toolkit via Pyjamas
- Includes jQuery for Effects and Ajax
- Includes a powerful Python-based template language to render objects into HTML or other text-based protocols
- Handles automatically upload and download streaming for large media files
- Includes portable cron mechanism for creating and running recurrent tasks in background
- Allows to bytecode-compile applications and distribute them in closed source
- Backward compatibility is guaranteed for the web2py API since 1.0
Enhancements
- There was a critical bug in version 1.32. You need to upgrade to version 1.33.
handle JSON, AJAX, RSS, CSV, RTF, XML, and WIKI markup and can talk to SQLite, MySQL, PostgreSQL and Oracle databases. - web2py is really easy to use. To develop with web2py you only need to know PythonLicense:GPL
Can handle HTML, RSS, CSV, AJAX, JSON, WIKI markup and can talk to MySQL, PostgreSQL and Oracle databases. Provides a ticketing system for reporting and logging errors. Applications developedSimple Groupware 0.520
Open source enterprise application offering email, calendaring, contacts, tasks, document management and more more>> Open source enterprise application offering email, calendaring, contacts, tasks, document management and more
Simple Groupware is a complete groupware package written in PHP, XML, SQL, HTML, CSS and sgsML. Unlike other groupware software, Simple Groupware contains the new programming language sgsML.
Simple Groupware combines standards like RSS, iCalendar, vCard, IMAP, POP3, SMTP, CIFS, CSV, WebDAV, LDAP and SyncML under one platform.
Simple Groupware allows quick and easy creation of powerful web applications.
Simple Groupware Solutions is a small German one-man company, founded in September 2003. The business domain is focused on individual services and software development. Simple Groupware is developed in my free time and offered to you for free.
Main features:
- simple installation (only one form)
- simple update (just copy the files)
- simple usage (all modules share a consistent look & feel)
- simple to adapt to your needs (see sgsML)
- but not simple in functionality
- can be created much faster
- are easier to maintain
- contain less errors
- are easier to write
- are much smaller in size
- feature a consistent look
- build powerful web applications in minutes
- change web applications in seconds
- decrease time for implementing and deploying web applications by a factor 10, compared to the usual solutions
- keep costs for maintenance and change management to a new minimum
System requirements:
- Apache: 1.3.x or 2.x and higher / IIS 5.1 and higher
- PHP: 5.1.0 and higher
- Database: at least MySQL 5, PostgreSQL 8.1, Oracle 9.2
- CPU: 1 GHz or more
- RAM: 512 MB or more
- Hard disk: 1 GB or more
Enhancements
- added Graphviz markup to the CMS module
- added folder copying
- added custom home folder redirection for users
- updated RSS output to RSS 2.0
- updated PmWiki engine to 2.20
- fixed downloading unicode filenames in IE
- some smaller code optimizations
Plazma 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
