Md Sadakul Islam

@musk_news13 Yes

My twitter network Please help me to spread this. #SaveBangladeshStudents #SaveBangladeshiStudents #StudentProtest #StarlinkforBangladesh

Cheat codes I wish I knew at 22 as a Programmer:

If you liked this thread: 🔔 Follow: @systemdesign42 ♻ Repost to help others find it 🧑‍🦰 Tag a person learning system design 💾 Bookmark it for future reference

If you want to become a world-class programmer, read these 8 books:

If you want to become good at cracking coding interviews, learn these templates:

2000+ Interview Questions -- 💯 FREE -- Crack your interviews effortlessly. ❯ SQL interviewquestions.notion.site/SQL-Interview-… ❯ Python interviewquestions.notion.site/Python-Intervi… ❯ JavaScript interviewquestions.notion.site/JavaScript-Int… ❯ React interviewquestions.notion.site/React-Intervie… ❯ DSA interviewquestions.notion.site/DSA-Interview-… ❯ OOPs interviewquestions.notion.site/OOPS-Interview… ❯ HTML/CSS interviewquestions.notion.site/HTML-CSS-Inter… ❯ Git interviewquestions.notion.site/GIT-Interview-… Do you need more interview-related resources? Comment below the topic.

If you're still new to @PostgreSQL, here are some useful info bits from me: 1) tuples are physical versions of rows; you can start understanding them by selecting hidden columns ctid, xmin, xmax (all tables have them); start looking at this as early as possible, and later you won't be surprised by slow massive DELETE not reclaiming disk space, autovacuum, and bloat issues. 2) always use BUFFERS checking EXPLAIN ANALYZE – the right command is EXPLAIN (ANALYZE, BUFFERS) 3) throw away pgAdmin – stick with tmux&psql or, if you do need UI, use DBeaver or DataGrip or Postico (but still learn psql-fu, it will pay off) 4) enable as much logging as you can afford: log_checkpoints = 0, log_autovacuum_min_duration = 0, log_temp_files = 0, log_lock_waits = on, and as low non-negative log_min_duration_statement as you can afford – say, 200ms (watch out observer effect caused by too much logging though) 5) install pg_stat_statements – it's a must; and if you can install pg_stat_kcache and pg_wait_sampling (or pgsentinel) and auto_explain (these guys require a few decisions on settings though) 6) use thin cloning and branching @Database_Lab to develop and test (and yes, ChatGPT can be helpful, but it often has hallucinations, so always check it) 7) make sure data checksums are enabled 8) tune autovacuum to run frequently and move faster 9) query optimization will eventually be more important than configuration tuning, and more often needed – tune .conf "well enough" and then focus on continuous use of pg_stat_statements and EXPLAIN (ANALYZE, BUFFERS) 10) indexes need to be rebuilt, unfortunately, since their health decline over time – even in PG14+ with well-tuned autovacuum; prepare for that, better do it in an automated way; and clean up unused and redundant ones regularly

10 excellent GitHub repositories for every Java developer: 1. Java Design Patterns - github.com/iluwatar/java-… 2. Interviews - github.com/kdn251/intervi… 3. Algorithms - github.com/TheAlgorithms/… 4. Real-World Projects - github.com/gothinkster/re… 5. Awesome Java - github.com/akullpp/awesom… 6. Baeldung Tutorials - github.com/eugenp/tutoria… 7. JHipster - github.com/jhipster/gener… 8. Spring Framework - github.com/spring-project… 9. Spring Boot Tutorials by Java Guides - github.com/RameshMF/sprin… 10. racking the Coding Interview in Java - github.com/careercup/CtCI…

Just got an email from work that our hospital is full and all elective surgical cases have. Even cancelled. No transfers allowed to hospital. Driving home, passed a restaurant that was full. Shaking my head. Frustrated is an understatement.

Popular websites to practice coding challenges: ▫️TopCoder ▫️CoderByte ▫️Project Euler ▫️HackerRank ▫️CodeChef ▫️Exercism .io ▫️Codewars ▫️Leetcode ▫️SPOJ ▫️CodingGame

There are two kinds of code that frustrate me the most: - One that does not work, but should - One that works, but shouldn't

First Unique Character in a String - LeetCode leetcode.com/problems/first…

Are you preparing for your interviews? It can be difficult to chalk out a plan yourself. Here's a list of Github repositories which will help you create a study plan: 🧵👇🏻

Save when you can so you have options when you can't.

Keeping pace with what's new in Java 15 by @eMalaGupta, a Developer Advocate with JetBrains and a Java Champion. The session is hosted by Bangalore Java User Group - meetup.com/BangaloreOpenJ…

Your hobby can help you become a Software Engineer #JavaChallengers Check it out the 3 Things James Gosling Said That Will Make You a Top Software Engineer: bit.ly/3jVne7K bit.ly/3jVne7K

Completed elasticsearch course on Udemy. udemy-certificate.s3.amazonaws.com/pdf/UC-f3c67c2… #elasticsearch

Tough coding interview question! interviewcake.com/question/java/… via @interviewcake