#django

ive got a django model 'Campaign', and a model Creative, who's foreign key is Campaign

the admin interface allows me to open up campaign, and add 'creatives' with a tabular inline

my question is, i want to add 'conversions' whose foreign key will be Creative

is there a way thtat i can "see" conversions somehow under the campaign object..for each creative?

(i.e. i dont want to make a conversion's foreign key Campaign, but Creative... so I kind of want nested tabular..)

jarshwah: I am using unittest

jarshwah: would you believe it is because of a __init__.py file not being in the directory.

everything is fine, but this one threw me off!

:) glad you figured it out

morning, jarshwah

hey mate

how goes it

not bad... had some good breakthroughs on the weekend... you?

looks like your vagrant project is being received well

liver stress test over the weekend proved successful ;)

it managed to sterss your liver? :P

yeah I expect a little more interest to pick up.. I figure for every person that replies on the ML, there's another 10 that are in the same boat

fair reasoning

no no no.. the drinking for bday celebrations were the cause of that

ah, heh

which breakthroughs did you make?

in understanding dealing with oauth in shopify

so in a day or so I should have my shopify app fully translated to AWS Serverless :)

schinckel / mattmcc : what's the relative cost of an icontains versus regex in PG?

Yeah, I'm not sure about that.

I'd run some EXPLAIN ANALYSE queries and see what it says.

hmm

I would *guess* that regex would be better for simple lookups

rather than lower(%search%)

It _might_ depend on the regex though.

oh ilike is a thing

yeah that's why "simple lookups"

well

yeah I'd be testing different forms of regex too, without looking for chars on either end

well, it's a csv of "tags"

oh, and I'm missing the second \s*

which I'm not even sure I need either of

you're also missing __iregex

:P

well, just hte i

yah

ting is, this could well eliminame many candidates which are filtered client side

or ... it might now

not

ah, well

FunkyBob: You can use make "like '%foo%'" indexed with pg_trgm: https://www.depesz.com/2011/02/19/waiting-for-9...

Also, if you are looking for full tag matches, then you could potentially index better too. Not sure how.

yeah, well, I think they're hoping to move to array fields eventually