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/)
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/)
From Full stack to Full Team stack
https://www.reddit.com/r/programming/comments/1nrd0os/from_full_stack_to_full_team_stack/

<!-- SC_OFF -->Hello fellow gladiators, I conducted deep research for a comparative analysis of the software engineering environment from 2000 to 2025 and the report is in the Google Drive. But I want to discuss the current software engineering environment. I've been absent from the software engineering scene for 4 years now, and I returned, and the amount of my shock at how it has become so notoriously difficult is like a gladiator's arena. A software engineer not only needs to be full-stack, but **full-team stack (**I hope this term not be used in hiring); front-end with at least two or three frameworks "mastery" (React, Angular, Vue.js...) for JavaScript, and frameworks for CSS too with UI/UX knowledge and experience With backend three or four mastery (C/C++, Python, Java, C#, NodeJS, now Rust ...) with each one of the languages needing mastery of one or two frameworks that each have. Need to have Cloud mastery too (AWS, Azure, Google Cloud...), DevOps Docker, Kubernetes, CI/CD are the most basic tools, even to be called a software engineer at the entry-level. databases at least one or two SQL and two NoSQL: (SQL server, MySQL ,PL/SQL, MongoDB, Redis, Cassandra...) Quality and test assurance MLOps also with all that ML/AI/DL "fundamental knowledge" (TensorFlow, Keras,nlp...) Maybe Networking knowledge with Cisco professional certificate aimed for at least mid-seniority Here is an example, this is for an entry-level A Bachelor’s DegreeSuccessful engineer in this role have majored in computer science and related fieldsGPA above 3.7
A Few Related Skills and Experiences(This is an entry-level role, and experience in every one of these areas is not required - training is provided on all core platforms, tools, and technologies you will need to know! But the following skills/experience are awesome to have, and will help get your career off to a running start:):
Part-time/Full-time/summer job/internship experience is a must
Experience with open-source web development
Experience with web-based programming languages (JavaScript, HTML, etc.)
Project-level experience with at least one JavaScript-based project
Experience with Cloud Computing Programs, Google Cloud Platform, AWS, Azure, etc.
Experience with OOP and procedural programming methodologies
Understanding of software development life-cycles and best practices
Knowledge of standard-compliant HTML, CSS, and Javascript
Database experience (MySQL, Google BigQuery)
Experience with CCS Frameworks (Bootstrap, Foundation, Intuit, etc.)
Experience with JS Frameworks (JQuery, React, Vue, Backbone, etc.)
Experience with Git Version control (or other version control software)
Experience with package management and Task Runners (NPM, Yarn, Gulp, Grunt)
Experience with browser testing using built-in developer tools
Familiarity with TensorFlow and Machine Learning
Experience with NodeJS
Experience with SaaS monitoring software such as DataDog
Experience with data management using data pipeline tools
Previous agency experience
Any of these Signature of our Traits!
You’re passionate about web/software development -
"you even find yourself spending your free time tinkering and learning new technologies!"(Should the canditat breath too? Or inhale and exhale assembly code?)
You’re comfortable with both object-oriented and procedural programming methodologies
You’re committed to delivering high-quality projects for clients
You enjoy variety, and like the challenge of working on multiple projects
You’re comfortable working both independently and as part of a team
You take direction well, but aren’t afraid to take initiative and make decisions
You see yourself as a problem-solver, and face challenges with a can-do mindset
You put the customer and their goals first