Local memory for my HA chat bot

You want to have a 1TB JSON file? Yeah, that’s not going to work. You’ll have to load it all into memory to search it. You need a database.