one_linerの検索結果1 - 2 件 / 2件

• あとで読む

  One-liner for running queries against CSV files with SQLite

  • 4 users
  • til.simonwillison.net
  • テクノロジー
  • 2022/06/22

  I figured out how to run a SQL query directly against a CSV file using the sqlite3 command-line utility: sqlite3 :memory: -cmd '.mode csv' -cmd '.import taxi.csv taxi' \ 'SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger_count' This uses the special :memory: filename to open an in-memory database. Then it uses two -cmd options to turn on CSV mode and import the taxi.

  • SQLite

  
• あとで読む

  Cleaning up merged git branches: a one-liner from the CIA's leaked dev docs | spencer.wtf

  • 3 users
  • spencer.wtf
  • テクノロジー
  • 2026/02/21

  Cleaning up merged git branches: a one-liner from the CIA's leaked dev docs 20 Feb 2026 In 2017, WikiLeaks published Vault7 - a large cache of CIA hacking tools and internal documents. Buried among the exploits and surveillance tools was something far more mundane: a page of internal developer documentation with git tips and tricks. Most of it is fairly standard stuff, amending commits, stashing c

  • github