@hichris123 Well... What are you wanting to run? I always use Ubuntu, because it can run just about every open-source thing out there, but if you want to use an MS language, you probably need Windows.
@hichris123 I think they're all in the free tier. The reason for regions is durability, I.e. if a tornado knocks out one datacenter you can have another one on the other side of the world that's probably safe. I know that N. Virginia is on the free tier (and it's cheapest when not on the free tier), so best stick with that.
@hichris123 @Undo I will be working on a data dump some today/tomorrow (just did one, but it needs another run for updated ReadMe, we're including PostLinks now)
@hichris123 One other thing you can do: If you plan on running a server 24x7 (like mine), you want to buy one of those reserved instances right at the end of the free tier.
Big (comparatively) up-front cost, but like 1/4 the hourly price.
For EC2 you have to have a sec group. All they are are big firewalls that by default let absolutely nothing in. Your job is to open the ports for inbound traffic depending on what you're doing. MySQL is 3306, Apache is 80 & 443, SSH is 22, etc.
> If you are an Amazon EC2 user, you can get started with Amazon SES for free. You can send 2,000 messages for free each day when you call Amazon SES from an Amazon EC2 instance directly or through AWS Elastic Beanstalk.
I'm getting a PHP Parse error: syntax error, unexpected '(', expecting ',' or ';' in /var/www/oauth/index.php on line 7 on this file - what am I doing wrong?
That would be a fun exercise, though - every time an election pops up you work like crazy to get your helpful flag counts and your rep as high as possible at the end of seven days.
There's a query that's supposed to look for deleted posts that have validated spam flags on them. Instead, it looks for deleted posts that have live spam flags on them. A live (active/unhandled) spam flag on a deleted post is a situation that shouldn't ever be allowed, and as a result generally doesn't exist. — Shog921 mins ago
Select *
From stop_times
Where stop_id = 30078 AND trip_id =43065086586;
/* Affected rows: 0 Found rows: 1 Warnings: 0 Duration for 1 query: 10.249 sec. */
Select *
From stop_times
USE INDEX (trip_ids)
Where stop_id = 30078 AND trip_id =43065086586;
/* Affected rows: 0 Found rows: 1 Warnings: 0 Duration for 1 query: 0.203 sec. */
