Posts by mucio@mastodon.social
 (DIR) Post #ASWgnHO5kArjqW9R6e by mucio@mastodon.social
       2023-02-10T05:10:04Z
       
       0 likes, 0 repeats
       
       @simon my quick comments, can you rename cte to something that explains what that query is doing? Maybe repos_with_ranked_rel. Who will maintain this query will appreciate it. Also, the left join, do you expect repos without releases? Or the repo creation isalready a release and so the join can be an inner?Apologies in advance, if you didn't need these advices
       
 (DIR) Post #ASWi8TEWzq0mcXLdJY by mucio@mastodon.social
       2023-02-10T05:25:05Z
       
       0 likes, 0 repeats
       
       @simon sorry, just read the article. I see the repos without releases are mentioned there.If I were to performance tuning this query I would do the release ranking, json object build, and filter only top 3 in a separated cte before joining with repos (assuming all releases belong to a repo). This could also avoid using filter for the json array. I will try yo test it later today
       
 (DIR) Post #AUU7nF7bMLPFcAnkmG by mucio@mastodon.social
       2023-04-09T19:12:35Z
       
       0 likes, 0 repeats
       
       @simon I had a t68i with the attached external camera. It was possible to send images via MMS. Then I bought a P800 and the first Xperia. I just liked tech gadgets (I had also a cheap Bluetooth headset) and I had a job to buy them. Similarly a few yeara before I bought a laptop. I didn't really taught about what will be the future, I just assumed it will happen (like for personal computer, internet, or mobile phones). Looking back it happened, faster than home computers