Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: I wrote a free eBook about many lesser-known/secret database tricks

sqlfordevs.com

Post reply on HN
Print view View original

101–110 of 185 posts

Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks

#101

Post by randStr_ »

cdrini wrote: post #76

I get the frustration about the email, but that aside, I do wonder whether requiring the email before getting the book is the most effective mechanism for your end goal. What do you want to achieve? Do you want to maximize the number of people subscribed? Do you want to create a community? Why do you want these things? Do you want to share your knowledge? Having no email-wall would probably result in fewer registrati…

I didn't put my email to get the book. I would probably have subscribed, if it was something like "if you enjoyed the content, do subscribe to get more".

Instead, it advertised free, then there is the wall. Like many others, I feel like I've been drawn to a false promise.

I totally understand the author can keep the book behind whatever wall he wants. The title could have been "I wrote a book about ...". And then in the site, "subscribe to get the book".

Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks

#102

Post by freebookthanks »

This is a great read, but for those who would rather not provide their email address until they've read the book, here's a download link: https://sqlfordevs.com/ebook-download?expires=1670195527&sig...

Archived copy: https://web.archive.org/web/20221202231259im_/https://sqlfor...

Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks

#103

Post by randStr_ »

remram wrote: post #88
NikolaNovak wrote: post #24

Earlier quoted context omitted.

I wouldn't. Author is offering their work at a given price. That price is email. It may be worth it to you or not. Requesting a pirated copy of it without paying the price is not something I encourage,given so many of us here are well to do knowledge workers whose live being depends on people paying for our work. (Not to mention, it's same or less work for you to create a temp email account, vs somebody else doing th…

You say that, yet every paywalled news article posted on HN quickly gets a web.archive.org or archive.is link as a top comment. What is the fundamental difference with this?

I've bounced back from so many walled articles that now I genuinely blame the OP (of that post) for not including a non-walled link.

HN should have a tag for walled contents.

Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks

#104

Post by wswope »

proto-n wrote: post #97
mdip wrote: post #45

I haven't read the whole thing but I really enjoyed the introduction and agree completely. The RDBMS I've spent the most time with over the years is Microsoft SQL (immediately when 2000 was released) and over the years I've been surprised by two things: (a) How many developers that work with databases every day yet haven't the foggiest idea how to do anything the GUI tooling doesn't handle "easily" and (b) How quickl…

Can you recommend some resources to achieve (b)? Just basic stuff without going full guru on every little detail. Or do you just mean using indexes basically? I'm just not sure how many unknown unknowns I have wrt sql.

The details depend heavily on what specific database you’re working with, but in broad strokes, you’ll want to know: indices, query plans, when and where to cache expensive computations, every f—- word of your DB manual’s chapter on concurrency control, and the fastest method(s) for yeeting data in and out from your language/toolkit of choice.

Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks

#106

Post by sneak »

tpetry wrote: post #2

In 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.

Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks

#108

Post by icedchai »

rendall wrote: post #37

No, it's not weird to not want to give up an email address before knowing the value proposition, qup and icedchai.

The value proposition was clear to me from the landing page. Maybe it wasn't to you. I could read enough of it to say "hey, this sounds interesting, I wouldn't mind hearing more from this person."

Also, SQL databases are one of my favorite tech topics. Postgres, especially, has tons of cool features (example: lateral joins.)

Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks

#110

Post by Terretta »

courgette wrote: post #39
qup wrote: post #18

Earlier quoted context omitted.

It's a 50-page book. If you actually look at what's presented on the landing page, three of the topics have the entire page shown, so you can see exactly what topics will look like.

I agree, I had a good idea of what you proposed just sliding on my phone. Let me give you an email in exchange of that bag of tricks. Out of curiosity: what’s happening with the email? ( out of honesty: you will get my spam ridden gmail ;) )

It says you're subscribing to the newsletter
Post reply on HN