Sajith vijesekara

Technical Lead. Passionate about cloud computing & web security | Blogger at @Medium | Freelance Mobile Developer | CKAD | AWS Community Builder 🇱🇰

[Sajith vijesekara @sajithv91]

Elephant's clever trick for getting more snacks - BBC https://t.co/5I76K9Ap3z via @YouTube

[Sajith vijesekara @sajithv91]

Sri Lanka's green gold: From mountain slopes to the world's teacups • FR... https://t.co/400eSBp5e3 via @YouTube

[Hasitha Liyanage @h_liyan]

1 Nobel Laureate
1 Central banker w/ Phd
2 Former military
1 Law professor
4 Human rights/student activists
2 Senior Legal professionals
2 Diplomats
1 Agriculture researcher
1 Psychology professor
1 Religious scholar
...
1 Friend of the President

Bangladesh did what we couldn't.

[Abier @abierkhatib]

This is beyond horrific. I'm disgusted to be a human being.

Israel delivered a truck full of bodies to be buried in mass graves without any explanation.

[Josh @joshmanders]

This is what I want to see AI used for, not to create yet another social media auto replier for marketing.

[Marques Brownlee @MKBHD]

Every single one of these videos is AI-generated, and if this doesn't concern you at least a little bit, nothing will

The newest model: https://t.co/zkDWU8Be9S

(Remember Will Smith eating spaghetti? I have so many questions)

[Sajith vijesekara @sajithv91]

I just published CKAD Exam Guide for 2024 https://t.co/9l6FJMiaqQ #k8 #ckad #2024 #cloud

[Vlad Mihalcea @vlad_mihalcea]

Applying the high scalability tips from Google and Netflix software architectures to your trivial project.

[Amazon Web Services @awscloud]

Need low latency & high performance? Accelerate workloads with #AWS. ☁️🏎️

Amazon #S3 Express One Zone delivers the fastest data access in the cloud with the lowest-latency cloud #Storage. Speed up data processing & cross the finish with time to spare.

👉 https://t.co/tVrtKvWVpB

[Sajith vijesekara @sajithv91]

@OfficialSLC It is sad to see "Awurudu kema" in April

[Josh Long @starbuxman]

I love @SpringBoot 3.2!!

- reactive cache/scheduled abstraction
- virtual threads
- CRaC
- Spring for @apache_pulsar
- RestClient / JdbcClient
- reloadable SSL
- @GraalVM
- @java 21
- observability
- spring.main.keep-alive=true
- @Docker for @neo4j, activemq, etc
- new dependencies
- TransactionalExecutionListener

Try it out: https://t.co/1zelhVJx8l

For the full details see release notes for @springboot (1) and @springframework (2)

1. https://t.co/qyNpFRpspA
2. https://t.co/F6CuXdbGol

[Sajith vijesekara @sajithv91]

@irajonline

[Sajith vijesekara @sajithv91]

@exfrotezter Dawas 7ma peya 24ma weda karanawalu pissekda muu

[Sajith vijesekara @sajithv91]

@AkhilaSene97 They are cricket board-paid journalists. they will receive free tours and other benefits so they just ask silly questions not the real issues

[Cricinfo @cricinfo]

GLENN MAXWELL, WOW!

THE GREATEST INNINGS IN ODI HISTORY?!

#AUSvAFG #CWC23

[Dr Milan Milanović @milan_milanovic]

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

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. For retrieving the same dataset, frequently try to use temporary sources.

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 works by taking the SQL query as input and analyzing 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

[Sajith vijesekara @sajithv91]

Do you remember when you joined X? I do! #MyXAnniversary

[Sajith vijesekara @sajithv91]

@rowmewan1 😆

[Josh Long @starbuxman]

hello, @java 21

https://t.co/S5mEMj5H4y

[Josh Long @starbuxman]

So many new things in @java 21 vs @java 17. A few of my favorites, in addition to Loom’s virtual 🧵s:
- SequencedCollections and new factory methods
- Math.div* methods
- auto-close HttpClient
- BigInteger#parallelMultiply
- enhanced switch pattern matching
- record component extraction in pattern matching
- exhaustive checks in sealed types in enhanced switch
- Future#getState()
- String#indexOf(String, int start, int stop)