The backend of file browsing softwares (e.g. Finder mac, file explorer windows)

Question

I am trying to create a finder/file explorer alternative using python and electron. I am obtaining file information (path, name, etc) and automatically categorize it into a folder(directory). Currently, I am storing the file information in a SQLite database, and every time when I open a folder, it searches the SQLite database (which has all the file information) using for loop for matching contents that should exist in that folder and displays the contents on electron, with a thumbnail of the specific file (when pressed opens it on default file previewer from the original path since there are no duplicates of the file). I was wondering if finder/file explorer use the same method to display files in a folder or if they have one database per folder.

Thank you.