🚀 Built my first CRUD API using FastAPI + MySQL and deployed it on Render! 🌐 Live URL: https://lnkd.in/gHKJaCXx Today I created a REST API with full CRUD operations using Python (FastAPI) and MySQL as the database, and deployed it using Render. What I built: ✔ GET → Read data from MySQL   ✔ POST → Insert data into MySQL   ✔ PUT → Update existing records   ✔ DELETE → Remove records from MySQL  Deployment: 🌐 Hosted on Render This project helped me understand how backend systems work in real-world applications—from API design to database integration and deployment. Key learnings: - REST API design principles   - CRUD operations with MySQL   - FastAPI backend development   - Deploying applications on Render  It’s a simple project, but it reflects real-world backend architecture. Next step: add authentication and improve security. #Python #FastAPI #MySQL #CRUD #BackendDevelopment #Render #Deployment #RESTAPI

How to Run Self-Hosted Link-in-Bio Tool with #LinkStack on #AlmaLinux #VPS This article provides a guide for how to run self-hosted Link-in-Bio tool with LinkStack on AlmaLinux VPS. How to Run Self-Hosted Link-in-Bio Tool with LinkStack on AlmaLinux VPS This guide walks you through installing and running LinkStack, a free and open-source alternative to Linktree, on an AlmaLinux VPS. What is LinkStack? 🔗 LinkStack is a self-hosted, open-source link sharing platform that allows users ... Keep Reading 👉 https://lnkd.in/gR5RiGMZ #composr #selfhosting #letsencrypt #opensource #python #laravel #selfhosted

How to Run Self-Hosted Link-in-Bio Tool with #LinkStack on #AlmaLinux #VPS This article provides a guide for how to run self-hosted Link-in-Bio tool with LinkStack on AlmaLinux VPS. How to Run Self-Hosted Link-in-Bio Tool with LinkStack on AlmaLinux VPS This guide walks you through installing and running LinkStack, a free and open-source alternative to Linktree, on an AlmaLinux VPS. What is LinkStack? 🔗 LinkStack is a self-hosted, open-source link sharing platform that allows users ... Keep Reading 👉 https://lnkd.in/gbXQ9hNb #letsencrypt #opensource #selfhosting #selfhosted #laravel #composr #python

𝐖𝐡𝐚𝐭 𝐢𝐟 𝐲𝐨𝐮 𝐧𝐞𝐯𝐞𝐫 𝐡𝐚𝐝 𝐭𝐨 𝐰𝐫𝐢𝐭𝐞 𝐫𝐚𝐰 𝐒𝐐𝐋 𝐚𝐠𝐚𝐢𝐧? That's Django's ORM (Object-Relational Mapper) in a nutshell. An ORM lets you interact with your database using Python instead of SQL. You define your data as Python classes (called models), and Django handles the database queries behind the scenes. Here's a simple example: Instead of writing: SELECT * FROM blog_post WHERE author_id = 1; You write: Post.objects.filter(author_id=1) Same result. Pure Python. No SQL dialect to worry about. What makes the Django ORM powerful: → Works with PostgreSQL, MySQL, SQLite, Oracle. Same code, different DB → Migrations: Change your model, run a command, database updates automatically → Querysets that are chainable, lazy, and incredibly readable → Relationships like ForeignKey, ManyToMany, OneToOne, all handled elegantly I've worked with Oracle 19c and PostgreSQL in production. The ORM made switching between them painless which required just a config change. The caveat? For very complex queries, raw SQL is still available. The ORM doesn't replace SQL knowledge. It reduces how often you need it. If you're building data-heavy apps, learning the Django ORM deeply is one of the best investments you can make. Tomorrow: Django REST Framework, turning Django into an API powerhouse. #Django #ORM #Python #BackendDevelopment #Database

🌐 Backend Series #1: How I actually understood HTTP/HTTPS When I was in Pre University, I had just learned HTML. Like most beginners, I used to tweak existing web pages, create my own .html files, and proudly show them to friends 😄 One day I had a simple question: 👉 “Why can’t I save this somewhere so my friends can open it from their own laptops?” That curiosity changed everything. I started exploring… found Python… and discovered something called a simple HTTP server. With one command, I could “host” my HTML file. And suddenly… 👉 My friends on the same Wi-Fi (LAN) could open it in their browsers. That’s when it clicked: 💡 My laptop became a server 💡 Their browsers became clients 💡 And something was enabling this communication… 👉 That something is HTTP 📦 So what exactly is HTTP? HTTP is just a set of rules for communication between: • Client (browser) • Server (my laptop running that Python server) When my friend typed: http://192.168.x.x:8000 Their browser sent a request like: 👉 “Hey, give me that HTML file” My server responded with: 👉 “Here it is” That’s HTTP. Simple request → response. 🔧 HTTP Methods (what kind of request?) As I learned more, I realized not all requests are the same: • GET → “Give me this file/data” • POST → “I’m sending you new data” • PUT → “Replace existing data completely” • PATCH → “Update just a part of it” • DELETE → “Remove this data” 💡 In my early setup, I was using GET without even realizing it 😄 📬 Status Codes (how server responds) • 200 OK → Worked perfectly ✅ • 404 Not Found → File missing ❌ • 500 Server Error → Something broke 💥 Back then it felt random… now it’s predictable. 🔒 Where HTTPS comes in In my LAN setup, everything was open. Anyone on the network could see the data being transferred. 👉 That’s HTTP Now imagine sending: • Passwords • Personal data • Payments That’s where HTTPS comes in: 👉 HTTP + Encryption (SSL/TLS) So even if someone intercepts the data, they can’t read it. 🚀 What this really means That small experiment taught me: • A server is just a responder • A browser is just a requester • And the entire internet runs on this simple exchange HTTP is how the internet talks. HTTPS is how it protects that conversation. #Backend #HTTP #WebDevelopment #CodingJourney #SystemDesign #Developers

How to Run Self-Hosted Link-in-Bio Tool with #LinkStack on #AlmaLinux #VPS This article provides a guide for how to run self-hosted Link-in-Bio tool with LinkStack on AlmaLinux VPS. How to Run Self-Hosted Link-in-Bio Tool with LinkStack on AlmaLinux VPS This guide walks you through installing and running LinkStack, a free and open-source alternative to Linktree, on an AlmaLinux VPS. What is LinkStack? 🔗 LinkStack is a self-hosted, open-source link sharing platform that allows users ... Keep Reading 👉 https://lnkd.in/gNAh3Sn2 #laravel #opensource #letsencrypt #selfhosted #python #selfhosting #composr

How to Run Self-Hosted Link-in-Bio Tool with #LinkStack on #AlmaLinux #VPS This article provides a guide for how to run self-hosted Link-in-Bio tool with LinkStack on AlmaLinux VPS. How to Run Self-Hosted Link-in-Bio Tool with LinkStack on AlmaLinux VPS This guide walks you through installing and running LinkStack, a free and open-source alternative to Linktree, on an AlmaLinux VPS. What is LinkStack? 🔗 LinkStack is a self-hosted, open-source link sharing platform that allows users ... Keep Reading 👉 https://lnkd.in/gNAh3Sn2 #selfhosting #selfhosted #laravel #opensource #python #letsencrypt #composr

How to Run Self-Hosted Link-in-Bio Tool with #LinkStack on #AlmaLinux #VPS This article provides a guide for how to run self-hosted Link-in-Bio tool with LinkStack on AlmaLinux VPS. How to Run Self-Hosted Link-in-Bio Tool with LinkStack on AlmaLinux VPS This guide walks you through installing and running LinkStack, a free and open-source alternative to Linktree, on an AlmaLinux VPS. What is LinkStack? 🔗 LinkStack is a self-hosted, open-source link sharing platform that allows users ... Keep Reading 👉 https://lnkd.in/gfn9vXYc #letsencrypt #opensource #composr #selfhosting #python #selfhosted #laravel

PyAdminer Tired of fighting phpMyAdmin—or lugging a heavy desktop client—just to work with MySQL? I’ve been building PyAdminer: a lightweight Python + Flask web UI for MySQL and MariaDB. Think Adminer-style browsing and editing, with extras for day-to-day database work. Here’s what stands out: → Built-in optional AI: natural language → suggested SQL (configurable, can be turned off). → Full database and table workflows—structure with indexes and foreign keys, filters, and safe edit/delete using real primary keys (including composite keys). → A SQL command panel, plus an optional AI assistant that suggests SELECT queries from plain English. You choose the provider in settings; admins can turn it off entirely. → Visualize tab: column profiles, charts (categorical, time series, scatter), and pivots. → Impact, Quality, and Diff views—foreign-key relationships, duplicate keys, orphan checks, and table comparison. → A rich data grid: numeric heatmaps, plus expanders for JSON and long text. → ER diagrams (Mermaid), plus an Advanced panel for views, routines, triggers, and events. → Exports to CSV and SQL, optional read-only mode, HTTP Basic Auth, rate limits, an audit log, and a /health endpoint for monitoring. MIT licensed. Easy to self-host—including Docker for a quick local stack. If you live in dashboards and terminals, this might cut a few context switches. Repository: https://lnkd.in/g5Nd8Fsy Stars, issues, and pull requests welcome—I’d love more eyes on MySQL/MariaDB tooling in open source. #OpenSource #Python #Flask #MySQL #MariaDB #DatabaseTools #DevOps

Your queryset works. But your database is doing the heavy lifting. Most Django developers treat QuerySets like simple Python objects. Chain filters, loop over results, and ship it. But under the hood, every queryset translates into SQL executed by PostgreSQL (or your database). Inefficient queries, N+1 problems, and unnecessary evaluations don’t show up in code, they show up in performance, latency, and load. The real issue is not writing queries. It’s understanding when they execute, how many times they execute, and what SQL they generate. Methods like select_related, prefetch_related, and proper indexing are not optimizations—they are baseline requirements once your data grows. Ignoring them turns a working API into a slow system under real traffic. If you don’t know what SQL your queryset generates, are you really in control of your backend? #Django #QuerySet #BackendEngineering #Performance