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.

Phobos is a financial manager for Mac OS X. The new version of Phobos has very little in common with the previous version. The interface is completely re-designed, it is much cleaner and easier to interact.

Phobos is now capable of interacting with OmniGraffle: you can create reports through .graffle templates. The plug-in manager allows you to create your own plugins (bundles) and load them at runtime. Phobos will "ship" with a plug-in that allows to export/import files in different formats: SQL, QIF, XML.

Whether you want to learn SQL or need a tool to look at the inner working (see the "Log" on the screen shot below) of the PostgreSQL server while you program a client application for it, EduPhant will be the answer.

You can use EduPhant regardless of your language or favorite operating system since it supports any text encoding PostgreSQL supports and works on Mac OS 8 and 9, OS X, Windows, and we have an experimental build for Linux too now.

Most other SQL clients dumbly enter data in PostgreSQL in their operating systems default text encoding, regardless of the encoding in which your database has been defined. This results in corrupted data that isnt usable cross-platform or with other clients that do respect the text encodings like EduPhant. The corruption is most noticable with non-ASCII characters like an accented "e."

EduPhants SQL query templates will allow the novices to quickly pick up the SQL syntax and logic, or they will jog the memory of the more advanced users. Plus they make it a breeze to rapidly construct your SQL queries. When you click on cells or headers of the query results table or of the database overview table, you enter their content into your query -- another very practical feature to reduce typing (and typos). You can also store your own custom SQL templates.

FmPro Worksheet - A free graphical utility for sending SQL commands to FileMaker 7/8 databases. FmPro Worksheet enables FileMaker 7/8 database developers to use libraries of SQL commands to speed development of FileMaker 7/8 solutions. FileMaker 7/8 developers can utilize all SQL commands supported by the FileMaker 7/8 database including CREATE TABLE, DROP TABLE, SELECT, INSERT, UPDATE and DELETE. FmPro Worksheet is available for MacOS X and Windows, and may be downloaded from: http://www.fmpromigrator.com/downloads/demo_software/index.html#download_fmpro_worksheet
Enhancements:
- Added new Batch Load & Execute feature.
- This feature loads and executes all of the .sql files located within a folder selected by the user.

View Apache PHP Errors is a small AppleScript that enables you to view SQL and PHP errors from the apache error log in BBEdit.

It shows how to populate an error browser.

View Apache PHP Errors is useful for PHP/MySQL development on your local machine.

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.

ODBC OverDRIVER is a Mac ODBC driver that enables FileMakerPro, Office, 4D, OMNIS and other Mac OS X applications to access hundreds of SQL database systems (including MS-Access, FileMakerPro, SQLServer, MYOB, ORACLE, DB/2, INFORMIX, AdaBase, Ingres, IMS, NonStop, Pick/Universe, mySQL, PostgresSQL, Rdb/VMS, DBMS, RedBrick, Pervasive and more) by way of a central Windows PC equipped with our ODBC ROUTER and the database vendors officially supported Windows ODBC driver.
Enhancements:
- Automatic translation of extended characters between MacRoman, Win-1252/ANSI and ISO-8859-1 (enabling text stored from one platform to be retrieved correctly on others)
- Improved memory management
- Additional per-connection GUI options
- Better performance, smaller footprint, less bandwidth.