@wendell_adriel@PovilasKorop Nice solution, but I do see some optimalizations. Using after will rebuild the table and can make the migration slow. Also the backfilling can be done in chunks with raw / column statements. And I think the temporary sync is not needed perse.
@madebygoogle is it normal for the outdoor camera cables to just break down after 3,5 years? Camera stopped working and found out the issue just now.. This is the 4th Nest item that broke down.. #badquality π
@marcelpociot Slow test suite due to too many queries when setting up basic data for each integration test. Created a trait to show me a summary of the queries per test and help me reduce it. Performance was 3x faster
Not to mention the poor support, which just tells you to reset the products over and over again, what clearly does not fix the fact that the app is slow and the free subscription is useless.
@madebygoogle @googlenest what is going on with the nest products? App show empty frame when someone rings the bell, the app is extremely slow, the cameraβs now broke down for the 3rd time, subscription changed so without subscription the product is useless. Worst product ever!
@tado can someone please tell me when my order will arrive! The support channel is not giving any (helpful) answers and it has been a week! Next to the fact that the products are not very durable, make sure you help customers. And at least donβt put me in the cold (literally)!
@tado I started to experience issues with my Tado since the 26th and it completely failed since 2nd of December. Iβm started to think this issue might have triggered something. Next to that Iβm still waiting to receive any news on my order of a new thermostats since then. π‘
Just learned about MySQL's FIELD(...) function, which allows you to order by appearance in a list. Useful for forcing the order of results based on an array of values you know in a WHERE IN clause
I have *so* much admiration for Taylor and what heβs accomplished β I owe basically my entire career to him and the community heβs built.
Really excited for this next chapter π₯³
I'm excited to announce that Laravel has raised a $57M Series A in partnership with Accel.
I believe that Laravel is the most productive way to build full-stack web applications, and Laravel Cloud will be the platform for shipping those applications that this community deserves.
π₯How to degrade MySQL query performance by 10,000x
Read this slowly:
Querying an indexed, string column using an integer value will not use your index.