Home Newsletter LinkedIn Github YouTube Channel Instagram X

Querying CSV files using SQL

Categories

  • Programming

Tags

  • csv
  • sql
  • sqllite

The Change Log podcast mentioned the ability to query CSV files with SQL as if they are tables. I searched and found a post from Simon Willison: One-liner for running queries against CSV files with SQLite. Great tool to have in the back pocket.

Recent Posts

  • My Hong Kong Office Before my flight
  • 24-hour Cursor Singapore hackathon weekend
  • Importing Solarized Theme for Mac OS Terminal
  • Identifying All Network Devices on your Local Network
  • Interview of Brent Deverman on CCTV4 half hour Chinese television program

Categories

  • apple
  • artificial intelligence
  • audio
  • b2b
  • business
  • china
  • content
  • Decentralized Finance
  • Dinner
  • ecommerce
  • editor
  • email
  • events
  • Fintech
  • food
  • Generative AI
  • History
  • Hong Kong
  • lunch
  • mac os x
  • managment
  • Music
  • networking
  • outdoors
  • Photography
  • Podcast
  • Product Management
  • Productivity
  • Programming
  • server administration
  • singapore
  • software development
  • travel
  • trends
  • Uncategorized
  • video