PDA

View Full Version : mySQL server



whackaxe
Jul 2nd, 2002, 07:27 PM
can anyone explai nto me why there are only a handfull of rubbish servers who give you a mySQL database. if anyone can explain that or tell me where i can find a free web host (apart from tripod with their HUGE ads) who support mySQL. a mySQL server is easy to setup and maintain so why dont people use one?

joh6nn
Jul 2nd, 2002, 07:35 PM
because for the most part, if you're using free hosting, then you don't need SQL. you need mouse trailers, and status bar scrollers.

Jeewhizz
Jul 2nd, 2002, 07:36 PM
because you can store pictures and sounds in a dbase, and its hard to monitor.. i.e. i can store an mp3 in a mysql dbase, and they'd have no idea what it was!

Jee

whackaxe
Jul 2nd, 2002, 07:45 PM
what! you can store mp3 in a db! i understand better. the thing is that i am developing a big phat PHP script which needs a DB (its a kind of hybrid forum for role playing games) and when you know you have to put 1 tables with 20 colums-unlimited rows, 1 tabel with 10 colums and about rows 300 rows, and another with 6 colums and 150 rows then you dont want to put that in an array. a friend of mine has even gone so far to make his own DB system using multi dimesional arrays. really this sux hard

joh6nn
Jul 2nd, 2002, 07:55 PM
if you're looking to play with new toys, so you can see how they work, you can go to evolt.org. but if you're looking to host a site, don't waste your time, because the server is only for development purpose.

whackaxe
Jul 2nd, 2002, 08:26 PM
yeah well thats the thing, i do want a host. i can do the messing about on my comp but i cant leave my comp on all the time just to be a server. and anyways it wouls be to slow. and i dont want to pay for a host just so i can get the script i'm working on into action and show people how it works and why maybe why they shpuld use it

Flamerule
Jul 3rd, 2002, 09:47 AM
*is curious* :D

How can you store images and sounds in a mysql database?:confused:

bcarl314
Jul 3rd, 2002, 01:54 PM
Originally posted by Flamerule
*is curious* :D

How can you store images and sounds in a mysql database?:confused:

I'm pretty sure you can store images in a mySQL DB, but the question I have is WHY? Personally, I think it's not an effecient use. I prefer to store a path the the image/sound file in a table and work from there. That doesn't bloat the DB then. I'm not sure if storing a huge amount of data (as would be necessary if you store a file IN a db) would cause performance issues, but I would assume it would.

Thejavaman1
Jul 4th, 2002, 01:42 AM
no, this causes performance issues



searchindex Browse Select Insert Properties Drop Empty 891,314 21.8 MB


It was near 1million entries until I reindex the search...

:eek:

people store files in MySQL because it is very secure if the DB password is kept secure...