Tech does not just watch: Take action against Russia’s war on Ukraine 🇺🇦, and take action against Israel’s occupation, destruction, and ethnic cleansing of Palestine (history) 🇵🇸 Hide

Frontend Dogma

“databases” News Archive

Definition, related topics, and tag feed

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

Entry (Sources) and Other Related TopicsDate#
These Queries Cover 80% of SQL106
sql
Build Your Own Database (nan)105
guides
Backend Concepts Every Experienced Developers Must Know104
concepts, network, concurrency, apis, caching, scalability, security, observability, architecture
PostgreSQL 18 Released (pos)103
release-notes, postgresql
An Interactive Guide to TanStack DB (max)102
guides, tanstack
Advanced PostgreSQL Indexing: Multi-Key Queries and Performance Optimization (ada/fro)101
postgresql, performance, optimization
Introduction to Postgres Indexes (ada/fro)100
introductions, postgresql
The One Architecture Decision That Destroyed Every Project I Touched99
architecture
Why /dev/null Is an ACID Compliant Database98
unix-like, comparisons
Fear May Be the Mind-Killer, but Unindexed Database Queries Are the Database-Killer97
performance
Testing MongoDB in Node With the MongoDB Memory Server (app)96
nodejs, testing, mongodb
Postgres Is Too Good (and Why That’s Actually a Problem)95
postgresql
Handling PostgreSQL Migrations in Node.js (har/bit)94
migrating, nodejs, postgresql
Scaling to 1 Million Users: The Architecture I Wish I Knew93
architecture, scalability, servers, caching, microservices, asynchronicity, observability, content-delivery
Waiting for Postgres 18: Accelerating Disk Reads With Asynchronous I/O (luk/pga)92
postgresql, asynchronicity
Database Internals Explained: The Invisible Engine Behind Every App You Use (rak)91
videos
How to Prevent WordPress SQL Injection Attacks (sma)90
how-tos, wordpress, sql, security
Why Teams Are Ditching DynamoDB (hop/the)89
dynamodb, aws
Postgres vs. MySQL88
postgresql, mysql, comparisons
Database Trends: A 2024 Review and a Look Ahead (and/the)87
retrospectives, trends, outlooks
A Gentle Introduction to Using a Vector Database86
introductions, vector-databases, javascript, ai, openai
Drizzle Database Migrations (ada/fro)85
migrating, tooling
Revamping a Five-Year Old Node.js Project84
nodejs, mongodb, architecture, refactoring, maintenance
How Document-Oriented Databases Store Data Similar to JSON Objects (ami)83
json, objects
Comparing Local-First Frameworks and Approaches82
Top 4 Web Vulnerabilities With Example and Mitigation81
security, vulnerabilities, sql, xss, csrf
How to Build an Image Search Application With OpenAI CLIP and PostgreSQL in JavaScript80
how-tos, images, search, ai, openai, postgresql, javascript, functionality
Indexed Database API 3.0 (w3c)79
standards, indexeddb
Database 101: SSL/TLS for Beginners78
introductions, ssl, tls, authentication, security
Some Go Web Dev Notes (b0r)77
go, sql
The Secret Inside One Million Checkboxes76
html, community
Just Use Postgres75
postgresql, sql, aws, dynamodb, mongodb, mysql, comparisons
How to Create Fake Back-End Using IndexedDB74
how-tos, indexeddb, browser-storage, javascript
I Got Hacked and Blew Up Prod73
career, docker, debugging
Cloning Queries in Laravel (ami)72
laravel
Epic App Performance Starts With the Database71
videos, performance, optimization
Preventing SQL Injection Attacks in Node.js70
security, nodejs, sql
A Day in the Life of a Developer—Building a Dashboard App With SQL, Node.js, Django, and Next.js69
functionality, sql, nodejs, django, nextjs
Vector Database Recommender System (ast)68
vector-databases
Optimizing SQL Queries by 23×67
sql, performance, optimization
CRUD and SQL—the Basics66
fundamentals, sql
Introducing JavaScript Support in MySQL65
introductions, mysql, javascript, support
Introduction to AWS—DynamoDB64
introductions, aws, dynamodb
Comparing MySQL, PostgreSQL, and MongoDB63
mysql, postgresql, mongodb, comparisons
A Guide to Using MSSQL With Node.js62
guides, nodejs, sql
WTF Is a Vector Database: A Beginner’s Guide61
guides, vector-databases
What Happens When You Select “count(*)” in MySQL (ami)60
mysql
How to Improve Performance of Your Database by Indexing Large Tables59
how-tos, performance, optimization
Getting Started With Vector Databases in Node.js58
introductions, nodejs, vector-databases
Introduction to MongoDB and NoSQL Databases57
introductions, mongodb
Introduction to MySQL Data Types56
mysql, types
IndexedDB Tutorial for Beginners: A Comprehensive Guide With Coding Examples55
tutorials, guides, indexeddb, examples
Must Know JavaScript API—IndexedDB API54
indexeddb, javascript, apis
A Complete Guide to Using IndexedDB (log)53
guides, indexeddb
Building Offline-First Web Applications With Service Workers and IndexedDB52
offline, web-apps, web-workers, indexeddb, javascript
Temporal Intervals Are Handy in MySQL (ami)51
mysql, time
Writing Composable SQL Using JavaScript50
javascript, sql
Why You Should Consider Prisma.io49
tooling, prisma
How to Build Node.js REST API With MySQL48
how-tos, nodejs, apis, rest, mysql
How to Prevent SQL Injection Attacks in Node.js47
how-tos, nodejs, security, sql
Why IndexedDB Is Slow and What to Use Instead46
indexeddb, javascript, performance
Why Do Webdevs Keep Trying to Kill REST? (swy)45
apis, rest, protocols
1995: MySQL Arrives, Completing the LAMP Stack (ric)44
history, mysql, tech-stacks
What Is Prisma and Why Do We Need Another ORM? (nea)43
tooling, prisma
A Primer on the Different Types of Browser Storage (ido/css)42
introductions, browser-storage, indexeddb, apis, cookies, caching
MEAN Stack: Build an App With Angular and the Angular CLI41
angularjs, nodejs, express, mongodb, functionality
An Introduction to MongoDB40
introductions, mongodb
How to Install MySQL (cra)39
how-tos, installing, mysql
Using MySQL With Node.js and the mysql JavaScript Client38
mysql, nodejs, tooling
Explore GraphQL With Apollo and React: Build a Superhero Database37
graphql, react
Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB36
videos, aws, dynamodb, software-design-patterns, deep-dives
AWS Cloud Databases Go Serverless and Multi-Master (bel/ven)35
aws, cloud-computing, serverless, dynamodb
How to Optimize SQL Queries for Faster Sites34
how-tos, sql, mysql, performance, caching, optimization
How to Use JSON Data Fields in MySQL Databases (cra)33
how-tos, json, mysql
Working With Databases in WordPress32
wordpress, php
Caching a MongoDB Database With Redis31
mongodb, caching, javascript
SQL vs. NoSQL: How to Choose (cra)30
how-tos, sql, comparisons
Knowing When to Back Off29
load-balancing
The WordPress Database Demystified28
wordpress, mysql
An Introduction to Node.js and MongoDB (sma)27
introductions, nodejs, mongodb
MongoDB Indexing26
mongodb, php
Setting Up a MySQL Database (ast)25
mysql
IndexedDB Featured in New Web Development Open Standards Site24
indexeddb, standards, w3c, documentation
Building Your Own URL Shortener23
php, mysql, functionality, urls
Amazon DynamoDB: Store PHP Sessions With a Load Balancer (vta)22
aws, dynamodb, php, load-balancing
Loading Half a Billion Rows Into MySQL21
mysql, performance
MySQL Master-Slave Replication: Setting Up20
mysql
Up Close and Personal With HTML5 IndexedDB19
html, indexeddb
Introduction to MongoDB18
introductions, mongodb
How to Synchronize Your PHP and MySQL Timezones (cra)17
how-tos, php, mysql
W3C Drops Support of Web SQL (sts/zdn)16
w3c, sql
MySQL: Are You Actually Utilizing Your Indexes? (lea)15
mysql
Inappropriate Uses (chr/css)14
html, css, javascript, principles
Ajaxian Roundup for March 2008: IE 8, Acid3, and Performance (dal/aja)13
browsers, javascript, dojo, dwr, extjs, prototypejs, jquery, css, design, performance, tooling, mobile, comet, ajaxian, link-lists
Google Gears DB Abstractions (dal/aja)12
gears, google
Embedding a Database in IE (dal/aja)11
internet-explorer, microsoft, browsers
What’s the Best MySQL Admin Tool? (jus)10
mysql, tooling
Top 7 PHP Security Blunders9
php, sql, security
JavaScript Database: In Browser (dal/aja)8
javascript, json, browsers
HTML, CSS, PHP, and More Cheat Sheets7
cheat-sheets, link-lists, html, xhtml, css, wordpress, php, encoding, seo, servers, tooling
An SVG Case Study: Integrated, Dynamic Avalanche Forecasting6
perl, html, sql, svg, images, case-studies
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 Escape Generator2
tools, exploration, code-generation, sql, escaping
SQL Formatter1
tools, exploration, optimization, sql, formatting