erdemozg's comments

On: I wandered off and built an IDE

[erdemozg]

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?

[anakic → erdemozg]

No plans for the cloud solution so far. I figured it needs a community, so a lot of it has to be free for non commercial use. For commercial use I figured the price isn't going to be an issue. Probably there's more tweaking to do there. I'd love to get some thoughts on it.

On: How a malicious seed generation website stole $4M

[erdemozg]

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?

[pedrocr → erdemozg]

IOTA is the coin that invented their own cryptography using ternary logic. Practicality doesn't seem to be a core value.

[Quiark → erdemozg]

It is gross incompetence that it was not a built-in feature.

On: IoT goes nuclear: creating a ZigBee chain reaction

[erdemozg]

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.

[Freak_NL → erdemozg]

Economically vendors have little to no incentive to fix this mess either, so it will haunt us for some time to come. Introducing a slew of devices that all need security updates into each household that falls for them doesn't seem all that clever.

A light bulb that can change its brightness and colour shouldn't be smart; it should be dumb as a brick and expose only those parameters that can sensibly and safely be set by a user — kind of like a normal light bulb does.

[kbart → erdemozg]

"IoT ecosystem will be one of the biggest holes in cyber security and a heaven for black-hat hackers."

I think you meant "is" here.

[erdemozg → kbart]

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.

[digi_owl → erdemozg]

1. shit brick easily.

2. vendors mix feature changes/removals and security updates.

3, better the devil you know...

On: Gail, not Gmail

[erdemozg]

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.

[NKCSS → erdemozg]

It's called Catch-All; I have it set up for my Google For Work account (e.g. I have a gmail that receives @my domain). So, you could use gmail to catch all e-mails to @gail.com; no need for a 'custom SMTP server'.

[throwanem → NKCSS]

You can also do this with a real MTA; no need for Google, either.

[NKCSS → throwanem]

I know; was just an example of an available 'Catch-All' solution.

Back in the day™ I wrote a C# dll to add the functionality to my Exchange server (was not an option back then; don't know if it's possible out of the box now). There are many solutions once you know what to look for (e.g. the phrase 'Catch-All')

[Cpoll → NKCSS]

I wanted this and I couldn't find it, thanks!

How much spam do you get from the Catch-All?

[erdemozg → NKCSS]

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

[vlucas → erdemozg]

I made a service that does this ( https://disposeamail.com/ ), and I am constantly asking myself if it's worth it. The PostgreSQL database takes up over half the disk space on the VPS I run it on, and that's only after a few months. And of course it's almost all ultra low quality spam.

[vocatus_gate → vlucas]

You're doing the Lord's work, son.

[thinkmilitant → vlucas]

This is a great service/idea. Have you considered a donate button to help support it?

[tokenizerrr → thinkmilitant]

http://www.mailinator.com/ is probably better. They have a ton of domain aliases, see their homepage.

[tokenizerrr → erdemozg]

> though I have no idea if I'd face any legal issues.

Why would you? It's standard practice to set up a catch-all for your domain and you can just configure postfix to do that.

[paulcole → tokenizerrr]

Ignorance of the law isn't an excuse.

[tokenizerrr → paulcole]

Right... And your point is? What law would this break? Or are you ignorant of that as well? If so, why even bother replying?

[Cpoll → tokenizerrr]

I think he means that "why would you?" is not good legal advice.

I mean, I agree with you in principle, but I can imagine some backwater judge deciding that Alice Techie was violating the privacy of Bob D. Luddite by accepting emails addressed to bob.d.luddite@alicetechie.com.

[tokenizerrr → Cpoll]

> I think he means that "why would you?" is not good legal advice.

It is when it is literally common practice. Similar to if someone were to ask if they'd get in legal trouble for breathing. Why would you?

[manmal → erdemozg]

Or just pretend that you are a gmail mail server and store the credentials that are transmitted when people add the account to their mail app.

[dbbk → manmal]

Would DMARC not prevent this?

On: Show HN: Math Attack – My side project of 3 years

[erdemozg]

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

[Sanctor → erdemozg]

Thank you! It really does. The hardest part is getting at least passable skills in all the areas required for game development. I'm a full time programmer and I draw but I had no idea how to handle sound, things like that.

On: Microsoft Word for Windows Version 1.1a Source Cod...

[erdemozg]

haha, good one.

On: Writing more legible SQL

[erdemozg]

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.