Auto-aggregated global tech articles · 71 posts
Two articles ago I wrote that the Postgres role which runs your migrations bypasses every row-level security policy. Last week I wrote that with one tenant in the fixture, your isolation suite passes with no policy at all. Both came out of the same comment thread, and by the end of it we had three a
Turning Mermaid ER diagrams into shareable 3D schema tours Mermaid erDiagram is great for docs and PRs. It’s less great when the schema gets dense: boxes overlap, FK lines tangle, and “just zoom out” stops helping. I built Schema3D for that moment: open a Mermaid ER (or SQL / DrawDB) in the brows
been learning redis properly for a side project and putting together notes as I go so I actually remember this stuff. always just knew "redis is in memory so it's fast" and left it at that. turns out the part that actually matters is that it runs commands on a single thread. that's not a downside, i
Use one webhook registration, land the payload in a durable queue, and make every internal consumer acknowledge its own copy. That is the least complex design that survives a downstream outage and still answers the question an auditor asks six weeks later: which internal service read which event, un
This article is a beginner friendly guide that gets you started into learning SQL as a programming language. Introduction Relational databases store data in tabular form, often referred to as structured data. The alternative is Unrelational databases. Now SQL is simply the programming l
Not a hype list. These are the three MCP servers I have running right now in Claude Desktop. 1. Filesystem mcp-hub install @modelcontextprotocol/server-filesystem I use this to let Claude read project files directly instead of me copy-pasting code. Configure it to point at your
Hi, I just need to fill data in from sqlite running in a wasm to a table with a fixed column length while the row size should be dynamic from a delimeter hinting towards a new row. Needs to have export table feature and native sorting from clicking on the ribbon header What to use? submitted by
SQL vs NoSQL: Kenapa PostgreSQL Masih Jadi 'Swiss Army Knife' di 2026 Sering kali kita terjebak dalam perdebatan klasik antara SQL dan NoSQL. Ada anggapan bahwa jika kita butuh fleksibilitas atau skala besar, maka NoSQL adalah satu-satunya jawaban. Namun, jika kita melihat perkembangan teknologi d
I've been running multiple migrations recently. A common step in all of them is a long cleanup action at the end. I ended up using postgres advisory locks and sqlx. As part of a larger Today I've learned series, I dug a bit deeper using bpftrace to improve my understanding of how the locks actually
Hey WebDev! I work with Redis on my projects all the time, and I recently had to dig deeper - deep enough to actually dive into the project's source code This gave me the idea to create an interactive 3D map showing how Redis works and visualizing its internal structure (I’d seen similar projects fo
I haven't seen too many comprehensive approaches to this topic, so I took a swing at it. Goal isn't to be exhaustive, but to be thorough enough to help people trying to get their bearings on the topic. It covers the core differences and trade-offs of different cache flavors: In your application lay
Well I failed a amazon OA because of a rate limiting question, So I have built this rate limiter from first principles and haven't followed any tutorial. Through this blog, I want to answer questions like: Why even use Redis to make a rate limiter? Why not just use a Node.js process? What are the i
Problem Statement At lastyard.space, we treat endurance telemetry like production infrastructure: if the runner is still moving, the system must still be receiving, ordering, persisting, and replaying data. A recent live trail run entered the ingestion path with these facts: Workout: Trail Run
Most "audit logs" are append-only by convention, not by enforcement. The application inserts a row and politely promises never to UPDATE or DELETE it. That promise holds right up until the moment someone does one of these: A bug in the app calls repo.delete(id) on the wrong entity. An operator con
Nexus Core v1.7.0: Moving from MongoDB-Centric to Multi-Database Architecture Today I released Nexus Core v1.7.0, and this is one of the most important architectural changes since the project's first stable release. Nexus Core was originally designed around MongoDB as its persistence layer. That
I'm building [mongopg-migrate], a tool that migrates MongoDB collections onto an existing Postgres schema you already designed. It's alpha pip install mongopg-migrate, currently v0.2.0. This is a bug from it, the worst one I've hit so far, because every safeguard the tool has fired correctly, and th
SQL Joins, Simply Join combines rows from two tables, matched on shared column, usually an id. Example tables: customers orders customer_id | name order_id | customer_id | item 1 | Amina 101 | 1 | Bag 2 | Brian 102
Auto-fix is the most dangerous feature a linter has. Every other part of the tool only reads your code. --fix writes to it, usually across a whole repository, usually in CI, usually without anyone reading the diff. So it is worth asking a blunt question: does the fixer ever produce output the tool
PostgreSQL 19 was expected to be released in September, in keeping with the database project's longstanding tradition of a major release every year. However, some late-breaking concerns about several of the features slated for inclusion has some developers worried about the quality of the release.
I haven't seen too many comprehensive approaches to this topic, so I took a swing at it. Goal isn't to be exhaustive, but to be comprehensive enough to provide a nice overview for people trying to get their bearings with the topic. Did I miss anything? submitted by /u/compy3 [link] [留言]
1–20 / 71
![[Showoff Saturday] Redis City - 3D map of Redis internals](/storage/uploads/covers/2026/09/af3ffe48-7da1-4036-bd8e-1c0d55cd0ef7.webp)
![[$] PostgreSQL 19's "scary patch contest"](/storage/uploads/covers/2026/09/3df1de34-f41e-4e47-bafe-dd33f80d68bd.webp)
