#savol#savol djangoda qilingsan web saytlar bor 50 60ta ularni hammasiga bir xil ma'lumot qoshiladi. shu saytlarga bitta bitta yangilik qoshmasdan birdaniga hammasiga qoshiladigan qilsa boladimi

#savol

Ko'pchilik vakansiyalarda Django va birorta SQL yozilgan bo'ladi.

Django ORM turganda SQL o'rganishim kerakmi?

Misol uchun Postgresql ni o'rgansam uning men uchun pro taraflari nima buladi.

Yoki SQL ni shunchaki ORM qanday ishlayotganligi haqida tasavvurga ega bo'lish uchun o'rganishim kerakmi?

#savol
Assalomu alaykum database transaction haqida tushunarliroq ma'lumot kerak edi.

#savol
topSkills = profile.skill_set.exclude(descriptionexact="") shu kodda "exact" ni vazifasi nima ?

#savol GIL O'zi nima kim qanday malumotga ega tushuncha berib yuboringlar menda internet tezligi 13 B/s Google ning ochaolmayabman iltimos😢🧐😊

#savol
Assalomu alaykum, hammaga!

Postgresqlda replikatsiya bo'yicha savol:

replikatsiyani maqsadi performance'ni oshirish ya'ni yagona serverga yuklama ortib ketib, uni ishlashi sekinlashmasligi uchun ishlab chiqilgan desak, master-slave o'rtasida sinxronizatsiya paytidagi jarayon(masterdan slave'ga yozuv yozish) performance'ga qanchalik ta'sir qiladi?

#savol
Webhook nima va qanday qulayliklar yaratib beradi?

#savol

database_sync_to_async(Profile.objects.get)(user=user)

Nega user=user ni get dan tashqarida yozildi?

#savol #pycache
Assalomu alaykum, _pycache_ fayllar nega kerak, vazifasi nima?

#savol
Can anybody explain in simple words to me
What does INCLUDE does in CREATE INDEX?

#savol
Djangoda fayllarni to'g'ridan-to'g'ri DBda saqlash mumkinmi?
Buning qanday kamchiliklari bor?
*qisqartirildi

#savol

Shu error nimadan kelib chiqvoti?

psycopg2.InterfaceError: connection already closed

#savol

FastAPI nima?
U ham REST APIning bir qismimi?
Ikkalasining farqi nima?

#savol
Webhook nima va qanday qulayliklar yaratib beradi?

#savol

FastAPI nima?
U ham REST APIning bir qismimi?
Ikkalasining farqi nima?

#savol
Why HTTP/3 uses UDP instead of TCP?

#javob
I think the main reason why HTTP/3 (which uses QUIC) is built on top of UDP instead of TCP is to solve the problem with lost packets in HTTP/2.

One of the biggest problems with h2 is that streams (a logical communication for a single request) are not fully independent from each other. Since the TCP retransmission works on layer 4 of the OSI model but h2 itself is implemented on layer 7, the TCP connection has no knowledge of h2 streams. So if a single TCP packet is missing in one of the streams, TCP blocks the entire connection (thus, all the streams on it) till the missing packet is retransmitted successfully.
That means, if I try to send 10 request at the same time over h2 and if any of them fails to reach, all 10 requests are blocked. This is called HOL blocking, but on the transport layer.

HTTP/3 solves this problem by using QUIC, which is built on top of UDP. Since UDP does not guarantee delivery of data, it has no retransmission mechanism. QUIC has its own recovery mechanism that guarantees delivery. Unlike TCP, this recovery mechanism works on the same layer as the QUIC streams and knows which packet belongs to which stream. That's why if any packet is lost, the recovery mechanism blocks only the stream that packet belongs to. It does not affect other streams.

#savol
Can anybody explain in simple words to me
What does INCLUDE does in CREATE INDEX?