Sometimes one right decision could save a lot of time. That's what happened to me in the article. medium.com/career-dev/how-iv…

When i was 18, my teacher says to me that i will never be a good developer because I'm weak in math, today after 14 years as a senior dev / Tech lead I've proved it wrong. Follow your passions / instinct no matter what. #developers

👀 Have you ever used webrtc? This kind of protocol is really helpful when you're thinking about a real time communication up (like Google meet or Microsoft teams). ✍️ Here you will find my medium article about this for beginners, enjoy. medium.com/@lo.casponi/what-…

🚀 Gm #developers what you'll do today at work? For me is code review day, I will optimize some code from our codebase (and yes, it's a very important part of our job). Whenever u can, aim at full optimization. #CodingJourney #php #javascript

🚀 Let's talk about solid principles in oop, I will explain them in a few lines: 🇬🇧 EN: 1. SRP (Single Responsibility Principle): A class should have only one reason to change, making the code more manageable. 2. OCP (Open-Closed Principle): Software entities should be extendable without modification. 3. LSP (Liskov Substitution Principle): Derived classes should be substitutable for their base classes. 4. ISP (Interface Segregation Principle): Use specific interfaces to avoid unused methods. 5. DIP (Dependency Inversion Principle): Depend on abstractions, not concrete classes, for flexibility. 🇮🇹 Ita: 1. SRP (Single Responsibility Principle): Una classe dovrebbe svolgere un solo compito, rendendo il codice più gestibile. 2. OCP (Open-Closed Principle): Le entità del software dovrebbero essere estendibili senza modificarle. 3. LSP (Liskov Substitution Principle): Le classi derivate dovrebbero poter sostituire le classi di base senza problemi. 4. ISP (Interface Segregation Principle): Utilizza interfacce specifiche anziché una generica per evitare metodi inutilizzati. 5. DIP (Dependency Inversion Principle): Dipendenze da astrazioni, non da classi concrete, per favorire la flessibilità. #OOP #programming #php #javascript

🇺🇸 Painful thruts about #programming : A lot of companies doesn't want to deliver nice software, them aiming at cash without quality. --------- 🇮🇹 Verità scomode sulla programmazione : Una marea di aziende se ne frega della qualità del #software ma mira soltanto al guadagno. #developer #PHP

💭 Programming books are expensive? Not today. 🚀 15 useful books from O'Reilly for under 30$, take a look on this bundle. #developer #CodingJourney #codinglife humblebundle.com/books/softw…

👨‍🎓 Attention! A case study so DEVASTATING that it sends shivers down your spine. 👨‍💻 Not a clickbait, I want to talk about a real case that helps you understand how there are n solutions in programming for anything. That said, let's dive in: 🌐 Scope of the project: After user input in a dedicated search bar, perform a search involving and aggregating various data types, based on 5 very large tables in an SQL database. Since it's based on user input, response speed is vital, and data consistency and up-to-date responses must be ensured. 1️⃣ "Old-School" Method: Giant time-space query with all the necessary joins and user input comparisons to extract similar results by concatenating conditions. 2️⃣ "What a View" Method: Create a view that includes all the necessary columns for the search, obtaining a constantly updated table queryable with each user input, no need to redo joins and such at runtime. 3️⃣ "Scream Aim Fire" Method: Prepare various tables (depending on what we're reading) with full-text indices, then set up triggers attached to the "real" tables that, with stored procedures, update the "archive" tables with full text when certain fields change/events occur. Then use a MATCH(...) AGAINST (...) query paired with REGEXP or LIKE in the search. 4️⃣ "Scream Aim Fire" but Manual: Similar to the previous method, but instead of triggers/SP, call runtime methods to update archives based on CRUD operations on the relevant tables. 🙏 Now here comes the fun part, I won't tell you which one we chose, but I ask you to write in the comments what you would have done (even solutions not listed), enjoy. #sql #database #developer #webdeveloper

Gm #developers, today is office day! Are you doing full remote or you're going to the office sometime? 🚀 I think that human contact is important anyway, but remote is so comfortable 😛 #developer #remotejob #codinglife

📝 SQL, like a pink asterisk, stands between "SELECT" and "FROM table_with_an_incomprehensible_name_that_I_need". 🚀 Feeling poetic today, aren't we? 😬 But aside from that, let's talk about some tips to improve your query performance (but first, leave a follow, or you might accidentally DROP the user database in production next time): - When using SELECT, you don't always need to fetch all columns from the table, save resources; - If you need a subquery as a filter, and its result is not influenced by the main query, sometimes it's more performant to incorporate it into a WITH clause and use it within the main query, saving you from calling it for each record in the table; - Limit the number of joins on massive tables or restrict their scope; - ORMs are nice but add an extra layer between you and the database, making things heavier. Use them sparingly; - Watch out for non-clustered indexes; too many on a table can slow down queries instead of speeding them up, especially on very large tables, they can consume a lot of disk space; - If you have tables accumulating gigabytes of data, consider periodic purging. Data like logs is rarely useful after 15 years; - If you find yourself repeatedly running a complex query involving multiple tables, consider creating a dedicated view. Read-only access to the view will be faster, and it will always stay up to date. 😁 Feel free to suggest more in the comments below #sql #database #developer #performanceTips

✒️ Painful truths about #programming : 💭 FE devs are who plays with pixels 💭 BE devs are who restart servers 💭 Junior dev is who is underpayied 💭 Devops is a trendy name for sys admins 💭 Software analyst is who analyzes customers fantasies that not makes sense 💭 Data scientist is who launch queries every day but don't know why ... Others? 🤔 #php #javascript #golang

💻 #programming isn't about perfection; Programmers make mistakes and face challenges they can't conquer alone. Watch my latest video to discover the right mindset! 💡👩‍💻 🇮🇹🇺🇸 Ita / eng subs. #ProgrammingJourney #MindsetMatters #php

🚀 #PHP 8 Static typing brings precision to your code: 1. 📌 Strict types: Specify type declarations for function parameters and return values, reducing unexpected errors. 2. 🔍 Union Types: Flexibility to accept multiple types for a parameter, making code more adaptable. 3. 🕵️‍♂️ Nullable Types: Embrace null safely, ensuring your code handles optional values gracefully, use null-safe operator (->foo?) and null coalesce operator and improve readability (??) 4. 🎯 Named Arguments: Improved readability and flexibility in function calls. PHP 8 is all about precision and control! 💪💼 #PHP8 #StaticTyping #Coding

🚀 Gm #devs with a photo from the past! One of my first computers and setups in 2012. Many years are passed but that fire is still burning 🔥. Did you have a Pic of your past as a programmer? If you want share it below and caption it. #CodingJourney #php #javascript

✒️ Painful truths about #programming : The perfect language doesn't exists, the perfect programmer neither. You don't need to pursue perfection, just be passionate enough and reach your goals 💻 #coding #php #javascript #golang

✒️ Today I'm writing some page of my new book "Sopravvivenza per programmatori", it will not be a technical book, but I'm filling it with tons of tips about Tech market : - what do you need to study and how; - approaching companies and get more raises during your career; - red flags you must known; - how to crack interview processes; And a lot of interesting things based on my personal experience in the latest 12 years. 💻 I will publish it on Amazon in Italian and English ❤️ Stay tuned #books #book #developer #CodingJourney

💻 Gm #developers! ✒️ Did you ever need your queries run faster? 😜 Today I wanna explain you how to speed up your #sql subqueries in 2 minutes with a little trick. 🚀 Eng / Ita subs in the video below

✒️ When I've started studying #golang, my first impressions where like : - what a simple syntax ; - WOAH native concurrency and channels; - it seems C with muscles ; 😜 I had always loved this language, but if you want to check it out, below you'll find an useful map (credit roadmap.sh) #developers #CodingJourney #CodingCommunity