Preserved Topic: MySQL/Database (Page 1 of 1)

I'm about to get into the MySQL and Database thing and I was wondering do you have to purchase these from your server or can you make them yourself cause on my current server they said you can buy them and I'm not too sure how to set one up...

::K::A::R::N::

When you purchase them from your server you are basically purchasing ACCESS to them. The software itself is free, and if you ahve your own Apache server then you can install them (but it's not too easy to set up). The reason your ISP charges you is not for the software itself, but rather for the processing power that they suck from the server.

Buying it is definitely gonna be your best bet because you'll know they have it set up correctly, and you can jump right in learning.

-jiblet

I see... I'll just have to learn how to operate one instead of setting it up... usually does it go monthly pay or just one payment?

::K::A::R::N::

KARN

If you want to learn to use a database, there's nothing like having one of your very own. This link will get you set up with the software you need.
http://www.phpgeek.com/phptriad.php With it you will get the Apache/PHP/MySQL trio.

Then you can learn while doing on your own machine. There's some good books for PHP and MySQL, lots of tutorials, and a whole boat load of knowledgeable, helpful, people in this here forum.

Give it a shot! What have you got to lose?

thanx butcher

::K::A::R::N::

There's also another Apache/PHP/MySQL bundle called FoxServ available...

What someone needs to do is develop an FTP-able DB product, so us
small-timers can simply download the engine to our site and do DBMS work
without paying ISP's "standard business rates" - I.e., out the wazoo.

My take on MySQL-
I can't do serious (ie, meaningful) schemas without views and stored
procedures, sorry. Maybe MySQL does these things now (I hope they do), but
IMHO, you're better off spending a few dollars and getting POLITE
(Personal Oracle Lite).

I don't know enough about IP adressing to answer this, but is it possible to
have my DB (let's say, Personal Oracle - a great RDBMS engine for the bux)
running on my DSL-equipped home computer, and then having my java servlets
runnng on my cheepie webdot.net domain accessing my Oracle engine via
the non-authenticated IP address? If so, this could be REALLY badass...

Possible, but DSL is too flaky to seriously consider it.
Some providers explicitly forbid it.
Allowing access by IP address alone is suicidal (someone could bury you in packets, if nothing else).
Most providers use dynamic IP addressing of some type which makes it nigh-on impossible to run a server.
And MySQL works great for me w/o views and stored procedures. I guess it's all in how you were trained.

kevincar - why so demanding of your database? Whatever you use for access can provide the functionality you want. I wouldn't pay for a database unless I really needed the extra horsepower.

-jiblet

>kevincar - why so demanding of your database? Whatever you use for access can >provide the functionality you want. I wouldn't pay for a database unless
>I really needed the extra horsepower.

Well, yeah, for simple stuff.

Basically, (VERY broad strokes here) Views reduce duplication of data, and stored procedures gets code out of your program... I've done a lot of very heavy database work before, and I just kinda got used to those features.

I didn't mean to sound dogmatic.

So how much does it cost to get POLITE? (cause I can stay rude for free )

Well, that depends :-)

Oracle has the most Byzantine pricing structure in the world -
I got POLITE free with Symantec Visual Cafe.
You can buy it from http://oraclestore.oracle.com for anywhere from
$39.95 to $300, depending on the package.

Keep in mind, Oracle is probably more complicated than most operating systems -- and I know a lot of people who make pretty good careers just specializing within a SPECIALTY of the Oracle product-line :-)

But you really can buy it for a song (relatively) and learn about what a big-boy database is all about.