 Database Program With GUI |
|
|
|
|
  |
 Dec 22 2005, 03:51 AM
Post
#11
|
|
|
Advanced Member  Group: Members Posts: 105 Joined: 22-December 05 Member No.: 10,229  |
QUOTE(grumpygerbil @ Oct 11 2005, 06: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  Well if you have any programming experience, you can create your own GUI with Java. In my own experiences Java is a great front-end to use with Database applications. It is highly portable as in it should work the same on Windows or Linux or Mac. Java has great support for JDBC/ODBC connections and works with MS Access, mySql, SQL server, and DB2. If you are interested in going down this path, trying looking around for anything about Java Swing. That is the graphical interface library for Java. And of course the graphical end won't do squat if the SQL working behind it doesn't work. |
 |
 
|
|
Oct 21 2006, 05:28 PM
Post
#12
|
|
|
Member [ Level 1 ] Group: Members Posts: 34 Joined: 19-October 06 Member No.: 16,667 |
QUOTE(Quatrux @ Oct 12 2005, 11:59 PM) if you are talking about localhost on your computer, you can use mysql administrator if working with mysql. Yeah! First Install MySql and then start winmysqladmin from Strat Menu or go to c:\mysql\bin\winmysqladmin.exe. Its quite a good GUI for creating database and tables. It'll save you the hassle of installing Apache with php enabled. |
|
|
|
|
Oct 22 2006, 01:48 AM
Post
#13
|
|
|
Premium Member Group: Members Posts: 493 Joined: 15-August 05 Member No.: 7,873 |
Consider the phptriad option and then get phpForm Generator. I've found that to be a quick easy way of creating a custom database with online forms without having to code everything yourself. I am developing a CRM system to track some of our customers from a specfic promotion, instead of using our existing system, and used PhpFormGenerator which is free and opensource.
Closest you'll find in the opensource world to Access. Again this is for a quick and dirty project. (Speed and function needed as opposed to looks) |
|
|
|
|
Oct 25 2006, 09:54 AM
Post
#14
|
|
|
Newbie [ Level 1 ] Group: Members Posts: 1 Joined: 25-October 06 Member No.: 16,778 |
Hi
if are you working with MSSQL the easy ways to create tables are: Use "SQL Server Management Studio" from Microsoft Create tables in MSAccess then upgrade to MSSQL Create tables with MSAccess directly in MSSQL |
|
|
|
|
Dec 5 2006, 03:33 PM
Post
#15
|
|
|
PsYcheDeLiC dR3aMeR  Group: Admin Posts: 2,242 Joined: 29-January 05 From: Nakorn Chaisri, Thailand Member No.: 2,411 myCENTs:84.36 |
Just as an interesting footnote... the MySQL GUI program that I've been an avid fan of - the one which I've sung praises for, profoundly in my earlier posts in this thread has gone Open Source recently (Community Edition only)..
 Get your hands on the all new SQLYog 5.2 Comunity Edition along with source-code ( http://www.webyog.com/en/ ) This one's a MUST TRY. |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 22nd November 2008 - 09:14 PM |