- German COVID android app has 89 branches, 1,636 commits and 82 contributors. Last update 6 hours ago.
- Estonian app has 3 commits, 1 branch and 1 contributor. Last update 2 months ago.
Source Pets’ FB.
Just for a reminder.
Made second post. Grouping by 25 days should be good.
Writing daily posts is getting challenge on its own. Therefore I will continue as one post.
It took me around an hour to write the algorithm in Java during the exam to find the width of a tree (defined as the maximum number of children for a single node).
Now I have been wondering (trying to improve my code) why on earth are podcast and blog feeds NOT json standard but XML 😀 Much more difficult to generate and parse.
Wrote littlebit in Java for algorithms exam (on monday) and improved birthay app. Bootstrap 5 has some really nice improvements.
I have been thinking about setting up by own web server to understand (and learn) better how VPS and containers work. I belive I need to do another post for this 🙂
Cool that Thonny made it to Hacker News.
Today I have to admit I did not open IDE somehow for more than just one line of code 😀 Got stuck into analyzing the logs and cleaning one of my website’s database.
All in One SEO plugin (do not recommend!) created around 3 million garbage entries into the WP+WooCommerce database with scheduled actions (mainly by
aioseo_sitemap_ping). It is multiple times more than the whole site itself.
wp_actionscheduler_logstable had 1 973 366 entries
wp_actionscheduler_actionstable had 912 058 entries
I emphasize that these entries are just unwanted garbage and do not create any value. In order to clear it you need to enter the database (through PMA or some other way) and run
DELETE FROM table WHERE ...; SQL query. I can assure that deleting millions of entries takes some time from database engine 🙂
The only line I wrote today (except SQL queries) was
add_filter( 'aioseo_sitemap_ping', '__return_false' ); to kill the unnecessary scheduled action.
Issues with guides. When installing twig then phpStorm cried that I have old version of composer. OK,
sudo apt-get remove composer (because suggested
composer self-update does not work) and
sudo apt-get composer and the result is that I still have old one 😂 Then I followed the composer installation guide and when trying to make it global it gives me wrong path in the guide. Correct one would be /usr/bin/composer and debugging it took me quite a while.
As you can see I have been messing around with the birthday reminder app.
Listened: Matt Mullenweg: Collaboration Is Key – the founder of WordPress on Knowledge Project podcast
Discovered: “Officials are investigating whether the company, founded by three Russian engineers in the Czech Republic with research labs in Russia…” is a way to describe JetBrains in The New York Times.
As I sometimes lock myself out from Facebook I have no idea if any of my friends is having a birthday any time soon. I also already have difficulty remembering ages and birthdays of all my relatives (especially new ones). Before solving my personal CRM needs with Monica I decided to build something myself.
Today I worked on building a small web app using sqlite and php to save/edit/delete birthdays of my friends and family, calculate ages etc.
Most difficult was to figure out how to sort recurring (yearly) events starting from “next upcoming” with single SQL query. But I think I figured it out by using one SQL query followed small php loop (which has worst case complexity of O(n)) to find the place to split an array 🙂
SELECT id, firstname, lastname, birthday,
(current_date - birthday - 1) as age,
substr(birthday, 9, 100) as day,
substr(birthday, 6, 2) as month
ORDER BY month, day;
Hopefully I can get it ready enough at some point for sharing on Github. Something cool for the end: OpenAI has trained a model that can create new images – you just describe them in English. Mindblowing.
Felt myself strong and very fit before the exam. Not that strong afterwards 😀 But was fun 1h 45min rally.
Main learnings from the exam:
Found hilarious Github repo. If you are asking what C# for beginners course is in TalTech then in a nutshell: EnterpriseQualityCoding (just imagine that it is written in C# instead of Java). It is a FizzBuzz (very simple game) EnterpriseEdition (written in a complicated way).
Today I have revised for tomorrow’s exam (php, mysql, http etc). I’ll grab a cup of coffee and will end the day with an hour of AngularJS. Let’s call it a week then 🙂
Offtopic: great podcasts I listened to today (while walking) were Hidden Brain – A Creature of Habit, Business Lunch – You Don’t Have to Buy A Whole Business and there was an interesting aspect about the evolution of the importance of blogs as authentic user generated content in Stack Overflow Welcome 2021 episode.