- Oracle Database – Data Types
VARCHAR2 versus CHAR and why the BYTE/CHAR length qualifier matters in UTF-8. NUMBER precision and why money never goes in a binary float. The fact that DATE includes a time, and the range comparison that follows from it. Booleans before 23ai, the empty string that is NULL, and a full mapping table to Java types.
- Rate Limiting
Four algorithms and what each one does at the boundary: fixed window and its doubling bug, sliding log, sliding window counter, and the token bucket that wins most of the time. Where the limiter belongs, how to identify a caller without handing them a way to reset their own quota, why the counter must be atomic, and the 429 contract a client can actually back off against.
- Oracle Database – Users, Schemas and Privileges
In Oracle a user is a schema, so CREATE USER is how you create a namespace. Setting up a proper application account: why a tablespace quota is not optional, what CONNECT and RESOURCE really grant, the owner/role/service-account split, three ways to stop qualifying table names, and the password expiry that locks out service accounts.
- LeetCode 33 – Search in Rotated Sorted Array
A rotated array is not sorted, so binary search should not work on it. It does, because however you cut it in half at least one half is properly sorted — and telling which is a single comparison. Why that comparison needs <= and not <, the overflow-safe midpoint, and why the duplicates variant provably degrades to O(n).
- Oracle Database – Run It Locally with Docker
Oracle Database Free in a container: the image to pull, the three environment variables that matter, how to tell when the database is genuinely ready, and why you must connect to the FREEPDB1 service rather than FREE. Includes a docker-compose file with schema init scripts, and the gotchas on Apple Silicon.