Well, there are some free hosting services here and there. It "could" be possible to use one of those perhaps?

Also, let's settle this argument, marv and Holy: You both get ME drinks instead.
I just solved your problem, you should be thanking me just now.

kitaman27

United States9245 Posts

January 31 2014 02:33 GMT

#166

We've given that a try, but unfortunately we weren't able to get any functionality out of it. Hopefully I'll come up with something in the next few weeks.

Keirathi

United States4679 Posts

January 31 2014 03:24 GMT

#167

What kinda server stuff do you need for the script to run? PHP & SQL? Or is it Python + SQL or something?

If you only need PHP and SQL, you could always host it on SourceForge. If you put a project on there, they give you free webspace that you can use and a couple of databases. I don't remember what all features it has, but I made a site on there a while back for a thing I made.

Palmar

Iceland22633 Posts

January 31 2014 11:59 GMT

#168

Poke me prplhz. Unless you've written this thing in .net or something I should be able to host it.

Acrofales

Spain18240 Posts

January 31 2014 12:55 GMT

#169

Insofar as I know Amazon Web Services has a free tier. Of course, you need to get everything set up, but it should be easy to host the DB there?

gonzaw

Uruguay4911 Posts

January 31 2014 16:49 GMT

#170

Yes, AWS gives you a free instance (server) to basically put anything you want in it.
However, it kind of sucks because the free tier has a LOT of restrictions, and as soon as you pass one of them they start charging you. So at every single minute you have to keep tabs on every single thing (amount of records in the DB, amount of trafic, amount of storage, etc etc) so you don't pass the limit on one of those.

But yes, depending on your language and shit you need (SQL db, bla bla bla), your possible choices of hosting services change

gonzaw

Uruguay4911 Posts

January 31 2014 17:10 GMT

#171

Anyways, here are some options:

Heroku:
Link: https://www.heroku.com/
Pricing (free): https://www.heroku.com/pricing
No restrictions basically. Other than having 10k DB records. Oh...you need PostgreSQL though. But I really like this one, you can use Rails or PHP and others. Porting from, say, MySQL to PostgreSQL might be worth it to use this one.

AWS:
Link: http://aws.amazon.com/en/elasticbeanstalk/
Pricing (free): http://aws.amazon.com/en/free/
As you can see, you have lots of stuff to worry about to use the free tier. But...well, if you know it's just for the database, and it's not a super popular website with millions of viewers and the like, you could almost be sure you'll be below those limits. And at the very least, it'll be something like 5$ per month at some points maybe.

AppFog:
Link: https://www.appfog.com/
Pricing (free): https://www.appfog.com/pricing/
Don't know anything about this one just stumbled upon it. But it seems it may work.

The database is a web site that will likely be accessed few times. It's mainly an online storage, with a nice GUI to access it. There won't be that many data in it either, since there aren't THAT many mafia games and players in TL.
So I think choosing any of the above you guys will be fine and won't need to pay a dime. I recommend Heroku, but well you can find guides for any of the others.

iGrok

United States5142 Posts

January 31 2014 18:11 GMT

#172

I've already talked to prplhz about this, since he is cohosting Classified with me.

My understanding is that the big issue is man-hours, not $$$ - I already offered to cover server costs.

gonzaw

Uruguay4911 Posts

January 31 2014 18:20 GMT

#173

But isn't the whole thing already done? And it only needs an on-going server?

iGrok

United States5142 Posts

January 31 2014 18:46 GMT

#174

Like I said, just my understanding

kitaman27

United States9245 Posts

January 31 2014 18:50 GMT

#175

On January 31 2014 12:24 Keirathi wrote:
If you only need PHP and SQL, you could always host it on SourceForge. If you put a project on there, they give you free webspace that you can use and a couple of databases. I don't remember what all features it has, but I made a site on there a while back for a thing I made.

I was able to set up the database hosting, but does anyone know if you can actually host the php side of things? I don't see any reference to a subdomain or any tools to get things set up. There is a file manager, but that seems more like something used for source control and file sharing, rather than web hosting.

On February 01 2014 02:10 gonzaw wrote:
The database is a web site that will likely be accessed few times. It's mainly an online storage, with a nice GUI to access it. There won't be that many data in it either, since there aren't THAT many mafia games and players in TL.
So I think choosing any of the above you guys will be fine and won't need to pay a dime. I recommend Heroku, but well you can find guides for any of the others.

We're actually around 7500 records right now, so we're probably not that far off from the limit.Thanks for the suggestions, I'll take a look and see if I can get any of them to work.

On February 01 2014 03:11 iGrok wrote:
I've already talked to prplhz about this, since he is cohosting Classified with me.

My understanding is that the big issue is man-hours, not $$$ - I already offered to cover server costs.

Thanks for the offer!

On February 01 2014 03:20 gonzaw wrote:
But isn't the whole thing already done? And it only needs an on-going server?

Well you have to register for an account, create the database and script the schema and records, ftp the files and set up the file structure, configure the php settings, and change all the connection strings that are currently hard coded. The issue is that once I've done this on the 2-3 "free" hosting services, it still isn't working and there isn't a great way to figure out what's wrong.

Keirathi

United States4679 Posts

February 01 2014 00:11 GMT

#176

On February 01 2014 03:50 kitaman27 wrote:

Show nested quote +

Yea, there are some instructions on how to get access to your project web here: http://sourceforge.net/p/forge/documentation/Project Web Services/

An example page I hosted on sourceforge: http://twitchmodbot.sourceforge.net/

Used wordpress and phpBB

gonzaw

Uruguay4911 Posts

February 01 2014 01:01 GMT

#177

On February 01 2014 03:50 kitaman27 wrote:

Show nested quote +

We're actually around 7500 records right now, so we're probably not that far off from the limit.Thanks for the suggestions, I'll take a look and see if I can get any of them to work.

Hmm, yeah that might be a problem. Guess Heroku is out then.
AWS offers 20GB of DB space for free. Maybe AWS will be the best choice. You won't have much traffic and stuff to worry about, so you won't have to worry about the limits.

Show nested quote +

Well, maybe I could help a little if you give me more info. Like which framework/language/database/etc you are using, if you are using a specific file system (to get images maybe), etc.
Some of the hosting services I mentioned work better with "simple" frameworks and the like. Like just a PHP server with a database and nothing else, or a whole ruby on rails structure, etc.
If you have more detailed stuff, it may be harder to get one that does exactly what you want with little effort

gonzaw

Uruguay4911 Posts

February 01 2014 01:19 GMT

#178

Although yeah, you'll need some dependency management in almost all of those.
Either Maven if you used java, Composer if you used php (I believe), gems if you used rails, etc.

EDIT: Actually, maybe not. Depends on you set up your project basically

kitaman27

United States9245 Posts

February 05 2014 14:26 GMT

#179

I've finally managed to get the database connection working in some parts.

You can load a player and factions list, but loading the game info and saving any changes still isn't functional. This would be a lot easier if I had minimal php knowledge

http://tlmafiadatabase.sourceforge.net/