Ynohtna.fr - Veille technologique

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 3 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 3 years ago

teamtnt/tntsearch: A fully featured full text search engine written in PHP
github.com/teamtnt/tntsearch

php Search

Added 3 years ago

High-speed inserts with MySQL. When you need to bulk-insert many… | by Benjamin Morel | Medium
medium.com/@benmorel/high-speed-inserts-wi...

MYSQL performance sql

Added 3 years ago

How to build and distribute beautiful command-line applications with PHP and Composer — osteel's blog
tech.osteel.me/posts/how-to-build-and-dist...

composer Console php

Added 3 years ago

The API Design Platform and API Client - Insomnia
insomnia.rest

API App

Added 3 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 3 years ago

Don’t do Code Review, try Mob instead | by Svaťa Šimara | Verotel | Jan, 2022 | Medium
medium.com/verotel/dont-do-code-review-try...

process quality

Added 3 years ago

jupeter/clean-code-php: Clean Code concepts adapted for PHP
github.com/jupeter/clean-code-php

clean code php

Added 3 years ago

La CNIL publie une nouvelle version de son guide RGPD pour les développeurs | CNIL
www.cnil.fr/fr/la-cnil-publie-une-nouvelle...

Guide RGPD

Added 3 years ago

The long journey of making PHP’s Composer memory-efficient and fast | by Yanick Witschi | Jan, 2022 | Medium
medium.com/@yanick.witschi/the-long-journe...

composer php

Added 3 years ago

Fastest Magento 2 ReactJS Luma PWA Theme | by Yegor Shytikov | Jan, 2022 | Medium
yegorshytikov.medium.com/fastest-magento-2...

2 magento

Added 3 years ago

PHP 7.4 vs PHP 8.1 Magento 2 an Adobe Commerce Performance | by Yegor Shytikov | Jan, 2022 | Medium
yegorshytikov.medium.com/php-7-4-vs-php-8-...

2 magento performance

Added 3 years ago

Magento 2 ReactJS UI components. How to use React with Magento in the right way 2022! | by Yegor Shytikov | Jan, 2022 | Medium
yegorshytikov.medium.com/magento-2-reactjs...

2 magento react

Added 3 years ago

Emoji flag in the Symfony CountryType | by Smaine Milianni | Jan, 2022 | Medium
smaine-milianni.medium.com/emoji-flag-in-t...

php Symfony

Added 3 years ago

Designing a Symfony Validator - the TDD way 📝 | by .com software | Jan, 2022 | Medium
medium.com/@dotcom.software/designing-a-sy...

php phpunit tdd test

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...

No Tags

Added 3 years ago

Efficient Pagination Using Deferred Joins - Aaron Francis
aaronfrancis.com/2022/efficient-pagination...

MYSQL sql

Added 3 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 3 years ago

Implementation of Chain of Responsibility Design Pattern in PHP
orangesoft.co/blog/chain-of-responsibility...

design pattern

Added 3 years ago

flow-php/etl: Extract Transform Load - Abstraction
github.com/flow-php/etl

etl php

Added 3 years ago

staabm/phpstan-dba: database handling related class reflection extension for PHPStan & framework-specific rules
github.com/staabm/phpstan-dba

quality

Added 3 years ago

kamranahmedse/design-patterns-for-humans: An ultra-simplified explanation to design patterns
github.com/kamranahmedse/design-patterns-f...

design pattern php

Added 3 years ago

Regex Crossword
regexcrossword.com

game regex

Added 3 years ago