R1D3 Learning More Python Lists and Exploring the Wordpress API
For Day 3 I continued to work more on my old_posts python script. My favorite part of 100 Days of Code is that I am taking the time to actually think through some of these problems, read documentation, and try to learn something.
Python Lists
Learned a ton about python lists thanks to this wonderful google developer guide. Specifically (after writing python for about 5 years) I learned aboutlist.extend()
for the very first time. Came in handy in this particular use case because I was doing some very inefficient for loops
to append
to a list when it was more efficient to extend
since it requires less operations.
The key differnce is that append will add a single to the end of a list, where extend will inject a list to the end of a list merging the two lists. This is particularly handy when you want to grab JSON from several requests and merge them together into a single JSON object for further processing which is what I am doing in this script.
Using Requests HEAD
I also explored more of the requests library and made an optimization that looks really silly in hindsight.In the script I was making a single request in order to grab the headers to see the total number of pages. Instea of using request.head
which has a tiny payload of headers, I was using request.get
which gets the headers along with the entire JSON payload. This was immediately thrown away since I did not use the response in later parts of the function.
Exploring the Wordpress API Filters
I also explored more of the WordPress API and started to use some API level filters to reduce the payload that I was receiving in an effort to reduce the overall time that the script takes to run. Specifically I am now usingcontext=embed
which removes the text body (since I only need the title and the link), and before=(today - 1 year + 1 day)
since I only care about posts that were written more than a year ago today.
JSON is Not SQL
I’ve been thinking about my very first forray into any sort of programming years ago. I primarily worked with Microsoft SQL Server and learned how to write efficient queries. I was thinking of how easy this problem would have been to solve if I had direct access to the database. The lesson here, that it is still taking me a while to fully wrap my head around, is that JSON is not a SQL database. You have to think about it differently. If an API offers the ability to do some filtering you should take advantage of it when you can.Thank you for reading! Share your thoughts with me on bluesky, mastodon, or via email.
Check out some more stuff to read down below.
Most popular posts this month
- 2024
- Reinstalling Windows at 1am
- SQLite DB Migrations with PRAGMA user_version
- My Custom Miniflux CSS Theme
- How to Disable Wayland in Debian Testing
Recent Favorite Blog Posts
This is a collection of the last 8 posts that I bookmarked.
- workflows for ai coding from /* 🤖🛠️ */
- Reinvent the Wheel from Matthias Endler
- CAPTCHAs are over (in ticketing) from pretix – behind the scenes
- You Can Choose Tools That Make You Happy from Fernando Borretti
- Using Git as S3 from Kris Tun
- Future Fonts from Blog – Brad Frost
- 21st Century C++ from Communications of the ACM
- Submarines DevCon 2025 Keynote Speech from JoshHaines.com
Articles from blogs I follow around the net
Tradeoffs to Continuous Software?
I came across this post from the tech collective crftd. about how software is in a process of “continuous disintegration”: One of the uncomfortable truths we sometimes have to break to people is that software isn't just never “done”. Worse even, it rot…
via Jim Nielsen’s Blog May 28, 2025Pluralistic: America is a scam (28 May 2025)
Today's links America is a scam: Welcome to the age of cheating. Hey look at this: Delights to delectate. Object permanence: 2010, 2015, 2020 Upcoming appearances: Where to find me. Recent appearances: Where I've been. Latest books: You keep readi…
via Pluralistic: Daily links from Cory Doctorow May 28, 2025How I taught my 3-year-old to read like a 9-year-old
Tripling reading level through tutoring
via The Intrinsic Perspective May 28, 2025Generated by openring