Free execute sql statements software for mac

Beet can thus help you to analyze usage patterns and research production performance issues. Beet requires Spring framework 2.0 and the Quartz Scheduler.
Beet adds flexible user behavior and performance tracking to a Spring-based Java application.
HTTP requests, SQL statements and method executions are tracked and associated to a user and session. includes XML, JDBC loggers and binary XML.

Main features:
- Record Java method calls, SQL statements, and HTTP requests, or add your own events
- Simple configuration, zero code modification required
- Know immediately which user and session caused each event and when
- JMX administration and diagnostic tools
- Record data as XML, compressed binary XML, directly to an RDBMS, or write your own storage
- Flexible ETL and log manipulation tools for compressed binary XML
- Low resource overhead, appropriate for production systems

System requirements:
- Java

Manage any SQLite database on your computer. An intuitive heirarchical tree showing database objects. Helpful dialogs to manage tables, indexes, views and triggers. You can browse and search the tables, as well as add, edit and delete the records.
Facility to execute any sql query. A dropdown menu helps with the sql syntax thus making writing sql easier. Easy access to common operations through menu, toolbars, buttons and context-menu.
SQLite Manager allows you to export tables/views in csv or xml format.
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. An SQLite database is a single ordinary disk file that can be located anywhere in the directory hierarchy. It is likely that most of the storage in Mozilla applications, in near future, will use SQLite.
Note: The SQLite Manager add-on is cross-platform and it works on Mac OS X, Windows and Linux.

Main features:>
- dialogs for creation, deletion of tables, indexes, views and triggers
- ability to rename, copy, reindex tables
- ability to add and drop columns
- create new db, open any existing db, copy an existing db
- a tab for database settings (no need to write the pragma statements) where you can view and change the sqlite library settings
- export tables as csv files
- a dropdown menu showing all profile db (*.sqlite)
- an intuitive hierarchical tree showing all tables, indexes, views and triggers
- ability to browse data from any table
- dialogs to allow searching in a table
- allows editing and deleting selected record while browsing a tables data
- an extensive menu that helps with writing sql by hand and then executing it
- remembers the last used db across sessions

System requirements:
-

Enhancements:
- Issue #178 : Enhance new database to allow creation of in-memory database. Done. To open an in-memory db, go to Database menu -> New In-Memory Database. If the db opens successfully the title displays "in-memory database", in the left sidebar "in-memory" is displayed instead of db name and the statusbar displays "Memory" instead of Shared/Exclusive.
- Issue #180 : alert the user if a file from MRU could not be opened and remove the failed entry from MRU. Fixed.

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:

1. 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
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
7. 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.
8. 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

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.