Databases
Working with Databases in Python: SQLite and SQLAlchemy
Most applications need to store data persistently, and databases are the standard solution. Python has built-in support for SQLite, a lightweight, file-bas…
Stories Worth Reading
PixelProse is your go-to blog for insightful articles on Technology, Travel, Food, Health, Lifestyle, Business, Fashion and Sports. Fresh perspectives. Real stories. Zero fluff.
Results for "cloud database"
106 articles found
Databases
Most applications need to store data persistently, and databases are the standard solution. Python has built-in support for SQLite, a lightweight, file-bas…
AWS
Aurora is a MySQL and PostgreSQL-compatible database built for the cloud. It offers better performance than standard RDS—up to 5x for MySQL and 3x for Po…
Google Cloud Platform
It was 3 AM on a Tuesday. I was tired, running a script I thought was pointed at my test environment. One wrong click. One mistyped command. And just like…
Google Cloud Platform
It was 3 AM on a Tuesday. I was tired, running a script I thought was pointed at my test environment. One wrong click. One mistyped command. And just like…
AWS
Relational Database Service takes the pain out of database administration. Before RDS, I spent weekends managing backups and patching. With RDS, AWS handle…
Google Cloud Platform
Okay, hear me out. I love GitHub. I have a paid account. But for my work projects on GCP, I started using Cloud Source Repositories. The integration is sea…
Google Cloud Platform
Okay, hear me out. I love GitHub. I have a paid account. But for my work projects on GCP, I started using Cloud Source Repositories. The integration is sea…
Google Cloud Platform
I have a problem: I start too many side projects. But I also have a solution: Google Cloud Functions. Need a webhook? Cloud Function. Need to process an im…
Google Cloud Platform
I have a problem: I start too many side projects. But I also have a solution: Google Cloud Functions. Need a webhook? Cloud Function. Need to process an im…
Google Cloud Platform
I used to find out my app was down when users emailed me. Hours of downtime. Angry customers. Panicked debugging. Then I set up Cloud Operations (formerly…
Google Cloud Platform
I had this app idea. A travel planner that uses AI to generate itineraries. Big dreams, no money. I decided to build it on Google Cloud. I used Cloud Run f…
Google Cloud Platform
I used to find out my app was down when users emailed me. Hours of downtime. Angry customers. Panicked debugging. Then I set up Cloud Operations (formerly…
Google Cloud Platform
I came into GCP knowing nothing. No cloud experience. No infrastructure background. Just a developer who wanted to deploy an app. Month one was chaotic. I…
Google Cloud Platform
I came into GCP knowing nothing. No cloud experience. No infrastructure background. Just a developer who wanted to deploy an app. Month one was chaotic. I…
Google Cloud Platform
I had this app idea. A travel planner that uses AI to generate itineraries. Big dreams, no money. I decided to build it on Google Cloud. I used Cloud Run f…
AWS
DynamoDB is a fully managed NoSQL database with seamless scalability. I was used to relational databases, but DynamoDB's key-value and document model took…
Database
Choosing the right database is one of the most important decisions in web development. SQL databases like PostgreSQL and MySQL store data in structured tab…
Database
PostgreSQL has become the database of choice for web development, but many developers only scratch the surface of its capabilities. Beyond basic SELECT que…
Google Cloud Platform
Cloud Scheduler is technically for triggering Cloud Functions or HTTP endpoints. But I've started using it for everything. I have a scheduler job that call…
Google Cloud Platform
Cloud Scheduler is technically for triggering Cloud Functions or HTTP endpoints. But I've started using it for everything. I have a scheduler job that call…
Google Cloud Platform
I had a weekly task: process 50,000 user records, generate reports, and send emails. I used to run this on a small VM. It would run for an hour every Sunda…
Technology
Cloud gaming is poised to disrupt the video game industry by decoupling high-end gaming from expensive consoles and PCs. Services like Xbox Cloud Gaming, N…
Google Cloud Platform
I had a weekly task: process 50,000 user records, generate reports, and send emails. I used to run this on a small VM. It would run for an hour every Sunda…
Google Cloud Platform
I had 10,000 files on an old FTP server. They were disorganized, poorly named, and scattered across folders. Moving them to Google Cloud Storage seemed dau…
Google Cloud Platform
I had 10,000 files on an old FTP server. They were disorganized, poorly named, and scattered across folders. Moving them to Google Cloud Storage seemed dau…
Google Cloud Platform
I was storing years of old backups, logs, and user uploads in standard Cloud Storage buckets. My bill was growing every month. Then I discovered storage cl…
AWS
A Virtual Private Cloud is your isolated section of the AWS cloud. It's like having your own data center with complete control over networking. I found VPC…
Google Cloud Platform
I was storing years of old backups, logs, and user uploads in standard Cloud Storage buckets. My bill was growing every month. Then I discovered storage cl…
Google Cloud Platform
I tried Jenkins. I tried GitLab CI. I tried GitHub Actions. They all worked, but they all felt like they required configuration YAML that was more complex…
Google Cloud Platform
I tried Jenkins. I tried GitLab CI. I tried GitHub Actions. They all worked, but they all felt like they required configuration YAML that was more complex…
Web Development
Django is a high-level web framework that encourages rapid development and clean, pragmatic design. It includes many built-in features that Flask does not…
Databases
When I first learned SQL, I loved it. But mapping SQL results to Java objects manually with JDBC is tedious. That’s where JPA (Java Persistence API) and…
Google Cloud Platform
We've all done it. Hardcoded API keys in config files. Committed them to Git. Then scrambled to revoke them when you realize the repo is public. I was guil…
Google Cloud Platform
We've all done it. Hardcoded API keys in config files. Committed them to Git. Then scrambled to revoke them when you realize the repo is public. I was guil…
Google Cloud Platform
I used to ignore VPC networks. I'd just use the default network and let everything talk to everything. It was easy. It was also dangerous. One misconfigure…
Google Cloud Platform
I used to ignore VPC networks. I'd just use the default network and let everything talk to everything. It was easy. It was also dangerous. One misconfigure…
CMS
The headless CMS architecture decouples content management from content presentation, giving developers flexibility to use any frontend technology while le…
Google Cloud Platform
I was stuck on a Cloud Function. I needed to process images uploaded to a bucket, generate thumbnails, and store metadata in Firestore. The event structure…
Google Cloud Platform
This might be controversial. I started on AWS. EC2, RDS, S3. It worked. But something always felt off. The console was a maze. The documentation felt like…
Google Cloud Platform
I was stuck on a Cloud Function. I needed to process images uploaded to a bucket, generate thumbnails, and store metadata in Firestore. The event structure…
Google Cloud Platform
My app crashed. I had logs. Thousands of them. I needed to find the error that happened at 3:14 AM. I used to SSH into servers and grep through log files…
Google Cloud Platform
This might be controversial. I started on AWS. EC2, RDS, S3. It worked. But something always felt off. The console was a maze. The documentation felt like…
Google Cloud Platform
I run a Discord bot for a gaming community. Ten thousand users. Hundreds of requests per minute. And I pay exactly $0 to host it. The secret? Google Cloud…
Google Cloud Platform
My app crashed. I had logs. Thousands of them. I needed to find the error that happened at 3:14 AM. I used to SSH into servers and grep through log files…
AWS
AWS certifications validate your cloud knowledge and open doors. I started with the Cloud Practitioner exam, which covers foundational concepts. It's perfe…
AWS
When I first heard about Amazon Web Services, I thought it was just online storage. I was wrong. It's a massive collection of cloud computing services that…
Google Cloud Platform
I used to be a server person. I liked having my little VPS, SSH-ing into it, installing packages manually. It felt like being a real sysadmin. But then cam…
Google Cloud Platform
I used to be a server person. I liked having my little VPS, SSH-ing into it, installing packages manually. It felt like being a real sysadmin. But then cam…
Google Cloud Platform
I've used all the major clouds. AWS's console feels like a government website from 2005. Azure's feels like a maze where every hallway looks the same. But…
Technology
Remember when people called Microsoft boring? That was ten years ago. Satya Nadella took over as CEO in 2014. Everyone expected more Windows versions. More…
Google Cloud Platform
I've used all the major clouds. AWS's console feels like a government website from 2005. Azure's feels like a maze where every hallway looks the same. But…
Google Cloud Platform
I run a Discord bot for a gaming community. Ten thousand users. Hundreds of requests per minute. And I pay exactly $0 to host it. The secret? Google Cloud…
Web Development
Flask is a micro web framework for Python. It is lightweight and easy to get started with, making it perfect for beginners who want to build web applicatio…
Google Cloud Platform
Kubernetes is powerful but scary. It's also expensive if you run it wrong. I had a small app that needed a database, a cache, and an API. Running this on s…
Google Cloud Platform
Kubernetes is powerful but scary. It's also expensive if you run it wrong. I had a small app that needed a database, a cache, and an API. Running this on s…
Machine Learning
At some point, your laptop won’t be enough. Training a deep learning model on a CPU is like trying to dig a pool with a spoon. I had to make the jump to…
Technology
As the volume of data generated by IoT devices explodes, cloud computing alone is no longer sufficient to handle the latency and bandwidth demands. Enter e…
Google Cloud Platform
I used Docker Hub for a while. It was fine until I had a private image that I didn't want public. Then I discovered Artifact Registry on GCP. It's a privat…
AWS
The Well-Architected Framework is a set of best practices for designing cloud systems. It covers five pillars: operational excellence, security, reliabilit…
AWS
Elastic Compute Cloud, or EC2, is the backbone of AWS. Think of it as renting a powerful computer online instead of buying one. You can launch a virtual se…
Google Cloud Platform
I used Docker Hub for a while. It was fine until I had a private image that I didn't want public. Then I discovered Artifact Registry on GCP. It's a privat…
Technology
Launching a startup today requires assembling a sophisticated technology stack that enables rapid development, efficient collaboration, and scalable growth…
Google Cloud Platform
My family wanted a website for our reunion. Photos, RSVP, schedule, updates. I built it in a weekend. Frontend on Firebase Hosting. A Cloud Function to han…
Google Cloud Platform
My family wanted a website for our reunion. Photos, RSVP, schedule, updates. I built it in a weekend. Frontend on Firebase Hosting. A Cloud Function to han…
Google Cloud Platform
Three years on GCP. I've made mistakes. I've learned lessons. Here's what I wish someone told me on day one. First: set up billing alerts immediately. That…
Google Cloud Platform
Three years on GCP. I've made mistakes. I've learned lessons. Here's what I wish someone told me on day one. First: set up billing alerts immediately. That…
Google Cloud Platform
My previous job involved analyzing CSV files. Gigabytes of them. Excel would crash. My laptop would overheat. I spent hours writing VLOOKUPs that took minu…
Cybersecurity
I was a history major, which seems like a weird path to cybersecurity. But I was always into puzzles and logic. After taking a few online courses, I got my…
Google Cloud Platform
I gave a service account the 'Owner' role. I know. I'm ashamed. It was my first week on GCP. I wanted everything to just work. It did work. Too well. One d…
AWS
Simple Storage Service, or S3, is where you store files—images, videos, backups, anything. But it's not just a folder in the cloud. It uses buckets, whic…
Google Cloud Platform
I wanted to break into data science, but I didn't have any projects to show. Then I discovered that Google Cloud gives $300 in free credits to new users. I…
Google Cloud Platform
I gave a service account the 'Owner' role. I know. I'm ashamed. It was my first week on GCP. I wanted everything to just work. It did work. Too well. One d…
Google Cloud Platform
My previous job involved analyzing CSV files. Gigabytes of them. Excel would crash. My laptop would overheat. I spent hours writing VLOOKUPs that took minu…
Google Cloud Platform
I wanted to break into data science, but I didn't have any projects to show. Then I discovered that Google Cloud gives $300 in free credits to new users. I…
Google Cloud Platform
I woke up to an email from Google Cloud: "Your bill for this month is $10.52." I panicked. My little side project was supposed to be on the free tier. How…
Google Cloud Platform
I woke up to an email from Google Cloud: "Your bill for this month is $10.52." I panicked. My little side project was supposed to be on the free tier. How…
Testing
I used to hate writing tests. I thought it was a waste of time until I had to refactor a legacy module with 100% coupling. I broke everything, and I spent…
JavaScript
Once I was comfortable with frontend JavaScript, I wanted to build my own backend. Express.js is the most popular framework for Node.js. It's minimalist an…
Concurrency
Asynchronous programming is a way to write concurrent code that can handle many tasks without the overhead of threads or processes. AsyncIO is Python's lib…
How Claude Works
You don't need to understand neural networks to use Claude well, but a basic intuition for how it generates text can help you understand why it sometimes g…
Databases
When I first started using Spring Data JPA, I was amazed that I could just create an interface extending `JpaRepository` and get CRUD methods for free. But…
Spring Framework
Early in my career, I used the `new` keyword everywhere. `new UserService(new UserRepository(new Database()))`. I thought I was being efficient. Then came…
Web Development
REST APIs are a common way to expose functionality to other services or frontend applications. Flask-RESTful is an extension that simplifies building REST…
Security
WebAuthn (Web Authentication) is a browser API that enables passwordless authentication using biometrics (fingerprint, face ID), security keys (YubiKey), o…
Lifestyle
This was a weird experiment. I connected an AI agent to my smart fridge, my grocery delivery app, and a recipe database. I told it to manage meals for the…
Animals
Crows are often considered among the most intelligent birds, and their memory is legendary. They can remember human faces for years, even distinguishing be…
Security
Authentication is one of those topics that every web developer eventually needs to understand. The two traditional approaches are session-based authenticat…
DevOps
Understanding what's happening in production applications requires more than scattered console.log statements. Observability is the practice of instrumenti…
Backend
Rust is increasingly making its way into web development, not as a JavaScript replacement, but for the performance-critical layers where every millisecond…
AI Ethics & Tips
Let's talk about the stuff nobody puts in their "10 ways to master ChatGPT" threads. First: hallucinations. ChatGPT will confidently lie to you. I once as…
Machine Learning
We often ignore the environmental cost of training large models. Some of these models consume as much energy as a car over its lifetime. I’ve become more…
Business
Dubai has made a serious strategic bet on becoming a technology hub, backed by government funding, regulatory flexibility, and active recruitment of talent…
Rise of America
There is a strip of land between San Francisco Bay and the Santa Cruz Mountains that, in the span of about fifty years, produced more transformative techno…
DevOps
The days of deploying a WAR file to a Tomcat instance on a virtual machine are fading. Most Java shops are moving to containers. I started Dockerizing my S…
Jobs
Dubai's economy has diversified significantly over the past decade, and the sectors with the greatest appetite for talent in 2025 reflect that diversificat…
Machine Learning
There’s a huge trend right now to use deep learning for everything. But honestly? Sometimes a simple Random Forest or even Logistic Regression will do th…
Google Cloud Platform
My handwriting is illegible. Even I can't read it sometimes. So I built an app using Google Cloud's Vertex AI and the Vision API. I take a photo of my note…
Jobs
Dubai's technology sector has expanded rapidly, fuelled by government digital transformation initiatives, a growing startup ecosystem, and large corporates…
AWS
The number one fear for AWS beginners is getting an unexpectedly high bill. I've been there. The key is understanding that AWS charges for what you use, an…
Security
Okay, let’s be real for a minute. Handing over your passwords and API keys to an autonomous piece of software is a security nightmare waiting to happen i…
Technology
Deep in the New Mexico desert, a group of scientists changed the world. They didn't know it at the time, not really. They were racing against the Germans…
Environment
We talk a lot about how cool AI is, but rarely about the energy it consumes. Running large language models and AI agents takes massive data centers that gu…
Technology
Quantum computing is no longer just a concept reserved for theoretical physicists; it is rapidly becoming a tangible technology that promises to revolution…
Google Cloud Platform
My handwriting is illegible. Even I can't read it sometimes. So I built an app using Google Cloud's Vertex AI and the Vision API. I take a photo of my note…
Introduction to Claude
Privacy is a legitimate concern when sharing information with any AI service, and Claude is no exception. Understanding Anthropic's data practices helps yo…
Development
You don't need to be a software engineer or know Python to build your own AI-powered application. The rise of no-code and low-code platforms has democratiz…