Python database programming isn’t just about writing queries, it’s also about understanding the right tools. From sqlite3 to MySQL and PostgreSQL (via mysql-connector-python and psycopg2), and even NoSQL with pymongo, each plays an important role. You also need a basic understanding of SQLAlchemy and pandas. In this article, I’ve combined all these concepts into a set of 100 Python SQL & Database MCQs, helping you prepare for your upcoming interviews or exams. 100 Python SQL & Database MCQs Each of these 100 Python SQL & Database MCQs covers a key concept. Master them, and you’ll be interview-ready. Q1. Which built-in…
Author: drweb
Your on-call phone rings at 2 AM. Application timeouts are climbing and someone is already asking for updates in the incident channel. You open one dashboard. Then another. Then a cloud portal. Then the legacy monitoring tool nobody wanted to retire. Forty minutes later you are still figuring out which SQL Server instance is actually responsible. Meanwhile, the LCK_M_S wait chain has quietly been building for an hour. Let us talk about SQL Server Monitoring Across Cloud, Hybrid, and On-Prem. This is not a tooling problem. Most teams have tools. It is a visibility problem. And it becomes painfully obvious…
Agentic AI is rapidly entering DevOps pipelines, platform engineering platforms and cloud-native infrastructure. DevOps Experience 2026 brings the community together to decide which tools matter, how they should be governed and what comes next. The DevOps ecosystem is entering one of its most consequential transitions since the rise of CI/CD. Across the industry, vendors are racing to introduce agentic AI systems designed to automate DevOps workflows. These systems promise to assist with everything from pipeline orchestration and incident response to infrastructure management and security remediation. The promise is compelling: faster delivery, less operational toil and smarter automation. But alongside that…
A critical vulnerability in a popular Microsoft GitHub repository could allow a threat actor to easily exploit its CI/CD infrastructure to run arbitrary code in the repository and gain access to secrets, according to researchers with cybersecurity firm Tenable. In an advisory issued April 21, Rémy Marot, staff research engineer at Tenable, wrote that “by exploiting this vulnerability, an attacker with an unprivileged GitHub account could exfiltrate secrets available to the workflow run and perform unauthorized operations on the target GitHub repository.” The security flaw can be easily exploited, and illustrates the growing security risks as CI/CD pipelines play an…
Images and NumPy arrays are closely related in Python. An image is fundamentally a grid of pixel values, and NumPy makes it easy to work with that grid directly. Whether you are building a machine learning pipeline or just need to manipulate pixels, converting an image to a NumPy array is the first step. Different Python libraries read images in different ways. Each approach produces a slightly different array shape, dtype, and value range. Here is how the four most common methods compare. TLDR Pillow + NumPy – best for general use, no extra dependencies OpenCV – fastest for bulk…
Every once in a while, the platform drops something that makes you want to build strange demos again, or at least weirder ones. The new HTML in Canvas API is a perfect example of one of those moments. The promise is simple and exciting: take native HTML, render it into canvas workflows, and then apply visual effects with 2D Canvas, WebGL, or WebGPU. In other words, you can keep real semantic elements in your markup while treating their rendered output as pixels. Support Status (Important) To enable it, go to chrome://flags/#canvas-draw-element and turn on the “Canvas Draw Element” flag. After…
I keep coming back to encryption whenever I need to secure API keys, store sensitive config, or send data between services. Python makes this surprisingly approachable, and in this guide I’ll walk through building an encryption program from scratch. We’ll cover the basics of cryptography, why encryption matters in 2026, and three different approaches you can use today. By the end, you’ll have a working encryption tool and a clear picture of when to use each method. TLDR Python’s cryptography module is the standard for secure encryption Fernet (symmetric encryption) works best for most practical applications Never roll your own…
The Eclipse Foundation today announced it will make available a managed instance of the Open VSX Registry available to industry partners for a fee. Thabang Mashologu, chief marketing officer and head of products at the Eclipse Foundation, said the Open VSX Managed Registry provides an economically sustainable approach to providing access to a registry that is now widely invoked within application development workflows that incorporate tools based on open source VS Code. Initial customers of the Open VSX Managed Registry include Amazon Web Services (AWS), Google, and Cursor, which will continue to incorporate the registry in the services they provide…
Flappy Bird started as a mobile game where you tap to make a bird fly through gaps in pipes. The bird falls with gravity, and each tap gives it an upward push. Hit a pipe or the ground, and the game ends. I remember wasting way too much time on this game back in 2013, and building a clone of it in Python was one of the first game projects I ever completed. There is something satisfying about getting the physics just right so the bird feels responsive but still challenging. In this tutorial, I walk through building a complete…
Coolify is an open-source, self-hosted platform that deploys web apps, databases, and services on your own server without the monthly bills of Heroku, Vercel, or Railway, and this guide walks through installing it on a fresh Linux server, connecting a domain, and deploying your first app with git push. Most developers pay 20 to 200 dollars a month for a platform that runs on a server they will never see, configured by a team they will never meet, on pricing that keeps going up every quarter. Coolify puts that same workflow on a 5 dollar VPS you already own, with…