Skip to main content

ScourDiscover Docs

Discover About Docs Changelog

You are offline. Trying to reconnect...

Copied to clipboard

Unable to share or copy to clipboard

Back to article

Evan Schwartz37w37 weeks ago

Subtleties of SQLite Indexes (opens in new tab)

Discussed on Hacker News, Lobsters, and r/programming

|

|

Feeds

Evan Schwartz emschwartz.me

Hi 👋, I'm Evan Schwartz. I'm an ideas person, inventor, and software engineer (Rust/Typescript).

Scour - May Update2w2 weeks ago

April Update7w7 weeks ago

Your Clippy Config Should Be Stricter7w7 weeks ago

Awesome Dev News awesome-dev.news

I Made a Website Where You Can Create AI Videos from Text18w18 weeks ago

Hello World: Algorithmic Trading & DeFi Logic18w18 weeks ago

Show HN: LocalGPT – A local-first AI assistant in Rust with persistent memory18w18 weeks ago

Blaggregator blaggregator.recurse.com

Tech Interviews Are Broken: Here’s How to Fix Them in the Age of AI20w20 weeks ago

An anecdote about backward compatibility20w20 weeks ago

GraphQLConf CFP is Open20w20 weeks ago

feedle | sqlite feedle.world

OpenAPI, ORM, SVG and Lottie3d3 days ago

Hylke Bons: Bobby joins GNOME Circle4d4 days ago

Clojure Deref (Jun 16, 2026)5d5 days ago

+3 more in the past month

Lobsters: databases - Databases (SQL, NoSQL) lobste.rs

Ten years of ClickHouse in open source1d1 day ago

A Wake-Up Call for Kernel-Bypass on Modern Hardware1d1 day ago

Building high-performance full-text search for object storage1d1 day ago

+7 more in the past week

top scoring links : programming reddit.com

OOP is just Named FP4d4 days ago

Frontend Minimalism in Action: Do More With Less JavaScript | Peter Kröner | webinale Berlin 20264d4 days ago

Christopher Winslett: British Columbia, Time Zones, and Postgres4d4 days ago

+17 more in the past week

programming reddit.com

Is it the end of REST, gRPC, Thrift, SignalR and GraalVM?3d3 days ago

Designing TikTok: From a Feed That Scores Everything to a Two-Stage Engine3d3 days ago

OpenAI joins The Rust Foundation as a Platinun member and donates funds to support Rust maintenance3d3 days ago

+18 more in the past week

Hacker News: Newest hnrss.org

cssQuake18h18 hours ago

I Stored a Website in a Favicon23h23 hours ago

‘A man of great appetites’: what’s it like to be a dictator’s personal chef?1d1 day ago

+87 more in the past week

Hacker News: Newest hnrss.org

Finland's libraries are increasingly being valued not by how many books they lend, but how they help societies function6h6 hours ago

Turns Out, There Is a Cabal of Elite Crazies Trying to Control the World6h6 hours ago

Pre-2022 Books6h6 hours ago

+8 more in the past day

Lobsters lobste.rs

SOCKMAP - TCP splicing of the future3h3 hours ago

Volunteer Responsibility Amnesty Day4h4 hours ago

Ansel: The Better Future for Darktable5h5 hours ago

+15 more in the past day

Hacker News: Front Page hnrss.org

Encryption, spyware, and now Mythos: History shows why cyber export control doesn’t work15h15 hours ago

Lithuanian startup launches open-source network to detect Shahed-type drones17h17 hours ago

16-year-old SATA II SSD survives 1 petabyte of writes — 25x more than the drive's endurance rating17h17 hours ago

+2 more in the past day

Lobsters: Newest Stories lobste.rs

SOCKMAP - TCP splicing of the future3h3 hours ago

Volunteer Responsibility Amnesty Day4h4 hours ago

Ansel: The Better Future for Darktable5h5 hours ago

+17 more in the past day

Pinboard (popular bookmarks) feeds.pinboard.in

Advanced Compilers: The Self-Guided Online Course6h6 hours ago

Norway imposes near ban on AI in elementary school7h7 hours ago

Use iPhone more comfortably while riding in a vehicle16h16 hours ago

+31 more in the past day

Hacker News: Front Page hnrss.org

Your brain was never designed for this much bad news1h1 hour ago

Developers don't understand CORS (2019)3h3 hours ago

EXCLUSIVE: White House delays release of US voting machine study as midterms near3h3 hours ago

+34 more in the past day

Hacker News news.ycombinator.com

Links for the intellectually curious, ranked by readers.

Your brain was never designed for this much bad news1h1 hour ago

Armstrong Effect1h1 hour ago

Developers don't understand CORS (2019)3h3 hours ago

+41 more in the past day

progscrape progscrape.com

Massive bonuses for South Korea's chip workers puts central bank on inflation alert3h3 hours ago

SOCKMAP - TCP splicing of the future3h3 hours ago

Volunteer Responsibility Amnesty Day4h4 hours ago

+59 more in the past day

Hacker News: Newest hnrss.org

Your brain was never designed for this much bad news1h1 hour ago

Greece’s Parthenon gets a facelift, revealing a look not seen for 220 years1h1 hour ago

palmier-io/palmier-pro1h1 hour ago

+59 more in the past day

Hacker News: Newest hnrss.org

Your brain was never designed for this much bad news1h1 hour ago

Greece’s Parthenon gets a facelift, revealing a look not seen for 220 years1h1 hour ago

Ask HN: Is Claude Code with Fable 5 worth switching back from Codex?1h1 hour ago

+141 more in the past day

Hacker News: Newest hnrss.org

Building Reliable Agentic AI Systems36m36 minutes ago

I'm tired of there not being a middle ground, so I build things myself59m59 minutes ago

SafeRE: Building a production-quality regex library with agents1h1 hour ago

+252 more in the past day

Hacker News: Newest hnrss.org

Is anyone still using Emacs?23m23 minutes ago

Show HN: Moduna –- Mixpanel for AI Agents46m46 minutes ago

Your brain was never designed for this much bad news1h1 hour ago

+377 more in the past day

Jullang's Likes on Scour scour.ing

ZFS Performance Tuning in the Real World: ARC, L2ARC, and SLOG37w37 weeks ago

Subtleties of SQLite Indexes37w37 weeks ago

100% All Achievements37w37 weeks ago

NemoNowhere's Likes on Scour scour.ing

Subtleties of SQLite Indexes37w37 weeks ago

_V_'s Likes on Scour scour.ing

Subtleties of SQLite Indexes37w37 weeks ago

cd1415's Likes on Scour scour.ing

Looking Beyond Collective Blogging36w36 weeks ago

Helping Students Find a Study Space through Iterative Research and Design37w37 weeks ago

In Praise of RSS and Controlled Feeds of Information37w37 weeks ago

devalexwhite's Likes on Scour scour.ing

Searching the indieweb: How to find real people, real projects, real writing in a sea of AI slop28w28 weeks ago

Subtleties of SQLite Indexes37w37 weeks ago

ditch's Likes on Scour scour.ing

Kaitai Struct: declarative binary format parsing language35w35 weeks ago

Compiling static Nmap binary for jobs in restricted environments35w35 weeks ago

A new breed of analyzers36w36 weeks ago

gaol1147's Likes on Scour scour.ing

Subtleties of SQLite Indexes37w37 weeks ago

linhns's Likes on Scour scour.ing

On the Changing Role of Software Engineers1w1 week ago

Intelligence Per Dollar2w2 weeks ago

I Am Retiring from Tech to Live Offline3w3 weeks ago

+3 more in the past month

samhza's Likes on Scour scour.ing

Subtleties of SQLite Indexes37w37 weeks ago

shy.crab5411's Likes on Scour scour.ing

What is random generation?6w6 weeks ago

A data model for Git (and other docs updates)23w23 weeks ago

A Tale Of Four Fuzzers29w29 weeks ago

slower_loris's Likes on Scour scour.ing

Running Out of Disk Space on Launch11w11 weeks ago

CSS or BS?11w11 weeks ago

Release Nvim 0.12.011w11 weeks ago

tameness8912's Likes on Scour scour.ing

Subtleties of SQLite Indexes37w37 weeks ago

emschwartz's Likes on Scour scour.ing

Researchers used math to crack Wordle6h6 hours ago

Magnitude: A coding agent that runs on open models11h11 hours ago

Cargo-Geiger14h14 hours ago

+1 more in the past day

Keyboard Shortcuts

Navigation

Next / previous post: j/k
Open post: oorEnter
Preview post: v

Post Actions

Love post: a
Like post: l
Dislike post: d
Undo reaction: u
Save / unsave: s

Recommendations

Add interest / feed: Enter
Not interested: x

Go to

Home: gh
Interests: gi
Feeds: gf
Likes: gl
History: gy
Changelog: gc
Settings: gs
Discover: gb
Search: /

Pagination

Next page: n
Previous page: p

General

Show this help: ?
Submit feedback: !
Close modal / unfocus: Esc

Press ? anytime to show this help

Docs Blog (opens in new tab)Changelog Roadmap (opens in new tab)