Why the Sanitizer API is just setHTML()
https://www.reddit.com/r/programming/comments/1phc4ge/why_the_sanitizer_api_is_just_sethtml/
submitted by /u/evilpies (https://www.reddit.com/user/evilpies)
[link] (https://frederikbraun.de/why-sethtml.html) [comments] (https://www.reddit.com/r/programming/comments/1phc4ge/why_the_sanitizer_api_is_just_sethtml/)
https://www.reddit.com/r/programming/comments/1phc4ge/why_the_sanitizer_api_is_just_sethtml/
submitted by /u/evilpies (https://www.reddit.com/user/evilpies)
[link] (https://frederikbraun.de/why-sethtml.html) [comments] (https://www.reddit.com/r/programming/comments/1phc4ge/why_the_sanitizer_api_is_just_sethtml/)
Using CTEs and Query Rewriting to Solve Versioning
https://www.reddit.com/r/programming/comments/1phcr73/using_ctes_and_query_rewriting_to_solve_versioning/
submitted by /u/shaberman (https://www.reddit.com/user/shaberman)
[link] (https://joist-orm.io/blog/query-rewriting-versioning/) [comments] (https://www.reddit.com/r/programming/comments/1phcr73/using_ctes_and_query_rewriting_to_solve_versioning/)
https://www.reddit.com/r/programming/comments/1phcr73/using_ctes_and_query_rewriting_to_solve_versioning/
submitted by /u/shaberman (https://www.reddit.com/user/shaberman)
[link] (https://joist-orm.io/blog/query-rewriting-versioning/) [comments] (https://www.reddit.com/r/programming/comments/1phcr73/using_ctes_and_query_rewriting_to_solve_versioning/)
Is vibe coding actually insecure? New CMU paper benchmarks vulnerabilities in agent-generated code
https://www.reddit.com/r/programming/comments/1phf2f9/is_vibe_coding_actually_insecure_new_cmu_paper/
<!-- SC_OFF -->BREAKING: CMU researchers found that “vibe coding” is insecure.
Developers are shocked.
The rest of us are shocked that anyone thought vibes counted as a security protocol. Paper: “Is Vibe Coding Safe? Benchmarking Vulnerability of Agent-Generated Code in Real-World Tasks” <!-- SC_ON --> submitted by /u/LateInstance8652 (https://www.reddit.com/user/LateInstance8652)
[link] (http://arxiv.org/abs/2512.03262) [comments] (https://www.reddit.com/r/programming/comments/1phf2f9/is_vibe_coding_actually_insecure_new_cmu_paper/)
https://www.reddit.com/r/programming/comments/1phf2f9/is_vibe_coding_actually_insecure_new_cmu_paper/
<!-- SC_OFF -->BREAKING: CMU researchers found that “vibe coding” is insecure.
Developers are shocked.
The rest of us are shocked that anyone thought vibes counted as a security protocol. Paper: “Is Vibe Coding Safe? Benchmarking Vulnerability of Agent-Generated Code in Real-World Tasks” <!-- SC_ON --> submitted by /u/LateInstance8652 (https://www.reddit.com/user/LateInstance8652)
[link] (http://arxiv.org/abs/2512.03262) [comments] (https://www.reddit.com/r/programming/comments/1phf2f9/is_vibe_coding_actually_insecure_new_cmu_paper/)
Swift for Android vs. Kotlin Multiplatform
https://www.reddit.com/r/programming/comments/1phgpm0/swift_for_android_vs_kotlin_multiplatform/
submitted by /u/jacobs-tech-tavern (https://www.reddit.com/user/jacobs-tech-tavern)
[link] (https://blog.jacobstechtavern.com/p/swift-for-android-vs-kmp) [comments] (https://www.reddit.com/r/programming/comments/1phgpm0/swift_for_android_vs_kotlin_multiplatform/)
https://www.reddit.com/r/programming/comments/1phgpm0/swift_for_android_vs_kotlin_multiplatform/
submitted by /u/jacobs-tech-tavern (https://www.reddit.com/user/jacobs-tech-tavern)
[link] (https://blog.jacobstechtavern.com/p/swift-for-android-vs-kmp) [comments] (https://www.reddit.com/r/programming/comments/1phgpm0/swift_for_android_vs_kotlin_multiplatform/)
Types of API Testing
https://www.reddit.com/r/programming/comments/1phh154/types_of_api_testing/
submitted by /u/stmoreau (https://www.reddit.com/user/stmoreau)
[link] (https://www.systemdesignbutsimple.com/p/types-of-api-testing) [comments] (https://www.reddit.com/r/programming/comments/1phh154/types_of_api_testing/)
https://www.reddit.com/r/programming/comments/1phh154/types_of_api_testing/
submitted by /u/stmoreau (https://www.reddit.com/user/stmoreau)
[link] (https://www.systemdesignbutsimple.com/p/types-of-api-testing) [comments] (https://www.reddit.com/r/programming/comments/1phh154/types_of_api_testing/)
Simplifying access to commonly used objects
https://www.reddit.com/r/programming/comments/1phh6x5/simplifying_access_to_commonly_used_objects/
submitted by /u/itsunclexo (https://www.reddit.com/user/itsunclexo)
[link] (https://medium.com/@unclexo/the-registry-pattern-simplifying-access-to-commonly-used-objects-93e2857abab7) [comments] (https://www.reddit.com/r/programming/comments/1phh6x5/simplifying_access_to_commonly_used_objects/)
https://www.reddit.com/r/programming/comments/1phh6x5/simplifying_access_to_commonly_used_objects/
submitted by /u/itsunclexo (https://www.reddit.com/user/itsunclexo)
[link] (https://medium.com/@unclexo/the-registry-pattern-simplifying-access-to-commonly-used-objects-93e2857abab7) [comments] (https://www.reddit.com/r/programming/comments/1phh6x5/simplifying_access_to_commonly_used_objects/)
Java Swing Library System | (Part 3) User Management Module – Login System Connected to MySQL
https://www.reddit.com/r/programming/comments/1phk4os/java_swing_library_system_part_3_user_management/
<!-- SC_OFF -->📌 Part 26 — Java Swing Library System | User Management Module (Part 3)
I just uploaded a new tutorial where I build a complete Login System in Java Swing, fully connected to MySQL.
If you’re learning Java desktop development or building real-world projects, this session will really help you. 🔥 What’s inside the video: Designing a professional Login Form in Java Swing Connecting Java Swing to MySQL User authentication with username & password Clean, reusable code patterns Part of a full User Management Module This tutorial is part of my ongoing Library Management System series built completely from scratch. <!-- SC_ON --> submitted by /u/Substantial-Log-9305 (https://www.reddit.com/user/Substantial-Log-9305)
[link] (https://www.youtube.com/watch?v=IP4lI8Ks3_Q) [comments] (https://www.reddit.com/r/programming/comments/1phk4os/java_swing_library_system_part_3_user_management/)
https://www.reddit.com/r/programming/comments/1phk4os/java_swing_library_system_part_3_user_management/
<!-- SC_OFF -->📌 Part 26 — Java Swing Library System | User Management Module (Part 3)
I just uploaded a new tutorial where I build a complete Login System in Java Swing, fully connected to MySQL.
If you’re learning Java desktop development or building real-world projects, this session will really help you. 🔥 What’s inside the video: Designing a professional Login Form in Java Swing Connecting Java Swing to MySQL User authentication with username & password Clean, reusable code patterns Part of a full User Management Module This tutorial is part of my ongoing Library Management System series built completely from scratch. <!-- SC_ON --> submitted by /u/Substantial-Log-9305 (https://www.reddit.com/user/Substantial-Log-9305)
[link] (https://www.youtube.com/watch?v=IP4lI8Ks3_Q) [comments] (https://www.reddit.com/r/programming/comments/1phk4os/java_swing_library_system_part_3_user_management/)
How many returns should a function have
https://www.reddit.com/r/programming/comments/1phx511/how_many_returns_should_a_function_have/
submitted by /u/South-Reception-1251 (https://www.reddit.com/user/South-Reception-1251)
[link] (https://youtu.be/1TmcBpwl_oE) [comments] (https://www.reddit.com/r/programming/comments/1phx511/how_many_returns_should_a_function_have/)
https://www.reddit.com/r/programming/comments/1phx511/how_many_returns_should_a_function_have/
submitted by /u/South-Reception-1251 (https://www.reddit.com/user/South-Reception-1251)
[link] (https://youtu.be/1TmcBpwl_oE) [comments] (https://www.reddit.com/r/programming/comments/1phx511/how_many_returns_should_a_function_have/)
Talk on strategies on how to make C++ safer over the years by John Lakos.
https://www.reddit.com/r/programming/comments/1phz0gc/talk_on_strategies_on_how_to_make_c_safer_over/
submitted by /u/germandiago (https://www.reddit.com/user/germandiago)
[link] (https://youtu.be/3eqhtK3hV9A?si=EPf3n736rAeZn4hN) [comments] (https://www.reddit.com/r/programming/comments/1phz0gc/talk_on_strategies_on_how_to_make_c_safer_over/)
https://www.reddit.com/r/programming/comments/1phz0gc/talk_on_strategies_on_how_to_make_c_safer_over/
submitted by /u/germandiago (https://www.reddit.com/user/germandiago)
[link] (https://youtu.be/3eqhtK3hV9A?si=EPf3n736rAeZn4hN) [comments] (https://www.reddit.com/r/programming/comments/1phz0gc/talk_on_strategies_on_how_to_make_c_safer_over/)
mapstore-go: Local, files backed map store with pluggable serialization, encryption, mutation events.
https://www.reddit.com/r/programming/comments/1phz70b/mapstorego_local_files_backed_map_store_with/
submitted by /u/ppipada (https://www.reddit.com/user/ppipada)
[link] (https://github.com/ppipada/mapstore-go) [comments] (https://www.reddit.com/r/programming/comments/1phz70b/mapstorego_local_files_backed_map_store_with/)
https://www.reddit.com/r/programming/comments/1phz70b/mapstorego_local_files_backed_map_store_with/
submitted by /u/ppipada (https://www.reddit.com/user/ppipada)
[link] (https://github.com/ppipada/mapstore-go) [comments] (https://www.reddit.com/r/programming/comments/1phz70b/mapstorego_local_files_backed_map_store_with/)
StackOverflow Programming Challenge #14 - Signal from Noise
https://www.reddit.com/r/programming/comments/1phzkhg/stackoverflow_programming_challenge_14_signal/
<!-- SC_OFF -->Hello r/programming (https://www.reddit.com/r/programming)! StackOverflow recently started hosting monthly(-ish) programming challenges, in the same vein as Advent of Code. If you want to participate, go onto stackoverflow.com and/or the linked /r/StackOverflow (https://www.reddit.com/r/StackOverflow) post, and submit your answer! <!-- SC_ON --> submitted by /u/davidalayachew (https://www.reddit.com/user/davidalayachew)
[link] (https://www.reddit.com/r/stackoverflow/comments/1pgy7gt/stackoverflow_programming_challenge_14_signal/) [comments] (https://www.reddit.com/r/programming/comments/1phzkhg/stackoverflow_programming_challenge_14_signal/)
https://www.reddit.com/r/programming/comments/1phzkhg/stackoverflow_programming_challenge_14_signal/
<!-- SC_OFF -->Hello r/programming (https://www.reddit.com/r/programming)! StackOverflow recently started hosting monthly(-ish) programming challenges, in the same vein as Advent of Code. If you want to participate, go onto stackoverflow.com and/or the linked /r/StackOverflow (https://www.reddit.com/r/StackOverflow) post, and submit your answer! <!-- SC_ON --> submitted by /u/davidalayachew (https://www.reddit.com/user/davidalayachew)
[link] (https://www.reddit.com/r/stackoverflow/comments/1pgy7gt/stackoverflow_programming_challenge_14_signal/) [comments] (https://www.reddit.com/r/programming/comments/1phzkhg/stackoverflow_programming_challenge_14_signal/)
Professional Student ID Card in Java Swing | With Image, Signature & Print Feature
https://www.reddit.com/r/programming/comments/1phzlv3/professional_student_id_card_in_java_swing_with/
<!-- SC_OFF -->Hey everyone!
I just uploaded a new tutorial where I show how to create a complete Student ID Card system in Java Swing — including: 🖼️ Student Photo Upload
✍️ Digital Signature Support
🖨️ Print / Save ID Card Feature
📌 Clean and professional UI
💡 Perfect for real-world Java Swing projects 👉 Watch the full tutorial here: (Professional Student ID Card in Java Swing | With Image, Signature & Print Feature - YouTube (https://www.youtube.com/watch?v=8snkc-bxJc0&t=28s)) 📺 Check Out My YouTube Channel I upload Java Swing, Java projects, and full desktop application tutorials.
🔗 YouTube Channel: (Kawsar Technologies - YouTube (https://www.youtube.com/@kawsartechnologies981)) <!-- SC_ON --> submitted by /u/Substantial-Log-9305 (https://www.reddit.com/user/Substantial-Log-9305)
[link] (https://www.youtube.com/watch?v=8snkc-bxJc0&t=28s) [comments] (https://www.reddit.com/r/programming/comments/1phzlv3/professional_student_id_card_in_java_swing_with/)
https://www.reddit.com/r/programming/comments/1phzlv3/professional_student_id_card_in_java_swing_with/
<!-- SC_OFF -->Hey everyone!
I just uploaded a new tutorial where I show how to create a complete Student ID Card system in Java Swing — including: 🖼️ Student Photo Upload
✍️ Digital Signature Support
🖨️ Print / Save ID Card Feature
📌 Clean and professional UI
💡 Perfect for real-world Java Swing projects 👉 Watch the full tutorial here: (Professional Student ID Card in Java Swing | With Image, Signature & Print Feature - YouTube (https://www.youtube.com/watch?v=8snkc-bxJc0&t=28s)) 📺 Check Out My YouTube Channel I upload Java Swing, Java projects, and full desktop application tutorials.
🔗 YouTube Channel: (Kawsar Technologies - YouTube (https://www.youtube.com/@kawsartechnologies981)) <!-- SC_ON --> submitted by /u/Substantial-Log-9305 (https://www.reddit.com/user/Substantial-Log-9305)
[link] (https://www.youtube.com/watch?v=8snkc-bxJc0&t=28s) [comments] (https://www.reddit.com/r/programming/comments/1phzlv3/professional_student_id_card_in_java_swing_with/)
Rigorous Nonsense - Readable Code is Unreadable
https://www.reddit.com/r/programming/comments/1pi0uvr/rigorous_nonsense_readable_code_is_unreadable/
submitted by /u/Xadartt (https://www.reddit.com/user/Xadartt)
[link] (https://blog.wilsonb.com/posts/2025-06-06-readable-code-is-unreadable.html) [comments] (https://www.reddit.com/r/programming/comments/1pi0uvr/rigorous_nonsense_readable_code_is_unreadable/)
https://www.reddit.com/r/programming/comments/1pi0uvr/rigorous_nonsense_readable_code_is_unreadable/
submitted by /u/Xadartt (https://www.reddit.com/user/Xadartt)
[link] (https://blog.wilsonb.com/posts/2025-06-06-readable-code-is-unreadable.html) [comments] (https://www.reddit.com/r/programming/comments/1pi0uvr/rigorous_nonsense_readable_code_is_unreadable/)
10 Habits That Make You a Great Programmer
https://www.reddit.com/r/programming/comments/1pi15pa/10_habits_that_make_you_a_great_programmer/
submitted by /u/delvin0 (https://www.reddit.com/user/delvin0)
[link] (https://medium.com/gitconnected/10-habits-that-make-you-a-great-programmer-f5fd5686d80f?sk=49221a5d9e8aeef75b5afbb704762607) [comments] (https://www.reddit.com/r/programming/comments/1pi15pa/10_habits_that_make_you_a_great_programmer/)
https://www.reddit.com/r/programming/comments/1pi15pa/10_habits_that_make_you_a_great_programmer/
submitted by /u/delvin0 (https://www.reddit.com/user/delvin0)
[link] (https://medium.com/gitconnected/10-habits-that-make-you-a-great-programmer-f5fd5686d80f?sk=49221a5d9e8aeef75b5afbb704762607) [comments] (https://www.reddit.com/r/programming/comments/1pi15pa/10_habits_that_make_you_a_great_programmer/)
Really fast SPSC
https://www.reddit.com/r/programming/comments/1pi4rpj/really_fast_spsc/
<!-- SC_OFF -->would love to know your thoughts! <!-- SC_ON --> submitted by /u/M3GA-10 (https://www.reddit.com/user/M3GA-10)
[link] (https://abhikja.in/blog/2025-12-07-get-in-line/) [comments] (https://www.reddit.com/r/programming/comments/1pi4rpj/really_fast_spsc/)
https://www.reddit.com/r/programming/comments/1pi4rpj/really_fast_spsc/
<!-- SC_OFF -->would love to know your thoughts! <!-- SC_ON --> submitted by /u/M3GA-10 (https://www.reddit.com/user/M3GA-10)
[link] (https://abhikja.in/blog/2025-12-07-get-in-line/) [comments] (https://www.reddit.com/r/programming/comments/1pi4rpj/really_fast_spsc/)
Improving my flutter daily-recap app via hive caching, regenerate flows, error cards, and GH actions
https://www.reddit.com/r/programming/comments/1pi7i3k/improving_my_flutter_dailyrecap_app_via_hive/
submitted by /u/Party-Tower-5475 (https://www.reddit.com/user/Party-Tower-5475)
[link] (https://pieces.app/blog/production-ready-productivity-app?utm_source=reddit&utm_medium=referral&utm_campaign=r54) [comments] (https://www.reddit.com/r/programming/comments/1pi7i3k/improving_my_flutter_dailyrecap_app_via_hive/)
https://www.reddit.com/r/programming/comments/1pi7i3k/improving_my_flutter_dailyrecap_app_via_hive/
submitted by /u/Party-Tower-5475 (https://www.reddit.com/user/Party-Tower-5475)
[link] (https://pieces.app/blog/production-ready-productivity-app?utm_source=reddit&utm_medium=referral&utm_campaign=r54) [comments] (https://www.reddit.com/r/programming/comments/1pi7i3k/improving_my_flutter_dailyrecap_app_via_hive/)
2 years with Shape-Up, and why we switched back
https://www.reddit.com/r/programming/comments/1pi8thb/2_years_with_shapeup_and_why_we_switched_back/
submitted by /u/Wirbelwind (https://www.reddit.com/user/Wirbelwind)
[link] (https://scalex.dev/blog/2-years-with-shape-up/) [comments] (https://www.reddit.com/r/programming/comments/1pi8thb/2_years_with_shapeup_and_why_we_switched_back/)
https://www.reddit.com/r/programming/comments/1pi8thb/2_years_with_shapeup_and_why_we_switched_back/
submitted by /u/Wirbelwind (https://www.reddit.com/user/Wirbelwind)
[link] (https://scalex.dev/blog/2-years-with-shape-up/) [comments] (https://www.reddit.com/r/programming/comments/1pi8thb/2_years_with_shapeup_and_why_we_switched_back/)
How do you modernize a legacy tech stack without a complete rewrite?
https://www.reddit.com/r/programming/comments/1piasie/how_do_you_modernize_a_legacy_tech_stack_without/
<!-- SC_OFF -->As everyone warns about rewrite projects that they are set for failure, how would you modernize legacy software written with an out-of-date tech stack like Visual FoxPro or Visual Basic 6 without a complete rewrite? We have a lot of internal applications written in those tech stacks (FoxPro, VB6, ASP, etc.). Everyone seems to say that the right way to modernize these software is through the strangler fig pattern, but how would it work with these tech stacks where the new and old software can't co-exist? We are starting a migration project to migrate the largest internal application, migrating from VB6 on Windows to a web-based application backed by Go. Everyone on the team agrees that a Big Bang rollout is the only way. Curious on what you think. More background here: https://www.reddit.com/r/programming/comments/1piasie/comment/nt4spcg/ <!-- SC_ON --> submitted by /u/thana979 (https://www.reddit.com/user/thana979)
[link] (https://learn.microsoft.com/en-us/azure/architecture/patterns/strangler-fig) [comments] (https://www.reddit.com/r/programming/comments/1piasie/how_do_you_modernize_a_legacy_tech_stack_without/)
https://www.reddit.com/r/programming/comments/1piasie/how_do_you_modernize_a_legacy_tech_stack_without/
<!-- SC_OFF -->As everyone warns about rewrite projects that they are set for failure, how would you modernize legacy software written with an out-of-date tech stack like Visual FoxPro or Visual Basic 6 without a complete rewrite? We have a lot of internal applications written in those tech stacks (FoxPro, VB6, ASP, etc.). Everyone seems to say that the right way to modernize these software is through the strangler fig pattern, but how would it work with these tech stacks where the new and old software can't co-exist? We are starting a migration project to migrate the largest internal application, migrating from VB6 on Windows to a web-based application backed by Go. Everyone on the team agrees that a Big Bang rollout is the only way. Curious on what you think. More background here: https://www.reddit.com/r/programming/comments/1piasie/comment/nt4spcg/ <!-- SC_ON --> submitted by /u/thana979 (https://www.reddit.com/user/thana979)
[link] (https://learn.microsoft.com/en-us/azure/architecture/patterns/strangler-fig) [comments] (https://www.reddit.com/r/programming/comments/1piasie/how_do_you_modernize_a_legacy_tech_stack_without/)
Badge System Evolution: Building From Simple to Scalable (Part 1)
https://www.reddit.com/r/programming/comments/1pic8f3/badge_system_evolution_building_from_simple_to/
submitted by /u/Namit2111 (https://www.reddit.com/user/Namit2111)
[link] (https://www.namitjain.com/blog/backend-driven-badge-system-part-1) [comments] (https://www.reddit.com/r/programming/comments/1pic8f3/badge_system_evolution_building_from_simple_to/)
https://www.reddit.com/r/programming/comments/1pic8f3/badge_system_evolution_building_from_simple_to/
submitted by /u/Namit2111 (https://www.reddit.com/user/Namit2111)
[link] (https://www.namitjain.com/blog/backend-driven-badge-system-part-1) [comments] (https://www.reddit.com/r/programming/comments/1pic8f3/badge_system_evolution_building_from_simple_to/)
Using a piece tree to implement a lazy-loading text editor, and where this idea comes from originally
https://www.reddit.com/r/programming/comments/1picg8v/using_a_piece_tree_to_implement_a_lazyloading/
<!-- SC_OFF -->I wanted my text editor to be able to load - and edit - huge files (>>1GB) instantly. It started from an idea to support editing files hosted on slow media like S3 which is a similar but different problem (RAM is not the issue unless also those files are huge). I went back to the source code of Microsoft Word 1.1 (1990) to learn a bit more on how this was used back in the days when RAM was so scarce that the program itself consumed significant amounts of your entire system's RAM (programs employed hot swapping of its own modules in those days!) Also discovered that one of the people who came up with the piece table - J Strother Moore - previously worked on the Apollo guidance computer.
The blog includes links to some historically interesting resources and explains how the piece tree helps for laziness as well as failure recovery, diffing large buffers, etc. https://noamlewis.com/blog/2025/12/09/how-fresh-loads-huge-files-fast I'm using Claude Code to accelerate coding chores - allowing me to focus on these types of problems which require deeper understanding and keep my efforts on the higher impact tasks. <!-- SC_ON --> submitted by /u/sinelaw (https://www.reddit.com/user/sinelaw)
[link] (https://noamlewis.com/blog/2025/12/09/how-fresh-loads-huge-files-fast) [comments] (https://www.reddit.com/r/programming/comments/1picg8v/using_a_piece_tree_to_implement_a_lazyloading/)
https://www.reddit.com/r/programming/comments/1picg8v/using_a_piece_tree_to_implement_a_lazyloading/
<!-- SC_OFF -->I wanted my text editor to be able to load - and edit - huge files (>>1GB) instantly. It started from an idea to support editing files hosted on slow media like S3 which is a similar but different problem (RAM is not the issue unless also those files are huge). I went back to the source code of Microsoft Word 1.1 (1990) to learn a bit more on how this was used back in the days when RAM was so scarce that the program itself consumed significant amounts of your entire system's RAM (programs employed hot swapping of its own modules in those days!) Also discovered that one of the people who came up with the piece table - J Strother Moore - previously worked on the Apollo guidance computer.
The blog includes links to some historically interesting resources and explains how the piece tree helps for laziness as well as failure recovery, diffing large buffers, etc. https://noamlewis.com/blog/2025/12/09/how-fresh-loads-huge-files-fast I'm using Claude Code to accelerate coding chores - allowing me to focus on these types of problems which require deeper understanding and keep my efforts on the higher impact tasks. <!-- SC_ON --> submitted by /u/sinelaw (https://www.reddit.com/user/sinelaw)
[link] (https://noamlewis.com/blog/2025/12/09/how-fresh-loads-huge-files-fast) [comments] (https://www.reddit.com/r/programming/comments/1picg8v/using_a_piece_tree_to_implement_a_lazyloading/)
Solving the n+1 Problem in Postgres with psycopg and pydantic
https://www.reddit.com/r/programming/comments/1pidz1t/solving_the_n1_problem_in_postgres_with_psycopg/
<!-- SC_OFF -->I wrote a tutorial with code repository on writing efficient SQL queries using some of my favourite tools: Postgres and Pydantic and Pyscopg in Python. It shows how to fetch nested objects in a singe query and map them directly to Python models. <!-- SC_ON --> submitted by /u/kivarada (https://www.reddit.com/user/kivarada)
[link] (https://insidestack.it/articles/solving-the-n-1-problem-in-postgres-with-psycopg-and-pydantic) [comments] (https://www.reddit.com/r/programming/comments/1pidz1t/solving_the_n1_problem_in_postgres_with_psycopg/)
https://www.reddit.com/r/programming/comments/1pidz1t/solving_the_n1_problem_in_postgres_with_psycopg/
<!-- SC_OFF -->I wrote a tutorial with code repository on writing efficient SQL queries using some of my favourite tools: Postgres and Pydantic and Pyscopg in Python. It shows how to fetch nested objects in a singe query and map them directly to Python models. <!-- SC_ON --> submitted by /u/kivarada (https://www.reddit.com/user/kivarada)
[link] (https://insidestack.it/articles/solving-the-n-1-problem-in-postgres-with-psycopg-and-pydantic) [comments] (https://www.reddit.com/r/programming/comments/1pidz1t/solving_the_n1_problem_in_postgres_with_psycopg/)