Walex

@EnsedeCiencia Faltaron los extraterrestres

🥴🥴

@Python_Dv I am very surprised that PostgreSQL is not mentioned.

Types of Databases click.linksynergy.com/deeplink?id=Nh… #Databases #sql #nosql #mysql

@EnsedeCiencia 13

🤔

@Python_Dv A

Python Question / Quiz; What is the output of the following Python code, and why? 🤔🚀 Comment your answers below! 👇 #python #programming #developer #morioh #programmer #coding #coder #webdeveloper #webdevelopment #pythonprogramming #pythonquiz #machinelearning

@EnsedeCiencia Si la degeneración celular se considera enfermedad, pues me gustaría poder revertir la degeneración celular o al menos frenarla

🧐

@Python_Dv 45

IQ Question / Quiz; 🤔🚀 Comment your answers below! 👇 #iq #math #maths #mathematics #python #programming #developer #morioh #programmer #coding #coder #webdeveloper #webdevelopment #pythonprogramming #pythonquiz #machinelearning

Eran un español, un estadounidense y un australiano, que no se juntaron para un chiste sino para ofrecernos un momento sublime de magia musical. No se lo pierdan; emociona de veras.

How life would be without any electricity

@dev_maims Basic

Me JavaScript and you 🌚

sudo apt install food # <--😂🤓🥘 cyberciti.biz/faq/ubuntu-lts…

No todo el mundo lo entenderá...

@Python_Dv B

Python Question/Quiz; What is the output of the following Python code, and why? 🤔🚀 Comment your answers below! 👇 #python #programming #developer #morioh #programmer #webdev #webdeveloper #webdevelopment #pythonprogramming #pythonquiz #ai #ml #machinelearning #datascience

@Crayfe Si, y lo peor que los colecciono 😃

¿No os pasa que compráis varias tarjetas microSD y luego tenéis una colección absurda de adaptadores SD que no valen para nada?

@alvaro_chirou Me gustaría la 6, pero soy de la 3 con pantallas de la 2

¿Cuál tienes tú o te gustaría o es tu favorita? Vota en comentarios Yo tengo la 5. Me gustaría la 6 😂

@Python_Dv B

Python Question/Quiz; What is the output of the following Python code, and why? 🤔🚀Comment your answers below! 👇 #python #programming #developer #morioh #programmer #webdev #webdeveloper #webdevelopment #pythonprogramming #pythonquiz #ai #ml #machinelearning #datascience

𝗧𝗼𝗽 𝟮𝟬 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝘆 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀 Here is the list of the top 20 SQL query optimization techniques I found noteworthy: 1. Create an index on huge tables (>1.000.000) rows 2. Use EXIST() instead of COUNT() to find an element in the table 3. SELECT fields instead of using SELECT * 4. Avoid Subqueries in WHERE Clause 5. Avoid SELECT DISTINCT where possible 6. Use WHERE Clause instead of HAVING 7. Create joins with INNER JOIN (not WHERE) 8. Use LIMIT to sample query results 9. Use UNION ALL instead of UNION wherever possible 10. Use UNION where instead of WHERE ... or ... query. 11. Run your query during off-peak hours 12. Avoid using OR in join queries 14. Choose GROUP BY over window functions 15. Use derived and temporary tables 16. Drop the index before loading bulk data 16. Use materialized views instead of views 17. Avoid != or <> (not equal) operator 18. Minimize the number of subqueries 19. Use INNER join as little as possible when you can get the same output using LEFT/RIGHT join. 20. Frequently try to use temporary sources to retrieve the same dataset. Do you know what is 𝗤𝘂𝗲𝗿𝘆 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗲𝗿? Its primary function is to determine 𝘁𝗵𝗲 𝗺𝗼𝘀𝘁 𝗲𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝘁 𝘄𝗮𝘆 to execute a given SQL query by finding the best execution plan. The query optimizer takes the SQL query as input and analyzes it to determine how best to execute it. The first step is to parse the SQL query and create a syntax tree. The optimizer then analyzes the syntax tree to determine how to run the query. Next, the optimizer generates 𝗮𝗹𝘁𝗲𝗿𝗻𝗮𝘁𝗶𝘃𝗲 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗽𝗹𝗮𝗻𝘀, which are different ways of executing the same query. Each execution plan specifies the order in which the tables should be accessed, the join methods, and any filtering or sorting operations. The optimizer then assigns a 𝗰𝗼𝘀𝘁 to each execution plan based on the number of disk reads and the CPU time required to execute the query. Finally, the optimizer 𝗰𝗵𝗼𝗼𝘀𝗲𝘀 𝘁𝗵𝗲 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗽𝗹𝗮𝗻 with the lowest cost as the optimal execution plan for the query. This plan is then used to execute the query. Check in the image the 𝗼𝗿𝗱𝗲𝗿 𝗶𝗻 𝘄𝗵𝗶𝗰𝗵 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝗶𝗲𝘀 𝗿𝘂𝗻. #technology #softwareengineering #programming #techworldwithmilan #sql

Cuando el humor no es lo tuyo #programacion

thank you @FFmpeg 😍

@maripydev Lo más difícil es intentar entender que es lo que quiere el cliente

Aprender a programar no es difícil.. Lo difícil es programar 🙃😆