Same here. In my formative years I was led to believe you had to use a “real” RDBMS for everything- MySQL or Postgres. Anything else was just a toy not suitable for use in the real world.
I succumbed to the SQLite hype train in 2020 when every other post on HN was about it. I started building things with it. First, small things. Then bigger things.
Now I’m at the point where I default to starting most things with SQLite unless there’s a really good reason. It’s incredible how far SQLite can take you. It feels almost like a cheat code. Wish I had jumped on the train years ago.