Db replication scaling
Initializing search
About me
Python
Telegram bot
Database
Go
System Design
DSA
Blog
Farruxnet
About me
Python
Python
001. Birinchi modul
001. Birinchi modul
Pythonda birinchi dasturimiz
O'zgaruvchilar
Ma'lumot turlari
Operatorlar
Izohlar
Ekrandan ma'lumot kiritish
Matematik kutubxona
Vazifalar
002. Ikkinchi modul
002. Ikkinchi modul
Matnlar: strings
Mantiqiy toifalar: Booleans
If, else operatori
Vazifalar
003. Uchinchi modul
003. Uchinchi modul
For sikl operatori
While sikl operatori
Break va Continue
pass haqida
Vazifalar
004. To'rtinchi modul
004. To'rtinchi modul
Ro'yxatlar
Kortej
Set
Lug'atlar
005. Beshinchi modul
005. Beshinchi modul
Funksiyalar
Lambda: Nomsiz funksiya
Modullar
Misollar
006. Oltinchi modul
006. Oltinchi modul
OOP
Class va object
Object va method
Class method
Static method
Property
Vorislik: inheritance
Vazifalar
007. Yettinchi modul
007. Yettinchi modul
Pythonning standart kutibxonalari: os, sys, datetime...
Vazifalar
Json bilan ishlash
Xatolarni boshqarish: try...except
Tashqi so'rovlar: requests
Vazifalar
008. To'qqizinchi modul
008. To'qqizinchi modul
Fayllar bilan ishlash: open
Fayllar bilan ishlash: write
Fayllar bilan ishlash: read
Fayllar bilan ishlash: delete
Vazifalar
009. Python advanced
009. Python advanced
Sync va Async
Telegram bot
Telegram bot
001. BotFather bilan tanishuv
002. Python muhitini sozlash
003. Hello world
004. Polling va Webhook
005. Telegram message
006. Xabarga javob berish(reply)
007. Xabarlarni formatlash(parse mode)
008. Xabar turlari(text, photo)
009. Rasm yuborish
010. Fayl yuborish
011. Video va Audio xabar yuborish
012. Manzil(location) yuborish
013. Xabarni taxrirlash(edit message)
014. Klavyatura(keyboard)
015. Inline klavyatura(inline keyboard)
016. Manzil olish(location)
017. Telefon raqamni ulashish (contact)
Database
Database
Relatsion ma'lumotlar ombori
Relatsion ma'lumotlar ombori
MOBT(DBMS) nima va uning vazifalari
Relatsion model nima?
Jadval, satr, ustun tushunchasi
Asosiy va tashqi kalit
Normallashtirish formalari (1NF, 2NF, 3NF)
Saqlash mexanizmi
Saqlash mexanizmi
Ma'lumotlar diskda qanday saqlanadi?
Page va Block tushunchasi
Page layout qanday ishlaydi?
Row format
Disk I/O va Database ishlashi
Buffer Pool nima?
Indexlar
Indexlar
Index nima va nima uchun kerak?
B-Tree index qanday ishlaydi?
Clustered vs Non-Clustered Index
Composite Index
Covering Index
Transactions va Concurrency
Transactions va Concurrency
Transaction nima?
ACID: Ishonchning 4 ustuni
Isolation darajalari
Dirty Read, Non-repeatable Read, Phantom Read
Locking qanday ishlaydi?
MVCC nima?
Deadlock qanday yuz beradi?
Qayta tiklash
Qayta tiklash
Write Ahead Log (WAL)
Checkpoint nima?
Crash Recovery qanday ishlaydi?
So'rovlarni qayta ishlash
So'rovlarni qayta ishlash
SQL qanday ishlaydi?
SELECT so'rovi qanday bajariladi?
JOIN qanday ishlaydi?
Query planner nima?
Execution plan nima?
Kengayish
Kengayish
Replication nima?
Partitioning nima?
Sharding nima?
CAP teoremasi
PostgreSQL
PostgreSQL
PostgreSQL nima va qachon ishlatiladi?
PostgreSQL arxitekturasi
Process va Memory modeli
WAL va Crash Recovery
MVCC PostgreSQL'da
Indekslar: B-Tree va Hash
Query planner va execution plan
VACUUM va Autovacuum
Locking va Concurrency
Replication va High Availability
Partitioning
Performance
Go
Go
001. Birinchi dasturimiz
002. O'zgaruvchilar
003. Operatorlar
004. Konsoldan ma'lumot kiritish
005. Matematik misollar
006. Shart operatori(if, else, if else)
007. Tanlash operatori(switch case)
008. Sikl operatori(for loop)
009. Misollar
010. Strings funksiyalari
011. Array ma'lumot turi va Make
012. Slice ma'lumot turi
013. Map ma'lumot turi
014. Ko'rsatkichlar(pointers)
015. Funksiyalar
015. Funksiyalar
Funksiyalar
Funksiya va ko'rsatkichlar
016. Structs, Interface, Method
016. Structs, Interface, Method
Structs
Method
Interface
017. Enums
018. Generics
019. defer, panic va errors
020. Tashqi kutubxonalar(packages)
021. Goda modullar
022. Concurrency and Parallalism
022. Concurrency and Parallalism
Parallel dasturlash
Goroutine
Wait group
023. Channels
023. Channels
Kirish
Turlari
Select
WorkerPool
024. Mutex
025. Goda sana va vaqt bilan ishlash
026. Fayllar bilan ishlash
026. Fayllar bilan ishlash
Fayllar
Kataloglar
Embed
027. Go standart paketlari
027. Go standart paketlari
Random paketi
Hashing(md5, base64 ...)
RegEx
Environment o'zgaruvchilari
028. Go da API va so'rovlar
028. Go da API va so'rovlar
Web server nima?
API nima?
API ga so'rov yuborish
029. Go'da API qurish (server tomoni)
029. Go'da API qurish (server tomoni)
net/http paketining tuzilishi
http.HandleFunc va http.ListenAndServe
ResponseWriter va *Request obyektlari
URL routing
URL va query parametrlar bilan ishlash
Loyiha: CRUD
Middleware
Middleware
Logging
Logging middleware
Request timing va error handler middleware
Handlerlarni modullarga ajratish (clean architecture)
JSON bilan Ishlash
JSON bilan Ishlash
encoding/json asoslari
Request body parsing
Response struct formatlash
Validation (go-playground/validator)
Xatoliklarni standart formatda qaytarish
Ma'lumotlar Bazasi
Ma'lumotlar Bazasi
Ma'lumotlar Bazasi va Xavfsiz So‘rovlar
PostgreSQL bilan bog‘lanish (pgx / database/sql)
Context bilan ishlash
SQL Injection oldini olish
Parollarni xeshlash (bcrypt)
Config va .env bilan ishlash
Authentication
Authentication
Authentication — From Scratch
Authentication nima?
Session va Token-based auth farqi
Login / Signup endpointlari
JWT yaratish va tekshirish
Auth middleware yozish
Authorization
Authorization
Authorization — Access nazorati
Authorization nima?
RBAC
Resource-based permission modeli
Middleware orqali ruxsat tekshirish
401, 403 va 500 statuslar
Routing (gorilla/mux)
Routing (gorilla/mux)
gorilla/mux bilan Routing"
Framework kerakmi?
mux bilan router yaratish
Path parametrlari
Subroutes
Middleware integratsiyasi
Gin Framework
Gin Framework
gin Framework bilan Tezkor API Yaratish
gin arxitekturasi
Request binding
JWT middleware
Error handling
Performance
HTTPS va TLS
HTTPS va TLS
HTTPS va TLS
HTTPS nima
Self-signed sertifikat
TLS konfiguratsiyasi
Let's Encrypt
HTTP → HTTPS majburlash
Xavfsizlik
Xavfsizlik
Xavfsizlik Tahdidlari va Himoya
CSRF & XSS
Input sanitizatsiyasi
Brute-force himoya
Rate limiting (Redis)
Security headers & CORS
System Design
System Design
Kompyuter Asoslari
Kompyuter Asoslari
Kompyuter qanday ishlaydi?
CPU (Markaziy protsessor)
RAM (Tezkor xotira)
Doimiy xotira(Disk)
Operatsion tizim (OS), Process, Thread, Scheduling
Web: Internet, IP, Domain, DNS
Client-Server Arxitekturasi
Request va Response modeli
Tarmoq Asoslari va HTTP
Tarmoq Asoslari va HTTP
OSI modeli
IP protokoli
TCP
UDP
TCP va UDP
HTTP protokoli
API Dizayni
API Dizayni
REST API
GraphQL
WebSockets
gRPC va RPC
Masshtablash va samaradorlik
Masshtablash va samaradorlik
Vertikal va gorizontal kengayish
Stateful va Stateless arxitektura
Load Balancer
CDN (Content Delivery Network)
Avto kengayish
Rate Limiting va Throttling
Ma'lumotlar omborlari
Ma'lumotlar omborlari
Ma'lumotlar ombori nima?
Transaction va ACID
Relatsion ma'lumotlar ombori
Indexlar va Query Optimizer
Replication va Sharding
NoSQL ma'lumotlar ombori
Graph va Time-series ma'lumotlar ombori
Caching(TTL, E-Tag, Jitter, eventual consistency
Asynchronous va Event-driven tizimlar
Asynchronous va Event-driven tizimlar
Event-driven tizim
Message queues (Kafka, RabbitMQ)
Pub/Sub
Monitoring va Observability
Monitoring va Observability
Logging, Metrics, Tracing
Alerting va SLA/SLO
DSA
DSA
Algoritm
Kompyuter
Big-O
Array
String
Blog
Db replication scaling