I am writing a log analysis program in bash. As part of it, I am compiling a list of known errors, so that I can search and reference those errors as part of the known list. I originally was going to just write them in a .sh file and use source to reference it. Then I realised that I have hundreds of thousands of error messages and that's going to be REALLY hard to do without killing myself.
So. I want to use a small and simple database where I can store error messages, some data associated with them (bug report, who found it, how to fix it, etc.), and it has to be easily searchable. I don't feel like dealing with dynamic queries and all that jazz, I want to be able to use static queries.
I know I can use Access, Excel, and other things like that, but this is CLI Linux. There are just so many options out there that I'm a little overwhelmed as to what would be perfect for something like this. I don't even know what type of database I should use, I just want it to be lightweight and common so it can be supported after I eventually move out of my current role.
What database engine should I use?
PS: I know Python, Perl, Ruby, C (and it's variants), and pretty much anything else would be better than bash for this. My hands are tied.