5 ms·
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
by tpetry 4y ago
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 do something about it. Knowledge must be preserved. I sat down for a few weeks and reworked every example and every text to create an ebook that you can read in an evening and still impart tons of knowledge.
And so "Next-Level Database Techniques for Developers" was born.
- dev_dude 4y agoThanks for all the valuable tips. It's amazing every time how much load a properly configured database can reduce. Especially the tips for optimizing indexes are very good. "Partial Indexes for Uniqueness Constraints" is my most favorite.
- elric 4y ago@tpetry: I enjoyed reading the book. Could you please have it added to the Goodreads database so I can leave a positive review?
- tuukkah 4y agoMay 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 require links to the textual versions.
- copperx 4y agoDon't we all have burner addresses? I mean, even Apple provides them.
- qup 4y agoIt'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.
- courgette 4y agoI 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 ;) )
- Terretta 4y agoIt says you're subscribing to the newsletter
- tpetry 4y agoI‘ll send you an email when I have written more full-length articles like the ones under „Tips“ in the navigation.
- angelaguilera 4y agoWhy not you publish them in a blog and provide a public RSS? Some people prefer those to newsletters.
- qup 4y agoI'm not the guy, so I don't know. But if I don't like what he does with it, I'll set a filter in about 25 seconds to send the email to the pits of /dev/null
- sakopov 4y agoThis looks awesome! Thanks for sharing this! Mind me asking what you used to write this ebook?
- tpetry 4y agoI‘ve used ibis https://github.com/themsaid/ibis https://github.com/themsaid/ibis
- tpetry 4y agoGmail now started to classify the email with the ebook attachment as spam. After having worked without any problems before. I am now changing my code, give me a few minutes. Fixed
- mooreds 4y agoThank you! Writing a book is hard work, esp a technical one. Thanks for sharing your knowledge.
- sneak 4y agoDecrease 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.
- javajosh 4y agoIt's not about PII, it's a comms channel to db pros. And yes, a good email list like that is quite valuable, and he wouldn't get that just sharing the resource as you suggest.
- hgrth6644fd23 4y agoA whole bunch of burner addresses of people who are hoping to one day be db pros must be REALLY valuable.
- AspenSix 4y ago