Tell HN: Cast('abc' AS INTEGER) returns 0 in SQLite

2•prmph•52m ago

Every day I encounter more weirdness of SQLite. Is this the JavaScript of databases?

Comments

hans_castorp•45m ago

There is more: https://dbfiddle.uk/FDkqamR_

(Some examples there no longer work with the current version - so they are improving :) )

This is by design and well documented though.

kankalar54950•4m ago

brokkoliclouds@gmail.com hackker ban yesin porn sex içerisinde bulunuyor

kankalar54950•3m ago

brokkoliclouds@gmail.com

Tell HN: Cast('abc' AS INTEGER) returns 0 in SQLite

Tell HN: I'm working on original approaches to tag-based file organization

Claude Code's API billing depends on how often the cache expires

Ask HN: What is holding back robots from being deployed everywhere?

Ask HN: What are you working on? (November 2026)

ChatGPT Desktop forwards your SSH agent to remote machines

Ask HN: Do you still enjoy coding in C++?

Ask HN: Personal "Tears in the Rain" Moments

Any good ways on how to get into kernel dev?

Ask HN: What do your technical interviews look like today? (Nov 2026)

Ask HN: Is lack of human imagination now the bottleneck instead of intelligence?

How do you keep up quality when you vibe-code?

What are your favorite tools?

Do 9/10 new AI SaaS websites seem like they should be an editor command to you?

Ask HN: "No AI" apps/companies/resources?

Ask HN: How did you convince family and friends to join your XMPP/Matrix server?

Ask HN: Did anybody used F# in a production?

Ask HN: Software engineer with broken arm, any tips?

Ask HN: How do you evaluate the skills your AI agents use?

Ask HN: Anybody using their own AI harness as well?

Tell HN: Another GitHub Major Outage

Tell HN: A flood of reports of Opus 5.5 being nerfed

CoderPad Reports a Security Breach

Why does Reddit want me to use the iOS app on my desktop?

uBlock Origin Can't Block Facebook Ads

Superwall (iOS Paywall Provider) Hacked – customers asked to rotate keys

Tell HN: Notion AI chat sessions have been exposed via Fireworks AI hack

Ask HN: Is misaligned AI less dangerous than AI controlled by a bad actor

Tell HN: Cast('abc' AS INTEGER) returns 0 in SQLite

Comments

Tell HN: Cast('abc' AS INTEGER) returns 0 in SQLite

Tell HN: I'm working on original approaches to tag-based file organization

Claude Code's API billing depends on how often the cache expires

Ask HN: What is holding back robots from being deployed everywhere?

Ask HN: What are you working on? (November 2026)

ChatGPT Desktop forwards your SSH agent to remote machines

Ask HN: Do you still enjoy coding in C++?

Ask HN: Personal "Tears in the Rain" Moments

Any good ways on how to get into kernel dev?

Ask HN: What do your technical interviews look like today? (Nov 2026)

Ask HN: Is lack of human imagination now the bottleneck instead of intelligence?

How do you keep up quality when you vibe-code?

What are your favorite tools?

Do 9/10 new AI SaaS websites seem like they should be an editor command to you?

Ask HN: "No AI" apps/companies/resources?

Ask HN: How did you convince family and friends to join your XMPP/Matrix server?

Ask HN: Did anybody used F# in a production?

Ask HN: Software engineer with broken arm, any tips?

Ask HN: How do you evaluate the skills your AI agents use?

Ask HN: Anybody using their own AI harness as well?

Tell HN: Another GitHub Major Outage

Tell HN: A flood of reports of Opus 5.5 being nerfed

CoderPad Reports a Security Breach

Why does Reddit want me to use the iOS app on my desktop?

uBlock Origin Can't Block Facebook Ads

Superwall (iOS Paywall Provider) Hacked – customers asked to rotate keys

Tell HN: Notion AI chat sessions have been exposed via Fireworks AI hack

Ask HN: Is misaligned AI less dangerous than AI controlled by a bad actor