GitHub

Push notifications do not work (SQL syntax error)

User A sends a message to user B. User B expects push notification on the other end. User B does not receive a push notification. The same behavior (with the same ...
LinkedIn

Solving SQL Import Errors in MySQL 8.0: What I Learned from Working on a Public Holiday

Hey everyone! Even though today is a public holiday, I encountered a database issue at work. I didn’t want to waste the experience I gained from working on my day ...
GitHub

Ecto 3.13.0 generates DO UPDATE SET with no fields, leading to SQL syntax error

\*\* (Postgrex.Error) ERROR 42601 (syntax\_error) syntax error at or near "RETURNING" query: INSERT INTO "field_names" ("name") VALUES ($1) ON CONFLICT ("name") DO ...
LinkedIn

SQL Injection: Episode 2: Syntax Errors & Fundamentals

If you're interested in understanding how SQL injection works and how they can be used to uncover security flaws in web applications, you're in the right place. This walkthrough is designed to be ...