TOtosh·Feb 25, 2022Submission
Google OAuth: OOB auth flow is scheduled for deprecation
2 points · Open discussionsimonw
google-drive-to-sqlite
Python2022–2022
simonw / google-drive-to-sqlite
google-drive-to-sqlite
Create a SQLite database containing metadata from Google Drive
4Distinct people
5Mentions
0Explicit recommenders
164GitHub stars
What to know before exploring
What it is
Create a SQLite database containing metadata from Google Drive
GitHub
Where it is used
No documented product use has been verified yet.
What people are saying
No recommendation phrase was found in the indexed comments.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
No other repository is repeatedly linked in the same discussions.
This week on Hacker News
Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 1:49:46 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by 6-hour interval5 dated mentions
Observed mentions: 2022-02-21 08:41:04 UTC to 2022-02-25 18:31:22 UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| Feb 21, 06:00 | 2022-02-21 06:00:00 UTC | 2022-02-21 12:00:00 UTC | 1 | 1 | 0 |
| Feb 21, 12:00 | 2022-02-21 12:00:00 UTC | 2022-02-21 18:00:00 UTC | 3 | 1 | 2 |
| Feb 21, 18:00 | 2022-02-21 18:00:00 UTC | 2022-02-22 00:00:00 UTC | 0 | 0 | 0 |
| Feb 22, 00:00 | 2022-02-22 00:00:00 UTC | 2022-02-22 06:00:00 UTC | 0 | 0 | 0 |
| Feb 22, 06:00 | 2022-02-22 06:00:00 UTC | 2022-02-22 12:00:00 UTC | 0 | 0 | 0 |
| Feb 22, 12:00 | 2022-02-22 12:00:00 UTC | 2022-02-22 18:00:00 UTC | 0 | 0 | 0 |
| Feb 22, 18:00 | 2022-02-22 18:00:00 UTC | 2022-02-23 00:00:00 UTC | 0 | 0 | 0 |
| Feb 23, 00:00 | 2022-02-23 00:00:00 UTC | 2022-02-23 06:00:00 UTC | 0 | 0 | 0 |
| Feb 23, 06:00 | 2022-02-23 06:00:00 UTC | 2022-02-23 12:00:00 UTC | 0 | 0 | 0 |
| Feb 23, 12:00 | 2022-02-23 12:00:00 UTC | 2022-02-23 18:00:00 UTC | 0 | 0 | 0 |
| Feb 23, 18:00 | 2022-02-23 18:00:00 UTC | 2022-02-24 00:00:00 UTC | 0 | 0 | 0 |
| Feb 24, 00:00 | 2022-02-24 00:00:00 UTC | 2022-02-24 06:00:00 UTC | 0 | 0 | 0 |
| Feb 24, 06:00 | 2022-02-24 06:00:00 UTC | 2022-02-24 12:00:00 UTC | 0 | 0 | 0 |
| Feb 24, 12:00 | 2022-02-24 12:00:00 UTC | 2022-02-24 18:00:00 UTC | 0 | 0 | 0 |
| Feb 24, 18:00 | 2022-02-24 18:00:00 UTC | 2022-02-25 00:00:00 UTC | 0 | 0 | 0 |
| Feb 25, 00:00 | 2022-02-25 00:00:00 UTC | 2022-02-25 06:00:00 UTC | 0 | 0 | 0 |
| Feb 25, 06:00 | 2022-02-25 06:00:00 UTC | 2022-02-25 12:00:00 UTC | 0 | 0 | 0 |
| Feb 25, 12:00 | 2022-02-25 12:00:00 UTC | 2022-02-25 18:00:00 UTC | 0 | 0 | 0 |
| Feb 25, 18:00 | 2022-02-25 18:00:00 UTC | 2022-02-26 00:00:00 UTC | 1 | 1 | 0 |
What Hacker News says
5 sourcesI'm collecting notes on how to address this here: https://github.com/simonw/google-drive-to-sqlite/issues/39
It looks like the localhost redirects are being disabled for "iOS, Android and Chrome app OAuth client types" so hopefully I can still use those by spinning up a localhost web server after all.
In Show HN: Google Drive to SQLiteWe discovered (in rclone) that Google are deprecating the auth method you are using - the OOB auth here: https://github.com/simonw/google-drive-to-sqlite/blob/121509...
Here is the google page: https://developers.googleblog.com/2022/02/making-oauth-flows...
Here is the discussion on the rclone issue - there are links to more stuff there: https://github.com/rclone/rclone/issues/6000
Luckily rclone already implements the oauth webserver for other backends, but for tools like this it has suddenly made authenticating with Google a whole lot harder.
In Show HN: Google Drive to SQLiteShow HN: 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...
305 points · Open discussion