NEW BOT Телеграм, страница

Real-World Case Study: Optimizing PostgreSQL Queries with Functional Indexes
https://www.reddit.com/r/programming/comments/1n2xlf4/realworld_case_study_optimizing_postgresql/

We at Mafiree recently published a case study on query optimization in PostgreSQL using functional indexes. It’s based on an actual production scenario where query performance was improved by rethinking indexing strategy. I’d love to hear how others here approach: Functional indexes in production environments Balancing index overhead with performance gains  submitted by /u/DbOpsNinja (https://www.reddit.com/user/DbOpsNinja)
[link] (https://www.mafiree.com/readBlog/optimizing-postgresql-queries-with-functional-indexes--a-real-world-case-study) [comments] (https://www.reddit.com/r/programming/comments/1n2xlf4/realworld_case_study_optimizing_postgresql/)

2 views06:49

Reddit Programming

Open source dilemma in the EU too: many see benefits, too few contribute
https://www.reddit.com/r/programming/comments/1n2xsd1/open_source_dilemma_in_the_eu_too_many_see/

submitted by /u/donutloop (https://www.reddit.com/user/donutloop)
[link] (https://www.heise.de/en/news/Open-source-dilemma-in-the-EU-too-many-see-benefits-too-few-contribute-10624536.html) [comments] (https://www.reddit.com/r/programming/comments/1n2xsd1/open_source_dilemma_in_the_eu_too_many_see/)

2 views06:50

Reddit Programming

Using git as a memory layer for AI code assistants
https://www.reddit.com/r/programming/comments/1n30oo9/using_git_as_a_memory_layer_for_ai_code_assistants/

Hey everyone, I've been exploring an interesting pattern: using git as a queryable memory for AI coding assistants. The problem: AI assistants like Claude have no memory between sessions and every debugging session means re-explaining your entire codebase burning lot of tokens. My approach: Auto-commit every file save to a parallel local hidden git repository, then expose git operations to the AI via MCP. Instead of feeding Claude my entire codebase, it now runs git commands directly on this hidden repo (which contains the full evolution of my codebase). The interesting part is that AI already speaks git fluently. It knows exactly which commands to run for different scenarios. Tradeoffs I'm seeing: - Pros: Massive token reduction, AI can trace bug introduction, perfect undo history - Cons: Disk usage (~12MB per 10k commits), another process running in background Has anyone else tried giving AI assistants access to version control? Thank you!
Alessandro  submitted by /u/Apart-Employment-592 (https://www.reddit.com/user/Apart-Employment-592)
[link] (https://github.com/blade47/shadowgit-mcp) [comments] (https://www.reddit.com/r/programming/comments/1n30oo9/using_git_as_a_memory_layer_for_ai_code_assistants/)

2 views10:45

Reddit Programming

The promise of Rust
https://www.reddit.com/r/programming/comments/1n355fd/the_promise_of_rust/

submitted by /u/Maybe-monad (https://www.reddit.com/user/Maybe-monad)
[link] (https://fasterthanli.me/articles/the-promise-of-rust) [comments] (https://www.reddit.com/r/programming/comments/1n355fd/the_promise_of_rust/)

2 views18:09

Reddit Programming

Instacart Consolidates Search Infrastructure on Postgresql, Phasing out Elasticsearch
https://www.reddit.com/r/programming/comments/1n38n66/instacart_consolidates_search_infrastructure_on/

submitted by /u/rgancarz (https://www.reddit.com/user/rgancarz)
[link] (https://www.infoq.com/news/2025/08/instacart-elasticsearch-postgres/) [comments] (https://www.reddit.com/r/programming/comments/1n38n66/instacart_consolidates_search_infrastructure_on/)

2 views18:10

Reddit Programming

Petition to stop Google's attack on Android devs
https://www.reddit.com/r/programming/comments/1n38vz6/petition_to_stop_googles_attack_on_android_devs/

Sign the petition! 🫵✊🤝  submitted by /u/Clippy-Windows95 (https://www.reddit.com/user/Clippy-Windows95)
[link] (https://chng.it/7GrRtBnPtd) [comments] (https://www.reddit.com/r/programming/comments/1n38vz6/petition_to_stop_googles_attack_on_android_devs/)

2 views18:11

Reddit Programming

Self-Healing Systems: Architectural Patterns
https://www.reddit.com/r/programming/comments/1n39yxo/selfhealing_systems_architectural_patterns/

Every self-healing system operates on three core principles that work in continuous loops: Detection: The System's Nervous System Modern self-healing relies on multi-layered health signals rather than simple ping checks. Netflix's microservices don't just monitor CPU and memory—they track business metrics like recommendation accuracy and user engagement rates. Circuit Breaker Integration: When a service's error rate crosses 50%, circuit breakers automatically isolate it while healing mechanisms activate. This prevents cascade failures during recovery. Behavioral Anomaly Detection: Systems learn normal patterns and detect deviations. A sudden 300% increase in database query time triggers healing before users notice slowness. Decision: The Healing Brain The decision engine determines the appropriate response based on failure type, system state, and historical success rates of different recovery strategies. Recovery Strategy Selection: Memory leaks trigger instance replacement, while network issues trigger retry with exponential backoff. Database connection exhaustion triggers connection pool scaling. Risk Assessment: Before taking action, the system evaluates potential impact. Restarting a critical service during peak hours might cause more damage than the original problem. Action: The Healing Hands Recovery actions range from gentle adjustments to aggressive interventions, always prioritizing system stability over perfect recovery. Graceful Degradation: Instead of complete failure, systems reduce functionality. YouTube serves lower-quality videos when CDN nodes fail rather than showing error pages. Progressive Recovery: Healing happens incrementally. One instance restarts at a time, with health verification before proceeding to the next.  submitted by /u/Extra_Ear_10 (https://www.reddit.com/user/Extra_Ear_10)
[link] (https://systemdr.substack.com/p/self-healing-systems-architectural) [comments] (https://www.reddit.com/r/programming/comments/1n39yxo/selfhealing_systems_architectural_patterns/)

2 views18:12

Reddit Programming

Aspects of modern HTML/CSS you may not be familiar with
https://www.reddit.com/r/programming/comments/1n3g6px/aspects_of_modern_htmlcss_you_may_not_be_familiar/

submitted by /u/ketralnis (https://www.reddit.com/user/ketralnis)
[link] (https://lyra.horse/blog/2025/08/you-dont-need-js/) [comments] (https://www.reddit.com/r/programming/comments/1n3g6px/aspects_of_modern_htmlcss_you_may_not_be_familiar/)

2 views02:54

Reddit Programming

Pyret: A programming language for programming education
https://www.reddit.com/r/programming/comments/1n3g825/pyret_a_programming_language_for_programming/

submitted by /u/ketralnis (https://www.reddit.com/user/ketralnis)
[link] (https://pyret.org/) [comments] (https://www.reddit.com/r/programming/comments/1n3g825/pyret_a_programming_language_for_programming/)

2 views02:55

Reddit Programming

Simple but Powerful Pratt Parsing
https://www.reddit.com/r/programming/comments/1n3ga48/simple_but_powerful_pratt_parsing/

submitted by /u/ketralnis (https://www.reddit.com/user/ketralnis)
[link] (http://matklad.github.io/2020/04/13/simple-but-powerful-pratt-parsing.html) [comments] (https://www.reddit.com/r/programming/comments/1n3ga48/simple_but_powerful_pratt_parsing/)

2 views02:56

About

Blog

Apps

Platform