JAVASCRIPT Tip💡

One liner to create a go back button in javascript

1️⃣ Where Is This:

This is for when you have a picture of a place and don't know where it is.

🔗 where-is-this.com

2️⃣ Cleanup Pictures:

Took a nice photo, but random objects are in the way?

You can remove any unwanted person or object in seconds.

🔗 cleanup.pictures

3️⃣ City Walks:

Take a virtual walk around any city on planet Earth.

From the comfort of your own home.

🔗 citywalks.live

4️⃣ 10 Minute Mail:

Need an email to sign up for a site/ service?

Don't want the unnecessary spam?

This tool gives you a free email address that's valid for 10 minutes.

🔗 10minutemail.com

5️⃣ Quillbot:

This tool enhances and rewrites your sentences/ paragraphs.

• Input text and hit Rephrase • Get AI-inspiration on how to rewrite • Scan text for plagiarism (built-in feature) • Credit sources

🔗 quillbot.com

6️⃣ RemoveBG:

Upload your image and easily remove any background.

It only takes a few seconds.

🔗 remove.bg

7️⃣ 12ft Ladder:

No more sitting behind a paywall, shaking your fist at our capitalist overlords.

Insert the URL into the ladder to remove the wall.

Access paid content for free.

🔗 12ft.io

JavaScript Tip💡

You can get the amount of RAM memory available on the device in gigabytes using navigator.deviceMemory.

Common Frontend interview question 💡👏

JavaScript Tip 💡

You can add a scroll to the top button using this function👇🏻

JavaScript Tip💡

You can check whether an element is present in the array or not, by using the includes() method.

JavaScript tip:

You can wrap your console.log() arguments with curly brackets to see the variable names.

Angular for Business 2024

https://t.me/c/2109572262/822

For questions here is the Chat group link
https://t.me/+2KE896TMwHkxOWE1

For Resources aka PDfs and Ebooks group link

https://t.me/+eweUkdFwlho4YjRl

Join Python Channel
https://t.me/python_assets

You're at a web development interview.💨

The interviewer asked:

"What is a web server and how does it play a crucial role in web development? ."

Here's how to answer:👇👇

A web server is the bridge in client-server communication.

It:
handles requests,
retrieves resources, and
ensures efficient data transfer.

Web servers fetch requested content from storage and send it back to the user's browser.

They use HTTP/HTTPS to communicate, manage security and maintain data integrity.

@javascript_resources
@python_assets

𝗧𝗼𝗽 𝟮𝟬 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝘆 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀

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.