Nice. I presume this is for a flavour e.g. Postgres?
Both MySql and Postgres
Show HN: I wrote a free eBook about many lesser-known/secret database tricks
121–130 of 185 posts
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#122In isolation because of Corona last year, I started to share many lesser-known database tricks I know on Twitter (@tobias_petry). Although I thought that only a few people would be interested in something like this, it became a matter of course over the months. Meanwhile, thousands follow me to read my database tips or news. Since every message in the constant social media stream vanishes after a few days, I had to d…
Decrease is misspelled on p48. Columns is misspelled on p33. You may wish to run a spellcheck to find the others I didn't. My disposable email I used to sign up has already been nullrouted. Rather than tit-for-tat collecting PII, why not just publish it to the whole web without the extra hoops? I'd have already sent you a PR in that case with more copy edits.
No post body was provided.
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#123Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#124For those who don't want to give their email, link to the PDF: https://file.io/5bJFEXNyPi8s
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#125Book looks good, shovelling the subscription at me was annoying and of course I used a throwaway address and unsubscribed immediately. It's actually probably a newsletter I wouldn't mind getting but the way it was done feels too spammy. I have Markus Winand's book SQL Performance Explained, actually paid for the download, and came away feeling cleaner. I do hear something from him through his mailing list once in a g…
Not only that, but every other chapter of the "book" ends in: "I have written a more extensive text about this topic on my database focused website ..." pushing their blog.
It's unclear why. If anything, I would expect the more extensive text in the "book".
At any rate, it starts to feel like a wild goose chase after a while and my expectation is that I'll have to fill something else out or watch a ton of ads before being show fluff content if I click on a link in a book that I had to sign up for newsletter to download....
I wouldn't know though because I'd rather whine about it here than actually follow the link :)
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#126Book looks good, shovelling the subscription at me was annoying and of course I used a throwaway address and unsubscribed immediately. It's actually probably a newsletter I wouldn't mind getting but the way it was done feels too spammy. I have Markus Winand's book SQL Performance Explained, actually paid for the download, and came away feeling cleaner. I do hear something from him through his mailing list once in a g…
Not only that, but every other chapter of the "book" ends in: "I have written a more extensive text about this topic on my database focused website ..." pushing their blog. It's unclear why. If anything, I would expect the more extensive text in the "book". At any rate, it starts to feel like a wild goose chase after a while and my expectation is that I'll have to fill something else out or watch a ton of ads before…
Yikes. Yeah I haven't looked at the pdf yet, but the idea of a book is to get all the info in one place, I'd hoped. If every chapter leads me to another web page, the book might as well not be there.
Tpetry, I get the idea that you don't want to give away the book outright. That is fine. Some people do that, but not everyone, and it's ok if you don't. But please, don't put us through this nonsense. Just charge money for the book, and make it so that people who pay up get everything in a single download, no subscriptions, no upsells from individual chapters. I am interested in such a thing, enough to probably be willing to buy a copy. Thanks for your consideration.
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#127Earlier quoted context omitted.
The problem is not unknown value. It’s unknown cost. Until I know everything you will ever do to me with my email I don’t know the true cost. What I can guess—given the thousands of precedents I’ve encountered over the years—is that the total cost will be time taken from my short life to fend of yet more marketing and yet more marketers. For comparison, if you ask me for currency, I know the total cost of ownership.…
The total cost is how much time it takes to google "temp email" and then click on the first link and use that temp email to get the book. It should take about 2 minutes, maybe even less time than writing out your comment.
Sure, same as the total cost of a movie is how long it takes to type the name into a torrent search and click the magnet link. If the OP wanted a bunch of dead temp emails, why ask other people to input them. But, not my point.
I think on HN a good assumption is posters want to discuss, to get feedback. Also not a bad assumption the notion of temp email will be news to absolutely no one at all here.
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#128Earlier quoted context omitted.
Yes. Please add donation button.
Thank you both. But correctly filling taxes for those donations would be more effort than it is worth. So i‘ll just keep it free :)
If you change your mind, it shouldn’t be hard to handle the taxes; I think the approach would be the same as for hobby income.
If you’re in the US and filing taxes as a employee I think you’d just sum up the book sales and stick that under Other Income. If you’re already filing as a business or self employed, just roll it in no? Of course, other countries are available.
Anyway, I’d happily pay a few bucks at the very least for this. If it’s useful, it’s going to help my own income. If I see people who maybe can’t afford a few bucks can get it for free, I’ll be even happier to pay.
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#129Earlier quoted context omitted.
YouTube asks you to watch ads, but we still consider it to be free. Many mobile games make you create an account (and provide your email) before you can play but we still consider them free because you don't have to give any money. That's the definition here: don't have to pay money = free. This ebook is free
You don't value your time = free Other people do value their time, therefore it's not free for them.
In that sense for people who value their time, HN is not free.
I would rather use the term opportunity cost.
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#130I'm fairly adept at writing queries and have been using MySQL for what seems like an eternity. The multiple aggregates per query thing kinda blew my mind. I've certainly done that by using something like SUM(CASE WHEN x = y then 1 ELSE 0), but did not know you could just COUNT(x=y). Awesome.