| # ENGLISH ABOVE, FRENCH BELOW -- VERSION FRANCAISE CI DESSOUS | |
| # You want to tally something in Rails and you like Ruby so you've written | |
| Object.pluck(:field).tally | |
| # and the results look OK so you don't look further | |
| {'ruby' => 999, 'python' => 300, 'java' => 42, 'C' => 1} | |
| # But you're actually asking the database to do only SELECT objects.field, fetch 1342 records, and counting in Ruby | |
| # Databases are quite cool and fast, and you'd rather do | |
| "SELECT objects.field, COUNT(objects.field) AS objects_count FROM objects GROUP BY objects.field" |
Disclaimer : motivé par Mathieu Sanchez je publie ce draft qui a plus de quatre ans. Ce sont clairement des hot takes et les plus chaudes sont à expliquer ou revoir. Je vais laisser comme tel, mais ajouter des étoiles. Encore merci Mathieu : https://www.linkedin.com/posts/matsanchez_humour-dev-orelsan-activity-6972841728902840320-fGyj/
OK, j'vais sortir un nouveau talk
Mais, avant, faut qu'on revoit les bases
J'vais faire un talk simple où j'vais dire des trucs simples