The 8 tables behind a real auth system (Postgres schema, explained column by column)
This is day 2 of the series. Yesterday I showed the architecture diagram. Today we are looking at the database that sits underneath it. Every table, e…
Architecture
⚑ Report a ProblemLatest Architecture news from Tech News
All topics
agents
ai
api
architecture
automation
aws
backend
beginners
career
claude
cloud
database
devchallenge
devops
javascript
llm
machinelearning
news
opensource
performance
productivity
programming
python
security
showdev
softwareengineering
systemdesign
tutorial
typescript
webdev
I've built auth six times. Here's the system I would build today
I am writing this series because I have built authentication from scratch six times, and every time I got it about 80 percent right and discovered the…
Authentication Systems Explained: JWT vs Sessions (What You Should Actually Use in 2026)
Authentication is one of those topics every developer uses—but not everyone truly understands. At some point, you’ll face this decision: 👉 Should I us…
RFC 7523 Deep Dive: JWT Profile
Introduction I perfectly understand how human users authenticate in modern web apps via OAuth 2.0. A browser opens, the user clicks "Allow" on a conse…
Secure by Default, Slow by Surprise. What AWS Forgot to Mention About RDS IAM Authentication
Throughout my career as a backend and cloud engineer, I have worked with several database management systems. And while each of them has its own proto…