Exploit your RootsMagic family tree database with SQLite Tools
Two SQLite queries developed by DeepSeek under my direction: These queries can be adapted to other SQLite database columns that employ comma-separated strings. Problem These queries were created when I was asked to convert Place Details into Places in a very large database with 48,000 records in the PlaceTable. I was able to use my…
Breakthrough! Something I’ve wanted for as long as I can remember is a means of detecting lineage loops (an ancestor is their own descendant) in family tree databases created with RootsMagic. This is my second major interaction with Google Gemini Flash 2.5 which took 18 attempts (only 18!) with lots of testing to nail down…