Reddit Programming
210 subscribers
1.22K photos
124K links
I will send you newest post from subreddit /r/programming
Download Telegram
Tired of messy SQL queries? I wrote a guide that helped me clean up mine
https://www.reddit.com/r/programming/comments/1nqupgj/tired_of_messy_sql_queries_i_wrote_a_guide_that/

<!-- SC_OFF -->Here’s the link: https://medium.com/@tanmay.bansal20/inside-the-life-of-an-sql-query-from-parsing-to-execution-and-everything-i-learned-the-hard-way-cdfc31193b7b?sk=59793bff8146f824cd6eb7f5ab4f5d7c I recently dove deep into SQL mistakes we all make — from subtle performance killers to common logic errors — and wrote a practical guide on how to spot and fix them. I also included tips for optimization and some tricks I wish I’d known earlier. Some things you’ll find in the guide: How simple mistakes can slow down your queries Common pitfalls with joins, groupings, and subqueries Optimization strategies that actually make a difference If you’ve ever wondered why your SQL feels slower than it should, or just want to write cleaner, more efficient queries, this might help. Would love to hear your thoughts or any tips you’d add. What’s the worst SQL bug you’ve run into recently? <!-- SC_ON --> submitted by /u/Tanmay__13 (https://www.reddit.com/user/Tanmay__13)
[link] (https://medium.com/@tanmay.bansal20/inside-the-life-of-an-sql-query-from-parsing-to-execution-and-everything-i-learned-the-hard-way-cdfc31193b7b?sk=59793bff8146f824cd6eb7f5ab4f5d7c) [comments] (https://www.reddit.com/r/programming/comments/1nqupgj/tired_of_messy_sql_queries_i_wrote_a_guide_that/)
Mastering Convolutional Neural Networks for Audio
https://www.reddit.com/r/programming/comments/1nr4fb9/mastering_convolutional_neural_networks_for_audio/

<!-- SC_OFF -->Here is a deep-dive blog that covers everything: pooling, dropout, batch normalization, how CNNs actually see audio, mel spectrograms, and of course the results from my own model. Read the full blog here:
Mastering CNNs for Audio: The Full Story of How I Built (https://medium.com/@tanmay.bansal20/mastering-cnns-for-audio-the-full-story-of-how-i-built-sunoai-c97617e59a31?sk=3f247a6c4e8b3af303fb130644aa108b)a model with 88% accuracy And if you’re more into visuals, here are feature maps, waveforms, spectrograms, everything down to the last detail:
https://sunoai.tanmay.space (https://sunoai.tanmay.space/) <!-- SC_ON --> submitted by /u/Tanmay__13 (https://www.reddit.com/user/Tanmay__13)
[link] (https://medium.com/@tanmay.bansal20/mastering-cnns-for-audio-the-full-story-of-how-i-built-sunoai-c97617e59a31?sk=3f247a6c4e8b3af303fb130644aa108b) [comments] (https://www.reddit.com/r/programming/comments/1nr4fb9/mastering_convolutional_neural_networks_for_audio/)