Access Clone?

[cjolley]

Originally posted by Gurm
No no.

MySQL and PostgreSQL are database SERVERS.

To create the database you still need a DB tool, any will do if you aren't connecting to an MS database server.

- Gurm

Sorry, I only know Oracle. You lost me.
They don't come with a gui or commandline tool that can take a "create database..." command?
What sort of generic tool could do that?
Or, do you mean the tables and code for the database?
In which case the DB server should still come with some kind of interface, shouldn't it?
chuck

[Kurt]

Originally posted by Kooldino
Hmmm, it's a possibility. I'm just trying to avoid as much MS stuff as possible.

You can always try Filemaker Pro (www.filemaker.com). I have to see an easier DB yet. Makes DBs in minutes with a nice graphical interface, put icons, pictures, whatever...push a button and it's web enabled...voilà!

It's not for overly complex projects as it doesn't have a general overview of all links and databases à la Access. Not that it couldn't handle it..."your brain's the limit" is more like it

4D is another one that's promising. You can code your DB and reuse the code as snippets you store as you like.

[drslump]

Originally posted by cjolley
Sorry, I only know Oracle. You lost me.
They don't come with a gui or commandline tool that can take a "create database..." command?
What sort of generic tool could do that?
Or, do you mean the tables and code for the database?
In which case the DB server should still come with some kind of interface, shouldn't it?
chuck

You can login into the db server and create the data structures by hand. For a GUI front-end there are lots of alternatives being my favorite one mysqlfront.
There is also a very nice web front-end in php phpmyadmin.

I personally found the SQL language very easy to work with if you don't try to do complex request.

-Dr.Slump

[cjolley]

Originally posted by drslump
...For a GUI front-end there are lots of alternatives being my favorite one mysqlfront.
There is also a very nice web front-end in php phpmyadmin.

I personally found the SQL language very easy to work with if you don't try to do complex request.

-Dr.Slump

All I do, all day long, every day, is write complex SQL (or design the structures they run against)

For Oracle the usual tool of choice in windows is TOAD

https://www.toadsoft.com

There is nothing better, plus it goes "ribbet" when it starts

chuck

[Kooldino]

Originally posted by cjolley
We are an all MS shop (except for Oracle).
I am mainly a DB programmer and designer for applications, not web, but I use ASP to do the small amount of web interface DB stuff I'm responsible for.
It was easy to learn.
You can also use JAVA.
chuck

PS Not maddness! FUN!!!!

Ok, well i know a little java...what's the easiest way for me to go? Java/Oracle? etc.

[Kooldino]

Man, so many different suggestions. Hehe.

Ok, it looks like I need a DB creator/editor/frontend program (for example, one that works like Access). I ALSO need a DB server (Windows, Linux, i don't care which, as long as it's easy), and then I need to use a language to CONNECT to my database server (Java, ASP, etc). I'd like to be able to make completely dynamic web pages and easily do a "search" function. And since this is new to me, I'd like a language with a lot of built in functions, or at least some good code examples I can use to get started.

So let's hear some suggestions for the DB frontend editor, the server, and the connecting language, if you will.

[cjolley]

How much time do you want to spend on this?
1, Pitch tent & do some camping?
2, Buy a house in the suburbs?
3, Build a log cabin?
4, Build a house of your own from scratch?
5, Become a carpenter?

chuck

[Ali]

I use Postgres here, and psql as the front end. Its all command line, but thats fine for setting up if you know SQL.

For interface, I like PHP for web stuff, and use Delphi for local stuff.

There is lots of stuff (help, source etc) on the net about mySQL, and its meant to be good, but Ive never used it.

Whatever you do, get away from Access, and use some 'real' DB, that uses SQL.

Ali

[Drizzt]

Kooldino, you look a bit confused...

What do want to do, exactly?

[Kooldino]

Originally posted by cjolley
How much time do you want to spend on this?
1, Pitch tent & do some camping?
2, Buy a house in the suburbs?
3, Build a log cabin?
4, Build a house of your own from scratch?
5, Become a carpenter?

chuck

Somewhere between 1 and 2 would be nice.

[Kooldino]

Originally posted by Drizzt
Kooldino, you look a bit confused...

What do want to do, exactly?

Just like I said above...I want...

-a GUI tool to create a DB with
-a db server for Linux or Windows to HOST said DB
-some way of connecting EASILY to the DB from a web page, and allow things such as Searching, Adding to the DB, and creating dynamic pages simply and quickly. I can code if necessary, but the LESS i have to code the better. Unless it's really simple, quick code. I just don't wanna spend TOO much time on it.

Also, I'd REALLY prefer it if all of what i need from my above list are free for personal use.

[Gurm]

Well, for FREE servers, you're limited to the SQL flavors except MS SQL. That's MySQL, PostgreSQL, mSQL, etc.

As for FREE graphical tools... there are lots and lots, although I tend to either write PHP code to do it for me or else I use PHPmyAdmin.

And ... to connect from a web page, err... you'll need to learn SOME kind of server-side scripting. Sorry.

- Gurm

[Drizzt]

Originally posted by Kooldino
Just like I said above...I want...

-a GUI tool to create a DB with
-a db server for Linux or Windows to HOST said DB
-some way of connecting EASILY to the DB from a web page, and allow things such as Searching, Adding to the DB, and creating dynamic pages simply and quickly. I can code if necessary, but the LESS i have to code the better. Unless it's really simple, quick code. I just don't wanna spend TOO much time on it.

Also, I'd REALLY prefer it if all of what i need from my above list are free for personal use.

Ok, in a few words you want to create "easily" a web site.

So, the first question is: who is the server provider? In other words, where the website will be hosted?

And, if the provider is yourself: what kind of OS are you using to host?
If the provider is a commercial provider, what services he is offering to you?
I think it's useless if we teach you hou to use PHP and MySql, if your provider give you only M$, or the reverse.

[Kooldino]

Originally posted by Drizzt
Ok, in a few words you want to create "easily" a web site.

Basically, yeah.

So, the first question is: who is the server provider? In other words, where the website will be hosted?

And, if the provider is yourself: what kind of OS are you using to host?

I have some 2k/xp boxes and a box running mandrake 9.

If the provider is a commercial provider, what services he is offering to you?
I think it's useless if we teach you hou to use PHP and MySql, if your provider give you only M$, or the reverse.

Good point, but yeah, I'll be running off of a home machine for simplicity.

Gurm: I'm not totally against learning some kind of scripting language, I just want something where I'd be able to find a good amount of examples on the web, that's versatile, easy to learn, and not a pain in my ballz. :-) I know about a dozen or so languages now, so at this point I pick up on them quick (they're all the same after awhile). I know Javascript and I've just dabbled in java breifly...would either of those suffice? If not, which is the way to go?

[Gurm]

Well the issue with Java is that it's client-side and your DB server would be accepting connections from all over the place, which is a MAJOR security risk.

You could do server-side Java... or JSP. But I personally found that harder to learn (and implement/install/work with) than PHP.

- Gurm