mySQL server

[whackaxe]

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]

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]

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]

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]

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]

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]

*is curious*

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

[bcarl314]

Originally posted by Flamerule
*is curious*

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

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]

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



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