Sponsored Content
Full Discussion: MySQL GUI recommendation
Top Forums Programming MySQL GUI recommendation Post 302976780 by stomp on Wednesday 6th of July 2016 05:32:58 AM
Old 07-06-2016
Quote:
...Visual Query Development...
I'm not very deep in Database-Application-Development. Mainly LAMP-Type Applications. But I've heard some horror stories of such great Query-GUI-Tools and what output was reported to be generated from them:

60-200 Lines of Code for SQL-Queries. Extremeley complicated. Extremeley Hard to debug. For myself, I'm very cautious not to create such a time bomb. But maybe the mentioned product
creates much cleaner Queries.

For now I create all Queries by Hand. Another reason for this is
to keep an eye on the performance of the query.

For day to day MySQL-Administration and Debugging I love HeidiSQL. A small and very powerful Management Application.(Supports Postgres too, and as I just read: even MS SQL).

I'll eventually have a look the DevArts product too. Thanks for sharing.

Just my 2 cents.
 

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
MySQL::Diff(3pm)					User Contributed Perl Documentation					  MySQL::Diff(3pm)

NAME
MySQL::Diff - Generates a database upgrade instruction set SYNOPSIS
use MySQL::Diff; my $md = MySQL::Diff->new( %options ); my $db1 = $md->register_db($ARGV[0], 1); my $db2 = $md->register_db($ARGV[1], 2); my $diffs = $md->diff(); DESCRIPTION
Generates the SQL instructions required to upgrade the first database to match the second. METHODS
Constructor new( %options ) Instantiate the objects, providing the command line options for database access and process requirements. Public Methods Fuller documentation will appear here in time :) o register_db($name,$inx) Reference the database, and setup a connection. The name can be an already existing 'MySQL::Diff::Database' database object. The index can be '1' or '2', and refers both to the order of the diff, and to the host, port, username and password arguments that have been supplied. o db1() o db2() Return the first and second databases registered via "register_db()". o diff() Performs the diff, returning a string containing the commands needed to change the schema of the first database into that of the second. COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
mysqldiff, MySQL::Diff::Database, MySQL::Diff::Table, MySQL::Diff::Utils AUTHOR
Adam Spiers <mysqldiff@adamspiers.org> perl v5.14.2 2012-04-06 MySQL::Diff(3pm)
All times are GMT -4. The time now is 11:57 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy