nil
amavis All email is perl.
in postgres you can do SELECT a.this, b.that FROM a, b WHERE a.id = b.a_id; it just implies SELECT ... FROM a LEFT JOIN b ON(true) WHERE ...
it only matters when you quote the column name. SELECT a."This_Col" = b.this_col FROM table a JOIN "Table" b;
rfc2822
sql is the language of the gods
two things 1) leading commas in SQL 2) RAISE an EXCEPTION or RETURN --no more `else` statements in code SELECT this , that , something FROM table takes a while to get used to
yeh, it is quite a bit cheaper. However, heroku is more aggressive in throttling the cheap stuff. I still use it for ci though. AWS simply offers more granular control and a more robust infrastructure. If you dig down…
cakePHP on EC2 + postgres on RDS is nice. toss in some Redis caching and feed it traffic from a load balancer. you can get a lot done with very little effort.
to be productive, you have to minimize the need to rtfm, but you should also be cognizant of any new implementations -- a refresher may sometimes provide a better way. I recently stumbled on the postgres method…
yeh... but, we sorta live and die by the evidence. We can't just blindly assume OP is correct. Thankfully, OP knew that and saved us the hassle or typing it ourselves.
nil
amavis All email is perl.
in postgres you can do SELECT a.this, b.that FROM a, b WHERE a.id = b.a_id; it just implies SELECT ... FROM a LEFT JOIN b ON(true) WHERE ...
it only matters when you quote the column name. SELECT a."This_Col" = b.this_col FROM table a JOIN "Table" b;
rfc2822
sql is the language of the gods
two things 1) leading commas in SQL 2) RAISE an EXCEPTION or RETURN --no more `else` statements in code SELECT this , that , something FROM table takes a while to get used to
yeh, it is quite a bit cheaper. However, heroku is more aggressive in throttling the cheap stuff. I still use it for ci though. AWS simply offers more granular control and a more robust infrastructure. If you dig down…
cakePHP on EC2 + postgres on RDS is nice. toss in some Redis caching and feed it traffic from a load balancer. you can get a lot done with very little effort.
to be productive, you have to minimize the need to rtfm, but you should also be cognizant of any new implementations -- a refresher may sometimes provide a better way. I recently stumbled on the postgres method…
yeh... but, we sorta live and die by the evidence. We can't just blindly assume OP is correct. Thankfully, OP knew that and saved us the hassle or typing it ourselves.