Free sql software for mac

Enhancements:

• Qilan is fully compatible with Mac OS X 10.6.
• Qilan has been rebuilt using JNI.
• Webtemplate exports are significantly faster and memory management has been improved.
• There are number of new features including check for Qilan updates, new operators and a find function.

phpMyAdmin 3.2.2.1 is created with the aim to help handle the adminstration of MySQL over the web.

Key Functions:

• create and drop databases
• create, copy, drop and alter tables
• delete, edit and add fields
• execute any SQL-statement, even batch-queries
• manage keys on fields
• load text files into tables
• create and read dumps of tables
• export data to CSV values
• administer multiple servers and single databases

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:

1. Database Browser
   • Tree based navigation through all database objects. Browse object details and invoke management features
2. 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.
3. Table Data Management
   • Support for editing table data including binary/BLOB and CLOB data types, import from file
4. SQL Tools
   • SQL editor with support for auto completion, parameterized SQLs, SQL formatter, visual query builder, explain plan, export large result sets
5. Database Server Management
   • DBA features for managing database instance, storage and security parameters in the database server
6. Tools
   • Export objects in a database/schema as DDL and table data
7. 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.

Jailer is a tool for database subsetting and sampling, schema browsing, and rendering. Jailer exports consistent, referentially intact row-sets from relational databases.
Jailer removes obsolete data without violating integrity. Jailer is DBMS agnostic (by using JDBC), platform independent, and generates DbUnit datasets, topologically sorted SQL-DML, and hierarchically structured XML,
NOTE: Jailer is licensed and distributed under the Apache License Version 2.0.

Main features:
- Exports consistent and referentially intact row-sets from your productive database and imports the data into your development and test environment.
- Improves database performance by removing and archiving obsolete data without violating integrity.
- Generates hierarchically structured XML, topologically sorted SQL-DML and DbUnit datasets.
- Open Source. Entirely written in Java. Platform independent. DBMS agnostic.

System requirements:
-
- JDBC-driver for your R-DBMS

Enhancements
- fixed a bug concerning multi-line CLOB content.

Reverse Snowflake Joins is a free and open source tool that parses SQL Select statements and generates a diagram. The diagram will show parts of the underlying SQL directly in the diagram.
For example x=30 , GROUP BY (year), HAVING MIN(age) > 18. It is easy to see cartesian joins and/or loops.

System requirements:
-

Enhancements
- If possible, aliases are displayed inside the tables they belong (previously they were displayed each in its own frame).
- Some progress with subselects, to be finalized later.

SqlBuilder is a library which attempts to take the pain out of generating SQL queries within Java programs. Using one programming language (Java) to generate code for another language (i.e. SQL) is always a challenge.
There are always issues with escaping characters within string literals, getting spaces in the right place, and getting the parentheses to match up. And often, even after the code is debugged and fully tested, it is still very fragile.
The slightest change will throw things out of balance and will require another round of tweaking and testing.
SqlBuilder changes that whole scenario by wrapping the SQL syntax within very lightweight and easy to use Java objects which follow the "builder" paradigm (similar to StringBuilder).
This changes many common SQL syntactical, runtime errors into Java compile-time errors! Lets dive right in to some quick examples to to see how it all works.

Enhancements
- Add support for additional query "set operators" (EXCEPT, INTERSECT), and add support for mixed usage of said operators. Fixes 2794171 .
- Add UnaryCondition EXISTS and UNIQUE operators.
- Fix isEmpty implementation for Subquery.
- Dont put double parens around IN condition with subexpression.