Alternatives to MySQL
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
aka Rohan posted this at 13:09 — 13th February 2007.
He has: 200 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.
andy206uk posted this at 19:17 — 13th February 2007.
He has: 1,758 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.
Andy
aka Rohan posted this at 08:27 — 14th February 2007.
He has: 200 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
pr0gr4mm3r posted this at 00:24 — 16th February 2007.
He has: 1,502 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.
aka Rohan posted this at 09:12 — 16th February 2007.
He has: 200 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
pr0gr4mm3r posted this at 14:17 — 16th February 2007.
He has: 1,502 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.
lordbiron posted this at 17:31 — 16th February 2007.
He has: 71 posts
Joined: Feb 2007
noone is to old for gameing my dad is 62 and still plays halo with me
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.