Sign in

SQL

SQL in practice: writing queries, avoiding N+1 problems and keeping user input out of your SQL.

2 articles
RSS

PHP API Performance: N+1 Queries, cURL, and Connection Pools

Web Development

PHP API Performance: N+1 Queries, cURL, and Connection Pools

A PHP API case study: fixing an N+1 query, twenty serial cURL calls, missing connection pooling, and stats recalculated on every request with Redis caching.

What is SQL Injection? The Attack That's Been Destroying Databases Since 1998

What is SQL Injection? The Attack That's Been Destroying Databases Since 1998

In 2008, attackers used SQL injection to breach Heartland Payment Systems, a payment processing company. They stole 130 million credit and debit card numbers. The breach cost Heartland