Hello all, I am curious about what tools you guys use to make your databases. I know David uses CocoaMySQL. Are there other tools for other platforms and for other databases? I''m not very good with the SQL language, so I would like being able to do all my database setup with an easy-to-use tool (defining tables, fields, primary keys, foreign keys, indexes, etc.) Big kisses, Vincent. -- Vincent Foley-Bourgon Blog: http://www.livejournal.com/~gnuvince World.run while 6 * 9 == 42
I wonder if there''s an application that lets you set up a schema and then export DDLs for different databases. That would be helpful. On Wed, 9 Mar 2005 18:54:25 -0500, Vincent Foley <vfoley-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hello all, > > I am curious about what tools you guys use to make your databases. I > know David uses CocoaMySQL. Are there other tools for other platforms > and for other databases? I''m not very good with the SQL language, so > I would like being able to do all my database setup with an > easy-to-use tool (defining tables, fields, primary keys, foreign keys, > indexes, etc.) > > Big kisses, > Vincent. > > -- > Vincent Foley-Bourgon > Blog: http://www.livejournal.com/~gnuvince > World.run while 6 * 9 == 42 > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
Dbschema (www.dbschema.com) is very nice. It''s a java based so it''s platform independent, and is pretty robust and *very* cheap for a schema tool. Larry Wells Joe Van Dyk wrote:> I wonder if there''s an application that lets you set up a schema and > then export DDLs for different databases. That would be helpful. > >
Personally I just use text files and psql. I may have to sit down and have a look at some of these other options though. On March 9, 2005 05:09 pm, Larry Wells wrote:> Dbschema (www.dbschema.com) is very nice. It''s a java based so it''s > platform independent, and is pretty robust and *very* cheap for a schema > tool. > > > Larry Wells > > Joe Van Dyk wrote: > > I wonder if there''s an application that lets you set up a schema and > > then export DDLs for different databases. That would be helpful. > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails-- Scott Brooks Network Operations Manager Binary Solutions Ltd. sbrooks-7+OF9GBfT4Xe9wHmmfpqLOTW4wlIGRCZ@public.gmane.org
On Wed, Mar 09, 2005 at 06:54:25PM -0500, Vincent Foley wrote:> Hello all, > > I am curious about what tools you guys use to make your databases. I > know David uses CocoaMySQL. Are there other tools for other platforms > and for other databases? I''m not very good with the SQL language, so > I would like being able to do all my database setup with an > easy-to-use tool (defining tables, fields, primary keys, foreign keys, > indexes, etc.) > > Big kisses, > Vincent. > > -- > Vincent Foley-Bourgon > Blog: http://www.livejournal.com/~gnuvince > World.run while 6 * 9 == 42I''ve use DBDesigner4 from fabforce.net in the past. I really liked it. I''m not sure how it deals with the changed password algorithm in the newer versions of MySQL. It''s comparable to ER/WIN but the cost is right (free). If you''re a OSX user you might look into Data Architect from theKompany.com It''s about $60 downloaded. I have not used it and cannot vouch for it but it appears to have the essentials. Eric -- ------------------------------------------------------------------------ # Eric A Lucas | __|__ # "Oh, I have slipped the surly bond | *---oOo---* # of earth and danced the skies on | __|__ __|__ # laughter-silvered wings... | *---oOo---* *---oOo---* # -- John Gillespie Magee Jr. |
I use dia to draw the schema and tedia2sql to generate the DDL files. Granted I only generate for mysql db but tedia2sql can generate DDL for quite a number of other databases. On Wed, 2005-03-09 at 18:54 -0500, Vincent Foley wrote:> Hello all, > > I am curious about what tools you guys use to make your databases. I > know David uses CocoaMySQL. Are there other tools for other platforms > and for other databases? I''m not very good with the SQL language, so > I would like being able to do all my database setup with an > easy-to-use tool (defining tables, fields, primary keys, foreign keys, > indexes, etc.) > > Big kisses, > Vincent. >-- --------------------------------------------------------------- Privileged, confidential and/or copyright information may be contained in this e-mail. This e-mail is for the use only of the intended addressee. If you are not the intended addressee, or the person responsible for delivering it to the intended addressee, you may not copy, forward, disclose or otherwise use it or any part of it in any way whatsoever. To do so is prohibited and may be unlawful. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software. This message is subject to and does not create or vary any contractual relationship between Little Green Apples Pte Ltd (the Company) or any of its subsidiaries (comprising of LGA Technologies Pte Ltd; LGA International Pte Ltd; & LGA Telecom Pte Ltd) and you. By opening any attachment to this message, you also agree to accept the risk that it may contain a virus or damaging code, and you agree that the sender and/or the Company and its subsidiaries will not be liable for any loss or damage thereby caused. ---------------------------------------------------------------
On Wed, Mar 09, 2005 at 06:54:25PM -0500, Vincent Foley wrote:> Hello all, > > I am curious about what tools you guys use to make your databases. I > know David uses CocoaMySQL. Are there other tools for other platforms > and for other databases? I''m not very good with the SQL language, so > I would like being able to do all my database setup with an > easy-to-use tool (defining tables, fields, primary keys, foreign keys, > indexes, etc.)MS SQL Server Enterprise Manager and the corresponding SQL Query Analyzer are sweet. It''s cool using an ERD-style page (optionally showing columns within tables and even more if you want) to design the whole database, from tables to columns to relationships to other indexes. Is there anything like this for PostgreSQL? Cheers, Dave
Mostly out of habit I''ve stuck with web based tools, phpPgAdmin and phpMyAdmin. -Ross On Wed, 9 Mar 2005 18:54:25 -0500, Vincent Foley <vfoley-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hello all, > > I am curious about what tools you guys use to make your databases. I > know David uses CocoaMySQL. Are there other tools for other platforms > and for other databases? I''m not very good with the SQL language, so > I would like being able to do all my database setup with an > easy-to-use tool (defining tables, fields, primary keys, foreign keys, > indexes, etc.) > > Big kisses, > Vincent. > > -- > Vincent Foley-Bourgon > Blog: http://www.livejournal.com/~gnuvince > World.run while 6 * 9 == 42 > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
On Wed, 9 Mar 2005 18:54:25 -0500, Vincent Foley <vfoley-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I am curious about what tools you guys use to make your databases. I > know David uses CocoaMySQL. Are there other tools for other platforms > and for other databases? I''m not very good with the SQL language, so > I would like being able to do all my database setup with an > easy-to-use tool (defining tables, fields, primary keys, foreign keys, > indexes, etc.)I use MySQL''s "Administrator" GUI tool. But, if you don''t know MySQL well, it might trip you up a few times. http://www.mysql.com/products/administrator/ Their "Query Browser" tool is based around the same toolset but rather unstable on Linux at the moment. Leon
On Thu, Mar 10, 2005 at 05:53:34PM +1300, leon breedt wrote:> I use MySQL''s "Administrator" GUI tool. But, if you don''t know MySQL > well, it might trip you up a few times. > > http://www.mysql.com/products/administrator/ > > Their "Query Browser" tool is based around the same toolset but rather > unstable on Linux at the moment.I also usually use MySQL Adminstrator, although previously, I was pretty much in the habit of just writing SQL. I used to use ERWin for diagramming complex relationships, but it costs thousands of dollars, so I usually just do it in my head now. -- - Adam ** Optimize your Database! http://www.everylastounce.com/mysql.html ** Blog........ [ http://www.aquick.org/blog ] Links....... [ http://del.icio.us/fields ] Photos...... [ http://www.aquick.org/photoblog ] Experience.. [ http://www.adamfields.com/Adam_Fields_Resume.htm ]
Vincent Foley said something:> I am curious about what tools you guys use to make your databases. I > know David uses CocoaMySQL. Are there other tools for other platforms > and for other databases? I''m not very good with the SQL language, so > I would like being able to do all my database setup with an > easy-to-use tool (defining tables, fields, primary keys, foreign keys, > indexes, etc.)For Postgres, I found PgAdmin III (http://www.pgadmin.org/) very easy to use and powerful. iain
Hi Vincent,> I am curious about what tools you guys use to make your > databases. I know David uses CocoaMySQL. Are there other > tools for other platforms and for other databases? I''m not > very good with the SQL language, so I would like being able > to do all my database setup with an easy-to-use tool > (defining tables, fields, primary keys, foreign keys, indexes, etc.)For schema design, I personally use and enjoy DbDesigner from FabForce. It saves the database schema in its own XML format, and it can do round-trip engineering on MySql, SQL Server and a couple of others that I don''t use. It works well with Windows (if you''re using standard fonts). I think it''s written in Kylix, so there might be a Linux version (I''ve never looked into it). It can generate CREATE TABLE scripts for initial DB creation, and also ALTER TABLE scripts for modifications. You can also enter standard data for look-up tables etc. For query design, I use the tools that come with either MySql or SQL Server. Haven''t heard of CocoaMySql before. Adelle.
On Thursday 10 March 2005 01:13, Scott Brooks wrote:> Personally I just use text files and psql. I may have to sit down and have > a look at some of these other options though.Might want to take a look at pgaccess. rhdb-admin is nice too, but it''s crashing with some silly bug on debian right now. phppgadmin is a good web-based UI (although it''s php, *spit* ;). There is another PostgreSQL GUI... pg(something)3, I think, but I can''t recall what it''s like. -- Lee.
> I''ve use DBDesigner4 from fabforce.net in the past. I really liked > it. I''m not sure how it deals with the changed password algorithm > in the newer versions of MySQL.I''ve been using the DBDesigner4 program for quite some time and have had nothing but good results with it. It has the ability to export your diagrams as an image (good for printing and taping up on the walls in your office so the boss *thinks* you are doing something) and as an HTML report. --austin
Hello, i''m now using YourSQL. It''s perfect for "clicky" create of the tables (it''s the easiest app I''he ever use :), then export it to sql for versioning and so. But I guess it''s Mac and MySQL only. Pepe On 10.3.2005, at 5:53, leon breedt wrote:> On Wed, 9 Mar 2005 18:54:25 -0500, Vincent Foley <vfoley-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: >> I am curious about what tools you guys use to make your databases. I >> know David uses CocoaMySQL. Are there other tools for other platforms >> and for other databases? I''m not very good with the SQL language, so >> I would like being able to do all my database setup with an >> easy-to-use tool (defining tables, fields, primary keys, foreign keys, >> indexes, etc.) > I use MySQL''s "Administrator" GUI tool. But, if you don''t know MySQL > well, it might trip you up a few times. > > http://www.mysql.com/products/administrator/ > > Their "Query Browser" tool is based around the same toolset but rather > unstable on Linux at the moment. > > Leon > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
Dezign for Databases (datanamics.com) does this well, imho. Other tools to do so for reasonable/right prices (but for much more limited set of RDBMS) include ReKall (thekompany.com), dia (?) and Visio Professional. I think Visio Enterprise will do two-way, but it''s just overkill. Dezign does a good job with ERD design. On Wed, 9 Mar 2005 15:57:49 -0800, Joe Van Dyk <joevandyk-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I wonder if there''s an application that lets you set up a schema and > then export DDLs for different databases. That would be helpful. > > > On Wed, 9 Mar 2005 18:54:25 -0500, Vincent Foley <vfoley-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > Hello all, > > > > I am curious about what tools you guys use to make your databases. I > > know David uses CocoaMySQL. Are there other tools for other platforms > > and for other databases? I''m not very good with the SQL language, so > > I would like being able to do all my database setup with an > > easy-to-use tool (defining tables, fields, primary keys, foreign keys, > > indexes, etc.) > > > > Big kisses, > > Vincent. > > > > -- > > Vincent Foley-Bourgon > > Blog: http://www.livejournal.com/~gnuvince > > World.run while 6 * 9 == 42 > > _______________________________________________ > > Rails mailing list > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >