SPARROWHAWK  SQLite does actually support foreign keys in terms of parsing - however it does not enforce them (i.e. they are ignored). Hopefully one day they will support them fully.

So theoretically this tool should be able to see these implied relationships and display the ERD for SQLite. I've not tried it so cannot say - if not you could ask the developer, it sounds like he is quite responsive.

Incidentally, you can force SQLite referential integrity using triggers - plenty of articles about this online.

Hope this helps.

Now, what I'd really like to see is TOAD for MySQL on OS X... :)  
(Version 1.4.2b2)

JOHN  The field types that are available can be completely customized to your needs, so it essentially works with any SQL Server from the design aspect.

As far as exporting SQL Queries, it supposedly exports to 'generic' SQL, MySQL, PostgreSQL and Sybase though I haven't tested it yet.

For importing, it utilizes the JDBC drivers, so if you've got a driver for your DBMS, you should be able to import just fine. Again, I haven't tested it myself, but the feature's in there.  
(Version 1.0CB11a)

AUSTIN TASHIS  Have you tried Aqua Data Studio?  
(Version 1.1b6)

ANONYMOUS  While a intersting product, DataWerkz is not a visual ER diagramming tool.  
(Version 1.0CB11a)

ANONYMOUS  YourSQL doesn't allow you to create ER diagrams.  
(Version 1.0CB11a)

ANONYMOUS  CrazyIvan,

Yes I mean Inferior exactly like my spelling ability. My spelling sucks, just like database apps for the Mac. Good example man. I'm proud of you. If spelling is your foundation for a good argument or a defense, you have a severe problem my friend.

I'm a die hard Mac user & am not knocking Apple itself in the slightest way. I never said anything in my post that would indicate that I was. I dont even own a Wintel box. As good as the OS envoronment is, the support for databases SUCKS. The ODBC Admin utility is largely useless as well as there being a severe lack of ODBC compliant applications for OS X.

Am I knocking MySQL? Ummm... yeah, actually I am. Sorry dude, market share doesn't equal quality. There is no easy way to install, configure, and administrate the application. Its largely command line, half the distributions require the end user to compile the stupid thing themsleves. Half the GUI front ends require a web server and PHP to run. I have yet to see a front end app that allows you to create and edit tables, fields stored procedures & relationships by dragging & connecting fields in tables. It supports fewer concurrent connections (at least it did last time I looked into it) than either Postgres SQL or SQL Server 2000. When I did Install it it I had to have an additional user on my laptop just to give MySQL an identity, which may be trivial but is just annoying to me. Overall its fine for epople that want to spend a bunch of time fighting with it, but I am far too busy to want to do command line work on a regular basis, let alone train anyone else to do it.

FURTHERMORE, many companies require SQL Server for other reasons. The BlackBaud fundraising software for example requires a SQL Server back end. MySQL is useless to me in that instance. Mac's offer very few solutions to administer SQL Server and those options are pricy & still incomplete.

As far as it MySQL being the most popular DB out there. Duh... its FREE. Same reason Apache is the most popular. Microsoft has the most widely distributed OS. You planning on switching to Windows soon? By your logic it MUST be better.

When push comes to shove yeah MySQL does a fine job & I wouldn't have any problem using it if it were even slightly conveniant, but the inconveniance of the app is rediculous & entirely antequated for anyone but the Unix geeks out there. I bought a MAC, the system that popularized the GUI. I dont want to Muck about with SQL statements & command line garbage. Now granted DB work isn'[t my full time thing so I dont know all the ins & outs, but thats the point. I need an app that doesn't require me to learn more. I have too much to have to keep up with as it is.

Might I recommend an intelligent argument next time rather than resorting to something as inconsequential as spelling or typos? And dont get your panties ina wad just because there are a few things that Microsoft really does do better for now.

"I dont give a d@mn for any man that can only spell a word one way" - Mark Twain  
(Version 1.0CB9)

NONA  URINATION CONTEST RESULTS!

C: "...don't knock Macs because 'MonopolySoft' doesn't port their software to other platforms. Don't kid yourself, Macs [could] certainly handle it."

10 decimeters.

A: "...yeah MySQL does a fine job & I wouldn't have any problem using it if it were even slightly convenient"

100 millimeters.

A: "Might I recommend an intelligent argument next time rather than resorting to something as inconsequential as spelling or typos?"

0.01 decameters

A: "(High profile) ...Customers ...are realizing significant cost savings by using MySQL's high performance, reliable database management software..."

0.001 kilometers.

And the winner is...  
(Version 1.0CB10)

ANONYMOUS  Would you be able to expand on this to offer suggestions as to which features should be included?  
(Version 1.0CB5)

MARK DEGG  I too would like a mimic of the MS SQL Enterprise Manager, i.e making new views and stored proceedures etc.  
(Version 1.0CB6)

ANONYMOUS  This is not intended to be a SQL Enterprise Manager. If that's what you're looking for, try Aqua Data Studio.

As for using Access to administer databases, I don't recommend it. There are too many data type inconsistencies. For example, Access can't tell the difference between a null and an empty string. You can copy a row of data from a table and then have Access refuse to let you paste the same row into another identical table because it thinks all the text fields with no text in them are null, so obviously something about the nature of the data has changed in the process of just copying and pasting. Not good.  
(Version 1.0CB7)

ANONYMOUS  Hey! Nice flame! The irony of thinking Access is usable while FileMaker is a joke... superb! Can't wait to read what you'll come up with next. You're a funny guy.  
(Version 1.0CB10)

ANONYMOUS  I think it's great. I currently use VPC and run SQL on my PowerBook so toggle to that screen to run enterprise manager.

My ideal scenario would be a native OSX app that lets me create/edit tables, stored procedures (and views) and also run queries against a database.

Real icing on the cake would be export scripts for structure and/or data

Access to functions such as profiler I can live with returning to the VPC shell as I imagine that would be very difficult to handle via a simple connection....  
(Version 1.0FC1)