Ynohtna.fr - Veille technologique

Alex Xu sur Twitter : "Awesome log parsing cheat sheet by @fr0gger_ ! https://t.co/iKkWU7n47e" / Twitter
twitter.com/alexxubyte/status/152695386092...

No Tags

Added 2 years ago

Alex Xu sur Twitter : "Let’s try something different today. Assuming in a system design interview, you are asked to design a distributed message queue. The following requirements are given: 1. Producers send messages 2. Consumers consume messages 3. Messages can be consumed repeatedly or only once https://t.co/VaOiYK62Kx" / Twitter
twitter.com/alexxubyte/status/154795863781...

No Tags

Added 2 years ago

Alex Xu sur Twitter : "You have just developed a new website. What does it take to be ranked at the top? We need to understand how search engines rank websites and then to optimize our website to be search engine-friendly. This is called SEO (Search Engine Optimization). https://t.co/bfc1rmNrh5" / Twitter
twitter.com/alexxubyte/status/154905206725...

No Tags

Added 2 years ago

Ciaran McNulty sur Twitter : "Random #php tip: You can destructure an array inside a foreach, to pick out just the elements you want https://t.co/p5roo2A3gL" / Twitter
twitter.com/ciaranmcnulty/status/148558144...

php

Added 2 years ago

X
twitter.com/CodeWithCaen/status/1781044384...

No Tags

Added 8 months ago

Kévin Dunglas sur Twitter : "Twig now supports getting the class name of an object using the `constant()` function! This is especially useful when you use #Symfony Turbo to receive real-time object updates directly in the browser. https://t.co/mXC3tHOKX9 https://t.co/RLqqQJdFpg" / Twitter
twitter.com/dunglas/status/150729558593361...

No Tags

Added 2 years ago

exakat, static analysis for PHP sur Twitter : "#phptip #phptrick Avoid long list of /../../../ by leveraging the dirname() second argument. https://t.co/fxkjVYXok5 https://t.co/oPP439YOB6" / Twitter
twitter.com/exakat/status/1630682503915921...

No Tags

Added 1 year ago

Sanjit Singh sur Twitter : "🔥 In #mysql you can compare strings by how they sound rather than how they have been typed using SOUNDEX() function #laravelframework #laravel #mysql #sql https://t.co/QJiFKQYmTY" / Twitter
twitter.com/justsanjit/status/147596514176...

MYSQL

Added 2 years ago

Mathieu Desnouveaux sur X : "Avant la reprise des conférences du #ForumPHP de l’ @afup, je vous partage une planche de #sketchnotes sur le sujet de l’accessibilité numérique et des textes alternatifs d’images par @AngiG29 J’espère que mon alt est bien rédigé https://t.co/BXXe2BJqbW" / X
twitter.com/mdesnouveaux/status/1712732396...

No Tags

Added 1 year ago

Martin Joo sur Twitter : "🔥 Let’s talk about Single Responsibility Principle for a moment. In my opinion, there are two kinds of SRPs: - Practical SRP - Technical SRP I’ll try to explain what’s the difference between them using this class as an example. 🧵Keep Reading https://t.co/L6ILEA3Rfo" / Twitter
twitter.com/mmartin_joo/status/15095308947...

No Tags

Added 2 years ago

Martin Joo sur X : "🔥 Here are some of the most basic monitoring techniques you can start using immediately: - Spatie laravel-health - Error tracking - Syntethic checks It takes ~30 minutes to set up these. 🧵 Keep Reading https://t.co/uO731UCyPC" / X
twitter.com/mmartin_joo/status/17077296979...

No Tags

Added 1 year ago

Tobias_Petry.sql sur Twitter : "⚡️ Database Tip Every tutorial for pagination is sharing the same inefficient and wrong concept of pagination with LIMITs. Cursor pagination is much more efficient and won't show rows multiple times which will happen sometimes! https://t.co/NP26uBDXO0" / Twitter
twitter.com/tobias_petry/status/1484454786...

No Tags

Added 2 years ago

Tobias_Petry.sql sur Twitter : "⚡️ Database Tip Deleting an unused index is still a risky operation: If you were wrong (and it is still needed) the database will become slow. Instead of deleting, you can make the index invisible first and make it visible again in a second if you still need it. https://t.co/KQjKTkgh5e" / Twitter
twitter.com/tobias_petry/status/1489255762...

MYSQL performance sql

Added 2 years ago

Tobias_Petry.sql sur Twitter : "⚡️ Database Tip Tag searching can be done wholly different: You can store the tag primary keys in a json array and effectively search for overlapping tag ids or missing ones without very complex joins. A single where instead of multiple (slow) joins to do the same thing. https://t.co/FttTZUvePx" / Twitter
twitter.com/tobias_petry/status/1491056283...

MYSQL performance sql

Added 2 years ago

Tobias_Petry.sql sur Twitter : "⚡️ Database Tip When doing many changes in a table by e.g. updating, deleting or inserting new rows your table statistics are not valid anymore. Your indexes may not be used, tables are joined very slow etc. You need to ANALYZE the table again to recalculate the stats. https://t.co/qih9iaUYo8" / Twitter
twitter.com/tobias_petry/status/1493836584...

MYSQL performance sql

Added 2 years ago

Tobias_Petry.sql sur Twitter : "⚡️ Database Tip Everyone knows the LIMIT clause. But what do you do if you want to have e.g. the employees with the TOP 3 salaries *and* not exclude the 4th or 5th one earning the same as the 3rd? The WITH TIES clause can return more results if the value is the same. Great! https://t.co/60pjUTqbgj" / Twitter
twitter.com/tobias_petry/status/1496470986...

No Tags

Added 2 years ago

Tobias_Petry.sql sur Twitter : "⚡️ Database Tip Your application probably has numerous indexes to guarantee fast performance. For columns which are only used in equality checks, you can use hash indexes, which can be smaller and faster. You don't need to use the standard b-tree index always! https://t.co/9CXMpp2DCs" / Twitter
twitter.com/tobias_petry/status/1508747860...

No Tags

Added 2 years ago

Tobias_Petry.sql sur Twitter : "⚡️ Database Tip Most developers are puzzled that indexes are not used for e.g. WHERE LOWER(email) = ?. But contrary to common belief, an index can be created for these cases! It's called a function-based index and is supported by MySQL and PostgreSQL. https://t.co/1go9wb39m8 https://t.co/XLoQR49hOV" / Twitter
twitter.com/tobias_petry/status/1511302969...

No Tags

Added 2 years ago

Tobias_Petry.sql sur Twitter : "⚡️ Database Tip Sometimes you want to make columns unique but you can't because e.g. there are still soft-deleted rows in the table witht the same value. By only including relevant rows (partial index) you can still enforce uniqueness, and you can even simulate it for MySQL! https://t.co/ItMAfudLRy" / Twitter
twitter.com/tobias_petry/status/1526868551...

No Tags

Added 2 years ago

Tobias_Petry.sql sur Twitter : "⚡ Database Tip Recursive queries are a great solution to e.g. querying multiple levels in a tree with just one query. But you should use cycle detection otherwise your query might run forever or fail for loops in your data. https://t.co/foSYLgWXRB https://t.co/aXNHAha3pt" / Twitter
twitter.com/tobias_petry/status/1554752933...

No Tags

Added 2 years ago

Tobias_Petry.sql sur Twitter : "⚡️ Database Tip When doing statistical aggregations by time, you may have e.g. days without data leading to strange results when charting the results. But you don't have to fill these gaps manually with code, the database can do that for you. https://t.co/4QGB7HZBxA https://t.co/uuwmGlYdKX" / Twitter
twitter.com/tobias_petry/status/1564890766...

No Tags

Added 2 years ago

Aleksandr Volodarsky 🇺🇦 sur Twitter : "There are tons of blogs by exceptional CTOs/engineers you probably have not heard of. They are super nerdy and beautiful. Here are 20 you should be reading:" / Twitter
twitter.com/volodarik/status/1603021813826...

No Tags

Added 2 years ago

🇺🇦Mathieu Santostefano 👨‍💻 sur Twitter : "Easily extract duplicated values from an array in #PHP https://t.co/f0QLiquf8d" / Twitter
twitter.com/welcoMattic/status/15268494786...

No Tags

Added 2 years ago

Trace Pixels To Vectors in Full Color, Fully Automatically, Using AI - Vectorizer.AI
vectorizer.ai

No Tags

Added 1 year ago