This is a very nice, concise, demo of RAG. I learned a lot of it. Thanks for posting!

The example required a few small changes in the function retrieve: the lines...

• This reply was modified 2 weeks, 1 days ago by sqlservercentral 57377. Reason: The BBcode formatting caused the same error in the code as in the published version
• This reply was modified 2 weeks, 1 days ago by sqlservercentral 57377. Reason: another try to avoid BBcode removing the [ i ]

Performance of SQLite is definitely OK for simple queries. It does take database statistics into account, but AFAIK it doesn't do parameter sniffing. Personally I wouldn't use it for a...

Just a few small corrections: The article states that everything is stored as string. This is not correct, SQLite supports blobs / integers / floats natively. Replication can be done...

It's kind of surprising to me that Steve Jones makes the distinction based on liability and formal knowledge. That might be an US thing. As an engineer, liability is part...