PostgreSQL bilan bog‘lanish (pgx / database/sql)
Initializing search
About me
Python
Telegram bot
Database
Go
System Design
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
Kirish
Kirish
001. SQL(Structured Query Language) haqida
002. Relyatsion ma'lumotlar bazasi
003. NoSql haqida
004. SQL vs NoSQL
005. ACID
MongoDB
MongoDB
000. MongoDB nima?
001. MongoDBdan qachon foydalanish kerak?
002. MongoDB Atlas nima?
003. MongoDB termenalogiyalari
004. BSON vs JSON
005. MongoDBni o'rnatish
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
001. Client-Server Arxitekturasi
002. Request va Response modeli
003. Tarmoq Asoslari
003. Tarmoq Asoslari
OSI modeli
IP protokoli
TCP
UDP
TCP vs UDP
004. HTTP Protokoli
004. HTTP Protokoli
HTTP nima?
HTTP versiyalari
HTTP metodlari
HTTP status kodlari
HTTP headerlari
HTTPS va TLS
005. Amaliy Web Asoslari
005. Amaliy Web Asoslari
CURL bilan so‘rovlar yuborish
CORS nima?
Cookies va Sessionlar
JWT (JSON Web Token)
006. API Dizayni
006. API Dizayni
REST API asoslari
REST API asoslari
007. Protokollar
007. Protokollar
WebSockets va real-time tizimlar
gRPC va zamonaviy RPC
System Design: Asosiy tushunchalar
System Design: Asosiy tushunchalar
Vertical, Horizontal scaling. Load balancer.
Database replication, scaling
Caching
Content delivery network (CDN)
Stateful architecture
Data centers
Message queue
Logging, metrics, automation
Rate limiting
Blog
PostgreSQL bilan bog‘lanish (pgx / database/sql)