Closed Thread Icon

Preserved Topic: MySQL/Database (Page 1 of 1) Pages that link to <a href="http://ozoneasylum.com/backlink?for=20907" title="Pages that link to Preserved Topic: MySQL/Database (Page 1 of 1)" rel="nofollow" >Preserved Topic: MySQL/Database <span class="small">(Page 1 of 1)</span>\

 
KARN
Bipolar (III) Inmate

From: North Bay, Ontario, CA
Insane since: Apr 2001

posted posted 05-11-2001 22:51

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::

jiblet
Paranoid (IV) Inmate

From: Minneapolis, MN, USA
Insane since: May 2000

posted posted 05-11-2001 23:38

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

KARN
Bipolar (III) Inmate

From: North Bay, Ontario, CA
Insane since: Apr 2001

posted posted 05-12-2001 00:39

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::

butcher
Paranoid (IV) Inmate

From: New Jersey, USA
Insane since: Oct 2000

posted posted 05-12-2001 01:04

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?

KARN
Bipolar (III) Inmate

From: North Bay, Ontario, CA
Insane since: Apr 2001

posted posted 05-12-2001 01:32

thanx butcher

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

mr.maX
Maniac (V) Mad Scientist

From: Belgrade, Serbia
Insane since: Sep 2000

posted posted 05-12-2001 08:54

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

kevincar
Paranoid (IV) Inmate

From: north hills, ca usa
Insane since: Apr 2001

posted posted 05-13-2001 20:50

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...



linear
Paranoid (IV) Inmate

From: other places
Insane since: Mar 2001

posted posted 05-14-2001 16:34

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.

jiblet
Paranoid (IV) Inmate

From: Minneapolis, MN, USA
Insane since: May 2000

posted posted 05-14-2001 17:31

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
Paranoid (IV) Inmate

From: north hills, ca usa
Insane since: Apr 2001

posted posted 05-15-2001 02:13

>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.



linear
Paranoid (IV) Inmate

From: other places
Insane since: Mar 2001

posted posted 05-15-2001 04:38

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

kevincar
Paranoid (IV) Inmate

From: north hills, ca usa
Insane since: Apr 2001

posted posted 05-15-2001 17:13

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.



« BackwardsOnwards »

Show Forum Drop Down Menu