I have an application that is a conversion tool that converts address files into the correct formatting for 40+ different applications. In the process of converting I need to take into account specific requirements by the particular applications for how things are formatted both in terms of full name vs abbreviation, but also in exact spellings since many of the applications my tool supports don't follow a standard naming scheme (it would be cake if they all just used the IS
Perfect. Play with this early Xmas toy and think how the global idea can fit your use case for storage/querying best. I didn't have enough clues about your actual requirements so my tentative may focus too much on language for example but ignore other aspects important to you; again I set this up quite fast as a basic sample.
Be aware that there are a lot more features in SQLite, like FTS tables (Full Text Search), virtual tables and support for add-on functions. The joined archive contai