python

When you have a Google Drive folder that’s shared publicly (set to “Anyone with the link can view”), you can access its contents programmatically using the Google Drive API. This is useful for building applications that need to display or process files from a shared drive. Prerequisites A public Google Drive folder (make sure it’s set to “Anyone with the link can view”) Google Cloud Project with the Drive API enabled API key from Google Cloud Console Setting Up First, you need to set up a Google Cloud project and enable the Drive API:...

Google Sheets provides a convenient way to share data publicly, and sometimes you may want to download this data in CSV format for processing in other applications. In this article, I’ll show you how to construct the URL to download a public Google Spreadsheet as a CSV file, and provide a Python script to automate the process. Understanding the Google Sheets CSV Export URL When you have a publicly accessible Google Sheet, you can export it as a CSV by modifying its sharing URL....

Exploring strategies for handling long-running background tasks in Django applications with reliability and efficiency.

A guide to deploying Django applications with Celery for handling background tasks efficiently.

A step-by-step tutorial on downloading video files from publicly accessible Google Drive links using Python with proper error handling and progress tracking.

A known thing - I am just posting this here as a reference Beautiful is better than ugly. Explicit is better than implicit. Simple is better than complex. Complex is better than complicated. Flat is better than nested. Sparse is better than dense. Readability counts. Special cases aren’t special enough to break the rules. Although practicality beats purity. Errors should never pass silently. Unless explicitly silenced. In the face of ambiguity, refuse the temptation to guess....

Keeping Secrets Secret in Python Based on an article by originally published by Jason Goldberger but unfortunately the original is not online anymore so I have rewritten a short version, since this is something I have been looking for a while. Fernet has one classmethod called generate_key() and two instance methods encrypt(plaintext_binary) and decrypt(cipher_binary). Step 1 : Generate a key Generate a key and save it to the OS’s environment variables:...

Problem Find all the combination of two in a team Solution 1 2 3 4 5 6 7 from itertools import combinations team = ["john", "joe", "bob", "al", "tony", "mark"] comb = combinations(team, 2) for i in list(comb): print(i) Result: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 ('john', 'joe') ('john', 'bob') ('john', 'al') ('john', 'tony') ('john', 'mark') ('joe', 'bob') ('joe', 'al') ('joe', 'tony') ('joe', 'mark') ('bob', 'al') ('bob', 'tony') ('bob', 'mark') ('al', 'tony') ('al', 'mark') ('tony', 'mark') Let’s up the game now we want to arrange the combinations results in a way that none of these guys are on call twice in a row...

Ok this is an experimental post. I realised I collect a lot of information during the week. I don’t have the time to make sense of it immediately, in a way that would be deep, and reasonate with the global zeigest… So, instead of pilling drafts on my drive, I decided to publish it as a weekly review of the stuff I collect. and will later, if time allow, get back to it....