Your AI diagram looks great and nobody will read it
https://www.reddit.com/r/programming/comments/1qqizxa/your_ai_diagram_looks_great_and_nobody_will_read/
<!-- SC_OFF -->- Mermaid has over 8 million users; GitHub added native support in Feb 2022 - AI diagrams are static images. You can't grep a PNG. - Git diffs on binary blobs are meaningless six months later - Regenerating to fix one box might break three others - The 15 minutes you saved skipping Mermaid syntax? You'll spend them on regeneration roulette TLDR: Learn Mermaid. And if you need ASCII art, you can use https://github.com/lukilabs/beautiful-mermaid <!-- SC_ON --> submitted by /u/jpcaparas (https://www.reddit.com/user/jpcaparas)
[link] (https://jpcaparas.medium.com/your-ai-diagram-looks-great-and-nobody-will-read-it-f1e34fe9c8f1?sk=46e2e66a39bc97190a554caad187c88d) [comments] (https://www.reddit.com/r/programming/comments/1qqizxa/your_ai_diagram_looks_great_and_nobody_will_read/)
https://www.reddit.com/r/programming/comments/1qqizxa/your_ai_diagram_looks_great_and_nobody_will_read/
<!-- SC_OFF -->- Mermaid has over 8 million users; GitHub added native support in Feb 2022 - AI diagrams are static images. You can't grep a PNG. - Git diffs on binary blobs are meaningless six months later - Regenerating to fix one box might break three others - The 15 minutes you saved skipping Mermaid syntax? You'll spend them on regeneration roulette TLDR: Learn Mermaid. And if you need ASCII art, you can use https://github.com/lukilabs/beautiful-mermaid <!-- SC_ON --> submitted by /u/jpcaparas (https://www.reddit.com/user/jpcaparas)
[link] (https://jpcaparas.medium.com/your-ai-diagram-looks-great-and-nobody-will-read-it-f1e34fe9c8f1?sk=46e2e66a39bc97190a554caad187c88d) [comments] (https://www.reddit.com/r/programming/comments/1qqizxa/your_ai_diagram_looks_great_and_nobody_will_read/)
C++ Modules are here to stay
https://www.reddit.com/r/programming/comments/1qqjdm1/c_modules_are_here_to_stay/
submitted by /u/Dear-Economics-315 (https://www.reddit.com/user/Dear-Economics-315)
[link] (https://faresbakhit.github.io/e/cpp-modules/) [comments] (https://www.reddit.com/r/programming/comments/1qqjdm1/c_modules_are_here_to_stay/)
https://www.reddit.com/r/programming/comments/1qqjdm1/c_modules_are_here_to_stay/
submitted by /u/Dear-Economics-315 (https://www.reddit.com/user/Dear-Economics-315)
[link] (https://faresbakhit.github.io/e/cpp-modules/) [comments] (https://www.reddit.com/r/programming/comments/1qqjdm1/c_modules_are_here_to_stay/)
challenge to compress 1M rows to the smallest possible size
https://www.reddit.com/r/programming/comments/1qqx086/challenge_to_compress_1m_rows_to_the_smallest/
submitted by /u/NoPercentage6144 (https://www.reddit.com/user/NoPercentage6144)
[link] (https://github.com/agavra/compression-golf) [comments] (https://www.reddit.com/r/programming/comments/1qqx086/challenge_to_compress_1m_rows_to_the_smallest/)
https://www.reddit.com/r/programming/comments/1qqx086/challenge_to_compress_1m_rows_to_the_smallest/
submitted by /u/NoPercentage6144 (https://www.reddit.com/user/NoPercentage6144)
[link] (https://github.com/agavra/compression-golf) [comments] (https://www.reddit.com/r/programming/comments/1qqx086/challenge_to_compress_1m_rows_to_the_smallest/)
Anthropic: AI assisted coding doesn't show efficiency gains and impairs developers abilities.
https://www.reddit.com/r/programming/comments/1qqxvlw/anthropic_ai_assisted_coding_doesnt_show/
<!-- SC_OFF -->You sure have heard it, it has been repeated countless times in the last few weeks, even from some luminaries of the development world: "AI coding makes you 10x more productive and if you don't use it you will be left behind". Sounds ominous right? Well, one of the biggest promoters of AI assisted coding has just put a stop to the hype and FOMO. Anthropic has published a paper that concludes: * There is no significant speed up in development by using AI assisted coding. This is partly because composing prompts and giving context to the LLM takes a lot of time, sometimes comparable as writing the code manually. * AI assisted coding significantly lowers the comprehension of the codebase and impairs developers grow. Developers who rely more on AI perform worst at debugging, conceptual understanding and code reading. This seems to contradict the massive push that has occurred in the last weeks, were people are saying that AI speeds them up massively(some claiming a 100x boost), that there is no downsides to this. Some even claim that they don't read the generated code and that software engineering is dead. Other people advocating this type of AI assisted development says "You just have to review the generated code" but it appears that just reviewing the code gives you at best a "flimsy understanding" of the codebase, which significantly reduces your ability to debug any problem that arises in the future, and stunts your abilities as a developer and problem solver, without delivering significant efficiency gains. <!-- SC_ON --> submitted by /u/Gil_berth (https://www.reddit.com/user/Gil_berth)
[link] (https://arxiv.org/abs/2601.20245) [comments] (https://www.reddit.com/r/programming/comments/1qqxvlw/anthropic_ai_assisted_coding_doesnt_show/)
https://www.reddit.com/r/programming/comments/1qqxvlw/anthropic_ai_assisted_coding_doesnt_show/
<!-- SC_OFF -->You sure have heard it, it has been repeated countless times in the last few weeks, even from some luminaries of the development world: "AI coding makes you 10x more productive and if you don't use it you will be left behind". Sounds ominous right? Well, one of the biggest promoters of AI assisted coding has just put a stop to the hype and FOMO. Anthropic has published a paper that concludes: * There is no significant speed up in development by using AI assisted coding. This is partly because composing prompts and giving context to the LLM takes a lot of time, sometimes comparable as writing the code manually. * AI assisted coding significantly lowers the comprehension of the codebase and impairs developers grow. Developers who rely more on AI perform worst at debugging, conceptual understanding and code reading. This seems to contradict the massive push that has occurred in the last weeks, were people are saying that AI speeds them up massively(some claiming a 100x boost), that there is no downsides to this. Some even claim that they don't read the generated code and that software engineering is dead. Other people advocating this type of AI assisted development says "You just have to review the generated code" but it appears that just reviewing the code gives you at best a "flimsy understanding" of the codebase, which significantly reduces your ability to debug any problem that arises in the future, and stunts your abilities as a developer and problem solver, without delivering significant efficiency gains. <!-- SC_ON --> submitted by /u/Gil_berth (https://www.reddit.com/user/Gil_berth)
[link] (https://arxiv.org/abs/2601.20245) [comments] (https://www.reddit.com/r/programming/comments/1qqxvlw/anthropic_ai_assisted_coding_doesnt_show/)
Silent foe or quiet ally: Brief guide to alignment in C++
https://www.reddit.com/r/programming/comments/1qqz74o/silent_foe_or_quiet_ally_brief_guide_to_alignment/
submitted by /u/Xadartt (https://www.reddit.com/user/Xadartt)
[link] (https://pvs-studio.com/en/blog/posts/cpp/1339/) [comments] (https://www.reddit.com/r/programming/comments/1qqz74o/silent_foe_or_quiet_ally_brief_guide_to_alignment/)
https://www.reddit.com/r/programming/comments/1qqz74o/silent_foe_or_quiet_ally_brief_guide_to_alignment/
submitted by /u/Xadartt (https://www.reddit.com/user/Xadartt)
[link] (https://pvs-studio.com/en/blog/posts/cpp/1339/) [comments] (https://www.reddit.com/r/programming/comments/1qqz74o/silent_foe_or_quiet_ally_brief_guide_to_alignment/)
State of C++ 2026
https://www.reddit.com/r/programming/comments/1qqzy7o/state_of_c_2026/
submitted by /u/dev_newsletter (https://www.reddit.com/user/dev_newsletter)
[link] (https://devnewsletter.com/p/state-of-cpp-2026/) [comments] (https://www.reddit.com/r/programming/comments/1qqzy7o/state_of_c_2026/)
https://www.reddit.com/r/programming/comments/1qqzy7o/state_of_c_2026/
submitted by /u/dev_newsletter (https://www.reddit.com/user/dev_newsletter)
[link] (https://devnewsletter.com/p/state-of-cpp-2026/) [comments] (https://www.reddit.com/r/programming/comments/1qqzy7o/state_of_c_2026/)
Schema registries solve runtime problems, not human ones
https://www.reddit.com/r/programming/comments/1qr02ju/schema_registries_solve_runtime_problems_not/
<!-- SC_OFF -->I’ve spent a lot of time working with event-driven systems, and I keep talking to people who are struggling with the same things I’ve struggled with. Schema registries are great at protecting production. They stop breaking changes, enforce contracts, and keep producers from accidentally breaking consumers. From a runtime point of view, they work really well. But they don’t help much when you are trying to understand the system as a human. When someone new joins the team, the questions are always the same: - Why does this event exist?
- Who owns it?
- What business flow does it belong to?
- What is supposed to happen after it is published?
- Is this still used or did it just never get cleaned up? In the past I tried fixing this with Confluence pages, architecture diagrams, and docs in repos. They were fine for general documentation, but they never really helped with this specific problem. They weren’t built for domain-driven design, software primitives, or events as first-class concepts. I could write things down, but it still didn’t help people understand how the system actually worked. So I built an open source tool to try and fix this. It focuses on documenting the human side of events. Ownership, intent, relationships, and flows live alongside schemas. It helped, but the longer I work in this space, the more convinced I am that we are still early in figuring this out... I’m curious to learn more, how other teams handle this? If you’ve felt this pain, what are you doing that actually works? <!-- SC_ON --> submitted by /u/boyneyy123 (https://www.reddit.com/user/boyneyy123)
[link] (https://github.com/event-catalog/eventcatalog) [comments] (https://www.reddit.com/r/programming/comments/1qr02ju/schema_registries_solve_runtime_problems_not/)
https://www.reddit.com/r/programming/comments/1qr02ju/schema_registries_solve_runtime_problems_not/
<!-- SC_OFF -->I’ve spent a lot of time working with event-driven systems, and I keep talking to people who are struggling with the same things I’ve struggled with. Schema registries are great at protecting production. They stop breaking changes, enforce contracts, and keep producers from accidentally breaking consumers. From a runtime point of view, they work really well. But they don’t help much when you are trying to understand the system as a human. When someone new joins the team, the questions are always the same: - Why does this event exist?
- Who owns it?
- What business flow does it belong to?
- What is supposed to happen after it is published?
- Is this still used or did it just never get cleaned up? In the past I tried fixing this with Confluence pages, architecture diagrams, and docs in repos. They were fine for general documentation, but they never really helped with this specific problem. They weren’t built for domain-driven design, software primitives, or events as first-class concepts. I could write things down, but it still didn’t help people understand how the system actually worked. So I built an open source tool to try and fix this. It focuses on documenting the human side of events. Ownership, intent, relationships, and flows live alongside schemas. It helped, but the longer I work in this space, the more convinced I am that we are still early in figuring this out... I’m curious to learn more, how other teams handle this? If you’ve felt this pain, what are you doing that actually works? <!-- SC_ON --> submitted by /u/boyneyy123 (https://www.reddit.com/user/boyneyy123)
[link] (https://github.com/event-catalog/eventcatalog) [comments] (https://www.reddit.com/r/programming/comments/1qr02ju/schema_registries_solve_runtime_problems_not/)
IvorySQL 5.0+: an open-source game changer for Oracle to PostgreSQL transitions
https://www.reddit.com/r/programming/comments/1qr2ssk/ivorysql_50_an_opensource_game_changer_for_oracle/
submitted by /u/talktomeabouttech (https://www.reddit.com/user/talktomeabouttech)
[link] (https://www.data-bene.io/en/blog/ivorysql-5/) [comments] (https://www.reddit.com/r/programming/comments/1qr2ssk/ivorysql_50_an_opensource_game_changer_for_oracle/)
https://www.reddit.com/r/programming/comments/1qr2ssk/ivorysql_50_an_opensource_game_changer_for_oracle/
submitted by /u/talktomeabouttech (https://www.reddit.com/user/talktomeabouttech)
[link] (https://www.data-bene.io/en/blog/ivorysql-5/) [comments] (https://www.reddit.com/r/programming/comments/1qr2ssk/ivorysql_50_an_opensource_game_changer_for_oracle/)
Camera Pipe Injection: Why Your Biometric Backend is Fed Fake Data
https://www.reddit.com/r/programming/comments/1qr3ly1/camera_pipe_injection_why_your_biometric_backend/
submitted by /u/JadeLuxe (https://www.reddit.com/user/JadeLuxe)
[link] (https://instatunnel.my/blog/camera-pipe-injection-why-your-biometric-backend-is-fed-fake-data) [comments] (https://www.reddit.com/r/programming/comments/1qr3ly1/camera_pipe_injection_why_your_biometric_backend/)
https://www.reddit.com/r/programming/comments/1qr3ly1/camera_pipe_injection_why_your_biometric_backend/
submitted by /u/JadeLuxe (https://www.reddit.com/user/JadeLuxe)
[link] (https://instatunnel.my/blog/camera-pipe-injection-why-your-biometric-backend-is-fed-fake-data) [comments] (https://www.reddit.com/r/programming/comments/1qr3ly1/camera_pipe_injection_why_your_biometric_backend/)
How Replacing Developers With AI is Going Horribly Wrong
https://www.reddit.com/r/programming/comments/1qr43mp/how_replacing_developers_with_ai_is_going/
submitted by /u/BlazorPlate (https://www.reddit.com/user/BlazorPlate)
[link] (https://youtu.be/ts0nH_pSAdM?si=Kn2m9MqmWmdL6739) [comments] (https://www.reddit.com/r/programming/comments/1qr43mp/how_replacing_developers_with_ai_is_going/)
https://www.reddit.com/r/programming/comments/1qr43mp/how_replacing_developers_with_ai_is_going/
submitted by /u/BlazorPlate (https://www.reddit.com/user/BlazorPlate)
[link] (https://youtu.be/ts0nH_pSAdM?si=Kn2m9MqmWmdL6739) [comments] (https://www.reddit.com/r/programming/comments/1qr43mp/how_replacing_developers_with_ai_is_going/)
Ktor 3.4.0: HTML Fragments, HTMX, and Finally Proper SSE Cleanup
https://www.reddit.com/r/programming/comments/1qr45rj/ktor_340_html_fragments_htmx_and_finally_proper/
submitted by /u/cekrem (https://www.reddit.com/user/cekrem)
[link] (https://cekrem.github.io/posts/ktor-340-html-fragments-htmx-and-finally-proper-sse-cleanup/) [comments] (https://www.reddit.com/r/programming/comments/1qr45rj/ktor_340_html_fragments_htmx_and_finally_proper/)
https://www.reddit.com/r/programming/comments/1qr45rj/ktor_340_html_fragments_htmx_and_finally_proper/
submitted by /u/cekrem (https://www.reddit.com/user/cekrem)
[link] (https://cekrem.github.io/posts/ktor-340-html-fragments-htmx-and-finally-proper-sse-cleanup/) [comments] (https://www.reddit.com/r/programming/comments/1qr45rj/ktor_340_html_fragments_htmx_and_finally_proper/)
Kindler: A New, lua-based build system designed to run anywhere
https://www.reddit.com/r/programming/comments/1qrofk8/kindler_a_new_luabased_build_system_designed_to/
submitted by /u/IRIX_Raion (https://www.reddit.com/user/IRIX_Raion)
[link] (https://setsunasoftware.com/kindler/) [comments] (https://www.reddit.com/r/programming/comments/1qrofk8/kindler_a_new_luabased_build_system_designed_to/)
https://www.reddit.com/r/programming/comments/1qrofk8/kindler_a_new_luabased_build_system_designed_to/
submitted by /u/IRIX_Raion (https://www.reddit.com/user/IRIX_Raion)
[link] (https://setsunasoftware.com/kindler/) [comments] (https://www.reddit.com/r/programming/comments/1qrofk8/kindler_a_new_luabased_build_system_designed_to/)
The Most Important Code Is The Code No One Owns
https://www.reddit.com/r/programming/comments/1qrpdkb/the_most_important_code_is_the_code_no_one_owns/
<!-- SC_OFF -->A detailed examination of orphaned dependencies, abandoned libraries, and volunteer maintainers, explaining how invisible ownership has become one of the most serious risks in the modern software supply chain. <!-- SC_ON --> submitted by /u/justok25 (https://www.reddit.com/user/justok25)
[link] (https://techyall.com/blog/the-most-important-code-is-the-code-no-one-owns) [comments] (https://www.reddit.com/r/programming/comments/1qrpdkb/the_most_important_code_is_the_code_no_one_owns/)
https://www.reddit.com/r/programming/comments/1qrpdkb/the_most_important_code_is_the_code_no_one_owns/
<!-- SC_OFF -->A detailed examination of orphaned dependencies, abandoned libraries, and volunteer maintainers, explaining how invisible ownership has become one of the most serious risks in the modern software supply chain. <!-- SC_ON --> submitted by /u/justok25 (https://www.reddit.com/user/justok25)
[link] (https://techyall.com/blog/the-most-important-code-is-the-code-no-one-owns) [comments] (https://www.reddit.com/r/programming/comments/1qrpdkb/the_most_important_code_is_the_code_no_one_owns/)
AI code review prompts initiative making progress for the Linux kernel
https://www.reddit.com/r/programming/comments/1qrqx99/ai_code_review_prompts_initiative_making_progress/
submitted by /u/Fcking_Chuck (https://www.reddit.com/user/Fcking_Chuck)
[link] (https://www.phoronix.com/news/AI-Code-Review-Prompts-Linux) [comments] (https://www.reddit.com/r/programming/comments/1qrqx99/ai_code_review_prompts_initiative_making_progress/)
https://www.reddit.com/r/programming/comments/1qrqx99/ai_code_review_prompts_initiative_making_progress/
submitted by /u/Fcking_Chuck (https://www.reddit.com/user/Fcking_Chuck)
[link] (https://www.phoronix.com/news/AI-Code-Review-Prompts-Linux) [comments] (https://www.reddit.com/r/programming/comments/1qrqx99/ai_code_review_prompts_initiative_making_progress/)
The worst programmer is your past self (and other egoless programming principles)
https://www.reddit.com/r/programming/comments/1qrxlgu/the_worst_programmer_is_your_past_self_and_other/
submitted by /u/BlunderGOAT (https://www.reddit.com/user/BlunderGOAT)
[link] (https://www.blundergoat.com/articles/egoless-programming-greatest-hits) [comments] (https://www.reddit.com/r/programming/comments/1qrxlgu/the_worst_programmer_is_your_past_self_and_other/)
https://www.reddit.com/r/programming/comments/1qrxlgu/the_worst_programmer_is_your_past_self_and_other/
submitted by /u/BlunderGOAT (https://www.reddit.com/user/BlunderGOAT)
[link] (https://www.blundergoat.com/articles/egoless-programming-greatest-hits) [comments] (https://www.reddit.com/r/programming/comments/1qrxlgu/the_worst_programmer_is_your_past_self_and_other/)
The dumbest performance fix ever
https://www.reddit.com/r/programming/comments/1qrysmp/the_dumbest_performance_fix_ever/
submitted by /u/Kyn21kx (https://www.reddit.com/user/Kyn21kx)
[link] (https://computergoblin.com/blog/the-story-of-a-5-minute-endpoint/) [comments] (https://www.reddit.com/r/programming/comments/1qrysmp/the_dumbest_performance_fix_ever/)
https://www.reddit.com/r/programming/comments/1qrysmp/the_dumbest_performance_fix_ever/
submitted by /u/Kyn21kx (https://www.reddit.com/user/Kyn21kx)
[link] (https://computergoblin.com/blog/the-story-of-a-5-minute-endpoint/) [comments] (https://www.reddit.com/r/programming/comments/1qrysmp/the_dumbest_performance_fix_ever/)
Single Entry Point Layer Is Underrated
https://www.reddit.com/r/programming/comments/1qs8t6w/single_entry_point_layer_is_underrated/
submitted by /u/Exact_Prior6299 (https://www.reddit.com/user/Exact_Prior6299)
[link] (https://medium.com/@HobokenDays/single-entry-point-layer-is-underrated-e116eab03b53) [comments] (https://www.reddit.com/r/programming/comments/1qs8t6w/single_entry_point_layer_is_underrated/)
https://www.reddit.com/r/programming/comments/1qs8t6w/single_entry_point_layer_is_underrated/
submitted by /u/Exact_Prior6299 (https://www.reddit.com/user/Exact_Prior6299)
[link] (https://medium.com/@HobokenDays/single-entry-point-layer-is-underrated-e116eab03b53) [comments] (https://www.reddit.com/r/programming/comments/1qs8t6w/single_entry_point_layer_is_underrated/)
Why I am moving away from Scala
https://www.reddit.com/r/programming/comments/1qs9rfb/why_i_am_moving_away_from_scala/
submitted by /u/simon_o (https://www.reddit.com/user/simon_o)
[link] (https://arbuh.medium.com/why-i-am-moving-away-from-scala-7a9d3dca17b9) [comments] (https://www.reddit.com/r/programming/comments/1qs9rfb/why_i_am_moving_away_from_scala/)
https://www.reddit.com/r/programming/comments/1qs9rfb/why_i_am_moving_away_from_scala/
submitted by /u/simon_o (https://www.reddit.com/user/simon_o)
[link] (https://arbuh.medium.com/why-i-am-moving-away-from-scala-7a9d3dca17b9) [comments] (https://www.reddit.com/r/programming/comments/1qs9rfb/why_i_am_moving_away_from_scala/)
Code is cheap. Show me the talk - Kailash Nadh
https://www.reddit.com/r/programming/comments/1qsakic/code_is_cheap_show_me_the_talk_kailash_nadh/
submitted by /u/Moltenlava5 (https://www.reddit.com/user/Moltenlava5)
[link] (https://nadh.in/blog/code-is-cheap/) [comments] (https://www.reddit.com/r/programming/comments/1qsakic/code_is_cheap_show_me_the_talk_kailash_nadh/)
https://www.reddit.com/r/programming/comments/1qsakic/code_is_cheap_show_me_the_talk_kailash_nadh/
submitted by /u/Moltenlava5 (https://www.reddit.com/user/Moltenlava5)
[link] (https://nadh.in/blog/code-is-cheap/) [comments] (https://www.reddit.com/r/programming/comments/1qsakic/code_is_cheap_show_me_the_talk_kailash_nadh/)
Why Bigtable scales when your PostgreSQL cluster starts screaming: A deep dive into wide-column stores
https://www.reddit.com/r/programming/comments/1qsbgpk/why_bigtable_scales_when_your_postgresql_cluster/
submitted by /u/netcommah (https://www.reddit.com/user/netcommah)
[link] (https://www.netcomlearning.com/blog/google-cloud-bigtable) [comments] (https://www.reddit.com/r/programming/comments/1qsbgpk/why_bigtable_scales_when_your_postgresql_cluster/)
https://www.reddit.com/r/programming/comments/1qsbgpk/why_bigtable_scales_when_your_postgresql_cluster/
submitted by /u/netcommah (https://www.reddit.com/user/netcommah)
[link] (https://www.netcomlearning.com/blog/google-cloud-bigtable) [comments] (https://www.reddit.com/r/programming/comments/1qsbgpk/why_bigtable_scales_when_your_postgresql_cluster/)
What breaks when you try to put tables, graphs, and vector search in one embedded engine?
https://www.reddit.com/r/programming/comments/1qsbj66/what_breaks_when_you_try_to_put_tables_graphs_and/
<!-- SC_OFF -->I’ve been working on an embedded database engine that runs in-process and supports multiple data models under one transactional system: relational tables, property graphs, and vector similarity search (HNSW-style). Trying to combine these in a single embedded engine surfaces some interesting programming and systems problems that don’t show up when each piece lives in its own service. A few of the more interesting challenges: 1) Transaction semantics vs ANN indexes
Approximate vector indexes like HNSW don’t naturally fit strict ACID semantics.
Per-transaction updates increase write amplification, rollbacks are awkward, and crash recovery becomes complicated. In practice, you have to decide how “transactional” these structures really are. 2) Storage layout tension
Tables want row or column locality.
Graphs want pointer-heavy adjacency structures.
Vectors want contiguous, cache-aligned numeric blocks. You can unify the abstraction layer, but at the physical level these models fight each other unless you introduce specialization, which erodes the “single engine” ideal. 3) Query planning across models
Cross-model queries sound elegant, but cost models don’t compose cleanly.
Graph traversals plus vector search quickly explode the planner search space, and most optimizers end up rule-based rather than cost-based. 4) Runtime embedding costs
Running a full DB engine inside a language runtime (instead of as a service) shifts problems: - startup time vs long-lived processes - memory ownership and GC interaction - crash behavior and isolation expectations Some problems get easier (latency, deployment); others get harder (debugging, failure isolation). The motivation for exploring this design is to avoid stitching together multiple storage systems for local or embedded workloads, but the complexity doesn’t disappear — it just moves. If you’ve worked on database engines, storage systems, or runtime embedding (JVM, CPython, Rust, etc.), I’d be curious: - where would you intentionally draw boundaries between models? - which parts would you relax consistency on first? - does embedded deployment change how you’d design these internals? For concrete implementation context, this exploration is being done using an embedded configuration of ArcadeDB via language bindings. I’m not benchmarking or claiming this is “the right” approach — mostly interested in the engineering trade-offs. <!-- SC_ON --> submitted by /u/Plastic_Director_480 (https://www.reddit.com/user/Plastic_Director_480)
[link] (https://github.com/humemai/arcadedb-embedded-python) [comments] (https://www.reddit.com/r/programming/comments/1qsbj66/what_breaks_when_you_try_to_put_tables_graphs_and/)
https://www.reddit.com/r/programming/comments/1qsbj66/what_breaks_when_you_try_to_put_tables_graphs_and/
<!-- SC_OFF -->I’ve been working on an embedded database engine that runs in-process and supports multiple data models under one transactional system: relational tables, property graphs, and vector similarity search (HNSW-style). Trying to combine these in a single embedded engine surfaces some interesting programming and systems problems that don’t show up when each piece lives in its own service. A few of the more interesting challenges: 1) Transaction semantics vs ANN indexes
Approximate vector indexes like HNSW don’t naturally fit strict ACID semantics.
Per-transaction updates increase write amplification, rollbacks are awkward, and crash recovery becomes complicated. In practice, you have to decide how “transactional” these structures really are. 2) Storage layout tension
Tables want row or column locality.
Graphs want pointer-heavy adjacency structures.
Vectors want contiguous, cache-aligned numeric blocks. You can unify the abstraction layer, but at the physical level these models fight each other unless you introduce specialization, which erodes the “single engine” ideal. 3) Query planning across models
Cross-model queries sound elegant, but cost models don’t compose cleanly.
Graph traversals plus vector search quickly explode the planner search space, and most optimizers end up rule-based rather than cost-based. 4) Runtime embedding costs
Running a full DB engine inside a language runtime (instead of as a service) shifts problems: - startup time vs long-lived processes - memory ownership and GC interaction - crash behavior and isolation expectations Some problems get easier (latency, deployment); others get harder (debugging, failure isolation). The motivation for exploring this design is to avoid stitching together multiple storage systems for local or embedded workloads, but the complexity doesn’t disappear — it just moves. If you’ve worked on database engines, storage systems, or runtime embedding (JVM, CPython, Rust, etc.), I’d be curious: - where would you intentionally draw boundaries between models? - which parts would you relax consistency on first? - does embedded deployment change how you’d design these internals? For concrete implementation context, this exploration is being done using an embedded configuration of ArcadeDB via language bindings. I’m not benchmarking or claiming this is “the right” approach — mostly interested in the engineering trade-offs. <!-- SC_ON --> submitted by /u/Plastic_Director_480 (https://www.reddit.com/user/Plastic_Director_480)
[link] (https://github.com/humemai/arcadedb-embedded-python) [comments] (https://www.reddit.com/r/programming/comments/1qsbj66/what_breaks_when_you_try_to_put_tables_graphs_and/)