Japheth Jerry (@Yafet_Tim) header
Japheth Jerry (@Yafet_Tim) profile picture

Tech Enthusiasm || Cybersecurity & Software Engineering || UI/UX Design

Earth
Joined June 2023
Photo by Japheth Jerry (@Yafet_Tim)Photo by Japheth Jerry (@Yafet_Tim)Photo by Japheth Jerry (@Yafet_Tim)Photo by Japheth Jerry (@Yafet_Tim)Photo by Japheth Jerry (@Yafet_Tim)Photo by Japheth Jerry (@Yafet_Tim)Photo by Japheth Jerry (@Yafet_Tim)Photo by Japheth Jerry (@Yafet_Tim)Photo by Japheth Jerry (@Yafet_Tim)Photo by Japheth Jerry (@Yafet_Tim)
Spent way too long obsessing over micro-interactions on my new portfolio. Worth every hour. yafetport.vercel.app
3
3
1
3
76
Solid baseline on SQL injection... Although telling people to just "use an ORM" and ask their agent to audit itself misses the traps vibe coded search bars actually fall into
does your vibecoded app have a search bar? ask your agent: "is user input ever put straight into a database query?" if yes, someone can type a few characters and read or delete your whole database.. fix: use parameterized queries or your ORM, never glue user text into SQL!
1
6
LLMs routinely reach for ORM escape hatches like $queryRawUnsafe, interpolate dynamic ORDER BY column names, which bind parameters can't protect, so you need strict allowlists.
1
5
No... In standard SQL's three valued logic, NULL represents an unknown state rather than a concrete value, so salary = NULL always evaluates to UNKNOWN (never TRUE) and silently returns zero rows, but salary IS NULL explicitly checks for the absence of a value...
SELECT * FROM users WHERE salary = NULL; SELECT * FROM users WHERE salary IS NULL; Are both these queries same?
1
1
Then it returns the matching records (barring legacy quirks like SQL Server's ANSI_NULLS OFF).
1
Japheth Jerry retweeted
Just default to returning 429 Too Many Requests with a 'Retry After' header right at the edge or API gateway via a token bucket rate limiter. Because failing fast sheds load cheaply without holding sockets and worker threads open.
Your API is receiving 10,000 requests per minute from one user. Would you block the user, slow down requests, or return an error?
1
1
1
12
Japheth Jerry retweeted
Nope, React is a JavaScript library for building user interfaces, while JavaScript (or TypeScript) is the actual programming language underneath.
Is React a programming language?
1
1
1
3
Nope, React is a JavaScript library for building user interfaces, while JavaScript (or TypeScript) is the actual programming language underneath.
Is React a programming language?
1
1
1
3
People often confuse it for a language because JSX blends HTML-like markup into code and then React ecosystem (hooks, Server Components, the React Compiler) feels like its own paradigm. But JSX is just syntactic sugar that compiles straight down to plain JavaScript function calls
1
2
Just default to returning 429 Too Many Requests with a 'Retry After' header right at the edge or API gateway via a token bucket rate limiter. Because failing fast sheds load cheaply without holding sockets and worker threads open.
Your API is receiving 10,000 requests per minute from one user. Would you block the user, slow down requests, or return an error?
1
1
1
12
And intentionally slowing down requests usually exhausts your own connection pool and turns a noisy user into a self-inflicted DoS.
1
1
3
Only escalate to a hard WAF block or key revocation IF they ignore the 429s or look malicious, since 10k req/min (~167 RPS) is often just a paying customer with a broken retry loop or a legitimate burst worth solving with batch endpoints and a higher tier...
1
Japheth Jerry retweeted
Grandfather's Paradox
1
1
4
Agreed!
Using AI to create logos is fine. Using AI to fake the sketches so people think you're some kind of design genius is not fine.
13
Japheth Jerry retweeted
All in favour of me building a model trained on the entirety of Stack Overflow, say aye
1
1
9
All in favour of me building a model trained on the entirety of Stack Overflow, say aye
1
1
9
Japheth Jerry retweeted
Middle school algebra in a SELECT statement 😂 The math gives $x = 7$... SQL doesn't solve equations, the query only returns 7 if 7 actually exists in the numbers table otherwise it returns an empty set, or multiple rows if there are duplicates...
Solve this SQL query without ChatGPT or running it, and you're above average. What is X?
2
1
1
20
Japheth Jerry retweeted
Node.js, and i'm not sorry... Startups overwhelmingly fail from slow iteration and empty runways long before hitting a runtime ceiling, and sharing TypeScript schemas, types, and engineers across your backend, web, and mobile apps eliminates the context-switching tax...
Which backend are you picking for your startup in 2026? 1. Node.js 2. Python 3. Go 4. Rust
2
1
1
15
Japheth Jerry retweeted
To avoid this enforce server side object level authorization on EVERY query alongside authentication. Scope every lookup directly to the verified session's user or tenant ID, such as WHERE id = :invoiceId AND user_id = :sessionUserId, and back it up with database-level (RLS)
le test que je fais dès que je tombe sur une app « vibe codée » tu te connectes avec un 2e compte tu changes l'id dans /invoices/123 si tu vois la facture de quelqu'un d'autre ton app est pas safe
1
1
1
39