Links
Add
The Only 3 Steps You Need To Write Proper Code | by Nico Anastasio | Oct, 2022 | FAUN Publication
faun.pub/the-only-3-steps-you-need-to-writ...
faun.pub/the-only-3-steps-you-need-to-writ...
No Tags
Added 2 years ago
The PHP Revolution Is Underway: FrankenPHP 1.0 Beta - Kévin Dunglas
dunglas.dev/2023/09/the-php-revolution-is-...
dunglas.dev/2023/09/the-php-revolution-is-...
No Tags
Added 1 year ago
The Tick Pattern for Temporal State Machines | Better Programming
betterprogramming.pub/the-tick-pattern-a-s...
betterprogramming.pub/the-tick-pattern-a-s...
No Tags
Added 2 years ago
No Tags
Added 1 year ago
ThomasBerends/symfony-certification-preparation-list: List of topic-specific resources to help you prepare for Symfony certification
github.com/ThomasBerends/symfony-certifica...
github.com/ThomasBerends/symfony-certifica...
No Tags
Added 3 years ago
Thunder Client – An Alternative Way to Test Restful APIs
www.freecodecamp.org/news/thunder-client-f...
www.freecodecamp.org/news/thunder-client-f...
No Tags
Added 3 years ago
Time Series Analysis with MySQL 8 | by Mickaël Andrieu | Simple Data | Aug, 2022 | Medium
medium.com/simple-data/time-series-analysi...
medium.com/simple-data/time-series-analysi...
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...
twitter.com/tobias_petry/status/1564890766...
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...
twitter.com/tobias_petry/status/1489255762...
Added 3 years 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...
twitter.com/tobias_petry/status/1484454786...
No Tags
Added 3 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...
twitter.com/tobias_petry/status/1496470986...
No Tags
Added 3 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...
twitter.com/tobias_petry/status/1511302969...
No Tags
Added 3 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...
twitter.com/tobias_petry/status/1554752933...
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...
twitter.com/tobias_petry/status/1526868551...
No Tags
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...
twitter.com/tobias_petry/status/1491056283...
Added 3 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...
twitter.com/tobias_petry/status/1493836584...
Added 3 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...
twitter.com/tobias_petry/status/1508747860...
No Tags
Added 3 years ago
TomasVotruba/lines: CLI tool for quick size measure of PHP project, runs anywhere
github.com/TomasVotruba/lines
github.com/TomasVotruba/lines
No Tags
Added 1 year ago
No Tags
Added 1 year ago
Tuto Symfony, 15 minutes pour mettre en place des tests automatiques qui vont vérifier toutes les routes de votre projet | by Frederic Leaux | May, 2023 | Medium
medium.com/@fredericleaux/tuto-symfony-15-...
medium.com/@fredericleaux/tuto-symfony-15-...
No Tags
Added 1 year ago
Tutoriel Symfony : Le composant Workflow de symfony - YouTube
www.youtube.com/watch?v=1Iu8evzKmF4
www.youtube.com/watch?v=1Iu8evzKmF4
No Tags
Added 2 years ago