Domain: minq.se
Stories and comments across the archive that link to minq.se.
Comments · 14
-
Re: there are more tools available for MS SQL
(Note - some content cross posted from the recent MSSQL2005 posting I made)
I take issue with the number of tools.
Postgresql has a great variety of tools, both OSS and commercial that work great. I've been working on an updated list of all the tools. Here are a few of the most popular admin tools:
PGadminIII
http://www.sqlmanager.net/products/postgresql/mana ger [sqlmanager.net]
DBvisualizer
http://www.minq.se/products/dbvis/ [www.minq.se]
EMS Postgresql Manager
http://www.sqlmanager.net/products/postgresql/mana ger [sqlmanager.net]
PHPpgadmin
http://sourceforge.net/projects/phppgadmin [sourceforge.net]
Sybase Power Designer
http://www.sybase.com/products/enterprisemodeling/ powerdesigner [sybase.com]
ERWIN data modeller
http://www3.ca.com/Solutions/Product.asp?ID=260 [ca.com]
CASE Studio 2
http://www.casestudio.com/enu/default.aspx [casestudio.com]
Postgresql has a vibrant tool community. If you want more info on Postgresql tools see
http://techdocs.postgresql.org/v2/Guides/PostgreSQ L%20GUI%20Tools/document_view [postgresql.org] -
Re: "Not many good tools for PostGreSQL"
dbvis is a nice bit of software and works with any db that has Java drivers, i.e. most of them. See here.
-
Re: "Not many good tools for PostGreSQL"
This must be in satire, or ignorance.
Postgresql has a great variety of tools, both OSS and commercial that work great. I've been working on an updated list of all the tools. Here are a few of the most popular admin tools:
PGadminIII
http://www.sqlmanager.net/products/postgresql/mana ger
DBvisualizer
http://www.minq.se/products/dbvis/
EMS Postgresql Manager
http://www.sqlmanager.net/products/postgresql/mana ger
PHPpgadmin
http://sourceforge.net/projects/phppgadmin
Sybase Power Designer
http://www.sybase.com/products/enterprisemodeling/ powerdesigner
ERWIN data modeller
http://www3.ca.com/Solutions/Product.asp?ID=260
CASE Studio 2
http://www.casestudio.com/enu/default.aspx
Postgresql has a vibrant tool community. If you want more info on Postgresql tools see
http://techdocs.postgresql.org/v2/Guides/PostgreSQ L%20GUI%20Tools/document_view -
Re:Newbie Question - UI Tool
If you don't mind Java GUIs, Db Visualizer is pretty slick.
-
Try DBVisualizer, Colorful and powerful
minq.se
Free (you need to registers), commercial version available($99 i guess).
Ok, this is not really an end-user tool, but an absolutely great DB Frontend. Written in Java, runs on many platforms, very nicely designed and quick.
Java has very solid database drivers these days, as Java (like it or not) has become the main middleware and server-side programming language.
Note to all those java haters out there: try it, you'll like it!
-
While your waiting...
I look forward to this being released. I've tried several different gui's for working with MySQL but have not found one that does everything I hoped for. Until it's released, I've found combining Dbvisualizer and phpMyAdmin works.
It would be really nice to have the features of both all combined in one nice gui...which is what I hope this will be.
-Pat -
Re:GCJ performance is a myth. Benchmarks inside.
Because pretty much the main drawback of Java is that it severly limits which platforms you can distribute to, ironically.
Let's assume for a second that you are correct, and Java limits the platforms you can distribute to. Tell me again exactly how GCJ improves on that?The only other option is distributing a 50 meg JVM with every app
The JRE is 13 MB last I looked. And you only have to download it once and it works for all your Java apps. Most Java applications are offered in a package both with and without a JRE. For example DbVisualizer (I wholeheartly recommend this database tool, very good and supports pretty much all databases) and IntelliJ IDEA (the best development environment ever).and increasing support costs by having to walk people through tedious installation procedures, for the JVM and your app.
The apps I showed as examples are one-click installable. Most others are too. Your statement was completely wrong and should have had a huge FUD warning sign all over it.If you can compile a native binary, you can distribute it to any binary compatible platform, regardless of what other software they have installed.
GCJ requires the GCJ runtime libs last I messed with it. Exactly how is this different from installing JRE?You don't have to explain CLASSPATH to your users.
Read the documentation on the Java site. Use of the CLASSPATH environment variable has been stringly discouraged ever since the 1.2 days. I hardly ever use it myself, although it's nice to have if I need it (mainly when developing and trying out different libraries).You don't have to explain why they can't type "java filename.class", but instead must type "java filename".
I have a better solution: Just double-click on the app! Yes, can you believe it? Ever since 1.2 there has been support for executable JAR's. When you install Windows .jar files are automatically associated with the Java runtime so that you can double-clik on the app to start it. If you have the stupid "hide extensions" feature enabled it looks just a normal app. I believe MacOSX does the same (although I haven't tried). Enabling the same in Nautilus is just a couple of mouse clicks away. From the command like you do have to type "java -jar the_application.jar".GCJ is the only hope Java has of actually being more than an acedemic curiosity, and "something that Sun used for a few apps".
Maybe you should leave the academic environment for a while and realise that Java is heavily used for developing very real and existing applications in Java. Also check out the statistic on programming language usage with PostgreSQL. I'm not so sure I should believe your asstertion that Java isn't used oustide of academic institutions.Are you even aware of the number of web sites exist whose server code is completely written in Java? Most likely you visitied a couple before you came here today.
-
Re:GCJ performance is a myth. Benchmarks inside.
Because pretty much the main drawback of Java is that it severly limits which platforms you can distribute to, ironically.
Let's assume for a second that you are correct, and Java limits the platforms you can distribute to. Tell me again exactly how GCJ improves on that?The only other option is distributing a 50 meg JVM with every app
The JRE is 13 MB last I looked. And you only have to download it once and it works for all your Java apps. Most Java applications are offered in a package both with and without a JRE. For example DbVisualizer (I wholeheartly recommend this database tool, very good and supports pretty much all databases) and IntelliJ IDEA (the best development environment ever).and increasing support costs by having to walk people through tedious installation procedures, for the JVM and your app.
The apps I showed as examples are one-click installable. Most others are too. Your statement was completely wrong and should have had a huge FUD warning sign all over it.If you can compile a native binary, you can distribute it to any binary compatible platform, regardless of what other software they have installed.
GCJ requires the GCJ runtime libs last I messed with it. Exactly how is this different from installing JRE?You don't have to explain CLASSPATH to your users.
Read the documentation on the Java site. Use of the CLASSPATH environment variable has been stringly discouraged ever since the 1.2 days. I hardly ever use it myself, although it's nice to have if I need it (mainly when developing and trying out different libraries).You don't have to explain why they can't type "java filename.class", but instead must type "java filename".
I have a better solution: Just double-click on the app! Yes, can you believe it? Ever since 1.2 there has been support for executable JAR's. When you install Windows .jar files are automatically associated with the Java runtime so that you can double-clik on the app to start it. If you have the stupid "hide extensions" feature enabled it looks just a normal app. I believe MacOSX does the same (although I haven't tried). Enabling the same in Nautilus is just a couple of mouse clicks away. From the command like you do have to type "java -jar the_application.jar".GCJ is the only hope Java has of actually being more than an acedemic curiosity, and "something that Sun used for a few apps".
Maybe you should leave the academic environment for a while and realise that Java is heavily used for developing very real and existing applications in Java. Also check out the statistic on programming language usage with PostgreSQL. I'm not so sure I should believe your asstertion that Java isn't used oustide of academic institutions.Are you even aware of the number of web sites exist whose server code is completely written in Java? Most likely you visitied a couple before you came here today.
-
They're not toad...
SQLGrinder
or (free)
DBVisualizer
We have grinder in the office, and if I end up doing too much more SQL work, myself, I'll probably grab a copy. Right now I use DBVis, which is a nice free product. Both have their pros and cons, and neither is TOAD, but if you don't want to fire up (or buy) VPC, they may be good enough. -
Re:Skills
And back in 97, I played around with a Java applet that could render Quake maps on a PPro-180 just fine. I was making UIs with the AWT that were fast and responsive, and I've done the same with swing. Mostly, my work has me doing J2EE, so it's just web based front ends, but I can still cut a reasonable UI. Check out DBVisualizer for a Swing UI that is responsive, well designed, easy to use, and gives you access to any JDBC database (close to TOAD in quality, but DBV 2.1 lacked updating via the data view and no cration wizards, while TOAD didn't have the relational graphing).
It is possible to do, but if you
a) don't care about speeding your UI up and/or,
b) believe the UI is slow because of Java and not because of crappy coding
then you will end up with a slow UI. -
Re:MySQL Control Center
I like dbVisualizer . It works with any Java 2.0 drivers to give you TOAD like access to the database. I doesn't have everything TOAD gives you (no wizards), but it does relational mapping and you can have all your databases in one tool (I have Oracle, Postgres, and MySQL on there).
-
Re:Performance
Other people have mentioned \dt , but I wanted to say you should try out DB visualizer. It's like TOAD without the wizards, but works for any JDBC database (even cloudscape). Very cool tool and best of all, free (as in beer, maybe as in speech too)
-
DBVisualizer or Visual Thought
A shameless plug for Visual Thought. It won't do ERD automatically, but it's great for the stuff you'd use a whiteboard for usually.
If you want to look at the structure of an existing database, try DBVisualizer -
Re:STILL looking for Access(TM) replacement
Well, this isn't Access, but Db Visualizer is the best cross-platform (Java) SQL tool I've ever seen. It's still not a tool for morons (it's aimed at SQL developers,) but it lets you visually edit rows in your DB and other niceties.
Sure beats INSERT INTO and UPDATE WHERE.