Viewing profile — ajw0100

Can you post the code for this somewhere? Thanks!

This is something we saw at Chartio very early on. It's why we built the concept of layers directly into our product to support cross-DB networked joins: https://support.chartio.co…

What if the limits on the lateral subqueries were 2 instead of 1, and they were doing select * instead on select sum() in the outer query? How would you recreate that with correlat…

Looking at this a little further, the outer nested loop could cause issues in the left join vs. left join lateral version, depending on how many use_demo events there are in the we…

The `sum(1)` and `order by...limit` approach really isn't the best way to build the funnel. And if you take another approach then this could have easily been built with normal left…

Am I the only one who finds it funny that the article quoted Oracle's Enterprise Manager docs?

I'm guessing the 6 figs is based off the 1000 original customers with the additional 5000 customers via partnership w/ Olark being prospective.

Yet they say their revenue is only "well into the 6-figures"? How is this possible? If only 5000 of those customers are paying the lowest per rep per month rate of $25 than that am…

http://oracle-wtf.blogspot.com/ This might have been what you're looking for if it was still updated. Still some funny stuff there though.

This is a breeze. Don't make me paste some of the wacky SQL I've seen generated from Oracle's BI tools when they are being abused.

Python is the same way - it lets you have trailing commas for lists, tuples, and dictionaries.

Along the same lines it makes it easier to comment out items when debugging. Especially if you add in tricks like SELECT 0. For example multiple lines in this query would cause an …

Do you know of any good articles demonstrating the repercussions of violating a ToS vs. violating a copyright? I'm guessing violating a copyright is more likely to result in aggres…

it's up for me in Boston