Free sql software for mac

SQL Language Module for BBEdit provides syntax coloring of SQL commands in BBEdit.

T-SQL Language Module For TextWrangler enables syntax coloring for the SQL scripts in TextWrangler.

Axamol SQL Library executes SQL statements stored in external library files from Java code, with named parameters. Separating SQL and Java code increases readability, eases maintenance, and allows separate testing and documentation.

Axamol SQL Library can often reduce code size of complex queries by 40%. You can also create HTML documentation with embedded documentation strings and a supplied XSLT stylesheet.

Freaky SQL is a tool for REALbasic developers which allows the creation, viewing, and modification of REAL SQL Databases (SQLite 3) and REAL Databases for use in REALbasic projects in version 2005 and 5.5 (and later), respectively.
Main features:
- Full Table and Field Schema Modification
- Data Viewing, Querying, and Editing
- Indexing and Encoding Support
- Conversion from the Old Database Format
- Conversion Between Folders and Virtual Volumes
- XML and CSV Import and Export.
Enhancements:
- Fixed some things..... creating RSD databases isnt really a wise idea yet.
- Opens RDB folders now.
- Cant rename stuff..... not supported in SQLite, the workaround is annoying.

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.

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, see Introduction.
The minimum version of Java supported is 1.5.x as of SQuirreL version 2.4. See the Old Versions page for versions of SQuirreL that will work with older versions of Java. SQuirreLs functionality may be extended through the use of plugins.
Main features:
Object Tree of Session window
- Right-click to access the popup menu which provides access to advanced script generation and graphing features. The graph plugin allows the user to create table charts.
SQL Editor with code completion popup (ctrl+space) open
- Code completion can be used to access drop-down lists of options that include keywords, tables, columns, views, stored procedures. Code completion also provides join generation functions.
SQL Editor with tools popup menu (ctrl+t) shown
- With the tools popup any editor function can be located with only a single short cut: ctrl+t
- Additionally, the list can be searched incrementally with just a few keystrokes.
SQL Editor with bookmark selection popup (ctrl+j) shown
- Bookmarks are user-defined code templates. SQuirreL comes with several pre-defined example bookmarks for the most common SQL and DDL statements.
Abbreviations and auto corrections dialog
- This feature works much like auto corrects in common office products. With the entries shown in the dialog you may for example type sf which will expand to SELECT * FROM.
Editing of SQL results.
- The result tabs of SQL queries support editing the rows returned from a query on a single table. You may also edit the contents tab of tables in the Object tree.
Graph: Charts of tables and their relations.
- To create new charts or to add tables to existing charts right mouse click tables in the Object tree and choose the Add to graph menu. Graph manipulation functions can be accessed by using the right-click context popup menu.
Graph: Scaling and distributing tables on configurable page sizes to prepare for printing
- Use the right-click context popup menu to switch to the scaling and printing mode.
Enhancements:
- Enhancements
- New plugins provide enhanced capabilities:
- DB2 Plugin: Stored Procedures, Triggers and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives DB2-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving DB2-specific information about them.
- H2 Plugin: Indexes and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives H2-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving H2-specific information about them.
- PostgreSQL Plugin: Stored Procedures, Triggers and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives PostgreSQL-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving DB2-specific information about them.
- Sybase Plugin: Allows the user to reverse engineer to the source code for Views and Stored Procedures displayed in the object tree.
- Added better support for executing large scripts so that SQuirreL remains responsive to UI interaction, as well as providing much faster execution.
- Added custom statement tokenizer framework to allow plugins to control how statements are tokenized.
- Drop tables, Delete Records and Copy Tables features now will order the tables according to Foreign Key dependencies instead of alphabetically by name.
- Oracle Plugin now supports executing create statements for triggers, stored procedures and functions using "/" just as is done in SQL-Plus. Also "@" can now be used to indicate a file to be parsed and executed while running another script in SQL Editor.
- SQL History Dialog allows for searching previously executed statements by regular expression.
- Many bug fixes