Reddit Programming
211 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/)
Dial-a-Precision Prime Search with 100% Recall
https://www.reddit.com/r/programming/comments/1nra46w/dialaprecision_prime_search_with_100_recall/

<!-- SC_OFF --> Abstract This is a recall-perfect pipeline for prime number searches that lets you dial the precision with two knobs: a scale-aware wheel sieve bound B(n) and the number of Miller–Rabin bases k. Step 1 is a high-recall prefilter (the “Purple Stripe”: numbers n where n mod 6 is 1 or 5). Step 2 adds anti-helices (a wheel built from small primes) whose filtering strength grows with the number n being tested. Step 3 runs a short chain of one-sided tests (they never reject a true prime), ending with a few MR bases. The result: recall is 100% by design, and precision jumps to 97–99% with just 2–3 MR bases and can be pushed arbitrarily close to 100%. 1. The Core Idea Beyond 3, every prime number is of the form 6k +/- 1. We call this the purple stripe. Composites on this stripe appear when a number is a multiple of a small prime (like 5, 7, 11, etc.). The density of prime numbers decreases as numbers get larger (it’s about 1 / ln(n)). To maintain high precision, the wheel’s filtering strength must increase with n by excluding multiples of more small primes. This isn’t new number theory; it’s a clean engineering approach that combines wheel sieves with the Prime Number Theorem to give you precise control over the trade-off between precision and computational cost. For more go to the above link to medium. <!-- SC_ON --> submitted by /u/caprazli (https://www.reddit.com/user/caprazli)
[link] (https://medium.com/@caprazli/dial-a-precision-prime-search-with-100-percent-recall-4c9ad30bd3c9) [comments] (https://www.reddit.com/r/programming/comments/1nra46w/dialaprecision_prime_search_with_100_recall/)