erdemozg

jaw-dropped.gif

Such a powerful tool... And thank you for letting us know about this trick.

Do you exclusively use the official Twitter API or do you also perform web scraping? How much did you spend last month for runnig this system?

But it seems like this discussion is about the lack of support for null values in enum types in joins (not joins in general). Am I missing something?

Can you provide some resources about the lack of support for joins in sqlc? Because I wasn't able to find in official documentation and actually there's a discussion on github containing queries with join statements: https://github.com/kyleconroy/sqlc/issues/213

From the technical perspective this is a great execution of an idea. But those actions will probably be considered as ad-fraud and web sites will be penalized by ad-networks.

Hi, since someone else mentioned your product's website I looked over it and I'm curious.

As far as I understand students need to install your app and the app requires users to log out and when they log in, it's launched automatically in full screen mode and users cannot escape until they submit their answers.

What if I install your app in a sandboxed environment (like a windows box in a vmware virtual machine)? While the app is in fullscreen mode inside it, I think there would be nothing preventing me from using host machine's functions (like accessing internet via browsers or opening documents). Have you considered these kind of risks?

Google somehow is able to link your newly created account to your personal/regular account. So if you some shady stuff with the new account, your other account is at risk of being locked out, too.

If one told me beforehand that those people from conservative background would do such things on a video and share it with the rest of the world, I'd say you have no idea about Turkish culture. But now I say I had no idea about Turkish culture and what those people are capable of. I literally get shocked every time I watch a tiktok compilation video. I wonder if those are the same people I see in the street everyday.

Why would getting suspended from Play Store mean the end of a developer's career ? Could you elaborate? Isn't it possible to continue with a new gmail account? Am I missing something here?

edit: spelling

For anyone wondering how is this possible I've made a quick research and the method is in the description part of this youtube video: https://www.youtube.com/watch?v=ufq2Eb78kSU

In short, Youtube API's resume upload function can be abused to achieve this.

It's like an image containing its own SHA2 hash. How is it possible?

That's exactly what I did, too. :)

Thank you for sharing this with us.

Have you considered turning this into a web based SaaS product? (upload excel -> do fancy stuff -> export or save the result on cloud)

Is there any specific reason for the current licensing/revenue model?

I think it's a shame how IOTA users desperately seeking ways to safely generate their wallet seeds on third party software. Souldn't it be a built-in feature?

Haha, I was in dilemma. But since most people are not aware of it, I chose the future tense. But you are right, it is already.

People don't bother to update even their home router's firmware. IoT ecosystem will be one of the biggest holes in cyber security and a heaven for black-hat hackers.

Thanks for the info. I didn't know it was that easy.

I would be tempted to implement a custom SMTP server that accepts every email as if that target mailbox exists and collect them on a nosql db (just for curiosity and technical challenge) though I have no idea if I'd face any legal issues.

Congratulations. It requires so much dedication to finish a side project.

haha, good one.

I use the following indentation pattern and find it very useful:

    select 
        t1.col1,
        t2.col1

    from 
        table1 t1 
        left join table2 t2 on t2.primarykey = t1.foreignkey

    where 
        t1.somevalue is not null
        and isnull(t2.someothervalue, 0) > 0

    order by 
        t1.someothervalue desc

By using this pattern I can easily locate columns, tables, criterias, grouping fields, orders etc. And it works well with more complicated queries as well given all the subqueries, cases etc. written in a similar fashion.