Ezilon.com - Target Your Audience, be Seen in Your Region

Alternatives to MySQL

You are viewing this site as a guest. Join our community to get your questions answered and share knowledge. Active members may advertise and ask for a website critique.
Monkeyboy's picture

He has: 199 posts

Joined: Feb 2006

Some of my friends an I are planning on starting a CounterStrike Clan (yes I am probably a bit old for gaming) and want to set up a small website for it (In fact I think it's required for the league).

Annnnnyway, i'm looking at just getting a dirt cheap bit of hosting, like streamline.net's £19 a year jobby for this but all the cheap packages don't seem to have MySQL databases.

Is it possible to have a site with log-in details/member only areas without relying on a MySQL database? I've only ever used things like Gallery2 or Wordpress. Are there methods using just php/html e.t.c.

Can a website call up a database hosted by a different site, i.e. could I configure say a site on generichost.com to use a database on my host (I have MySql on my host)?

The general consensus is to have an 'individual' site and not use url forwarding otherwise I could just host using my space i'm already paying for (which I think is still the best option).

Cheers Smiling

J's World Welcome to my world

Monkeyboy's picture

He has: 199 posts

Joined: Feb 2006

That's good news, thanks for the help Conrad. If I can use my existing Database with a seperate site as you say then that's cracking.

I don't know anywhere near enough to develop a "database driven website with user authentication" myself but will have a look around for a decent script. Maybe something like phpBB or similar. Smiling

J's World Welcome to my world

andy206uk's picture
DeveloperModerator

He has: 1,742 posts

Joined: Jul 2002

I use the same host as you and they don't allow remote connections to mysql for security reasons.

If the data is relatively simple you could just store it in a delimited text file rather than using a 'proper' database. Unless it's gonna get loads of views and store loads of data using text files is more than sufficient for most peoples needs.

Andyk

Music Rants News and Reviews | My Photoblog | Blog of a Web Designer
Give a man a fish and you feed him for a day. Teach him to use the Net and he won't bother you for weeks.

Monkeyboy's picture

He has: 199 posts

Joined: Feb 2006

Pah! Foiled again! I've never even heard of a delimited text file so I suppose i'll just have to use url forwarding and use my current webspace if I need a database then. To be honest I should be able to get away without needing one though, it depends wether my friends decide they need a forum/members only part Smiling

J's World Welcome to my world

pr0gr4mm3r's picture
ModeratorSponsor

He has: 544 posts

Joined: Sep 2006

What about SQLite? As far as I know, PHP 5+ has it included by default, and it uses local files for the db.

Hey! It compiles! Ship it!

Monkeyboy's picture

He has: 199 posts

Joined: Feb 2006

Would this need to be set up on the server or would I be able to install it into my webspace and use from there? I've had a quick look at it and it looks like it's out of my league knowledge wise to try and use Confused

J's World Welcome to my world

pr0gr4mm3r's picture
ModeratorSponsor

He has: 544 posts

Joined: Sep 2006

Run a phpinfo() on your server to see if it's installed. If it's not, you should be able to run the binary w/o installing it.

Hey! It compiles! Ship it!

lordbiron's picture

He has: 73 posts

Joined: Feb 2007

noone is to old for gameing my dad is 62 and still plays halo with me

This one time... i looked down... and there was this little bug... and he was like ..."whats up?"