Free sql software for mac

igSQL is a PostgreSQL client (not unlike psql). It enables the user to send SQL to a server and display the result.

Requirements:
Mac OS X 10.3 or later.

Enhancements:
Version 5.1.35: Release notes unavailable at the time this listing was updated.

Enhancements:

• Export results to XML or delimited format.
• Table schema window. Allows you to drag table and field names into the query box.
• Fixed Welcome Window.
• OpenBase Support Now Added. Now native support for OpenBase, PostGres, Mysql and ODBC (Any ODBC DB (mysql, access, exel etc...)
• Improved Error Checking

Requirements: Mac OS X 10.2 or later.

iPhoto To SQL is an export plugin for iPhoto that will create an SQL dump file with all picture metadata in addition to creating scaled images and thumbnails. If youve written your own photo gallery software, use this to get your photos and associated metadata into your database backend.
iPhoto To SQL will create the following fields: id, title, comment, keywords, stars, date, album, thumbnail filename and image filename. You can set height/width maximums on the thumbnails and images and they will be rescaled with their aspect ratio preserved.
Enhancements:
- Minor fix to no longer clobber the SQL file when doing multiple exports.
- The SQL file is named for the album being exported also saved in the directory itself.

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.

SqliteQuery is a utility for executing SQL statements on SQLite databases. You can edit and maintain existing databases or create new ones through the user-interface. SqliteQuery comes with the compiled SQLite database library built-in.
The main purpose of SqliteQuery is to execute SQL statements and watch the result on SELECT statements in a tableview. Choose which of the typed SQL statement to be executed by selecting or simply execute all if no selection is made.
The SqliteQuery user-interface is separated in four parts.
1. setting the database path (defining a not existing path will create a new database - you will actualy be asked before creating it
2. input of SQL statements
3. showing result of SELECT statements in a tableview
4. showing a log output
Enhancements:
- added menu item for manually checking updates
- added menu item for giving feedback via email
- added menu item for visiting the SqliteQuery website.

iSQL-Viewer is an open-source JDBC 2.x compliant database front end written in Java. It implements across multiple platforms features of the JDBC API. It does everything through a single interface.
iSQL-Viewer works with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix. iSQL-Viewer will provide a variety of tools and features to carry out common database tasks.
iSQL-Viewer is designed to meet the needs of JDBC Driver developers and database developers who work in single or multi-platform environments.
Main features:
- Scripting support using JPython and the IBM BSF framework
- A guided query builder for creating simple and complex SQL queries
- Enhanced object viewing for images, HTML, and other binary format files
- A friendly SQL console for executing SQL statements
- Batch processing of SQL files
- Database introspection
- "Bookmarks" to store SQL commands you commonly use
- Import and export to popular file formats such as Microsoft Excel, XML, HTML and ASCII delimited.
- Enhanced interface support across platforms.
Enhancements:
- The entire code-base was reworked.
- This is an initial beta release with basic functionality like schema browsing, querying, bookmarks, and historical commands.

CrushSQLPlugin is a plugin to make CrushFTP load its users from a SQL table. I used mySQL, but ti will work fine with MS SQL, or probably other SQL servers.
It makes it very easy for a website operator to generate accounts on the fly, or for someone to have direct control over their accounts in a different way from CrushFTP.
Enhancements:
- Bug fixes, and a security fix dealing with certain types of passwords.