/Tips

SQL Tips And Tricks

- Ben Nour tl;dr: “A somewhat opinionated list of SQL tips and tricks that I've picked up over the years in my job as a data analyst. Please note that some of these tips might not be relevant for all RDBMs.”

featured in #568

Tiger Style

tl;dr: “TigerBeetle's coding style is evolving. A collective give-and-take at the intersection of engineering and art. Numbers and human intuition. Reason and experience. First principles and knowledge. Precision and poetry. Just like music. A tight beat. A rare groove. Words that rhyme and rhymes that break. Biodigital jazz. This is what we've learned along the way.”

featured in #555

SQL Tips And Tricks

- Ben Nour tl;dr: “A somewhat opinionated list of SQL tips and tricks that I've picked up over the years in my job as a data analyst. Please note that some of these tips might not be relevant for all RDBMs.”

featured in #554

SQL Tips And Tricks

- Ben Nour tl;dr: “A somewhat opinionated list of SQL tips and tricks that I've picked up over the years in my job as a data analyst. Please note that some of these tips might not be relevant for all RDBMs.”

featured in #553

Effective Changelogs

- David Brownman tl;dr: “The Keep a Changelog project offers some good high-level guidelines, but speaking as someone who is frequently frustrated by changelogs, it seems like more specific advice is in order. I've collected some simple tips and examples to ensure your changelogs are fit for human consumption.”

featured in #543

Advanced Terminal Tips And Tricks

- Daniel Kleinstein tl;dr: “I wanted to share some things I learned at relatively late stages in the game that ended up being significant productivity boosters for me: (1) Use command line editing. (2) tmux scripting. (3) Use fzf liberally in custom scripts. (4) Use /dev/stdin as a replacement for heredocs. (5) Use SSH multiplexing.

featured in #534

Entering Text In The Terminal Is Complicated

- Julia Evans tl;dr: Julia asked her network what was confusing about working in the terminal, and one thing that stood out to me was “editing a command you already typed in”. Julia shares why this is hard and some tips she’s picked up along the way. 

featured in #531

Writing Tips for Improving Your Pull Requests

- Jeff Mueller tl;dr: “I’m going to show you how to purposely write less by using the techniques below.” Tips are: (1) Make it scannable. (2) Speak plainly. (3) Avoid adverbs. (4) Simplify your sentences. (5) Avoid a passive voice. Jeff adds examples to each.

featured in #530

Six Tips To Improve a Conversion Funnel

- Ryan Musser tl;dr: (1) Identify the friction. (2) Streamline. (3) A/B test your solution. (4) Personalize, where you can. (5) Build trust, when you can. (6). Track everything.

featured in #529

Developer Workflow Tips No One Tells You About

- Justin Joyce tl;dr: “These are the tools, tips and advice I wish I had internalized when I was just starting out. Many of the details below are specific to macOS, but similar tips and tricks apply on other systems. I've broken it down very roughly into the following categories: (1) Computer setup. (2) Command-line-related things. (3) Technical but non-CS advice. (4) Potpourri.

featured in #529