nowfound

Dev tools · February 21, 2022

Google Drive to SQLite

Here's the repo: https://github.com/simonw/google-drive-to-sqlite The README is using a trick I'm increasingly leaning on: parts of that document - the --help output and the example database schema - are automatically generated using Cog: https://nedbatchelder.com/code/cog and https://til.simonwillison.net/python/cog-to-update-help-in-r...

Google Drive to SQLite launched on February 21, 2022 with 305 votes, #51 of 2,645 launches that month and more than 95% of that year's launches. The site was still online in September 2026, 4 years on.

In plain words

Google Drive to SQLite is a command-line tool that exports files and metadata from Google Drive into SQLite databases. It is designed for developers and data analysts who need to work with Google Drive content in a queryable database format. The tool uses Cog to automatically generate documentation including help text and database schemas.

written from the facts on this page · September 2026

From the sources

I released a new tool this week: google-drive-to-sqlite. It’s a CLI utility for fetching metadata about files in your Google Drive and writing them to a local SQLite database. It’s …

Does a similar job

all alternatives →
  • Mongita is to MongoDB as SQLite is to SQL2021 · github.com · ▲126

    "Mongita is to MongoDB as SQLite is to SQL". Contribute to scottrogowski/mongita development by creating an account on GitHub.

  • Drive Explorer2020 · workspace.google.com · ▲107

    Export your Google Drive files 🗂️to Google Sheet 📗

  • My Go SQLite driver did poorly on a benchmark, so I fixed it2023 · github.com · ▲234

    https://github.com/ncruces/go-sqlite3 was doing poorly on this benchmark that was posted yesterday to HackerNews [1]. With the help of some pprof, I was able to trace it to a serious performance regression introduced two weeks ago, and come up with the fix (happy to field questions, if you're interested in the nitty gritty). It's not the fastest driver around, but it's no longer the slowest: comfortably middle of the pack. It's based on a WASM build of SQLite, and thanks to https://wazero.io doesn't need CGO. [1]:…

  • SQ
    SQLite query inside a Bash function2021 · ▲134

    Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES&#x2F;_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…

  • Drive – a tiny program to pull or push Google Drive files2015 · github.com · ▲69

    Google Drive client for the commandline. Contribute to odeke-em/drive development by creating an account on GitHub.

  • Overdrive2017 · overdrive.io · ▲88

    Make workspaces and sites automatically from Google Drive

More dev tools this month

the category →
  • /dev/null▲468

    a social network for devs

    Dev tools · 2d ago · dev-null.sh

  • open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

    Dev tools · 27d ago · github.com

  • Contribute to reladraw/reladraw development by creating an account on GitHub.

    Dev tools · 25d ago · github.com

  • OpenBot▲362

    Grok Bot alternative: free, local, open-source, multiplayer

    Dev tools · 22d ago · openbot.run

  • Talanoa▲340

    Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

    Dev tools · 20d ago · talanoa.email

  • CoreSpeed▲332

    One MCP for everything your agents need: apps, memory, tools

    Dev tools · 27d ago · corespeed.io

Source: Show HN post ↗

Launched alongside, February 2022

the whole month →
  • Bardeen▲1,286

    One-click automations for your repetitive tasks

    Growth · 2022 · bardeen.ai

  • Sha256 algorithm explained online step by step visually

    Life & fun · 2022 · sha256algorithm.com

  • Today, after years of research, development, and refinement EdgeDB graduates to a production-ready database. We are very proud to announce EdgeDB 1.0.

    Dev tools · 2022 · edgedb.com

  • Medusa▲893

    The open-source Shopify alternative

    Dev tools · 2022 · medusajs.com

  • Trusted ways to help Ukraine stop Russian aggression

    Life & fun · 2022

  • 100 ideas for your startup's first 100 users

    Growth · 2022 · first100users.com