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 ...
RM9 Database Diagram #rm9 #database
Database Diagram for RootsMagic version 9 – there are probably more table relationships to be added. RM9Database Diagram to Download ...
Remove Duplicate Merged Notes
Introduction This script was prompted by a discussion in the RootsMagic Community on Feb 10 '23: Notes are duplicated. The duplicate begins with MERGED NOTE. It is not uncommon, viz this Google search for the MERGED NOTE flag generated by ...