code completion
Navicat for MySQL 8.1.5
Navicat for MySQL brings you an effective solution for MySQL administration and development. more>>
Navicat for MySQL 8.1.5 brings you an effective solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management, development and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop. Navicat supports all verions of MySQL and let you converts Access to MySQL, MS SQL to MySQL, Excel to MySQL, synchronizes and backups database in a snap through helpful wizards.
Major Features:
- Latest MySQL Versions Support: Navicat for MySQL a powerful MySQL Database Server administration and development tool. Highlights of supported features:
- Support of MySQL versions from 3.21 or above
- Support of Unicode / Character Set
- Support of MySQL Events, Views and Stored Procedures creation
- Support of Triggers
- Support of Foreign Keys
- Support of Partition
- 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: Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their MySQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a MySQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
- Provide auto-reconnection for MySQL server: With the option "Keepalive Interval", you can keep connection alive with the server by pinging it.
- Comprehensive Management of MySQL objects
- Create, edit and drop table's fields, indices, foreign keys and triggers: With Table Designer the basic Navicat for MySQL 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 / 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 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.
- 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 / extended insert statements etc.
- 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 for MySQL allows you to transfer data from one MySQL 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 MySQL server.
- Support of Data Transfer between local / remote MySQL databases: Transfer tables/views/stored procedures/events from one MySQL database to another MySQL database, or to a plain text file.
- Support of Backup and Restore MySQL databases: Regular backup on database is important to users. Backup/restore all tables and records, views, stored procedures and events for your MySQL 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.
- Send notification e-mail and attachment for schedule task: Generate notification e-mails with attach exported files to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule.
- 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, tables/views, fields and stored procedures/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.
- Code-Completion for Query, View, Stored Procedure and Event: Experience a quick way in constructing SQL statements in Query Editor, View, Stored Procedure and Event 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 objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature. Virtual Grouping can be applied on Connection, Table, View, Stored Procedure, Event, Query, Backup and Schedule.
- 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 MySQL 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.
Enhancements:
- Improvements:
-
- Improved compatibility to some ODBC drivers for Import Wizard.
- Bug Fixes:
-
- Incorrect use of hexadecimal format in MySQL data types other than BLOB in Data Transfer.
- Data grid was unable to be opened properly when some kind of text were displayed.
- Removed some internal SQL run by Navicat in Query Viewer.
- Unable to change the default value of an existing field from NULL to other values in Table Designer.
Requirements
- Mac OS X 10.4 Tiger or 10.5 Leopard
Code-Completion for Query, View, Stored Procedure and Event: Experience a quick way in constructing SQL statements in Query Editor, View, Stored Procedure and Event with the Code-completionLicense:update/patch
Navicat Premium 8.1.4
Navicat Premium offers you a useful, multi-connections Database Administration 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 more>>
Navicat Premium 8.1.4 offers you a useful, multi-connections Database Administration 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.
Major Features:
- 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
- Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin
- 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.
- Mac OS X 10.4 Tiger or 10.5 Leopard
Komodo Edit 5.2.0
Komodo Edit will make you satisfied because it delivers powerful editing capabilities for dynamic languages including Perl, PHP, Python, Ruby and Tcl; plus support for browser-side code including JavaScript, CSS, HTML and XML. more>>
Komodo Edit 5.2.0 will make you satisfied because it delivers powerful editing capabilities for dynamic languages including Perl, PHP, Python, Ruby and Tcl; plus support for browser-side code including JavaScript, CSS, HTML and XML.
Background syntax checking and syntax coloring catch errors immediately, while AutoComplete and CallTips guide developers as they code. It is available now on Linux, Mac OS X, and Windows.
Other features include a project manager, for flexible organization of all project elements, and the Toolbox, for storing configurable "Run" commands, macros, code snippets, URLs, Live and Virtual Folders, templates, menus, toolbars and remote files. Toolbox items can be distributed to other Komodo users.
Komodo Edit also allows users to easily extend its architecture, with support for adding advanced capabilities through Firefox-style .xpi extensions.
Major Features:
- Multi-language editor
- Multi-language support: Advanced support for:
-
- Browser-side languages: CSS, HTML, JavaScript and XML
- Server-side languages: Perl, PHP, Python, Ruby and Tcl
- Web template languages: RHTML, Template-Toolkit, HTML-Smarty and Django
- Autocomplete and Call Tips
-
- Autocomplete and calltips
- Write code faster and shorten the learning curve with code completion that guides you as you work
- CSS, HTML, JavaScript, Perl, PHP, Python, Ruby, Tcl, XML and XSLT.
- Schema-based XML/HTML completion
- Multiple-language file support, such as CSS and JavaScript completion in HTML
- Support for adding third-party libraries
- Interpreter version differentiation of built-in and standard library information
- Multi-language file support
-
- Correct syntax coloring of multi-language files and templated files, common in many web programming frameworks. Add custom language support (User-Defined Languages or UDL, used to provide support for RHTML, Template-Toolkit, HTML-Mason, Smarty and Django).
- Standard editing features
-
- Code commenting, auto-indent and outdent, block selection, incremental search, reflow paragraph, join lines, enter next character as raw literal, repeat next keystroke and clean line endings on "save".
- Syntax checking
-
- Instant feedback for all fully-supported languages.
- Syntax coloring
-
- Spot errors easily and improve readability and context, even in multi-language files (unique to Komodo!).
- Vi emulation
-
- Modal Vi keybindings emulate navigation, text insertion and command behavior. Custom commands can be implemented by adding Komodo macros to a Vi Commands Toolbox folder.
- Emacs keybindings
-
- Emacs-like keybinding scheme supports new editor features modeled on Emacs, such as transient marks (similar to the Emacs "mark ring"), repeat next command and reflow paragraph.
- HTML preview
-
- Check HTML, XML and CSS files side-by-side or in a browser, using arbitrary files or URLs.
- Multilingual Input Method Editor (IME) support
-
- Use your standard keyboard to enter multi-byte characters, such as Simplified Chinese, Japanese and Korean.
- Code snippets
-
- Store any piece of code for reuse.
- Code folding
-
- Work quickly and efficiently with large sections of code.
- Multi-document editing
-
- Easily work on multiple documents simultaneously using multiple tab groups, split view, and cross-document search.
- Tutorials
-
- Easily master editing features.
- Project manager: Convenient, flexible organization of all project elements.
- Live Folders
-
- Project view displays the current contents of corresponding file system directory.
- Virtual Folders
-
- Explicitly maintained multi-purpose containers for any project or Toolbox component, containing pointers to selected components from different file system locations.
- Toolbox
- Store it
-
- Store virtually anything, including configurable "Run" commands, macros, code snippets, URLs, Live and Virtual Folders, templates, menus, toolbars and remote files.
- Share it
-
- Share a Toolbox with networked team members or distribute valuable Toolbox items to other Komodo users with the import/export function.
- Extensibility
- XPI Extensions
-
- Create your own plug-ins. XPI extension support provides the same capability as Firefox, with all standard Mozilla APIs based on XUL, XBL, and XPCOM, plus the own for Python and JavaScript. Other new features, such as the DOM Viewer, are also extensions. With full documentation and an active community providing support, Komodo IDE's power is as boundless as your imagination.
Enhancements:
- Better performance and stability
- Customizable list of primary languages
- Easily view source of HTML pages
- Sub-language background colors
- PHP 5.3 support
- Ruby 1.9.1 debugging support (IDE)
- SCC history search-ability (IDE)
- Dropped the Komodo Mac OS X powerpc builds.
- Mac OS X 10.4 or greater
- Intel processor
- 512 MB RAM (1 GB+ recommended)
- 200 MB hard disk space.
Komodo IDE 5.2.0
Komodo IDE 5.2.0 is a powerful program for end-to-end development of dynamic web applications. more>>
Komodo IDE 5.2.0 comes as the first unified workspace for end-to-end development of dynamic web applications. A rich feature set for client-side Ajax languages such as CSS, HTML, JavaScript and XML, coupled with advanced support for dynamic languages such as Perl, PHP, Python, Ruby and Tcl, enables developers to quickly and easily create robust web apps.
Award-winning features include comprehensive editing and debugging, plus intelligent tools for regular expressions, team development, customization and unparalleled extensibility. The result is a powerful coding environment for framework stacks like Ruby on Rails and CakePHP and client libraries such as the Yahoo! UI Library and Dojo. A single license covers you across Linux, Mac OS X and Windows.
Major Features:
- Multi-language Support
- Browser-side technologies: CSS, HTML, JavaScript, and XML
- Server-side languages: Perl, PHP, Python, Ruby, and Tcl
- Web template languages: RHTML, Template-Toolkit, HTML-Smarty, and Django
- Autocomplete and Call Tips
- Write code faster and shorten the learning curve with code completion that guides you as you work
- CSS, HTML, JavaScript, Perl, PHP, Python, Ruby, Tcl, XML, and XSLT
- Schema-based XML/HTML completion
- Multiple-language file support, such as CSS and JavaScript completion in HTML
- Framework support for Rails and Zend
- Support for adding third-party libraries
- Interpreter version differentiation of built-in and standard library information
- Multi-language File Support
- Correct syntax coloring of multi-language files and templated files, common in many web programming frameworks. Add custom language support with UDL.
- Standard Editing Features
- code formatting
- code commenting
- auto-indent
- block selection
- column editing
- Syntax Checking
- Instant feedback for all fully-supported languages.
- Syntax Coloring
- Spot errors easily and improve readability and context, even in multi-language files.
- Abbreviations
- Inserts snippets from your toolbox at the touch of a key.
- Vi Emulation
- Modal Vi keybindings emulate navigation, text insertion and command behavior. Custom commands can be implemented by adding Komodo macros to a Vi Commands Toolbox folder.
- Emacs Keybindings
- Emacs-like keybinding scheme supports new editor features modeled on Emacs, such as transient marks (similar to the Emacs "mark ring"), repeat next command and reflow paragraph.
- HTML Preview
- Check HTML, XML and CSS files side-by-side or in a browser, using arbitrary files or URLs.
- View HTML Source
- Drag and drop a URL onto Komodo (http://, https://), Komodo now offers to view the source contents of this web page. This is convenient for checking the underlying HTML source code of web pages.
- Multilingual Input Method Editor (IME) support
- Use your standard keyboard to enter multi-byte characters, such as Simplified Chinese, Japanese and Korean.
- Code Snippets
- Store any piece of code for reuse.
- Code Folding
- Work quickly and efficiently with large sections of code.
- Multi-document Editing
- Easily work on multiple documents simultaneously using multiple tab groups, split view, and cross-document search.
- History
- Navigation (forward and back) buttons and a drop list in the toolbar that let you browse though the files and buffer locations you've been editing recently.
- Search Highlighting
- Matches are highlighted in the current buffer.
- Editor Hyperlinking
- Ctrl'+'hover' will highlight HTTP hyperlinks under the pointer; 'Ctrl'+'click' will open the URL in the configured browser.
- CSS Color Popup
- Ctrl' + 'hover' over a color value in CSS will display a popup of that color; 'Ctrl'+'click' will open the color picker.
- Primary Language Preferences
- It is now possible to configure which languages you'd like to see as primary languages in Komodo. The primary languages are the first group of languages seen in the language drop-down menus, whilst secondary languages are grouped under the Other sub-menu.
- Sub-language Background Colors
Enhancements:
- Ruby Debugging Support: Debugging support for Ruby 1.9.1 and up.
- PHP: New PHP 5.3 support:
- Code browser and sectionlist support for namespaces
- Code completions for /Namespaces
- Syntax coloring of latest keywords ("namespace", "use", "as", etc...)
- Updated xdebug builds to support PHP 5.3
- Improved debugger wizard for the first time setup
- Support for a wider range of PHP builds on Windows
- Sub-language background colors: You can now give sub-languages a different background color in multi-language buffers.
- View HTML Source: Drag and drop an http:// or https:// URL onto Komodo to see the contents of the page.
Aptana Studio 1.5.1
Aptana Studio is an advanced program which features code Assist on JavaScript, HTML, PHP, and CSS languages, HTML and CSS preview, FTP/SFTP support and a JavaScript debugger to troubleshoot your code. more>> <<less
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
Navicat version 8 supports Code Completion, Form View and email Notification Services, etc. Navicat is the number 1 MySQL database administration shareware in Download.com with over 350,000License:update/patch
BOUML 4.12.4
Free UML 2 tool box (under development) allowing you to specify and generate code in C, Java, Idl, Php and Python more>> Free UML 2 tool box (under development) allowing you to specify and generate code in C, Java, Idl, Php and Python
BOUML is cross-platform UML 2 tool box that runs under Mac OS X(Intel), Unix/Linux/Solaris, and Windows.
BOUML is very fast and doesnt require much memory to manage several thousands of classes, see benchmark.
BOUML is extensible, and the external tools named plug-outs can be written in C or Java, using BOUML for their definition as any other program. The code generators and reverses are ones of the pre-defined plug-outs included in the BOUML distribution.
Main features:
- it is free
- it runs under Mac OS X, Linux/Unix/Solaris, and Windows thanks to Qt
- it allows to program simultaneously in C , Java, Php, Python and IDL
- thanks to a full access to the generated forms, you are the master and you decide what must be generated
- it is extensible, and the external tools may be developed in C or Java, using BOUML for their definition as any other program.
- it is very fast and doesnt require much memory to manage several thousands of classes
Enhancements
- Browser search allows now to search for elements depending on their stereotype.
- The menu miscellaneous has the new toggle completion in dialog, it is set by default to be compatible to the behavior of the previous releases. When it is set and you enter a string in a list of choices (combo box) in a dialog, an auto completion/search is done, note this one is non case sensitive (Qt limitation). If you dont like this auto completion/search, unset the toggle.
- Internal extension of the Plug-out API for Java Roundtrip.
- C++ Generator 2.13
- A dependency stereotyped friend produced a wrong code in case the target class was a template, fixed.
- Follow the new API.
- Plug-out upgrade 1.13
- A crash occured when you upgraded an old plug-out without Python management, fixed.
- Follow the new API.
- Java Roundtrip 1.0
- New plug-out, please refer to the documentation
- C++ Reverse 2.10
- Java Generator 2.17
- Java Reverse 2.13
- Java Catalog 2.12
- Idl Generator 2.10
- Php Generator 1.5
- Php Reverse 1.3
- Python Generator 1.1
- Roundtrip body 1.8
- Follow the new API.
- XMI Generator 1.4.6
- When a parameter of an operation doesnt have type the token UML:Parameter wasnt closed, fixed.
- XMI2 Generator 1.10.2
- The base type of a class stereotyped typedef is now produced in an extension form supposing you ask for them
Pydee 0.4.12
A free and open source PYthon Development EnvironmEnt, a powerful alternative to IDLE Pydee is an open source Python development environment providing MATLAB-like features in a simple and more>> A free and open source PYthon Development EnvironmEnt, a powerful alternative to IDLE
Pydee is an open source Python development environment providing MATLAB-like features in a simple and light-weighted software, available for Mac OS X, Microsoft Windows XP/Vista, GNU/Linux.
Pydee is part of pydeelib, a Python module based on PyQt4 and QScintilla2.
Main features:
Pydee options (type pydee --help to see all available options):
- light option (i.e. -l or --light) to disable all widgets except the shell and the working directory changer
- modules option, i.e. -m or --modules followed by a comma separated (without spaces) list of module names to be imported at startup
- s (or --startup): specify a startup script (overrides PYTHONSTARTUP script)
Shell:
- Scintillas code completion
- filename/dirname completion (press Tab after a " or character)
- Calltips: objects documentation or arguments (if callable)
- PYTHONSTARTUP script is executed at startup
- IPython-like run, edit, cls and system commands (using prefix !, e.g. !ls or !dir)
- IPythons deep reload function as builtin reload replacement
- xedit command to edit script in an external editor
- oedit function to edit object in a GUI-based editor (dictionaries, lists, tuples, arrays, strings, ...)
- Find/replace with a Firefox-like widget (not a pop-up window)
DocViewer:
- Automatic documentation on every callable object written in console
- History
- Find/replace with a Firefox-like widget (not a pop-up window)
Editor:
- Multiple file support
- Find/replace with a Firefox-like widget (not a pop-up window)
System requirements:
-
- PyQt4 4.3 or later with QScintilla2
XPE 0.9.5
Free and open source neXtgen Povray editor more>> Free and open source neXtgen Povray editor
XPE is a graphical editor for Povray based on wxWidgets library. XPE looks like a modern code editor but focused on Povray.
XPE includes numerous features and is organized to optimize work-space.
Main features:
- XML based translation system
- Auto-completion on CTRL+SPACE
- Internal image-files viewer
- Files explorer with external application support for non-handled filetypes
- Javadoc-like documentation support
- Povray files parsing with navigator display
- includes direct acces by right click
- ini files support
- insert menu
- rendering console
- notepad, clock, open documents
- configuration utility
- retractable panels interface
Enhancements
- added ini and profiles managment on rendering
- added gamma correction on color chooser
- workaround for linux transparency bug
- some other bug fixes
CodeLite 1.0.2841
Powerful open-source, cross platform IDE for the C/C++ programming languages more>> Powerful open-source, cross platform IDE for the C/C++ programming languages
CodeLite uses a sophisticated, yet intuitive interface which allows user to easy create and build complex projects.
CodeLite is regularly tested under Mac OS X 10.5.2, Windows XP SP2/3, and (K)Ubuntu 7.10/8.04 Gutsy Gibbon.
Main features:
- Generic support for compilers
- Can be easily extended with plugins (Several plugins are already included in the installer)
Built-in GDB support, with the following features included:
- Watches table - add persistent watches by a single click
- Quick Watch - right click on a variable to expand it
- Locals tree - automatically displays the current stack variables (also displays *this if available)
- Threads view - provides list of currently running threads and easily switching between then by single click
- Breakpoint management - add/remove breakpoint management panel
- Automatic tooltip
- and more...
- Subversion plugin (based on the command line tool), which mimics the TortoiseSVN (but unlike it, it runs on Linux as well)
- Makefile based build system
- Project explorer (Workspace view)
- File Explorer
- Automatically imports MSVS workspace/projects and converts them to GNU based makefile
- Active document outline
- Sophisticated database based Code Completion mechanism, a default database is supplied which contains symbols for wxWidgets, STL and standard headers
- Functions call tip
- Hover tip
- Comments tips
- Members List
- Supports C++ templates, namespaces and other advance features of the language
- Automatically add include statement for symbols
- Quickly open resources in the editor using Find Resource in workspace
- Quickly open types in the editor using Find Type in workspace
- XML based syntax highlighting, comes with the following: C/C++, Java, Perl, XML, Makefile, Lua, Diff files, PHP, JavaScript, Python, HTML, ASP
- Text Folding
- Bookmarks
- Find In Files
- Replace In Files
- Highly Configurable
- Built-in doxygen comment generator for functions/classes
Enhancements
- Fixed: Conditional breakpoints dont work with spaces (bug#2743414)
- Implemented FR#2739818: Replace with selection - the searched string when using find in files is now also set as the replace with string. In addition, each time a replacement is made, the content of replace with is added to the replace with drop down
- Added new option to the debugger: set breakpoints using short file names (NO full paths) this fixes a bug reported in the forum that codelite does not break if a breakpoint is set in header file which is a template file (forum post: http://codelite.org/forum/viewtopic.php?f=13&t=493)
- Commented code that printed garbage to sterr
- Applied patch by Mattia barbon so that codelite will send 2 events when file is renamed: 1 event for the removal of the file and one for adding new fie
- Fixed: renaming file now properly closes the old file (if it was open in the editor)
- Added missing include statement to allow compilation under GCC 4.4.0
- Applied patch to fix bug# 2783422 (Broken CodeLite symlink when DESTDIR is used)
- Fixed: function calltips included an extra ; following variables in the function signature (forum post: http://codelite.org/forum/viewtopic.php?f=3&t=511&sid=1c1475d6d134a022757b61261b255a64)
- Fixed: inconsistency in functions/variable tooltip apearance forum post: http://codelite.org/forum/viewtopic.php?f=3&t=511
- Improved new project dialog to split the different project types into categories
- Added new project templates (Qt based ones)
- Adjusted the Save project as template dialog to allow user to set category to the new template
- Added new Simple executable template configured to work with gcc (the sample main is also a C file)
- New project dialog: when selecting project template from the list, the compiler is now also updated according to the template settings
- added missing icons
- Implemented FR#2778634: Allow SnipWiz to insert simple snippets which contains the placeholders @ and $ symbols. This is now feasible by escaping those symbols @ and $
- Implemented FR#2784236: Display C++ scope for Replace tab
- Save as tempalte for project now sets User templates as the default project category
- Fixed: Bug ID#2792478: File AutoReload upon SVN Revert. In addition the will also be re-tagged
- Fixed: bug#2770561: File edited changes after replace in files (editor sets the focus back to the last active editor)
- Find In Files: the dialog has now no minimum size
- Find In Files: the dialog is now centered when first time showed
- Fixed: importing files using the import files from directory to an active project will no longer remove the active state of the project
- Changed the margin folding shapes to rectangle rather than rounded rectangle
- Find In Files output pane: search result tabs now have a right click menu which allows to select close/close all/close other tabs
- Find In Files: The Find button is now set as default action for hitting the ENTER key
- Find in files context menu is now disabled during an active search
TexMakerX 1.8.1
Free and open source, multi-platformed latex editor more>> Free and open source, multi-platformed latex editor
TexMakerX is a platform-independent LaTeX editor. TexMakerX provides interactive spell checking, code folding and extended text navigation, while it also includes the features of the LaTeX editor TexMaker, like wizards, code completion and syntax highlighting
Main features:
- WE - Integrated Writing Environment
- All LaTeX tools can be called from TexMakerX with just one key press and you can add your own command line options (e.g. for forward/inverse search)
- LaTex tags and 370 mathematical symbols you can easily select and add to your text
- Wizards generating necessary code (e.g. documents, tabular/array-environments and BibTex-types)
- LaTeX errors are displayed in a Log panel and highlight within the tex file
- Structure View which shows the logical hierarchy of a file
- HTML Converter which creates a html out of your LaTex-based PS-file
- Text analysis counting and showing often used words or phrases
- LaTeX documentation where you can lookup the tags you dont know
- Customizable menu shortcuts
- DDE-Support to interact with other programs on Windows
- And also customizable code snippets, tabbed MDI view, ...
- Powerful Text Editor based on QCodeEdit
- Interactive spell checker which marks errors while you type them
- Syntax highlighting drawing LaTex commands in different, customizable formats
- Code folding which allows you to hide certain blocks
- Auto completion completes tags you wrote and shows corresponding help entries
- Unicode support which can handle files in all encodings
- Incremental search like in FireFox on a search panel at the text bottom (where you can also find a replace panel)
- Text Navigation jumps to bookmarks, certain lines, last changes and LaTex errors/warnings
- Key Remapping of single keys for automatically text insertion (e.g of nice quotation marks)
- And also line numbers, dynamic word wrapping, parenthesis highlighting, undo/redo, line change state ...
- Platform independence allows you to use it on Windows, Linux, BSD and Mac
- Automatical detection of MikTeX, Ghostscript and Standardlatex
- USB-Mode stores its settings in a texmakerx.ini (only if you create one!), so you can use the same configuration on different computers
- Translated in English, German and French
Enhancements
- added Windows DDE support
- added free menu key board mapping (also shift+insert key bindings)
- added word completion
- added error highlighting
- improved text analysis (phrases), recent file menu
- fixed MAC support (compiling, line endings)
- fixed possible crash with multiple instances and spellchecking
- more bug fixes
R for Mac OS X 2.9
R for Mac OS X is such an essential program which provides a language and environment for statistical computing and graphics. more>>
R for Mac OS X 2.9 is such an essential program which provides a language and environment for statistical computing and graphics.
R is similar to the award-winning S system, which was developed at Bell Laboratories by John Chambers et al. It provides a wide variety of statistical and graphical techniques (linear and nonlinear modelling, statistical tests, time series analysis, classification, clustering, ...).
R is designed as a true computer language with control-flow constructions for iteration and alternation, and it allows users to add additional functionality by defining new functions. For computationally intensive tasks, C, C++ and Fortran code can be linked and called at run time.
Apart from specific innovations in R itself this new build provides a brand new Cocoa GUI designed and implemented from scratch with many new features. Among these: internal editor with syntax highlighting, code and file completion, enhanced AppleScript support, new packages installer and manager, data editor and manager.
FlameRobin 0.9.2
Database administration tool for Firebird DBMS more>> Database administration tool for Firebird DBMS
FlameRobin is a software utility that is: lightweight (small footprint, fast execution), cross-platform (Mac OS X, Linux, Windows, FreeBSD, Solaris), and dependant only on other open source software.
Enhancements
- New features
- Allowed deleting from system tables (ex. to stop queries via MON$STATEMENTS)
- Added support for trusted authentication
- Databases can now be recreated from existing registration info
- Transaction isolation level can now be selected in SQL editor
- Win64 port
- Enhancements and Bug fixes
- Fixed problems with mangled UTF8 identifiers
- Improved autoincrement triggers
- Drop FK only once for self-referencing tables in Rebuild script
- Improved management of passwords in connection dialogs
- Case insensitive DoMaIn keyword detection
- Fixed reported length of char fields in DDL extraction of system tables
- Fixed minor DDL extraction problem with BIGINT and scale
- Search words are now highlighted in advanced metadata search results
- DataGrid: sum of values of selected cells in the grid is shown in status bar
- Data grid cell editor now has a popup menu of a standard edit control
- Data of CHAR type using multibyte character set has correct padding now
- Database file size is now reported correctly for databases over 2GB
- Opening pages in tabs can now be controlled with Shift/Control keys
- Information on database property page is reloaded without reconnecting
- Fixed focus problem with property pages
- Fixed broken descriptions of system table columns in property pages
- Optionally display sources of all triggers on table property page
- Controls are now focused before their popup menus are shown
- Improved usability of menus and commands via keyboard
- SQL Editor: Improved detection of field sizes in resulting dataset
- Fixed statement parsing when SUBSTRING function is present
- Fixed column autocompletion for JOINed tables
- Fixed code completion when tables are listed in SQL89 order
- Fixed crash when opening query window and pressing F5 or F8 at once
- Improved the way views are switched in SQL editor
- Fixed completion under Mac OS X
- Other minor improvements and fixes to SQL editor
- Statement execution time is now displayed with milliseconds precision
- Minimum required version of wxWidgets is now 2.8.
Arcadia 0.6.0
Open source Ruby Integrated Development Environment written using the tcl/tk GUI toolkit more>> Open source Ruby Integrated Development Environment written using the tcl/tk GUI toolkit
Arcadia is a Integrated Development Environment (IDE) for Ruby language written in Ruby using the classic tcl/tk GUI toolkit.
NOTE: Arcadia is licensed and distributed under the terms of the Ruby License.
Main features:
- Editor with syntax highlighting, code completion and source browsing
- Debug support
- Contextual ruby documentation
- Work on any platform where ruby and tcl-tk work.
- Highly extensibility architecture.
- Support for RAD gui building
Enhancements
- Dynamic layout capability added: now you can change at run-time the framess position and create new frames.
Cache Monitor 0.51
An SQL development tool designed for InterSystems database Cache more>> An SQL development tool designed for InterSystems database Cache
Cache Monitor supports developers with features, like: Advanced SQL Query Editor, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting,Graphical SQL execution plan and more.
You see the process ID (PID) from your connection on the Tabpane on every Query Analyzer. Code completion will let you type a few characters and then display a list of context-sensitive possibilities to complete the text you are typing. Editor code completion brings up a list of Tables or Columns (also known as Intellisense).
Code completion can be triggered by pressing [CTRL+SPACE] or by typing a hotchar or keyword, such as . or , in an SELECT list. Cache-SQL formatting can executed from context menu to make your code, or the code of others, much easier to read (Format SQL). Also supports, of course: Undo/Redo and Search and Replace.
Since version 0.18 the Hyperlink navigation has been added. Hyperlink navigation is a means for simple navigation from the editor to Tables metadata. When you presses the CTRL key and hover the mouse cursor over a certain code element, the element is changed to a hyperlink. When you hold the CTRL key and click on the hyperlink, the go to Tables metadata action is performed.
Since 0.20, Cache Monitor contains features to tune the database.
Main features:
Advanced SQL Query Editor
- Cache-SQL Syntax highlighting
- SQL Code completion for Tables,Views,Columns and Indexes (also known as Intellisense)
- SQL History buffer for executed SQL commands
- SQL Code formatting
- Parallel (multi-threaded) queries
- The Graphical SQL execution plan supplies index and selectivity information from every used index in the plan
- SQL abbreviations, Type: se to complete to "SELECT * FROM "
- TuneTable for selected Tables or whole Namespaces
- Select2Table Function
DDL Code generation (CREATE TABLE)
MetaData-Browser for
- Namespaces
- Tables
- Views
- Routines
- Classes
- CachedQueries
- Stored Procedures
- Indexes
Cache Monitor can be used from any platform with an JAVA-JRE 5.0 (Linux, Windows,...).
- Cache Monitor helps you to organize your Server; to classify Cache Servers into groups, divide groups into subgroups etc.
- You can see Cache Version infos from connected Server
- Shows Executionplan from an SQL Statement.
- You can view the selectivity from the used columns in the execution plan
- Shows CachedQueries with their costs and the underlying SQL (AddHoc from Intersystems needed!)
- Select2Table Function
- Fast open Query Analyzer with CTRL+Q on selected Server
- Fast open Query Analyzer with CTRL+O
- CopyTable Function
- Execute TuneTable for selected Tables or the whole Namespace
- Shows PID (ProcessID) from each Query Analyzer connection
- Shows Processlist
- Shows SELECT-Statements from SQL Views
- Show Routines
System requirements:
-
Enhancements
- Global Viewer is now working. Please attention about the global size, currently there is no limit!
- The Table-Viewer have now more filter functions from the context menu (look at the Data Panel and use right click on table).
- Faster startup.
