monkeydata

3 ms·

1.
by monkeydata 4y ago
nil
2.
by monkeydata 5y ago
amavis All email is perl.
3.
by monkeydata 5y ago
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 ...
4.
by monkeydata 5y ago
it only matters when you quote the column name. SELECT a."This_Col" = b.this_col FROM table a JOIN "Table" b;
5.
by monkeydata 5y ago
rfc2822
6.
by monkeydata 6y ago
sql is the language of the gods
7.
by monkeydata 7y ago
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
8.
by monkeydata 7y ago
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 into it, you'll s
9.
by monkeydata 7y ago
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.
10.
by monkeydata 7y ago
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 jsonb_insert(jsonb,path,value
11.
by monkeydata 7y ago
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.