Re: [PHP] database design tool
On Feb 12, 2008 7:46 PM, Shawn McKenzie [EMAIL PROTECTED] wrote: Can anyone recommend a preferably visual DB design tool? I normally use mysql, but one that covered several types wood be cool. I'm on Linux, so the new mysql workbench is a dud. I used it in an alpha or prior version and it looked promising but crashed frequently. They say a Linux version in 2008, but I'm not holding my breath. Try DBDesigner4[1], MySQL based their workbench from DBDesigner. However, it won't allow you to connect to MySQL5 and sync your changes, but hey, you're looking for a graphical designer - and this tool is great for designing your DBs. You can install from source and tweak it a bit or you can install the win32 binary and let it run via wine (which works really well). [1] fabforce.net/dbdesigner4/ -- Dax Solomon Umaming http://knightlust.com/ GPG: 0x715C3547 signature.asc Description: This is a digitally signed message part.
Re: [PHP] database design tool
On Feb 12, 2008 7:46 PM, Shawn McKenzie [EMAIL PROTECTED] wrote: Can anyone recommend a preferably visual DB design tool? I normally use mysql, but one that covered several types wood be cool. I'm on Linux, so the new mysql workbench is a dud. I used it in an alpha or prior version and it looked promising but crashed frequently. They say a Linux version in 2008, but I'm not holding my breath. For RAD-style database design, check out OpenOffice.org Base. I know it comes pre-packaged with Mandriva (which I use), but I'm not certain about other distros. Depending on your flavor, you can probably apt-get, yum, urpmi, or manually install from an RPM or DEB. It works a lot like Filemaker and Access, so if you're familiar with those, you should notice a lot of similarities. Plus, it will work without a problem with MyODBC, Unix ODBC, JDBC, and native connections. For future reference though, Shawn, try sending to the PHP-DB list when asking questions like that. Then it's not off-topic. ;-) -- /Dan Daniel P. Brown Senior Unix Geek ? while(1) { $me = $mind--; sleep(86400); } ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] database design tool
Thanks. I use kubuntu and have all ooo including base, but it seems very minimal. I connected via jdbc (as only other option is odbc for mysql). I can't even see how to define a key as auto increment, there is no option. I tried dbdesigner4 and it is very old and buggy on linux. I found a post that suggested I download the windows version and run it under wine. Works great. As for the OT, many apologies, I never even thought of looking for a php-db list, thanks for the heads-up. -Shawn Thanks! -Shawn Daniel Brown wrote: On Feb 12, 2008 7:46 PM, Shawn McKenzie [EMAIL PROTECTED] wrote: Can anyone recommend a preferably visual DB design tool? I normally use mysql, but one that covered several types wood be cool. I'm on Linux, so the new mysql workbench is a dud. I used it in an alpha or prior version and it looked promising but crashed frequently. They say a Linux version in 2008, but I'm not holding my breath. For RAD-style database design, check out OpenOffice.org Base. I know it comes pre-packaged with Mandriva (which I use), but I'm not certain about other distros. Depending on your flavor, you can probably apt-get, yum, urpmi, or manually install from an RPM or DEB. It works a lot like Filemaker and Access, so if you're familiar with those, you should notice a lot of similarities. Plus, it will work without a problem with MyODBC, Unix ODBC, JDBC, and native connections. For future reference though, Shawn, try sending to the PHP-DB list when asking questions like that. Then it's not off-topic. ;-) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] database design tool
Can anyone recommend a preferably visual DB design tool? I normally use mysql, but one that covered several types wood be cool. I'm on Linux, so the new mysql workbench is a dud. I used it in an alpha or prior version and it looked promising but crashed frequently. They say a Linux version in 2008, but I'm not holding my breath. Thanks! -Shawn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php