Added some loading animations
Fixed a bug in language detection
Freshly introduced, already found a bug. When retrieving the summary of a blog post in the RSS feed, I am getting HTML. I already stripped the tags. But I didn't decode HTML entities. With chinese characters, pretty much everything is an escaped HTML entity and that was recognized as English. So I added HTML entity decoding, too. Language detection works better now!
Detected the language of the 200 blog posts that were already in the database
Wrote a tiny migration script with Supabase + Google Cloud Client in Node
Automatically detect blog post language
This allows only showing English blog posts by default, otherwise other language will be mixed in. Using Google Cloud Translation API. Quick, reliable and cheap (for me at least), will unlikely exceed the free quota, if so, it'll only be a few cents.
Give feedback to designer for logo
Read at least 10 pages (Breaking the Habit of Being Yourself)
Publish a new blog post
New part of the Inside Agile Product Development Series
Deadlines
https://kevcodez.de/inside-agile-product-development-series/13-deadlines/
Deadlines
https://kevcodez.de/inside-agile-product-development-series/13-deadlines/
Schedule tweets for the next 7 days
Freeletics/Bodyweight workout
Interview for an additional client
I am already booked out up to 40 hours per week with my first client, but the product and founder was too interesting not to reach out. I offered to do 4-6 hours per week (I'll either cut the hours at the other client or do that on top, as a freelancer I can decide that on my own 🚀)
Read at least 10 pages (Breaking the Habit of Being Yourself)
Added sorting for popular tweets
Heavily using JSONB in the Supabase Postgres database. Unfortunately, using a function for sorting does not work in the Supabase JS Client.
I.e. my JSONB column is named info and it has a field createdAt
{"created": "2020-05-05T10:00:15.000Z", "other": "prop"}
With plain SQL, you could do ORDER BY (info->>'createdAt')::TIMESTAMPTZ. That doesn't work via JS client so I introduced a separate field.
I.e. my JSONB column is named info and it has a field createdAt
{"created": "2020-05-05T10:00:15.000Z", "other": "prop"}
With plain SQL, you could do ORDER BY (info->>'createdAt')::TIMESTAMPTZ. That doesn't work via JS client so I introduced a separate field.
Finished the Kotlin topic
Just had to add a book and a few courses
Integrated Bugsnag for error reporting in Firebase
Read at least 10 pages (Breaking the Habit of Being Yourself)
Call realtor to see if flat is still available (investment property)
Published yesterday, flat is almost sold, no chance to get it unfortunately
Fixed a few UI quirks and completed the Vite topic for now
There's no podcasts, newsletters, books or courses. Not many RSS feeds to parse blog posts yet. Not too many communities (not necessarily a bad thing). It's also a pretty fresh technology.
Display popular tweets
Finished scraping popular tweets yesterday. Added a Firebase function to return a list of tweets for a topic (requerying the Twitter API to get latest information) based on the tweets I marked as popular earlier. Allows me to also include caching when it's needed in the future and avoid any API rate limits.
