Tech is political: The people under attack in Palestine 🇵🇸, Iran 🇮🇷, and Lebanon 🇱🇧 are people like us. They’re our brothers and sisters, too. Read up on their history, scrutinize what you’re told, and demand respect and accountability. Hide

Frontend Dogma

“databases” News Archive

Definition, related topics, tag feed

Definition · Supertopics: storage · Subtopics: dynamodb, indexeddb, indexing, mongodb, mysql, nosql, orm, postgresql, prisma, sql, vector-databases (non-exhaustive) · “databases” × ? · “databases” RSS feed (per email)

Entry (Sources) and Additional TopicsDate#
Building a Reliable PostgreSQL Queue: Concurrency, Crashes, Retries, and Scale (fro)133
postgresql, concurrency
How to Fix the Dual-Write Problem in Node.js With the Outbox Pattern (fre)132
how-tos, nodejs
Integration Testing Node.js With Testcontainers (fla)131
nodejs, testing, postgresql
Eighty Percent Done Is Not a Real Number (pce)130
processes, code-reviews, ai
Your Database’s Isolation Levels Don’t Mean What You Think (fro)129
postgresql, mysql, oracle, ibm, orm
Shipping psql Without psql: A Pure-TypeScript Postgres Client in neonctl128
tooling, ai, postgresql, case-studies
The Production Playbook for Node.js Stream Leaks (fro)127
nodejs, streaming
SQL Tutorial (jad)126
websites, courses, tutorials, sql
Migrating From DigitalOcean to Hetzner: From $1,432 to $233/Month With Zero Downtime125
migrating, hosting, digitalocean, economics
“work_mem”: It’s a Trap (la)124
memory, postgresql
Top 10 NoSQL Database Platforms: Features, Pros, Cons, and Comparison123
nosql, mongodb, dynamodb, firebase, comparisons
8 PostgreSQL Tricks (kem)122
postgresql, tips-and-tricks
These Queries Cover 80% of SQL121
sql
Build Your Own Database (nan)120
guides
Backend Concepts Every Experienced Developers Must Know119
concepts, network, concurrency, apis, caching, scalability, security, observability, architecture
PostgreSQL 18 Released (pos)118
release-notes, postgresql
An Interactive Guide to TanStack DB (max)117
guides, tanstack
Advanced PostgreSQL Indexing: Multi-Key Queries and Performance Optimization (ada/fro)116
postgresql, indexing, performance, optimization
Introduction to Postgres Indexes (ada/fro)115
introductions, postgresql
The One Architecture Decision That Destroyed Every Project I Touched114
architecture
Why /dev/null Is an ACID Compliant Database113
unix-like, comparisons
Go Ahead, Self-Host Postgres (fre)112
postgresql, self-hosting
Fear May Be the Mind-Killer, but Unindexed Database Queries Are the Database-Killer111
performance
Testing MongoDB in Node With the MongoDB Memory Server (app)110
nodejs, testing, mongodb
Postgres Is Too Good (and Why That’s Actually a Problem)109
postgresql
Handling PostgreSQL Migrations in Node.js (har/bit)108
migrating, nodejs, postgresql
Scaling to 1 Million Users: The Architecture I Wish I Knew107
architecture, scalability, servers, caching, microservices, asynchrony, observability, content-delivery
Waiting for Postgres 18: Accelerating Disk Reads With Asynchronous I/O (luk/pga)106
postgresql, asynchrony
Database Internals Explained: The Invisible Engine Behind Every App You Use (rak)105
videos
How to Prevent WordPress SQL Injection Attacks (sma)104
how-tos, wordpress, sql, security
Why Teams Are Ditching DynamoDB103
dynamodb, aws
Postgres vs. MySQL102
postgresql, mysql, comparisons
Database Trends: A 2024 Review and a Look Ahead101
retrospectives, trends, outlooks
A Gentle Introduction to Using a Vector Database100
introductions, vector-databases, javascript, ai, openai
Drizzle Database Migrations (ada/fro)99
migrating, tooling
The Path to Learn Web Development (fla)98
learning, http, html, css, tooling, git, javascript, typescript, frameworks
Revamping a Five-Year Old Node.js Project97
nodejs, mongodb, architecture, refactoring, maintenance
How Document-Oriented Databases Store Data Similar to JSON Objects (ami)96
json, objects
Top 4 Web Vulnerabilities With Example and Mitigation95
security, vulnerabilities, sql, xss, csrf
Comparing Local-First Frameworks and Approaches94
How to Build an Image Search Application With OpenAI CLIP and PostgreSQL in JavaScript93
how-tos, images, search, ai, openai, postgresql, javascript, functionality
Indexed Database API 3.0 (w3c)92
standards, indexeddb
Database 101: SSL/TLS for Beginners91
introductions, ssl, tls, authentication, security
Some Go Web Dev Notes (b0r)90
go, sql
The Secret Inside One Million Checkboxes89
html, community
Just Use Postgres88
postgresql, sql, aws, dynamodb, mongodb, mysql, comparisons
How to Create Fake Back-End Using IndexedDB87
how-tos, indexeddb, browser-storage, javascript
I Got Hacked and Blew Up Prod86
career, docker, debugging
Cloning Queries in Laravel (ami)85
laravel
Epic App Performance Starts With the Database84
videos, performance, optimization
Preventing SQL Injection Attacks in Node.js83
security, nodejs, sql
A Day in the Life of a Developer—Building a Dashboard App With SQL, Node.js, Django, and Next.js82
functionality, sql, nodejs, django, nextjs
Vector Database Recommender System (ast)81
vector-databases
Optimizing SQL Queries by 23×80
sql, performance, optimization
CRUD and SQL—the Basics79
fundamentals, sql
Introducing JavaScript Support in MySQL78
introductions, mysql, javascript, support
Introduction to AWS—DynamoDB77
introductions, aws, dynamodb
Comparing MySQL, PostgreSQL, and MongoDB76
mysql, postgresql, mongodb, comparisons
A Guide to Using MSSQL With Node.js75
guides, nodejs, sql
WTF Is a Vector Database: A Beginner’s Guide74
guides, vector-databases
What Happens When You Select “count(*)” in MySQL (ami)73
mysql
How to Improve Performance of Your Database by Indexing Large Tables72
how-tos, performance, optimization, indexing
Getting Started With Vector Databases in Node.js71
introductions, nodejs, vector-databases
Introduction to MongoDB and NoSQL Databases70
introductions, mongodb, nosql
Introduction to MySQL Data Types69
mysql, types
IndexedDB Tutorial for Beginners: A Comprehensive Guide With Coding Examples68
tutorials, guides, indexeddb, examples
Must Know JavaScript API—IndexedDB API67
indexeddb, javascript, apis
A Complete Guide to Using IndexedDB (log)66
guides, indexeddb
Building Offline-First Web Applications With Service Workers and IndexedDB65
offline, web-apps, web-workers, indexeddb, javascript
Temporal Intervals Are Handy in MySQL (ami)64
mysql, time
Writing Composable SQL Using JavaScript63
javascript, sql
Why You Should Consider Prisma.io62
tooling, orm, prisma
How to Build Node.js REST API With MySQL61
how-tos, nodejs, apis, rest, mysql
How to Prevent SQL Injection Attacks in Node.js60
how-tos, nodejs, security, sql
Why IndexedDB Is Slow and What to Use Instead59
indexeddb, javascript, performance
Why Do Webdevs Keep Trying to Kill REST? (swy)58
apis, rest, protocols
1995: MySQL Arrives, Completing the LAMP Stack (ric)57
history, mysql, tech-stacks
What Is Prisma and Why Do We Need Another ORM? (nea)56
tooling, orm, prisma
A Primer on the Different Types of Browser Storage (ido/css)55
introductions, browser-storage, indexeddb, apis, cookies, caching
MEAN Stack: Build an App With Angular and the Angular CLI54
angularjs, nodejs, express, mongodb, functionality
An Introduction to MongoDB53
introductions, mongodb
How to Install MySQL (cra)52
how-tos, installing, mysql
Using MySQL With Node.js and the mysql JavaScript Client51
mysql, nodejs, tooling
Explore GraphQL With Apollo and React: Build a Superhero Database50
graphql, react
Tips to Help You Write Faster MySQL Queries49
mysql, performance, tips-and-tricks
Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB48
videos, aws, dynamodb, software-design-patterns, deep-dives
AWS Cloud Databases Go Serverless and Multi-Master (bel/ven)47
aws, cloud-computing, serverless, dynamodb
How to Optimize SQL Queries for Faster Sites46
how-tos, sql, mysql, performance, caching, optimization
An Introduction to NoSQL Databases45
videos, introductions, nosql
How to Use JSON Data Fields in MySQL Databases (cra)44
how-tos, json, mysql
Working With Databases in WordPress43
wordpress, php
Caching a MongoDB Database With Redis42
mongodb, caching, javascript
SQL vs. NoSQL: How to Choose (cra)41
how-tos, sql, nosql, comparisons
Knowing When to Back Off40
load-balancing
MySQL39
translations, introductions, mysql, indexing, link-lists
What I’d Tell My Younger Self About Learning Development as a Web Designer38
learning, programming, javascript, servers, preprocessors, version-control, performance, security, career
The WordPress Database Demystified37
wordpress, mysql
An Introduction to Node.js and MongoDB (sma)36
introductions, nodejs, mongodb
MongoDB Indexing35
mongodb, indexing, php
Setting Up a MySQL Database (ast)34
mysql
IndexedDB Featured in New Web Development Open Standards Site33
indexeddb, standards, w3c, documentation
Building Your Own URL Shortener32
php, mysql, functionality, urls
Amazon DynamoDB: Store PHP Sessions With a Load Balancer (vta)31
aws, dynamodb, php, load-balancing
Loading Half a Billion Rows Into MySQL30
mysql, performance
MySQL Master-Slave Replication: Setting Up29
mysql
Up Close and Personal With HTML5 IndexedDB28
html, indexeddb
Introduction to MongoDB27
introductions, mongodb
How to Synchronize Your PHP and MySQL Timezones (cra)26
how-tos, php, mysql
W3C Drops Support of Web SQL (sts/zdn)25
w3c, sql
MySQL: Are You Actually Utilizing Your Indexes? (lea)24
mysql
Introducing Web SQL Databases (rem/htm)23
introductions, sql
Inappropriate Uses (chr/css)22
html, css, javascript, principles
Ajaxian Roundup for March 2008: IE 8, Acid3, and Performance (dal/aja)21
browsers, javascript, dojo, dwr, extjs, prototypejs, jquery, css, design, performance, tooling, mobile, comet, ajaxian, link-lists
Google Gears DB Abstractions (dal/aja)20
gears, google
Getting PHP to Talk to MySQL19
php, mysql
Embedding a Database in IE (dal/aja)18
internet-explorer, browsers
10 Realistic Steps to a Faster Web Site17
performance, network, servers, caching
What’s the Best MySQL Admin Tool? (jus)16
mysql, tooling
Top 7 PHP Security Blunders15
php, sql, security, mistakes
Track Browser Resizing in Your Database Using AJAX14
ajax, sql, php, resizing
JavaScript Database: In Browser (dal/aja)13
javascript, json, browsers
HTML, CSS, PHP, and More Cheat Sheets12
cheat-sheets, link-lists, html, xhtml, css, wordpress, php, encoding, seo, servers, tooling
Introduction to Databases (dig)11
introductions
Setting Up a PHP 5 Development Environment With Apache 2 and MySQL 4.1.310
apache, servers, mysql, php, installing
Making Usage Statistics in PHP9
php, mysql, analytics, functionality
An SVG Case Study: Integrated, Dynamic Avalanche Forecasting8
perl, html, sql, svg, images, case-studies
PHP and Working With Databases (for the Lazy Sod)7
php
Using a MySQL Database With PHP6
mysql, php
Databased Websites From Scratch5
link-lists
Migrate Your Site From MySQL to PostgreSQL4
migrating, mysql, postgresql
PostgreSQL Query Plan Analyzer and Visualizer (dal)3
tools, exploration, auditing, debugging, postgresql, visualization
SQL Character Escaper2
tools, exploration, conversion, sql, escaping
SQL Formatter1
tools, exploration, optimization, sql, python, php, formatting