how does aws build system work?
➖➖➖➖➖➖➖➖➖
🕊 @gopher_academy

📡دورد به همگی دوستان

❤️کسی اگر دوس داره اشتراک دانش داشته باشه (گولنگ)

و اون رو توی چنل مون برای همه به اشتراک بزاره کافی به من پیام بده 👇🏼

〽️ @mrbardia72

#admin

➖➖➖➖➖➖➖➖➖
🕊 @gopher_academy

How is a SQL statement executed in the database?
➖➖➖➖➖➖➖➖➖
🕊 @gopher_academy
👇🏼👇🏼👇🏼👇🏼👇🏼

Step 1 - A SQL statement is sent to the database via a transport layer protocol (e.g.TCP).

Step 2 - The SQL statement is sent to the command parser, where it goes through syntactic and semantic analysis, and a query tree is generated afterward.

Step 3 - The query tree is sent to the optimizer. The optimizer creates an execution plan.

Step 4 - The execution plan is sent to the executor. The executor retrieves data from the execution.

Step 5 - Access methods provide the data fetching logic required for execution, retrieving data from the storage engine.

Step 6 - Access methods decide whether the SQL statement is read-only. If the query is read-only (SELECT statement), it is passed to the buffer manager for further processing. The buffer manager looks for the data in the cache or data files.

Step 7 - If the statement is an UPDATE or INSERT, it is passed to the transaction manager for further processing.

Step 8 - During a transaction, the data is in lock mode. This is guaranteed by the lock manager. It also ensures the transaction’s ACID properties.
➖➖➖➖➖➖➖➖➖
🕊 @gopher_academy

#کدبوک

برای اندازه گیری ریسک و کنترل این کتاب رو توصیه میکنم

#DevTwitter | <Alireza/>
➖➖➖➖➖➖➖➖➖
🕊 @gopher_academy

اینم فایل پی دی اف کتاب
How to Measure Anything in Cybersecurity Risk
➖➖➖➖➖➖➖➖➖
🕊 @gopher_academy

Junior dev: My code is simple and easy to understand.

Mid-level dev: My code is subtle, clever, innovative, expressive, hyper-optimized, and ingenious.

Senior dev: My code is simple and easy to understand.

➖➖➖➖➖➖➖➖➖
🕊 @gopher_academy

#remote #job

looking for a Senior Software Engineer that has a depth of software development/engineering experience and proficient at using languages such as Golang, Java, and C++.

Salary: 180k € in year

Anton Testa
Talent Researcher @ Spectrum Search
[email protected]
+44 (0) 7849 703 103
+44 (0) 2034 686 977

➖➖➖➖➖➖➖➖➖
🕊 @gopher_academy

فایل صوتی دورهمی
➖➖➖➖➖➖➖➖➖
🔰@gopher_academy

چت ها
➖➖➖➖➖➖➖➖➖
🔰@gopher_academy

دورهمی هفته چهارم

موضوع: الگو Saga برای پیاده سازی معماری تراکنش محور
فایل ها: ویدئو - صوتی - چت

دوستان از طریق Spotify و Google Podcasts و همچنین castbox می توانید جلسه چهارم دورهمی را گوش دهید.

🔗 https://open.spotify.com/show/6aQdgKiOF5tuzI7mpijlfj

🔗 https://podcasts.google.com/feed/aHR0cHM6Ly9hbmNob3IuZm0vcy9kZGY3OWRiNC9wb2RjYXN0L3Jzcw

🔗 https://castbox.fm/va/5381928


➖➖➖➖➖➖➖➖➖
🔰@gopher_academy