EPT
TL Mafia Database - Page 9
| Forum Index > TL Mafia |
|
Holyflare
United Kingdom30774 Posts
| ||
|
marvellosity
United Kingdom36160 Posts
| ||
|
Holyflare
United Kingdom30774 Posts
| ||
|
marvellosity
United Kingdom36160 Posts
 | ||
|
gonzaw
Uruguay4911 Posts
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 States9244 Posts
| ||
|
Keirathi
United States4679 Posts
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
Iceland22632 Posts
| ||
|
Acrofales
Spain17952 Posts
| ||
|
gonzaw
Uruguay4911 Posts
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
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
My understanding is that the big issue is man-hours, not $$$ - I already offered to cover server costs. | ||
|
gonzaw
Uruguay4911 Posts
| ||
|
iGrok
United States5142 Posts
| ||
|
kitaman27
United States9244 Posts
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
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
On February 01 2014 03:50 kitaman27 wrote: 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. 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. 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
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 States9244 Posts
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/ | ||
|
Palmar
Iceland22632 Posts
| ||
| ||
