 Database Program With GUI |
|
|
|
|
  |
 Oct 11 2005, 10:21 PM
Post
#1
|
|
|
Newbie [ Level 1 ]  Group: Members Posts: 4 Joined: 11-October 05 Member No.: 9,052  |
I am looking for a program to create SQL databases through a GUI to simplify it, the only things i can seem to find are command prompt things and i can't work with them. I like MS access and would like something similar to that if possible. I am working with windows at the moment can anyone recommend a program i can use (preferably free)
Many thanks |
 |
 
|
|
Oct 12 2005, 12:32 AM
Post
#2
|
|
|
Super Member Group: Members Posts: 572 Joined: 25-April 05 From: Nashville Tennessee Member No.: 4,340 |
Well it worn't work with MS Access but phpMyAdmin works really well with MySQL which is a open source (free) program but you need to also have PHP (also free) as well installed on your webserver or local server and I just downloaded the new MySQL database tool but haven't used it yet.
If you get an account with Astahost you will have all that and easily manipulate your databases. |
|
|
|
|
Oct 12 2005, 03:15 PM
Post
#3
|
|
|
Premium Member Group: Members Posts: 233 Joined: 11-February 05 From: Bangalore Member No.: 2,607 |
Well if you're interested in using PhpMyAdmin on a Windows platform then you ought to get yourself "PHPTriad". PHPTriad has Apache webserver (which runs on Windows), MySQL and PhpMyAdmin all bundled into one single installation.
When I first started out with PHP and testing my very basic skills on it, PHP Triad proved to be of huge assistance. I still use it to test any PHP based program before uploading to a website. For Windows though, I'm yet to come across a 'ready to go' GUI based DB manupulation software other than Access. Should you want to download it PHPTriad is available here |
|
|
|
|
Oct 12 2005, 05:21 PM
Post
#4
|
|
|
Advanced Member Group: Members Posts: 199 Joined: 3-October 05 Member No.: 8,888 |
QUOTE(grumpygerbil @ Oct 11 2005, 05:21 PM) I am looking for a program to create SQL databases through a GUI to simplify it, the only things i can seem to find are command prompt things and i can't work with them. I like MS access and would like something similar to that if possible. I am working with windows at the moment can anyone recommend a program i can use (preferably free) Many thanks  OpenOffice and StarOffice have a database component. I have not used the database component myself, mainly the word processor and spreadsheet, but it is there and other people have found it useful. It has its own built-in mini-database system and can also access other products via SQL. PgAccess is a TCL/Tk based system for administering Postgress database systems. It has support for creating tables, making queries, and the other basic functions you will need. I remeber it being a little stark and a bit tough to set up when I last used it, but it was over two years ago and it did the job. I have also used the database component of the Applix word processor suite but it does not look like it is sold anymore. Hope this helps. P.S.: As a free bit of advice (its worth what you pay for it), start getting your feet wet with the command-line tools a little at a time. In particular, use the GUI tools as learning aids. Look at the queries and commands they build and start figuring out how they work. The command-line tools are always the most flexible and reliable. When things go wrong, they are the most likely to continue working. They also let you automate tasks by executing saved scripts. GUI tools are great for visualizing your data and seeing the structure, but the command-line tools have their place as well. |
|
|
|
|
Oct 12 2005, 06:29 PM
Post
#5
|
|
|
the Q  Group: [HOSTED] Posts: 1,015 Joined: 13-July 05 From: Lithuania, Vilnius Member No.: 7,059 |
if you are talking about localhost on your computer, you can use mysql administrator if working with mysql.
|
|
|
|
|
Oct 12 2005, 09:36 PM
Post
#6
|
|
|
Super Member Group: Members Posts: 572 Joined: 25-April 05 From: Nashville Tennessee Member No.: 4,340 |
I tried the Triad about two or three years ago and then found XAMPP which ifs far superior and easy to install locally if you haven't used it before you will get rid of anything else and use it only.
It comes with the latest version of Apache HTTPD, MySQL, PHP, Perl, FileZilla FTP Server, phpMyAdmin, OpenSSL, Freetype, Webalizer, mod_perl, Turck MMCache, mcrypt, SQLite, JpGraph, Mercury Mail Transport System, PHPBlender PHP Compiler. It is a large program but very well worth the download. |
|
|
|
|
Dec 3 2005, 03:26 AM
Post
#7
|
|
|
Newbie [ Level 1 ] Group: Members Posts: 3 Joined: 3-December 05 Member No.: 9,937 |
ummm.. the only thing i can suggest for creation of databases is; MS Acess? But not sure if you will be able 2 upload it?
|
|
|
|
|
Dec 3 2005, 12:20 PM
Post
#8
|
|
|
PsYcheDeLiC dR3aMeR  Group: Admin Posts: 2,242 Joined: 29-January 05 From: Nakorn Chaisri, Thailand Member No.: 2,411 |
See even if you don't use mysql and prefer to use ms-access, you can create a system DSN (Data Source Name) and link it to this access file. Next you can easily connect to this DSN using one of the standard SQL Manipulation packages - like SQLYog ( http://www.webyog.com ) and work on it as if you were working on a proper RDBMS Server..
On Windows XP you can easily create a DSN, by Start > Control Panel > Administrative Tools > Data Sources (ODBC). Next you click on ADD and select the proper database driver (mdb in case of access) - and specify a name for that DSN.. Just go through the help files in case you get stuck there.. or better yet, post back here. Regards, m^e |
|
|
|
|
Dec 3 2005, 01:43 PM
Post
#9
|
|
|
Advanced Member Group: Members Posts: 196 Joined: 17-June 05 From: Topi,Swabi,NWFP,Pakistan Member No.: 6,301 |
for phpMyAdmin you need php and apache setup ...if you dont need taht and just want a plain GUI based thing ...go for MySQLAdministrator. Its available for both linux and windows. I use it some times when my phpMyAdmin is not working ...ie i am updating apache or have to shut it down for other reasons...
IMO it has more usability than phpMyAdmin and is targetterd for administrators. |
|
|
|
|
Dec 3 2005, 01:54 PM
Post
#10
|
|
|
PsYcheDeLiC dR3aMeR Group: Admin Posts: 2,242 Joined: 29-January 05 From: Nakorn Chaisri, Thailand Member No.: 2,411 |
I never liked phpMyAdmin in the first place - I found it quite slow and very limiting in many ways. For my regular work, I've to deal with databases which generate on an average of over 200,000 records a day.. phpMyAdmin is entirely unsuitable to handle such jobs..
As for desktop based GUI tools - I'd suggest you to try out SQLYog - it's a terrific product that beats MySQL Administrator hands down... You can grab a copy of their Lite and fully functional freeware at http://www.webyog.com .. Infact that's what I use to manipulate my databases on Astahost ... rather than log in to cPanel and use phpMyAdmin.. They're a MySQL AB Gold Certified Partner Company and I'd say hats off to their product.. Here's a short comparison and advantages of using this client, straight from their site: QUOTE Does the responsiveness of your web-based MySQL admin tool decrease your efficiency? Or does it make you sleep-deprived!? If yes, read on. One of the major reasons for the pervasiveness of your web-based MySQL admin tool is that your ISP/Web Hosting Partner is paranoid about security! Most ISPs block the MySQL port or prevent remote connections to MySQL. The only option then left with you is to manage MySQL with a server based application. You are forced to live with the annoying page-refreshes because your ISP wants to play safe! SQLyog changes the rules of the game. Just by uploading a single PHP page to your web server, you can use all the cool features of SQLyog. The PHP page exposes the MySQL API as a set of web-services that can be consumed by SQLyog. This is exactly the architecture that MS recommends for all new applications and calls them "smart clients". SQLyog allows you do some of the cool things that your web-based admin app can never (ever!) provide. Some of these are: * Ability to directly upload any ODBC DB ( Access, MS SQL, ORACLE ) directly to your MySQL without going through the cumbersome process of CSV/SQL export/import. An upload session can be saved as a job which can be scheduled. * Provide context-sensitive menus. * Prevents you from losing your work when you click on the close button of your browser! * 100% keyboard friendly for turbo speed MySQL management. * Synchronize the schema between your development server and the production server. * Synchronize the data between your development server and the production server. * Take scheduled backups with email alerts. * and much more! Source: http://www.webyog.com/sqlyog/sqlyogvsphpmyadmin.html Forgot to add - this is what MySQL AB says about this product: QUOTE "Webyog delivers easy-to-use productivity tools that are accelerating the adoption of MySQL with a broad range of users,” Bertrand Matthelié, director of Alliances at MySQL AB. “Webyog's flagship product, SQLyog, offers powerful features like HTTP/SSH tunneling, Scheduled ODBC imports, Data Sync, high speed Scheduled Backups, Structure Sync and Notification Services, and it can be an valuable part of any MySQL user’s tool chest." Give it a try guys ... I recommend this one STRONGLY  Unless you give it a shot, you wouldn't know what you're MISSING out on 
|
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 29th August 2008 - 02:21 AM |