TABATA Hitoshi

TABATA Hitoshi

Aug 27

Eight of my eighteen AWS scanners failed against a fake AWS — and that was the point

#aws #terraform #devops #python

2 min read

TABATA Hitoshi

Aug 27

pg_total_relation_size() takes a lock. My locks page waited behind the lock it was there to explain.

#postgres #database #devops #sql

2 min read

TABATA Hitoshi

Aug 25

pg_cancel_backend() returned true. The queue didn't move.

#postgres #database #devops #sql

5 min read

TABATA Hitoshi

Aug 22

I deleted a queue and my own CLI told me a resource had been added

#aws #terraform #devops #python

5 min read

TABATA Hitoshi

Jul 30

My drift detector cried wolf every time my autoscaler scaled out — and the fix was a tag AWS already sets

#aws #terraform #devops #python

4 min read

TABATA Hitoshi

Jul 22

My infra tool could show drift, grade it, and Slack it — but it still couldn't fail a CI build

#django #devops #aws #python

5 min read

TABATA Hitoshi

Jul 7

A '12 libraries to make your Python production-ready' list crossed my feed — I use 2 of them, because a framework already made the other 10 decisions

#python #django #devops #architecture

5 min read

TABATA Hitoshi

Jul 6

Your connection pool is exhausted. pg_stat_activity tells you which of the three causes it is.

#postgres #database #devops

5 min read

TABATA Hitoshi

Jul 6

Django's makemessages wrote Japanese I never approved — and my UI shipped it with total confidence

#django #i18n #python #devops

5

4 min read

TABATA Hitoshi

Jul 5

Order your tables for a safe TRUNCATE with graphlib — circular FKs come free

#postgres #database #python

5 min read

TABATA Hitoshi

Jul 5

My drift detector graded every change — and stayed blind to the secret that hadn't rotated in 200 days

#aws #security #devops #python

5 min read

TABATA Hitoshi

Jul 3

The Terraform MCP server has 35+ tools and none of them can see the resource I made in the console

#terraform #aws #mcp #devops

1

4 min read

TABATA Hitoshi

Jul 3

Your database GUI is a text editor. Where's the console?

#postgres #database #devops

4 min read

TABATA Hitoshi

Jul 1

My infra tool knew what drifted, how bad, and who did it — then waited for someone to open a tab

#django #aws #devops #python

4 min read

TABATA Hitoshi

Jun 29

My drift detector knew a security group changed — not that it was dangerous, or who opened it

#aws #security #django #devops

4 min read

TABATA Hitoshi

Jun 29

In information_schema, a generated column looks exactly like a plain one

#postgres #sql #database

3 min read

TABATA Hitoshi

Jun 26

My dashboard showed every number and helped you decide nothing

#django #ux #webdev #devops

5 min read

TABATA Hitoshi

Jun 26

No SPA: a multi-panel database UI in Django + htmx + a sprinkle of Alpine

#django #htmx #webdev

4 min read

TABATA Hitoshi

Jun 25

I shipped a database console with no login — on purpose

#security #postgres #webdev

4 min read

TABATA Hitoshi

Jun 24

I added TOTP 2FA to my Django app in ~40 lines and no 2FA library — but one line decides whether it's real

#django #python #security #webdev

4 min read

TABATA Hitoshi

Jun 24

Streaming a pg_restore through Python without deadlocking

#python #postgres #devops

4 min read

TABATA Hitoshi

Jun 23

The feature that wrote a database row every minute — even when nothing happened

#django #postgres #python #devops

4 min read

TABATA Hitoshi

Jun 23

Try a Postgres index without HypoPG: CREATE INDEX in a transaction you roll back

#postgres #database #performance

1

4 min read

TABATA Hitoshi

Jun 22

Your Django background scheduler is probably running twice. Here's why, and the migrate chicken-and-egg.

#django #python #devops

3 min read

TABATA Hitoshi

Jun 19

Diffing two EXPLAIN plans as trees, not text

#postgres #database #algorithms

4 min read

TABATA Hitoshi

Jun 19

Your runtimes have an expiry date. I baked the EOL calendar into the app so it works offline.

#devops #python #security #programming

4 min read

TABATA Hitoshi

Jun 18

`terraform plan` is blind to anything not in its state. So I scan AWS directly with boto3.

#aws #terraform #python #boto3

4 min read

TABATA Hitoshi

Jun 17

I built a Django admin UI with no SPA. htmx bit me where I didn't expect: logout.

#django #htmx #webdev #python

1

4 min read

TABATA Hitoshi

Jun 17

Lie to the Postgres planner: EXPLAIN your query at 10,000 the rows

#postgres #database #performance #sql

3 min read

TABATA Hitoshi

Jun 16

Don't parse SQL to make a query runner read-only

#postgres #sql #database #webdev

3 min read

TABATA Hitoshi

Jun 16

Your Terraform state file is a plaintext secrets store. Mine was too.

#terraform #security #devops #python

1

3 min read

TABATA Hitoshi

Jun 15

I turned the psql commands I keep forgetting into buttons

#showdev #postgres #django #webdev

4 min read

TABATA Hitoshi

Jun 15

The bug that made my Terraform drift detector cry wolf (and the one-line fix)

#aws #terraform #devops #python

4 min read

TABATA Hitoshi

Jun 9

I'm 62 and I built a self-hosted AWS drift detector because I was tired of spreadsheets

#showdev #aws #devops #terraform

2

2 min read

DEV Community

Badges

1 Week Community Wellness Streak

Writing Debut

Eight of my eighteen AWS scanners failed against a fake AWS — and that was the point

Want to connect with TABATA Hitoshi?

pg_total_relation_size() takes a lock. My locks page waited behind the lock it was there to explain.

pg_cancel_backend() returned true. The queue didn't move.

I deleted a queue and my own CLI told me a resource had been added

My drift detector cried wolf every time my autoscaler scaled out — and the fix was a tag AWS already sets

My infra tool could show drift, grade it, and Slack it — but it still couldn't fail a CI build

A '12 libraries to make your Python production-ready' list crossed my feed — I use 2 of them, because a framework already made the other 10 decisions

Your connection pool is exhausted. pg_stat_activity tells you which of the three causes it is.

Django's makemessages wrote Japanese I never approved — and my UI shipped it with total confidence

Order your tables for a safe TRUNCATE with graphlib — circular FKs come free

My drift detector graded every change — and stayed blind to the secret that hadn't rotated in 200 days

The Terraform MCP server has 35+ tools and none of them can see the resource I made in the console

Your database GUI is a text editor. Where's the console?

My infra tool knew what drifted, how bad, and who did it — then waited for someone to open a tab

My drift detector knew a security group changed — not that it was dangerous, or who opened it

In information_schema, a generated column looks exactly like a plain one

My dashboard showed every number and helped you decide nothing

No SPA: a multi-panel database UI in Django + htmx + a sprinkle of Alpine

I shipped a database console with no login — on purpose

I added TOTP 2FA to my Django app in ~40 lines and no 2FA library — but one line decides whether it's real

Streaming a pg_restore through Python without deadlocking

The feature that wrote a database row every minute — even when nothing happened

Try a Postgres index without HypoPG: CREATE INDEX in a transaction you roll back

Your Django background scheduler is probably running twice. Here's why, and the migrate chicken-and-egg.

Diffing two EXPLAIN plans as trees, not text

Your runtimes have an expiry date. I baked the EOL calendar into the app so it works offline.

`terraform plan` is blind to anything not in its state. So I scan AWS directly with boto3.

I built a Django admin UI with no SPA. htmx bit me where I didn't expect: logout.

Lie to the Postgres planner: EXPLAIN your query at 10,000 the rows

Don't parse SQL to make a query runner read-only

Your Terraform state file is a plaintext secrets store. Mine was too.

I turned the psql commands I keep forgetting into buttons

The bug that made my Terraform drift detector cry wolf (and the one-line fix)

I'm 62 and I built a self-hosted AWS drift detector because I was tired of spreadsheets