RM-LineageLoopDetector.sql: Uncovering Lineage Loops in RootsMagic Databases
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 ...
Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI)
I just finished a session with the free Google Gemini Flash 2.5 model to develop a quite complex query to identify couples in a RootsMagic database who are cousins of each other (see the discussion that led to it in ...
New Page for Tool Requests
Stemming from recent discussion in the RootsMagic Community about the desire for a system to track Feature Requests for the RootsMagic application, I was curious to see what might be readily available and came across a free plugin for WordPress: ...
Custom functions in SQLiteSpy with sqlean extension are mighty and fast!
Intro I first reported on the #sqlean extensions for SQLite3 in my 2022 post In Praise of SQLite. What I did not pick up then that I have just now discovered is that sqlean supports the creation of user-defined or ...
RM9 (now 10) Data Documentation Initiative
Please join me in welcoming Kevin McLarnon ( @kmclarnon ) in the role of Editor on this site and, especially, for volunteering to lead a renewed initiative to improve the documentation we have on the design of the RootsMagic v9 ...
Richard Otter Genealogy Scripts
https://github.com/ricko2001/Genealogy-scripts Richard Otter is a skilled, professional developer who is also a RootsMagic user and has been building a library of scripts that are worthwhile checking out for possible solutions for your own needs. He publishes them on GitGub, list ...
Sources – Newspapers.com – Cleaner Footnotes and Simpler Bibliography
Issues This project arose from a request Fix & Merge Hundreds of Newspapers.com Sources in the Forum. The poster is a heavy consumer of the Newspapers.com sources through RM's TreeShare with Ancestry.com and had issues with:
- A long Source ...
Source Names – Append Surnames
Sources view in RM9 after running the script to append Surnames of people using each Source. In response to a request in the Forum, Adding Surname to Truncated Source Names in RM9, posted here is a script that may be ...
DBeaver Heredis 2023 and RootsMagic 9
They say a picture is worth a thousand words. This page compares pictures of the #RM9 and Heredis 2023 databases (both SQLite 3) as automatically created by the same tool. Entity Relationship Diagrams An Entity-relationship Diagram (ERD) says a lot ...
