3+ hour, 16+ min ago  (292+ words) Static methods for quickly creating JOOQ Table and Field objects, plus Map-to-Field conversion utilities. 1. T() " Create Table public static Table T(String. .. qualified Name) example: T("user_table") or T("schema", "user_table") 2. F() " Create Field public static Field F(String. .. qualified Name) public…...

6+ hour, 51+ min ago  (704+ words) Your team just shipped "offline mode" for your field-service app. Technicians work in basements, tunnels, plant floors " connectivity is unreliable. The demo looked great. Navigator. on Line said false, the app kept working, the sync button pulsed green. You shipped…...

8+ hour, 11+ min ago  (470+ words) I've hit walls with traditional SQL databases while building web applications. Evolving schemas become nightmarish migration scripts, and unstructured data doesn't fit neatly into rows and columns. That's where No SQL databases come in - they don't replace SQL but solve…...

8+ hour, 18+ min ago  (1462+ words) In the previous post, I wrote about RESP " the protocol layer that lets a Redis server understand commands coming over TCP. But parsing a command is only the first step. Once the server receives something like: and the RESP parser…...

8+ hour, 21+ min ago  (502+ words) I've seen databases that fall apart the moment you try to update something. Duplicate data everywhere. Change customer name in one place and three other places still have the old value. This is what happens when databases aren't normalized. Database…...

10+ hour, 54+ min ago  (1245+ words) What I thought was a scheduling problem turned out to be a portability problem first In my last article, I mentioned that scheduling is the next wall I'll be walking toward. So I guess, here I am, walking towards it…...

9+ hour, 13+ min ago  (348+ words) Localization is invisible. Nobody opens an app and thinks "wow, great translation infrastructure." They only notice when a button is cut off, a date is wrong, or half the menu is suddenly in English again. It's unglamorous work that quietly…...

9+ hour, 41+ min ago  (416+ words) For a long time, our default answer to "how should we structure tenant data?" was Schema-Per-Tenant. And that wasn't really because the other options were bad, but one had a cost problem that was hard to argue around. Database-Per-Tenant gives…...

13+ hour, 27+ min ago  (668+ words) Before migrating a distributed database to the cloud, do not start with node count or capacity sizing. Start with the failure model. Decide replication strategy first, then consistency level, then network topology, and only then capacity. A safe migration also…...

10+ hour, 39+ min ago  (312+ words) This article starts from real slow queries and explains how to read execution plans with EXPLAIN, use materialized views correctly, when to apply CTEs, and several high'frequency query tuning tips in a gbase database. The EXPLAIN output in GBase 8a is…...