I have a very negative reaction to sites that require an email to get something of unknown value.
Automatic no.
Show HN: I wrote a free eBook about many lesser-known/secret database tricks
11–20 of 185 posts
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#12This 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!)
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#13In 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…
This looks awesome! Thanks for sharing this! Mind me asking what you used to write this ebook?
I‘ve used ibis https://github.com/themsaid/ibis
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#14Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#15I 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.
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#16Nice tips.
I'm interested in https://sqlfordevs.com/sorted-table-faster-range-scan
Would you use this approach for something like:
1) movie_actors (movie_id, actor_id, order_index)
2) movie_watchlist (movie_id, user_id, created_at)
3) movie_ratings (movie_id, user_id, rating, created_at)
I know strange question, but most guides suggest all these table should have autoincrement id column
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#17In 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…
May I suggest providing a sample chapter before requiring an email address? EDIT: There are 10 sample pages (images) but on Firefox they are so small you might not notice them. The pages are in a row flexbox container which on Chrome overflows with a scrollbar but on Firefox scales all the way down to fit everything in view at once. Please add "min-width: 45%" in addition to the "width: 45%". Accessibility would also…
Don't we all have burner addresses? I mean, even Apple provides them.
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#18In 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…
May I suggest providing a sample chapter before requiring an email address? EDIT: There are 10 sample pages (images) but on Firefox they are so small you might not notice them. The pages are in a row flexbox container which on Chrome overflows with a scrollbar but on Firefox scales all the way down to fit everything in view at once. Please add "min-width: 45%" in addition to the "width: 45%". Accessibility would also…
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.
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#19I 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?
Re: Show HN: I wrote a free eBook about many lesser-known/secret database tricks
#20I have a very negative reaction to sites that require an email to get something of unknown value. Automatic no.
I have a negative reaction to sites that require email.
In this case, the value was made pretty clear in the homepage.
I was happy to only have to exchange my email for what appears to be a very high quality resource - the author is either extremely generous or undervaluing their knowledge!