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

21–30 of 185 posts

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

#21

Post by joe_guy »

qup wrote: post #15
adamc wrote: post #11

I have a very negative reaction to sites that require an email to get something of unknown value. Automatic no.

That's an interesting take, given that the landing page demonstrates its value with some example pages, and the index of topics. I can skim the chapter titles and get a pretty good idea of exactly what value there is. I'm not sure what's holding you up.

Why not a series of blog posts?

To me, the reader, what value does sharing my email or it being in The incredibly less flexible "ebook" format have?

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

#22

Post by andrewl »

btown wrote: post #12

This is amazing! Would definitely recommend you have a privacy policy though, as you're collecting personally identifiable information! (Also, one of my favorite techniques along the lines of your Lock Contention example: https://www.enterprisedb.com/blog/what-skip-locked-postgresq... is an amazing way to have a foolproof work queue without introducing things like Redis!)

I agree on the privacy policy. (I also agree that this looks good, and I want to sign up.)

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

#24

Post by NikolaNovak »

tr33house wrote: post #19
adamc wrote: post #11

I have a very negative reaction to sites that require an email to get something of unknown value. Automatic no.

can someone share the pdf here for folks who don't wanna share their email?

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 the work of signing up, sharing their email, and uploading and hosting content for your convenience). Yes yes information wants to be free and all that, but this is just lazy :-D

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

#25

Post by googlryas »

joe_guy wrote: post #21
qup wrote: post #15

Earlier quoted context omitted.

That's an interesting take, given that the landing page demonstrates its value with some example pages, and the index of topics. I can skim the chapter titles and get a pretty good idea of exactly what value there is. I'm not sure what's holding you up.

Why not a series of blog posts? To me, the reader, what value does sharing my email or it being in The incredibly less flexible "ebook" format have?

You, the reader, don't have a choice between a series of blog posts and an emailed pdf.

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

#26

Post by tr33house »

NikolaNovak wrote: post #24
tr33house wrote: post #19

Earlier quoted context omitted.

can someone share the pdf here for folks who don't wanna share their email?

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…

agree. Thanks for changing my perspective

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

#27

Post by 411111111111111 »

qup wrote: post #15
adamc wrote: post #11

I have a very negative reaction to sites that require an email to get something of unknown value. Automatic no.

That's an interesting take, given that the landing page demonstrates its value with some example pages, and the index of topics. I can skim the chapter titles and get a pretty good idea of exactly what value there is. I'm not sure what's holding you up.

I think that's true, but I'm also one of the people that's going to bounce from that.

While several chapters have mildly interesting titles, what I've come used to from these kinds of offers are mostly just rehashed blog articles from other sources. I remember one extra special case about an Elixir "book" that pretty much just copy-pasted the official getting started guide.

Generally speaking, these kind of hurdles don't inspire confidence in the quality of the content.

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

#28

Post by midnightmonster »

This is cool! Re: multiple aggregates in one query, I wrote a Ruby gem that adds an even-more-powerful and multi-database-compatible version to ActiveRecord. (I have tested Postgres, MySQL, and SQLite; others probably work, too.)

https://github.com/midnightmonster/activerecord-summarize

Post reply on HN