Login or Register to Ask a Question and Join Our Community


Programming

MySQL GUI recommendation

 
Thread Tools Search this Thread
Top Forums Programming MySQL GUI recommendation
Prev   Next
# 1  
Old 06-14-2016
MySQL GUI recommendation
I just wanted to share what a great MySQL (and other SQL) GUI DevArt provides.

3 years ago our company adopted a new ERP system that's entirely LAMP based. UGGG! Seriously? SQL Server *upgrade* to MySQL!???

This ERP is entirely vendor supported, but I have a replica database for data mining and ad-hoc reporting (full-on Crystal Reports served from an IIS Web Server). I was at a loss and searched everywhere for a SQL GUI that matched what Microsoft offers for SQL Server.

I'm aware of, and tried, the freebies (Quest Toad, Oracle, etc). Great on the surface but usability, as compared with Microsoft, was for the dogs. Finally I discovered and settled on DevArt DB Forge Studio for MySQL. I liked it enough that I later purchased their SQL Server version!

The ergonomics and usability for rapid development, as well as comprehensive database management, is outstanding!

3 years and probably 10,000 queries later, I'm still a fan. Just thought I'd share.

Note to purists: I came from a purist Oracle shop. After years of hand-typing all my queries and database object discoveries, I'm a convert and huge fan of 95% Visual Query Development, with 5% hand writing for the rare case when more complexity is needed. It works for my work environment anyway, where I'm lucky to get 30 minutes to deliver the typical inquiry ... with the GM breathing down my neck. Yeah, like I have time to hand type a query that links 5-10 tables and hand-type 15-20 column names. Even with a type-sensor, its arduous and brain-taxing.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Python gui or C++ gui or java gui?

python gui or c++ gui or java gui? and when to use etch one? (1 Reply)
Discussion started by: kaja
1 Replies

2. Red Hat

Open office recommendation

NEED recommendation and assistance on getting open office source installation on redhat 6 linux . I want an open office on redhat 6 linux server . Dont have root access Can someone guide me ? (0 Replies)
Discussion started by: ajayram_arya
0 Replies

3. UNIX for Dummies Questions & Answers

Mysql GUI tool?

Hi, I am looking for GUI based tool for Mysql. I found few but I need to pay for them to get the license. Since I work for mom & pop company, they don't have any money. :-( I was wondering if you guys know any good GNU tool out there? I get the data on the email, I was wondering if I... (3 Replies)
Discussion started by: samnyc
3 Replies

4. AIX

X-Client recommendation

Hi folks, Does someone have a good choice for a free xclient software ??? We used to use Xwin32 from Starnet, but there is a licensing issue currently happening and I need to indicate an alternative to it. The idea is just to provide a graphic interface access for AIX. Thanks Regards, ... (3 Replies)
Discussion started by: Ivan Junior
3 Replies

5. UNIX for Dummies Questions & Answers

LVm recommendation

hey guys i have a question about disadvantage of LVM i search many time but i cant find answer of my question i think it's undocumented. and my question : when or where is not good to use LVM or u dont recommended to use LVM ? is it every where benefit ??? (3 Replies)
Discussion started by: mhs
3 Replies

6. UNIX for Dummies Questions & Answers

Recommendation for a Server?

I would like to buy Itanium or PA-RISC server for the purpose of learning HP-UX operating system. As I don't have money to throw around, I'm looking for something older (used), just good enough to run newer version of OS for studying, experimenting, etc. What do you recommend? What to look for? ... (2 Replies)
Discussion started by: Moustahil
2 Replies

7. AIX

Recommendation help...

Hi guys, This is my first post. I have just started my training in AIX and would like some help with regards to training material. I have obtained IBM's CBTs (units 1 through 19) for AIX basics. I am looking at the following books - AIX 5L administration by Randal K Michael. - UNIX from new... (5 Replies)
Discussion started by: theaixeman
5 Replies

8. BSD

Partitioning recommendation

I have an old Pentium box pieced together from parts, and the 2G hard drive in it is showing signs of a coming death. I have purchased an 8G HD to replace the old one, and I plan to install NetBSD 1.6.1. The machine is to be used as a home server, with Mail handled as fetchmail -> sendmail ->... (4 Replies)
Discussion started by: criglerj
4 Replies

9. HP-UX

Hardware Recommendation

My J-Class system seems to have killed its onboard NIC. Does anyone have any good suggestions for a *cost effective* :p NIC for this machine? I am currently running 11i v1 on it, and have available PCI-X 5v slots. Alternatively, perhaps someone knows of where I might find a list of supported... (1 Reply)
Discussion started by: ipaddict
1 Replies

10. UNIX for Dummies Questions & Answers

If a is windows gui ( client), b is a unix gui ( Server for a) and c is a shell scrip

Hello all, 1) I want to have a GUI application that will call Unix shell scripts, 2) that GUI application should be able to reside on windows ( if possible) and then call Unix shell script either directly or through a server residing on unix. That is for example. If a is windows gui (... (1 Reply)
Discussion started by: hchivukula
1 Replies
Login or Register to Ask a Question

LEARN ABOUT OSX

dbix::class::storage::dbi::mysql

DBIx::Class::Storage::DBI::mysql(3)			User Contributed Perl Documentation		       DBIx::Class::Storage::DBI::mysql(3)

NAME

       DBIx::Class::Storage::DBI::mysql - Storage::DBI class implementing MySQL specifics

SYNOPSIS

       Storage::DBI autodetects the underlying MySQL database, and re-blesses the $storage object into this class.

	 my $schema = MyDb::Schema->connect( $dsn, $user, $pass, { on_connect_call => 'set_strict_mode' } );

DESCRIPTION

       This class implements MySQL specific bits of DBIx::Class::Storage::DBI, like AutoIncrement column support and savepoints. Also it augments
       the SQL maker to support the MySQL-specific "STRAIGHT_JOIN" join type, which you can use by specifying "join_type => 'straight'" in the
       relationship attributes

       It also provides a one-stop on-connect macro "set_strict_mode" which sets session variables such that MySQL behaves more predictably as far
       as the SQL standard is concerned.

STORAGE OPTIONS

   set_strict_mode
       Enables session-wide strict options upon connecting. Equivalent to:

	 ->connect ( ... , {
	   on_connect_do => [
	     q|SET SQL_MODE = CONCAT('ANSI,TRADITIONAL,ONLY_FULL_GROUP_BY,', @@sql_mode)|,
	     q|SET SQL_AUTO_IS_NULL = 0|,
	   ]
	 });

AUTHORS

       See "CONTRIBUTORS" in DBIx::Class

LICENSE

       You may distribute this code under the same terms as Perl itself.

perl v5.16.2							    2012-08-16				       DBIx::Class::Storage::DBI::mysql(3)