drupteg

#Web architect ,Web application #programmer, #Drupal #developer and #OpenSources Geek

[@wolfz.bsky.social @the_real_fago]

After many months of development, it's finally ready!
Hello https://t.co/H7f9xuPCXO! 👋🚀

https://t.co/izhUEJ1O3Z

[nunomaduro @enunomaduro]

PHP devs, if you haven’t tried @phpstan yet, you’re missing out. Think of it as TypeScript for PHP—super handy. I just published a video explaining why you need it in your workflow!

(video bellow)

[drupteg @drupteg]

@Boulanger Bonjour, j’ai acheté un four chez vous le 15/07/2025. Depuis, il est hors service malgré 6 interventions techniques en 2 mois. SAV inefficace : je suis sans four et toujours relancé pour pièces. Puis-je espérer un remboursement rapide?Merci. #Réclamation #ServiceClient

[Steve Tenuto @steve_tenuto]

We served over 15 terabytes of 4K video last month–and paid just $2.18 for it! 💸

Here’s how we do it (including the script we use): ⬇️

[Dries Buytaert @Dries]

Last week, I delivered my State of Drupal keynote at DrupalCon Europe. I demoed 17 key innovations in Drupal Starshot, including AI for site building, the experience builder, recipes, and more. Watch the demo at https://t.co/bMUOyOjNK2! #DrupalCon #Drupal

[drupteg @drupteg]

If you want to use the single file components You need to listen to this episode: Single File Components and Static Drupal Websites with @drupalsam

https://t.co/L9cYBfKUv9

[GitHub @github]

nobody will remember:
- your salary
- how “busy you were”
- how many hours you worked

people will remember:
- that PR with 14,276 changes
- the time you force pushed to main

[Drupal @drupal]

Drupal 11 has arrived and continues enhancing the strengths of #Drupal.

Learn more + get started now: https://t.co/oDFe4q7CYq

[Cristiano Giardina @CrisGiardina]

ChatGPT Advanced Voice Mode counting as fast as it can to 10, then to 50 (this blew my mind - it stopped to catch its breath like a human would)

[@levelsio @levelsio]

✨ Photo AI is now 2x to 3x faster at generating images because of speed up hack by @philz1337x and @anotherjesse (at @Replicate) which downloads AI model weights files in parallel instead of sync

Before it took 70 seconds to download a 4GB file

Now it takes 4 seconds

The worst was that those 70 seconds ran on the GPU so that cost me GPU time which was about $12,000/month without even using the GPU

Now avg gen time of 40-50 seconds for one image at high resolution

[Thijs Feryn @ThijsFeryn]

Thanks to everyone who attended my @varnishcache for #kubernetes talk at @k8sug #singapore 🇸🇬 tonight.

I promised to share the slides, so here they are: https://t.co/WPC0ZDiGrs

[Dr Milan Milanović @milan_milanovic]

𝗟𝗲𝗮𝗿𝗻 𝗳𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀 𝗻𝗼𝘁 𝗳𝗿𝗮𝗺𝗲𝘄𝗼𝗿𝗸𝘀

We, as developers, like to learn new stuff and try it ASAP. That stuff consists mainly of new frameworks and tools (such as React, Angular, Spring, Web Forms, etc.). Yet, those frameworks usually have 𝗮 𝘀𝗵𝗼𝗿𝘁 𝗹𝗶𝗳𝗲, 𝟮 𝘁𝗼 𝟱 𝘆𝗲𝗮𝗿𝘀 𝗮𝘁 𝘁𝗵𝗲𝗶𝗿 𝗯𝗲𝘀𝘁. Instead of learning frameworks, which are needed to some extent, we should focus more on learning fundamentals.

𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝘁𝗵𝗲 𝗳𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀 𝗼𝗳 𝘀𝗼𝗳𝘁𝘄𝗮𝗿𝗲 𝗱𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 allows a developer to understand the underlying principles and concepts common across different frameworks and programming languages. This understanding allows for more flexibility and adaptability when working with new technologies or facing problems that a specific framework may not quickly solve.

Additionally, a strong understanding of the fundamentals can lead to 𝗺𝗼𝗿𝗲 𝗲𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝘁 𝗮𝗻𝗱 𝗲𝗳𝗳𝗲𝗰𝘁𝗶𝘃𝗲 𝘂𝘀𝗲 𝗼𝗳 𝗳𝗿𝗮𝗺𝗲𝘄𝗼𝗿𝗸𝘀, as the developer can better understand how to customize and extend them to meet specific needs.

Take an example of a web application that allows users to upload and share images, e.g., Ruby on Rails, and its functionalities for image processing. If the number of users increases, we could struggle with performance issues if we know only the framework well. Yet, if we understand the fundamentals of web development, we could identify bottlenecks and try different solutions, such as using CDN-s, optimizing image sizes, using various storage solutions, etc.

So, which fundamentals to learn:

🔹 𝗔𝗹𝗴𝗼𝗿𝗶𝘁𝗵𝗺𝘀
🔹 𝗗𝗮𝘁𝗮 𝘀𝗼𝘂𝗿𝗰𝗲𝘀
🔹 𝗖𝗹𝗲𝗮𝗻 𝗰𝗼𝗱𝗲
🔹 𝗗𝗲𝘀𝗶𝗴𝗻 𝗽𝗮𝘁𝘁𝗲𝗿𝗻𝘀
🔹 𝗗𝗶𝘀𝘁𝗿𝗶𝗯𝘂𝘁𝗲𝗱 𝗖𝗼𝗺𝗽𝘂𝘁𝗶𝗻𝗴 𝗣𝗮𝘁𝘁𝗲𝗿𝗻𝘀
🔹 𝗧𝗲𝘀𝘁𝗶𝗻𝗴
🔹 𝗦𝘆𝘀𝘁𝗲𝗺 𝗗𝗲𝘀𝗶𝗴𝗻

Try to learn those fundamentals, buy and read these books:

🔸 𝗖𝗹𝗲𝗮𝗻 𝗖𝗼𝗱𝗲
🔸 𝗧𝗵𝗲 𝗣𝗿𝗮𝗴𝗺𝗮𝘁𝗶𝗰 𝗣𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗲𝗿
🔸 𝗖𝗼𝗱𝗲 𝗖𝗼𝗺𝗽𝗹𝗲𝘁𝗲
🔸 𝗗𝗲𝘀𝗶𝗴𝗻 𝗣𝗮𝘁𝘁𝗲𝗿𝗻𝘀: 𝗘𝗹𝗲𝗺𝗲𝗻𝘁𝘀 𝗼𝗳 𝗥𝗲𝘂𝘀𝗮𝗯𝗹𝗲 𝗢𝗯𝗷𝗲𝗰𝘁-𝗢𝗿𝗶𝗲𝗻𝘁𝗲𝗱 𝗦𝗼𝗳𝘁𝘄𝗮𝗿𝗲
🔸 𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝗼𝗻 𝘁𝗼 𝗔𝗹𝗴𝗼𝗿𝗶𝘁𝗵𝗺𝘀

#softwareengineering #programming #developers #softwaredesign #techworldwithmilan

[Drupal Association @drupalassoc]

Very exciting news from the #DrupalConPortland Driesnote - introducing Drupal Starshot, a new version of #Drupal! 💫 Read the full announcement now in the official press release: https://t.co/O1zCoIownz

[Lullabot @lullabot]

Drupal's Webform is a powerful, versatile module. But you need to do something with those form submissions. Here's an easy way to automate that process without writing any code.

https://t.co/Rux31A2rgV

[The Drop is Always Moving @DropIsMoving]

Drupal 11 development has reached a point where the system requirements are being raised in the development branch. To prepare core developers for this and to inform the community at large, we are announcing the following requirements for Drupal 11. https://t.co/eov2jsT6pT

[Théodore Biadala @nod_]

Starting to look for clients over the next few months, let me know if you need some Drupal work done.
https://t.co/pIfWG0tC5V

[Sascha Eggenberger @saschaeggi]

The Drupal Gin Admin Theme reached a pretty remarkable milestone with exceeding 50,000 Drupal site installs, which is incredible! 😍👏🚀 #OpenSource #Drupal #GinAdminTheme #DrupalThanks

[Dr Milan Milanović @milan_milanovic]

𝗧𝗼𝗽 𝟮𝟬 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝘆 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀

Here is the list of the top 20 SQL query optimization techniques I found noteworthy:

1. Create an index on huge tables (>1.000.000) rows
2. Use EXIST() instead of COUNT() to find an element in the table
3. SELECT fields instead of using SELECT *
4. Avoid Subqueries in WHERE Clause
5. Avoid SELECT DISTINCT where possible
6. Use WHERE Clause instead of HAVING
7. Create joins with INNER JOIN (not WHERE)
8. Use LIMIT to sample query results
9. Use UNION ALL instead of UNION wherever possible
10. Use UNION where instead of WHERE ... or ... query.
11. Run your query during off-peak hours
12. Avoid using OR in join queries
14. Choose GROUP BY over window functions
15. Use derived and temporary tables
16. Drop the index before loading bulk data
16. Use materialized views instead of views
17. Avoid != or <> (not equal) operator
18. Minimize the number of subqueries
19. Use INNER join as little as possible when you can get the same output using LEFT/RIGHT join.
20. Frequently try to use temporary sources to retrieve the same dataset.

Do you know what is 𝗤𝘂𝗲𝗿𝘆 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗲𝗿? Its primary function is to determine 𝘁𝗵𝗲 𝗺𝗼𝘀𝘁 𝗲𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝘁 𝘄𝗮𝘆 to execute a given SQL query by finding the best execution plan. The query optimizer takes the SQL query as input and analyzes it to determine how best to execute it. The first step is to parse the SQL query and create a syntax tree. The optimizer then analyzes the syntax tree to determine how to run the query.

Next, the optimizer generates 𝗮𝗹𝘁𝗲𝗿𝗻𝗮𝘁𝗶𝘃𝗲 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗽𝗹𝗮𝗻𝘀, which are different ways of executing the same query. Each execution plan specifies the order in which the tables should be accessed, the join methods, and any filtering or sorting operations. The optimizer then assigns a 𝗰𝗼𝘀𝘁 to each execution plan based on the number of disk reads and the CPU time required to execute the query.

Finally, the optimizer 𝗰𝗵𝗼𝗼𝘀𝗲𝘀 𝘁𝗵𝗲 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗽𝗹𝗮𝗻 with the lowest cost as the optimal execution plan for the query. This plan is then used to execute the query.

Check in the image the 𝗼𝗿𝗱𝗲𝗿 𝗶𝗻 𝘄𝗵𝗶𝗰𝗵 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝗶𝗲𝘀 𝗿𝘂𝗻.

#technology #softwareengineering #programming #techworldwithmilan #sql

[ultimike @ultimike]

Really interesting idea from the #drupal Association about using contribution credits as a form of currency for issue bounties.

https://t.co/AaVBX3S2mA

I look forward to @morenodotnet future blog post with the results!

[Gábor Hojtsy @gaborhojtsy]

Today at @fosdem, the Open Website Alliance is announced by @drupal, @joomla, @typo3 and @WordPress with the message that we have more in common than different. The Alliance represents the open source CMSs powering more than 50% of websites online today. https://t.co/EhyMfxEmPb