Julien SIMON

1.6K posts

Julien SIMON banner
Julien SIMON

Julien SIMON

@simonjulien

Ingénieur en systèmes et réseaux propageant la culture DevSecOps, Platform Engineering, et SRE adepte du Chaos

BORDEAUX Katılım Mart 2010
1.1K Takip Edilen174 Takipçiler
Julien SIMON retweetledi
Human Coders
Human Coders@humancoders·
Diode permet de construire, programmer et simuler du matériel électronique directement dans le navigateur : Arduino, circuits intégrés, résistances, transistors, etc. ⬇️ news.humancoders.com/t/developpemen…
Français
1
2
8
811
Julien SIMON retweetledi
Vladan
Vladan@vladan·
Thinware SimpleVM – A Free-Forever Hypervisor Alternative for VMware Admins Tired of Broadcom’s Rising Costs vladan.fr/thinware-simpl… via @vladan
Vladan tweet media
English
0
6
12
1.4K
Julien SIMON retweetledi
VideoLAN
VideoLAN@videolan·
If you are not too far from France, and you are discarding old hardware, consider donating it to @videolan. As you've seen, we did lately updates to VLC to fix support for Windows XP and macOS 10.7 (and iOS9). Because you should not need to buy new hardware because of software.
English
51
438
3.2K
119.5K
Julien SIMON retweetledi
Julien SIMON retweetledi
Quentin
Quentin@TheBidouilleur·
v0.0.1 en ligne ! 🎉 Hésitez pas à faire des retours (et à contribuer si ça vous botte😁) github.com/qjoly/talosctl…
Français
0
3
13
598
Julien SIMON retweetledi
Asso Infoclimat
Asso Infoclimat@infoclimat·
🔴 #TEMPETE #NILS – Situation ce matin (12 février) Rafales maximales près des Cévennes, Hérault, Aude et Roussillon. Pics nocturnes : 🌬️ 166 km/h Mont-Aigoual 🌬️ 162 km/h Biscarrosse 🌬️ 153 km/h Leucate 🌬️ 145 km/h Port-la-Nouvelle
Asso Infoclimat tweet mediaAsso Infoclimat tweet media
Français
1
1
8
2K
Julien SIMON retweetledi
Romain 💊
Romain 💊@Medelguer·
La montée en puissance des rafales de vent est assez impressionnante. #Elias #Bordeaux
Romain 💊 tweet media
Français
2
2
11
5.1K
Julien SIMON retweetledi
LDLC
LDLC@LDLC·
🎁 CONCOURS 🎁Un setup à 7 600€ à gagner ! #30ansLDLC Pour participer : ▪ FOLLOW @LDLC ▪ RT CE TWEET 💻 La config en détails👉 urlr.me/PEfbys 📢 Joue aussi sur Instagram, Facebook et dans tous nos magasins pour multiplier tes chances. Bonne chance ! 🍀 🥳TAS le 10/02/2026
LDLC tweet media
Français
2.4K
22.8K
11.8K
657.1K
Julien SIMON retweetledi
Jay Rogers 👨‍💻
Jay Rogers 👨‍💻@jaydrogers·
⚠️ NGINX USERS: There was a CVE published in NGINX yesterday for an SSL upstream injection vulnerability. You should upgrade to v1.28.2 or v1.29.5 as soon as you can. For serversideup/php users, the patch is available in our latest release 🔐 github.com/serversideup/d…
English
8
121
521
80K
Julien SIMON retweetledi
Dr Milan Milanović
Dr Milan Milanović@milan_milanovic·
𝗦𝗤𝗟 𝗤𝘂𝗲𝗿𝗶𝗲𝘀 𝗗𝗼𝗻'𝘁 𝗦𝘁𝗮𝗿𝘁 𝗪𝗶𝘁𝗵 𝗦𝗘𝗟𝗘𝗖𝗧 We usually start with SQL by entering SELECT, but it is not executed first. SELECT actually gets executed as the 5th step. This explains why some SQL statements work while others don’t. Here is the actual execution order: 𝟭. 𝗙𝗥𝗢𝗠/𝗝𝗢𝗜𝗡 – Tables are merged to form the basis of the data set. All ON conditions are assessed at this point 𝟮. 𝗪𝗛𝗘𝗥𝗘 – Rows are filtered before any grouping takes place. You cannot refer to any aggregates at this point because none have been created yet 𝟯. 𝗚𝗥𝗢𝗨𝗣 𝗕𝗬 – The remaining rows are grouped. After this step, you're working with groups rather than individual rows 𝟰. 𝗛𝗔𝗩𝗜𝗡𝗚 – Groups get filtered. This is where you can filter on aggregate results like 𝗖𝗢𝗨𝗡𝗧(*) > 𝟱 𝟱. 𝗦𝗘𝗟𝗘𝗖𝗧 – Columns are computed and returned. Window functions run here too 𝟲. 𝗢𝗥𝗗𝗘𝗥 𝗕𝗬 – Results are sorted. This runs after SELECT, so you can use aliases in your sorting 𝟳. 𝗟𝗜𝗠𝗜𝗧 – Output is capped to the specified row count This order answers common debugging questions. Can you filter on a window function result in WHERE? No, window functions run in SELECT, which happens after WHERE. Can you use a GROUP BY alias in ORDER BY? Yes, ORDER BY runs last. This is also why 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝘀, 𝗠𝘆𝗦𝗤𝗟, and 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿 all reject 𝗪𝗛𝗘𝗥𝗘 𝗖𝗢𝗨𝗡𝗧(*) > 𝟱, as the aggregate doesn't exist at that stage. Database engines optimize heavily and may reorder operations for performance. But this logical order determines what's valid SQL.
Dr Milan Milanović tweet media
English
16
120
691
28.3K
Julien SIMON retweetledi
Gonzague 👨🏼‍💻
Gonzague 👨🏼‍💻@gonzague·
Pour les curieux de mon aventure fibre avec @bouyguestelecom , j’ai reçu l’ONT qui devrait me permettre de me passer de leur box , un Nokia XS-010X-Q 10G
Gonzague 👨🏼‍💻 tweet media
Français
12
4
63
12.9K
Julien SIMON retweetledi
Le Dev ULTIME 🍜
Le Dev ULTIME 🍜@ledevultime·
L'état a créé son propre Slack, WeTransfer, Google Drive, Google Meet, Google Docs, et j'en passe. Peu de gens le savent mais... L'état a créé "La Suite" un ensemble d'outil numériques dont le code est disponible en OpenSource.
Le Dev ULTIME 🍜 tweet media
Français
98
265
2.1K
235.4K
Julien SIMON retweetledi
EFF
EFF@EFF·
The rampant data sharing fueled by online tracking has serious consequences. Privacy Badger blocks online tracking to prevent your browsing data from being used against you. eff.org/deeplinks/2025…
English
3
47
94
4.9K
Julien SIMON retweetledi
Sciences et Avenir
Sciences et Avenir@Sciences_Avenir·
C'est l'une des maladies ciblées par le #Telethon. La petite fille, aujourd'hui âgée de 3 ans, ne présente plus aucun symptôme de la maladie ! 👉 l.sciencesetavenir.fr/SCG
Sciences et Avenir tweet media
Français
0
7
22
2.2K