gdb commands reference guide

 Here is a very useful link to the gdb commands reference guide.

PostgreSQL list of commands

PostgreSQL, or Postgres, is an object-relational database management system that utilizes the SQL language. PSQL is a powerful interactive terminal for working with the PostgreSQL database. It enables users to execute queries efficiently and manage databases effectively.

Here, we highlight some of the most frequently used PSQL commands, detailing their functionalities to enhance your PostgreSQL experience.
Top PSQL Commands in PostgreSQL

Here are the top 22 PSQL commands that are frequently used when querying a PostgreSQL database:
Serial No.CommandDescription1 psql -d database -U user -W Connects to a database under a specific user
2 psql -h host -d database -U user -W Connect to a database that resides on another host
3 psql -U user -h host "dbname=db sslmode=require" Use SSL mode for the connection
4 \c dbname Switch connection to a new database
5 \l List available databases
6 \dt List available tables
7 \d table_name Describe a table such as a column, type, modifiers of columns, etc.
8 \dn List all schemes of the currently connected database
9 \df List available functions in the current database
10 \dv List available views in the current database
11 \du List all users and their assign roles
12 SELECT version(); Retrieve the current version of PostgreSQL server
13 \g Execute the last command again
14 \s Display command history
15 \s filename Save the command history to a file
16 \i filename Execute psql commands from a file
17 \? Know all available psql commands
18 \h Get help
19 \e Edit command in your own editor
20 \a Switch from aligned to non-aligned column output
21 \H Switch the output to HTML format
22 \q Exit psql shell

Additional Information:
The -d option in psql commands is used to state the database name.
The -U option specifies the database user.
The -h option indicates the host on which the database server resides.
The \h ALTER TABLE can be used to get detailed information on the ALTER TABLE statement.

Vim Copy & Paste Terminology

The keyboard shortcuts to copy, cut, and paste can be boiled down into three characters that utilize Vim-specific terminology.

Understanding these terms will help you recall the correct keyboard shortcut.

Y stands for “yank” in Vim, which is conceptually similar to copying.

D stands for “delete” in Vim, which is conceptually similar to cutting.

P stands for “put” in Vim, which is conceptually similar to pasting.

I deliberately use the phrase “conceptually similar to” because these actions are not one and the same. If you want to dive deeper into this explanation, scroll down to the section below titled “What Happens Under the Hood?”

Copy, Cutting, and Pasting in Vim/Vi - The Basics

1.Press esc to return to normal mode. Any character typed in normal mode will be interpreted as a vim command.

2.Navigate your cursor to the beginning of where you want to copy or cut.

3.To enter visual mode, you have 3 options. We suggest using visual mode because the selected characters are highlighted, and it’s clearer to see what’s happening. However, we have the keyboard shortcuts for normal mode (which achieve the exact same effect) in the section below.

4.Press v (lowercase) to enter visual mode. This will start selecting from where your cursor is.

5.Press V (uppercase) to enter visual line mode. This will select the entire line.

6.Press CTRL+V to enter visual block mode.

7.Move your cursor to the end of where you want to copy or cut.

8.Press y to copy. Press d to cut.

9.Move the cursor to where you want to paste your selection.

10.Press P (uppercase) to paste before your cursor. Press p (lowercase) to paste after your cursor.

Move the cursor to where you want to paste your selection.

Press P (uppercase) to paste before your cursor. Press p (lowercase) to paste after your cursor.

Vim Keyboard Shortcuts

Using arrow keys (or if you are an expert Vim user - h, j, k, and l) to move around in your vim file can take a long time.

Here are vim keyboard shortcuts for copying and cutting if you want to be even more efficient than the basic steps outlined above.

Copying (Yanking)

yy: Copy the current line in vi

3yy: To yank multiple lines in vim, type in the number of lines followed by yy. This command will copy (yank) 3 lines starting from your cursor position.

y$: Copy everything from the cursor to the end of the line

y^: Copy everything from the start of the line to the cursor.

yiw: Copy the current word.

Cutting (Deleting)

dd: Cut the current line

3dd: Cut 3 lines, starting from the cursor

d$: Cut everything from the cursor to the end of the line

Putting (Pasting)

P (uppercase): Paste before your cursor

p (lowercase): Paste after your cursor

What Happens Under the Hood?

Vim terms are slightly different from their conceptual counterparts that we mentioned above because these actions by default do not interact with the OS clipboard. For example, you can't paste yanked text from Vim into a different application with CMD + V.

Yank, delete, and put interact with Vim's notion of “registers”, which are basically Vim -specific clipboards. Each register is named with a character, which you can use to interact with that register. For example, you might yank line 50 of the current file to register “a” and yank line 14 of the same file to register “b”, because you intend to paste both line 50 and line 14.

To learn more about vim registers, check out this Stack Overflow page.

Conclusion

This should be everything you need to get started to copy, cut and paste in Vi. If you didn’t find what you were looking for, it may be worth checking out the official vim docs.

Interview preparation Guide for Software Engineers

- Designing Data-Intensive Applications by Martin Kleppmann
Amazon: https://amzn.to/4dlfPed

- Database Internals by Alex Petrov
Amazon: https://amzn.to/3YI515e

- System Design Interview (Volume 1) by Alex Xu
Amazon: https://amzn.to/3WJzwVV 

- System Design Interview (Volume 2) by Alex Xu
Amazon: https://amzn.to/3M7zEtv 

- Grokking the System Design Interview
https://lnkd.in/ebEwFWbP

- Grokking the Advanced System Design Interview
https://lnkd.in/e_c2CWge

- Donne Martin's System Design Primer
https://github.com/krmadhukar/system-design-primer

- Site Reliability Engineering: How Google Runs Production Systems
https://lnkd.in/edYzQwXW

- The Site Reliability Workbook: Practical Ways to Implement SRE
https://lnkd.in/e9tKypna

- Understanding Distributed Systems
https://amzn.to/4fGzg2H

- Fundamentals of Software Architecture - Mark Richards & Neal Ford
https://amzn.to/3Xdozxv

- Software Architecture: The Hard Parts - Mark Richards & Neal Ford
https://amzn.to/4cp3NyX

- System Design Interview by Lewis Lin
- Hacking the System Design Interview by Stanley Chiang
- Distributed Systems by Tanenbaum
- Building Microservices by Sam Newman

► YouTube Channels

- The Facebook E6 Guy
https://lnkd.in/ehwMYjeD

- ByteByteGo (Alex Xu)
https://lnkd.in/emgA9inH

- InfoQ
https://lnkd.in/eicU_fx3
covers Facebook's TAO architecture: https://lnkd.in/eryi_ZTT

- Jordan Has No Life
https://lnkd.in/ePUshbhX

- Usenix
https://lnkd.in/e5A5s4Xv
https://lnkd.in/ersgNbfg

- MIT Distributed Systems Course
https://lnkd.in/eDjvUJa7

- Amazon Principal Engineer's Channel (A Life Engineered)
https://lnkd.in/egxKHJxU

- Fireship : https://lnkd.in/esqeG7T9

- Martin Kleppmann
https://lnkd.in/eQQ8f2aX

- DistSys Reading Group
https://lnkd.in/ec9FZUbs

- Leslie Lamport's Video Series on Learning TLA+
https://lnkd.in/eFFABEgW

- Carnegie Mellon's Distributed Databases Course
https://lnkd.in/eTdJqU3b

–
P.S: Image Credits: https://lnkd.in/eAt-mmZF

LinkedIn Credits - https://www.linkedin.com/in/karan-saxena-466b07190

Free AI/ML LLM Fundamentals Course

Free AI/ML LLM Fundamentals Course
Save 1000s of dollars.
Bookmark this and follow the curriculum below.
You want to learn AI/ML LLM?
I have curated the Best FREE AI/ML roadmap that covers essential knowledge about maths, Python, NNs with hands-on projects Learning.

🙏 Help me spread the free courses! Kindly like, repost and comment! ♻️

Google Courses
https://www.cloudskillsboost.google/?qlcampaign=6y-in1-event-90

𝟭. 𝗠𝗮𝘁𝗵𝗲𝗺𝗮𝘁𝗶𝗰𝘀 𝗳𝗼𝗿 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴
• Linear Algebra - 3Blue1Brown: https://lnkd.in/ejApha3z
• Immersive Linear Algebra: https://lnkd.in/ekaUs4Wz
• Linear Algebra - KA: https://lnkd.in/emCEHTq5
• Calculas - KA: https://lnkd.in/emCEHTq5
• Statistics and Probability - KA: https://lnkd.in/e6_SirMr

𝟮. 𝗣𝘆𝘁𝗵𝗼𝗻 𝗳𝗼𝗿 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴
• Real Python: https://realpython.com
• Learn Python - freecodecamp: https://lnkd.in/ejfBftNf
• Python Data Science: https://lnkd.in/g4ZysfEe
• ML for Everybody: https://lnkd.in/ehR6xaGZ
• Intro to ML - udacity: https://lnkd.in/eVudd2Zm

𝟯. 𝗡𝗲𝘂𝗿𝗮𝗹 𝗡𝗲𝘁𝘄𝗼𝗿𝗸𝘀
• Neural Networks explained: https://lnkd.in/ehsg362K
• Deep Learning Crash Course: https://lnkd.in/edgfWdEv
• Practical Deep Learning - fast_ai: https://course.fast.ai
• PyTorch Tutorials: https://lnkd.in/dNUfmaCm

𝟰. 𝗡𝗮𝘁𝘂𝗿𝗮𝗹 𝗟𝗮𝗻𝗴𝘂𝗮𝗴𝗲 𝗣𝗿𝗼𝗰𝗲𝘀𝘀𝗶𝗻𝗴 (𝗡𝗟𝗣)
• RealPython - NLP with spaCy: https://lnkd.in/eqPbFf_d
• NLP Guide Kaggle: https://lnkd.in/eT2DsqdN
• Illustrated Word2vec by Jay: https://lnkd.in/e5wK5yg9
• PyTorch RNN from Scratch: https://lnkd.in/eJWj5fUH
• Understanding LSTMN: https://lnkd.in/ed9ZVBnf

𝟱. 𝗣𝗿𝗼𝗷𝗲𝗰𝘁𝘀
• ML Projects in Python: https://lnkd.in/eC_gG8WH
• Super Duper NLP Repo: notebooks.quantumstat.com

I hope you find this helpful.

Kindly Like, Repost & Comment, if you find it helpful.

Follow Arpit Singh for more...
•
•
hashtag#ai hashtag#llm hashtag#machinelearning hashtag#datascience hashtag#developer

𝐅𝐑𝐄𝐄 𝐂𝐨𝐮𝐫𝐬𝐞𝐬 𝐲𝐨𝐮 𝐰𝐢𝐥𝐥 𝐫𝐞𝐠𝐫𝐞𝐭 𝐧𝐨𝐭 𝐭𝐚𝐤𝐢𝐧𝐠 𝐢𝐧 𝟐𝟎𝟐𝟒

1 Introduction Generative Al
imp.i384100.net/5gNjVj

2. Generative AI with Large Language Models
imp.i384100.net/k0qRez

2 a) React Fundamentals
imp.i384100.net/9gYeRW

2 b) Angular: imp.i384100.net/eKWR9r

2 c) SEO: imp.i384100.net/xkGnW5

3. Generative Adversarial Networks (GANs) Specialization
imp.i384100.net/DKNLPn

4. Introduction to Artificial Intelligence (AI)
imp.i384100.net/QyQKoA

5. AI Engineering
imp.i384100.net/9gYeRy

6. Natural Language Processing Specialization
imp.i384100.net/rQPgZR

7. Deep Learning Specialization
imp.i384100.net/jrL1k5

8. Generative AI for Data Scientists Specialization
imp.i384100.net/k0qReN

9. IBM Data Science Professional Certificate
imp.i384100.net/AWNK91

10. Introduction to Data Science
imp.i384100.net/GmNDek

11. Learn SQL Basics for Data Science
imp.i384100.net/Vm54E3

12. Excel for Business
imp.i384100.net/g1EojB

13. Python for Everybody
imp.i384100.net/B0MKrL

14. Machine Learning Specialization
imp.i384100.net/WqkYnM

15. SQL for Data Science
imp.i384100.net/Vm54E3

Like and Share with your friends and Help Them 😊

#oops #c++ #cpp #interviewquestions #interview #prep #it #cse #cs #systemdesign

Learning Data Structures and Algorithms from scratch

If I had to start learning Data Structures and Algorithms from scratch, I would begin with these 20 articles to get a head start:
1) 𝐓𝐢𝐦𝐞 𝐂𝐨𝐦𝐩𝐥𝐞𝐱𝐢𝐭𝐲: https://lnkd.in/gWDD83fm

2) 𝐁𝐢𝐠-𝐎 𝐂𝐡𝐞𝐚𝐭 𝐒𝐡𝐞𝐞𝐭: https://lnkd.in/gsaAWbSs

3) 𝐒𝐨𝐫𝐭𝐢𝐧𝐠 𝐀𝐥𝐠𝐨𝐫𝐢𝐭𝐡𝐦𝐬: https://lnkd.in/g9npW9JN

4) 𝐋𝐢𝐧𝐤𝐞𝐝 𝐋𝐢𝐬𝐭: https://lnkd.in/gXQux4zj

5) 𝐐𝐮𝐞𝐮𝐞: https://lnkd.in/gJaGSafT

6) 𝐒𝐭𝐚𝐜𝐤𝐬: https://lnkd.in/gBtqxeJH

7) 𝐇𝐚𝐬𝐡 𝐓𝐚𝐛𝐥𝐞𝐬: https://lnkd.in/gCfWr7Eg

8) 𝐇𝐞𝐚𝐩𝐬: https://lnkd.in/gS6SVF5A

9) 𝐑𝐞𝐜𝐮𝐫𝐬𝐢𝐨𝐧: https://lnkd.in/gQiasy8H

10) 𝐁𝐚𝐜𝐤𝐭𝐫𝐚𝐜𝐤𝐢𝐧𝐠: https://lnkd.in/g8Vge2p9

11) 𝐓𝐫𝐞𝐞: https://lnkd.in/gRfmJVDf

12) 𝐁𝐢𝐧𝐚𝐫𝐲 𝐒𝐞𝐚𝐫𝐜𝐡 𝐓𝐫𝐞𝐞: https://lnkd.in/g7QYyVWy

13) 𝐓𝐫𝐢𝐞𝐬: https://lnkd.in/gTp3n4CP

14) 𝐁𝐢𝐧𝐚𝐫𝐲 𝐒𝐞𝐚𝐫𝐜𝐡: https://lnkd.in/gKEm_qUK

15) 𝐆𝐫𝐞𝐞𝐝𝐲 𝐀𝐥𝐠𝐨𝐫𝐢𝐭𝐡𝐦: https://lnkd.in/gUMnuQ26

16) 𝐃𝐲𝐧𝐚𝐦𝐢𝐜 𝐏𝐫𝐨𝐠𝐫𝐚𝐦𝐦𝐢𝐧𝐠: https://lnkd.in/gtXQsyXT

17) 𝐆𝐫𝐚𝐩𝐡 𝐓𝐡𝐞𝐨𝐫𝐲: https://lnkd.in/g9m8wAmp

18) 𝐃𝐅𝐒 𝐓𝐫𝐚𝐯𝐞𝐫𝐬𝐚𝐥: https://lnkd.in/gNKGuY2q

19) 𝐁𝐅𝐒 𝐓𝐫𝐚𝐯𝐞𝐫𝐬𝐚𝐥: https://lnkd.in/g6bSBgz5

20) 𝐃𝐢𝐣𝐤𝐬𝐭𝐫𝐚: https://lnkd.in/gZEp6FMZ

♻️ Repost to help others in your network.

Join 13,001+ readers of my free newsletter to master coding and system design interviews: https://lnkd.in/dXtb8SwU

Learn System Design from scratch

If I had to start learning System Design from scratch, I would begin with these 25 articles to get a head start:

1) Scalability: https://lnkd.in/gx-sPXZm

2) Horizontal vs Vertical Scaling: https://lnkd.in/gAH2e9du

3) Latency vs Throughput: https://lnkd.in/g_amhAtN

4) Load Balancing: https://lnkd.in/gQaa8sXK

5) Caching: https://lnkd.in/gC9piQbJ

6) ACID Transactions: https://lnkd.in/gMe2JqaF

7) SQL vs NoSQL: https://lnkd.in/g3WC_yxn

8) Database Indexes: https://lnkd.in/gCeshYVt

9) Database Sharding: https://lnkd.in/gMqqc6x9

10) Content Delivery Network (CDN): https://lnkd.in/gjJrEJeH

11) Strong vs Eventual Consistency: https://lnkd.in/gJ-uXQXZ

12) Batch Processing vs Stream Processing: https://lnkd.in/g4_MzM4s

13) Concurrency vs Parallelism: https://lnkd.in/gSKUm2Nh

14) Synchronous vs. asynchronous communications: https://lnkd.in/gC3F2nvr

15) Rest vs RPC: https://lnkd.in/gN__zcAB

16) CAP Theorem: https://lnkd.in/g3hmVamx

17) Reverse Proxy: https://lnkd.in/gFwWFDu8

18) Domain Name System (DNS): https://lnkd.in/gkMcZW8V

19) Rate Limiting: https://lnkd.in/gWsTDR3m

20) Redundancy and Replication: https://lnkd.in/gvwQGEiP

21) Fault Tolerance: https://lnkd.in/dVJ6n3wA

22) Failover: https://lnkd.in/dihZ-cEG

23) WebSockets: https://lnkd.in/g76Gv2KQ

24) Microservices Architecture: https://lnkd.in/gFXUrz_T

25) API Design: https://lnkd.in/ghYzrr8q

***

For more System Design resources, check out this GitHub repository: https://lnkd.in/gEVpTZKH

Golden rule of Programming - Don’t code today what you can’t debug tomorrow.

 One of the golden rule of programming is :

💡 Don’t code today what you can’t debug tomorrow.

Below some advices to improve yourself every day :

👉Master Your Tools: Become proficient in the programming languages, frameworks, and tools relevant to your field.

👉Problem-Solving Skills: Develop strong problem-solving skills to efficiently tackle coding challenges.

👉Debugging Proficiency: Sharpen your debugging skills to identify and fix issues quickly.

👉Algorithmic Understanding: Develop a strong understanding of algorithms and data structures for efficient problem-solving.

👉Code Readability: Write clean and readable code; it helps you and others understand and maintain it.

👉Time Management: Prioritize tasks, set deadlines, and manage your time effectively to stay productive.

👉Continuous Learning: Stay updated with industry trends, new technologies, and best practices to enhance your skills.

👉Testing: Embrace testing methodologies to ensure the reliability and correctness of your code.

👉Communication Skills: Effectively communicate with team members, stakeholders, and document technical decisions.

👉Collaboration: Foster a collaborative mindset, sharing knowledge and learning from your peers.

👉Stay Organized: Keep your codebase organized, use consistent naming conventions, and structure your projects logically.

👉Attention to Detail: Pay attention to details to avoid introducing errors and to produce high-quality code.

Efficiency comes from a combination of technical expertise, good practices, and effective collaboration.

Source - Linkedin post

Regular Expressions

Regular Expressions
List of meta characters:

. ---> Any one character
? ---> Zero or one
+ ---> One or more
* ---> zero or more
^ ---> at the beginning of the string
$ ---> at the end of the string
[abc] ---> any one of a b c
{m} ---> 'm' times
{m,n} ---> at least m times, at most n times
| ---> or
\ ---> escape sequence character
\s ---> a space
\d ---> a digit
\w ---> a word
\b ---> a word boundary

examples:
\d ---> a single digit number (0 to 9)
\d\d ---> a two digit number (0 to 99)
\d\d\d ---> a three digit number (000 to 999)

NOTE: ?, +, *, {} are used as Quantifiers (to represent quantity)

\d{3} ---> same as above
\d{3,5} ---> either 3 digit or 5 digit number

hell?o ---> helo | hello
hell+o ---> hello | helllo | helllllo | ...
hrll*o ---> helo | hello | helllo | helllllo | ...
he(ll)+o ---> hello | hellllo | hellllllo | ...

S = "hi hello how are hello"

hello ---> Yes
^hello ---> No
hello$ ---> Yes
\d+ ---> a number
[0123456789]+ ---> a number
[0-9]+ ---> a number
\d{3} ---> a 4 digit ODD number

\d+\s\w+ ---> a number then a space then a word
\d+\s[a-z]+ ---> a number then a space then lowercase word
\d+\s[A-K764]{5,10} ---> a number then a space then min 5 max 10 char uppercase word between A - K 764
\d{3}:\d{2}:\d{4} --->
(ABC)?\d{3}:\d{4}[XYZ]? --->

Go error: go : go.mod file not found in current directory or any parent directory; (working on GOPATH/src)

As of Go 1.16, the GO111MODULE environment variable is treated as "on" by default, meaning Go expects to find a go.mod file, and no longer falls back to pre-module GOPATH behavior.

If you want to go back to the pre-1.16 behavior, you now have to explicitly specify GO111MODULE=auto, but you're far better off creating a go.mod file.

See https://golang.org/doc/go1.16#go-command and https://golang.org/ref/mod

Source - https://stackoverflow.com/questions/67929883/go-error-go-go-mod-file-not-found-in-current-directory-or-any-parent-director