@alanonai: Engineering for Vibe Coders: Databse Indexing If your app is getting slower over time and you did not change anything, this is probably why. Most vibe-coded apps skip database indexes. At first, it feels fine. You have a small dataset, queries are fast, everything works. But under the hood, your database is scanning every row to find what you asked for. That is fine at 100 rows. It is a problem at 100,000. Suddenly your API slows down, your functions time out, and your costs start going up. Indexes fix this by giving your database a fast lookup path instead of searching everything. But here is the catch. Indexes only help if they match how you query your data. If you are filtering by user_id, you need an index on user_id. If you are sorting by created_at, that needs to be indexed too. If you are vibe coding and not thinking about indexes, your app is not fast. It is just small. Link in comments Thanks to @Senior for suggesting this topic! #ai #vibecoding #coding #programming #database
Alan on AI
Region: US
Monday 13 April 2026 16:34:09 GMT
Music
Download
Comments
Amaury Larancuent :
as a senior software engineer it's wild how we gotta teach people basic sh*t, lmao
2026-04-13 19:07:00
375
Martin Scales AI :
This is the kind of content vibe coders need way more of. Indexing is the silent killer — the app feels fast on day 1 with 50 rows, then by month 2 a single dashboard query is doing a 200k row sequential scan. Add an "EXPLAIN ANALYZE on slow queries" habit early and you save yourself a midnight production fire.
2026-04-14 23:52:23
78
Mr Ola 01 :
I thought that it is normal to use database index
2026-06-03 11:18:24
4
babdk295 :
Redis
2026-05-22 02:45:15
8
Strawberrymilk1133 :
Yes indexing and views. Do you know anything about cached egress? I already webp and compress but it’s not good
2026-04-29 07:13:00
5
Actively Me :
appreciate you helping open the door for new developers (or whatever we are calling this new generation of coders)
2026-04-16 00:18:32
7
Ghost 👻👻 :
how can I get a job as a web developer I have been looking for a job for a while
2026-06-01 15:00:09
0
Talking Tech With D :
Just fyi AI is getting pretty good. if you prompt it correctly, it will design your database correctly. people just don't have the technical know-how to write prompts
2026-04-23 03:40:28
17
AyClass :
Index only what’s necessary, the amount of storage you can save by choosing a what to index is a huge amount. My DB has billions of records so I guess this may not apply to everybody. Joint tables can be equally fast for reverse lookups and direct matches may not really need indexing
2026-04-15 04:28:57
9
Chainium :
I love your content. I’ve got adhd- when I’m scrolling on tiktok and come across your videos they make me jump back to my project. Thanks 🙌
2026-05-25 22:40:59
1
Cumberland Carnivores 🇨🇦 :
If this is a problem they had, they probably asked AI and it probably gave them the answer 😒
2026-04-22 05:06:18
1
travellerbu :
So Claude prompt can do that right
2026-06-04 00:32:27
2
Sahilios :
How many indexes is too many?
2026-06-01 12:02:16
1
Alan on AI :
https://alanknox.com/database-indexes-engineering-for-vibe-coders/
2026-04-13 16:35:41
6
ZeroDayv :
So timely as I’m working through a growth question.
2026-04-15 02:50:53
5
pedro :
Send my
2026-05-25 01:57:02
1
bruhhhfart :
im actually taking a class for databases right now! still early in the class but we will be covering SQL optimization, redundancy, etc
2026-05-28 23:00:55
2
AJ :
lol GenX telling em! You go pal
2026-04-16 06:05:58
5
Fr3quency :
There is also a drawback to it and this is about writing data to it
2026-05-29 09:14:05
1
Chainium :
This is so solid.
2026-05-25 22:39:19
1
EST MUSTI :
where is the article?
2026-04-21 20:10:40
2
Zane :
And dont over index otherwise your write performance becomes lower
2026-05-28 04:47:04
1
ei :
yeah I remember my senior solved this issue on my project
2026-05-29 15:52:25
1
alankar :
Question- for Ai rag we need indexing for both rational database but also very importantly docs — what’s the best way to indexing file based docs like splunk indexing
2026-05-30 16:30:22
1
Dhia :
lmfao i have an indexing techniques exam final upcoming next week
2026-05-26 12:33:23
2
To see more videos from user @alanonai, please go to the Tikwm
homepage.