Sponsored Content
Full Discussion: MySQL GUI recommendation
Top Forums Programming MySQL GUI recommendation Post 302975505 by vich on Tuesday 14th of June 2016 12:12:14 PM
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.
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
SQL::ReservedWords(3pm) 				User Contributed Perl Documentation				   SQL::ReservedWords(3pm)

NAME
SQL::ReservedWords - Reserved SQL words by ANSI/ISO SYNOPSIS
if ( SQL::ReservedWords->is_reserved( $word ) ) { print "$word is a reserved SQL word!"; } DESCRIPTION
Determine if words are reserved by ANSI/ISO SQL standard. METHODS
is_reserved( $word ) Returns a boolean indicating if $word is reserved by either "SQL:1992", "SQL:1999" or "SQL:2003". is_reserved_by_sql1992( $word ) Returns a boolean indicating if $word is reserved by "SQL:1992". is_reserved_by_sql1999( $word ) Returns a boolean indicating if $word is reserved by "SQL:1999". is_reserved_by_sql2003( $word ) Returns a boolean indicating if $word is reserved by "SQL:2003". reserved_by( $word ) Returns a list with SQL standards that reserves $word. words Returns a list with all reserved words. EXPORTS
Nothing by default. Following subroutines can be exported: is_reserved is_reserved_by_sql1992 is_reserved_by_sql1999 is_reserved_by_sql2003 reserved_by words SEE ALSO
SQL::ReservedWords::DB2 SQL::ReservedWords::MySQL SQL::ReservedWords::ODBC SQL::ReservedWords::Oracle SQL::ReservedWords::PostgreSQL SQL::ReservedWords::SQLite SQL::ReservedWords::SQLServer ISO/IEC 9075:1992 Database languages -- SQL ISO/IEC 9075-2:1999 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation) ISO/IEC 9075-2:2003 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation) AUTHOR
Christian Hansen "chansen@cpan.org" COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.8.8 2008-03-28 SQL::ReservedWords(3pm)
All times are GMT -4. The time now is 08:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy