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 "database"
43 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
Relational Database Service takes the pain out of database administration. Before RDS, I spent weekends managing backups and patching. With RDS, AWS handle…
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…
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…
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
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…
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…
CMS
The headless CMS architecture decouples content management from content presentation, giving developers flexibility to use any frontend technology while le…
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…
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…
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…
Security
WebAuthn (Web Authentication) is a browser API that enables passwordless authentication using biometrics (fingerprint, face ID), security keys (YubiKey), o…
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…
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…
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…
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…
AWS
CloudFormation lets you define your entire AWS infrastructure in a text file. I moved from manually clicking through the console to writing templates, and…
AWS
Key Management Service lets you create and manage encryption keys. I use it to encrypt S3 buckets, EBS volumes, and RDS databases. KMS integrates with many…
Technology
While blockchain technology is best known for powering cryptocurrencies like Bitcoin, its potential applications extend far beyond digital money. At its co…
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…
AWS
AWS Backup simplifies protecting your data across AWS services. Instead of configuring backups separately for each service, you create backup plans central…