Hi all, I know this is a bit off topic, but this list always has great ideas, and from what I can tell many of you use OS X. When using Rails I find myself constantly changing the DB structure (after all, there are no O/R mappings to regenerate ;), so I am looking for a database designer that allows me to visually create the DB structure and sync the structure with my DB. In Windows I used DBDesigner (http://www.fabforce.net/dbdesigner4/) which I liked very much, but after transitioning to a PowerBook, I haven''t been able to find a similar product for OSX. So far, Google has failed me. What DB design tools does this list use? What OSX products can people recommend? Thanks! --Dave.
> What DB design tools does this list use? What OSX products can > people recommend?Depends on your database, but for MySQL, there''s the excellent CocoaMySQL (http://cocoamysql.sourceforge.net/). I use that one all the time. -- David Heinemeier Hansson
And the more current YourSQL... http://yoursql.ludit.it/ David Heinemeier Hansson wrote:>>What DB design tools does this list use? What OSX products can >>people recommend? >> >> > >Depends on your database, but for MySQL, there''s the excellent >CocoaMySQL (http://cocoamysql.sourceforge.net/). I use that one all >the time. > >
On 19-jun-2005, at 18:22, David Teare wrote:> Hi all, > > I know this is a bit off topic, but this list always has great > ideas, and from what I can tell many of you use OS X. > > When using Rails I find myself constantly changing the DB structure > (after all, there are no O/R mappings to regenerate ;), so I am > looking for a database designer that allows me to visually create > the DB structure and sync the structure with my DB. In Windows I > used DBDesigner (http://www.fabforce.net/dbdesigner4/) which I > liked very much, but after transitioning to a PowerBook, I haven''t > been able to find a similar product for OSX. So far, Google has > failed me. > > What DB design tools does this list use? What OSX products can > people recommend?There are quite a few MySQL clients, but they are not "designers" in any way (no ER graph). Currently I know no good ER editors for OS X. XERD was the only one promising (http://www.joshuahawcroft.com/products/xerd/) but seems abandoned. -- Julian "Julik" Tarkhanov
On Jun 19, 2005, at 9:22 AM, David Teare wrote:> What DB design tools does this list use? What OSX products can people > recommend?If you''re on Tiger and install the developer tools, EOModel is now a part of Xcode. I have the older version installed with WebObjects, but I''ve been using it since 1998 as a GUI. It will generate the SQL as well. It works with anything that can connect to WO (Oracle, MySQL, etc). A wee sample of the output can be seen here: http://deirdre.net/?p=122 -- _Deirdre http://deirdre.net "Ideally pacing should look like the stock market for the year 1999, up and up and up, but with lots of little dips downwards...." -- Wen Spencer
On Jun 19, 2005, at 11:07 AM, Deirdre Saoirse Moen wrote:> On Jun 19, 2005, at 9:22 AM, David Teare wrote: > >> What DB design tools does this list use? What OSX products can >> people recommend? > > If you''re on Tiger and install the developer tools, EOModel is now a > part of Xcode.I forgot to add: this is as a part of the update available from developer.apple.com, probably not as part of the default install of Tiger''s dev tools. -- _Deirdre http://deirdre.net "Ideally pacing should look like the stock market for the year 1999, up and up and up, but with lots of little dips downwards...." -- Wen Spencer
> And the more current YourSQL... > > http://yoursql.ludit.it/I''ll second the recommendation for YourSQL. CocoaMySQL is fine, but it''s no longer under development. You don''t have to use it just cause DHH uses it in the videos. ;-)
I haven''t had a chance to try them yet at home (I use Windows, and SQL Server, at work), but MySQL just released MySQL Administrator and Query Analyzer tools as Free Software for Mac OS X. David> -----Original Message----- > From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails- > bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Julian ''Julik'' Tarkhanov > Sent: Sunday, June 19, 2005 12:49 PM > To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > Subject: Re: [Rails] OT: DB Designer for OS X > > > On 19-jun-2005, at 18:22, David Teare wrote: > > > Hi all, > > > > I know this is a bit off topic, but this list always has great > > ideas, and from what I can tell many of you use OS X. > > > > When using Rails I find myself constantly changing the DB structure > > (after all, there are no O/R mappings to regenerate ;), so I am > > looking for a database designer that allows me to visually create > > the DB structure and sync the structure with my DB. In Windows I > > used DBDesigner (http://www.fabforce.net/dbdesigner4/) which I > > liked very much, but after transitioning to a PowerBook, I haven''t > > been able to find a similar product for OSX. So far, Google has > > failed me. > > > > What DB design tools does this list use? What OSX products can > > people recommend? > > There are quite a few MySQL clients, but they are not "designers" in > any way (no ER graph). > Currently I know no good ER editors for OS X. XERD was the only one > promising (http://www.joshuahawcroft.com/products/xerd/) but seems > abandoned. > > -- > Julian "Julik" Tarkhanov > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails==============================================================================CONFIDENTIALITY NOTICE: The information in this electronic message (including any attachments) is confidential and may be privileged or proprietary. If you are not the intended recipient, any dissemination, disclosure, copying, downloading, or other use of the information is prohibited and unauthorized, and may be unlawful, regardless of address or routing. If you are not the intended recipient, please inform the sender immediately and permanently delete and destroy the original and any copies of this message, including any attachments. ==============================================================================
The replacement for DBDesigner 4, MySQL Workbench has been promised for sometime this year. From a post by Mike Lischke from MySQL, it will probably be near the end as it doesn''t sound like the project has a very high priority. Given MySQL''s increased support for OS X, I would deduce that this product too would be available in our favorite OS. Until then I develop at home on my iBook and move over to my work laptop to make my DB changes. *sigh* -Simon David Chilton wrote:>I haven''t had a chance to try them yet at home (I use Windows, and SQL >Server, at work), but MySQL just released MySQL Administrator and Query >Analyzer tools as Free Software for Mac OS X. > >David > > > > >>-----Original Message----- >>From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails- >>bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Julian ''Julik'' Tarkhanov >>Sent: Sunday, June 19, 2005 12:49 PM >>To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org >>Subject: Re: [Rails] OT: DB Designer for OS X >> >> >>On 19-jun-2005, at 18:22, David Teare wrote: >> >> >> >>>Hi all, >>> >>>I know this is a bit off topic, but this list always has great >>>ideas, and from what I can tell many of you use OS X. >>> >>>When using Rails I find myself constantly changing the DB structure >>>(after all, there are no O/R mappings to regenerate ;), so I am >>>looking for a database designer that allows me to visually create >>>the DB structure and sync the structure with my DB. In Windows I >>>used DBDesigner (http://www.fabforce.net/dbdesigner4/) which I >>>liked very much, but after transitioning to a PowerBook, I haven''t >>>been able to find a similar product for OSX. So far, Google has >>>failed me. >>> >>>What DB design tools does this list use? What OSX products can >>>people recommend? >>> >>> >>There are quite a few MySQL clients, but they are not "designers" in >>any way (no ER graph). >>Currently I know no good ER editors for OS X. XERD was the only one >>promising (http://www.joshuahawcroft.com/products/xerd/) but seems >>abandoned. >> >>-- >>Julian "Julik" Tarkhanov >> >>_______________________________________________ >>Rails mailing list >>Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org >>http://lists.rubyonrails.org/mailman/listinfo/rails >> >> > > >==============================================================================CONFIDENTIALITY NOTICE: The information in this electronic message (including any attachments) is confidential and may be privileged or proprietary. If you are not the intended recipient, any dissemination, disclosure, copying, downloading, or other use of the information is prohibited and unauthorized, and may be unlawful, regardless of address or routing. If you are not the intended recipient, please inform the sender immediately and permanently delete and destroy the original and any copies of this message, including any attachments. >=============================================================================>_______________________________________________ >Rails mailing list >Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org >http://lists.rubyonrails.org/mailman/listinfo/rails > >-- Simon C. Wex Sr. Software Developer simon-CdwZJljFklGxC8Nw+8W25jKzEDxYleXD@public.gmane.org 519.679.7888 "There are 10 types of people in this world, those who understand binary, and those who do not"
I''ve used them happily for windows, but they are still buggy as hell for osx. They look beautiful though. However much they crash and dont work quite as expected. I do hope that they will improve because the table designer functionality is superior to yoursql. etc. Even though yoursql is easier for day to day database admin. -Pelle On 6/21/05, David Chilton <david_chilton-Yt2XQmYAGVYAvxtiuMwx3w@public.gmane.org> wrote:> I haven''t had a chance to try them yet at home (I use Windows, and SQL > Server, at work), but MySQL just released MySQL Administrator and Query > Analyzer tools as Free Software for Mac OS X. > > David > > > > -----Original Message----- > > From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails- > > bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Julian ''Julik'' Tarkhanov > > Sent: Sunday, June 19, 2005 12:49 PM > > To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > Subject: Re: [Rails] OT: DB Designer for OS X > > > > > > On 19-jun-2005, at 18:22, David Teare wrote: > > > > > Hi all, > > > > > > I know this is a bit off topic, but this list always has great > > > ideas, and from what I can tell many of you use OS X. > > > > > > When using Rails I find myself constantly changing the DB structure > > > (after all, there are no O/R mappings to regenerate ;), so I am > > > looking for a database designer that allows me to visually create > > > the DB structure and sync the structure with my DB. In Windows I > > > used DBDesigner (http://www.fabforce.net/dbdesigner4/) which I > > > liked very much, but after transitioning to a PowerBook, I haven''t > > > been able to find a similar product for OSX. So far, Google has > > > failed me. > > > > > > What DB design tools does this list use? What OSX products can > > > people recommend? > > > > There are quite a few MySQL clients, but they are not "designers" in > > any way (no ER graph). > > Currently I know no good ER editors for OS X. XERD was the only one > > promising (http://www.joshuahawcroft.com/products/xerd/) but seems > > abandoned. > > > > -- > > Julian "Julik" Tarkhanov > > > > _______________________________________________ > > Rails mailing list > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > ==============================================================================CONFIDENTIALITY NOTICE: The information in this electronic message (including any attachments) is confidential and may be privileged or proprietary. If you are not the intended recipient, any dissemination, disclosure, copying, downloading, or other use of the information is prohibited and unauthorized, and may be unlawful, regardless of address or routing. If you are not the intended recipient, please inform the sender immediately and permanently delete and destroy the original and any copies of this message, including any attachments. > =============================================================================> _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- https://stakeitout.com + Stake out your own micro ventures http://neubia.com + Geek blog http://stakeventures.com + Bootstrapping blog http://SoapBX.com + Get on the box and shout
eomodeler the webobjects enterpise objects modeler free with the xcode tools starting with 2.1 you have to install the db''s appropriate jdbc drivers but it works great. there may even be a ruby OR mapping framework that understands eomodel files. hmm, that would be nice! -c On Jun 21, 2005, at 3:05 PM, David Chilton wrote:> I haven''t had a chance to try them yet at home (I use Windows, and SQL > Server, at work), but MySQL just released MySQL Administrator and > Query > Analyzer tools as Free Software for Mac OS X. > > David > > > >> -----Original Message----- >> From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails- >> bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Julian ''Julik'' Tarkhanov >> Sent: Sunday, June 19, 2005 12:49 PM >> To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org >> Subject: Re: [Rails] OT: DB Designer for OS X >> >> >> On 19-jun-2005, at 18:22, David Teare wrote: >> >> >>> Hi all, >>> >>> I know this is a bit off topic, but this list always has great >>> ideas, and from what I can tell many of you use OS X. >>> >>> When using Rails I find myself constantly changing the DB structure >>> (after all, there are no O/R mappings to regenerate ;), so I am >>> looking for a database designer that allows me to visually create >>> the DB structure and sync the structure with my DB. In Windows I >>> used DBDesigner (http://www.fabforce.net/dbdesigner4/) which I >>> liked very much, but after transitioning to a PowerBook, I haven''t >>> been able to find a similar product for OSX. So far, Google has >>> failed me. >>> >>> What DB design tools does this list use? What OSX products can >>> people recommend? >>> >> >> There are quite a few MySQL clients, but they are not "designers" in >> any way (no ER graph). >> Currently I know no good ER editors for OS X. XERD was the only one >> promising (http://www.joshuahawcroft.com/products/xerd/) but seems >> abandoned. >> >> -- >> Julian "Julik" Tarkhanov >> >> _______________________________________________ >> Rails mailing list >> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org >> http://lists.rubyonrails.org/mailman/listinfo/rails >> > > > ====================================================================== > ========CONFIDENTIALITY NOTICE: The information in this electronic > message (including any attachments) is confidential and may be > privileged or proprietary. If you are not the intended recipient, > any dissemination, disclosure, copying, downloading, or other use > of the information is prohibited and unauthorized, and may be > unlawful, regardless of address or routing. If you are not the > intended recipient, please inform the sender immediately and > permanently delete and destroy the original and any copies of this > message, including any attachments. > ====================================================================== > =======> _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails > >