Tell HN: SQLite's lower() only lowercases ASCII letters

Hacker News•Sat, Oct 31, 2026, 04:30 PM•2 min read

Remember this the next time someone suggests that SQLite is almost as good as (or even, cough, better than) PostgreSQL for production use. I was bit by this today while busily engaged in some related work on my web app project. What the heck?!

Source: [Hacker News](https://news.ycombinator.com/item?id=50317601)

📰 Read Full Story

This is an aggregated headline summary. For the complete report, visit the original publisher.

Continue Reading at Hacker News ↗

#tech #sqlite #tell #lower #lowercases #ascii #letters #remember #next

More Headlines

TechnologyHacker News• 5m ago

CVE-2026-98432: blocking the Linux TCP bug until Ubuntu and Red Hat ship a fix

2 points, 0 comments on Hacker News

TechnologyHacker News• 5m ago

Remote Imaging Protocol (RIP)

1 points, 0 comments on Hacker News

TechnologyDev.to• 5m ago

DEAD AIR: I Built a Haunted System That Won’t Acknowledge Goodbye

This is a submission for the Hacktoberfest Open-Source AI Challenge Week 4: Ghost in the Machine . What I Built I restart the worker. The message arrives again.

TechnologyHacker News• 6m ago

Wrangler – Open-Source macOS Window Manager (Swift, Grid HUD, Auto-Tiling)

1 points, 0 comments on Hacker News

TechnologyDev.to• 6m ago

Overcoding is a second articulation — Deleuze and Guattari on folding sediment into structure, and a plant whose rows never settle

Before the book talks about faces, it talks about rock. In "10,000 B. C.

TechnologyDev.to• 6m ago

Simplificando la extracción de datos de licitaciones europeas (TED): Un enfoque práctico

Trabajar con datos de contratación pública europea a través de la plataforma TED (Tenders Electronic Daily) es fundamental para muchos proyectos cívicos y empresariales. Sin embargo, quienes han lidiado con la API oficial o los volcados masivos de datos saben que la curva de aprendizaje puede se...