Exploit your RootsMagic family tree database with SQLite Tools
Applications that use SQLite with the RM database or operate on RM’s inputs or outputs.
Just learned of some interesting things about SQLite in this article that popped up in my Google News feed: In Praise of SQLite by Nikos Vaggalis, dated 28 July 2022. The latest version of SQLite is 3.39.2. I don’t monitor releases so this story made me aware of some significant changes delivered in 3.39.0 and…
TestExternalFiles by Richard J. Otter is a new Windows utility that helps identify these issues: A file on disk may get renamed, or moved, breaking the linkfrom the database. A file may be added to the media folder on disk but then not attached to thedesired database element. A file may be added to RM,…
SQLite Expert now takes the lead as the most compatible with the RootsMagic RMNOCASE collation, thanks to the C extension unifuzz.dll authored or revised by Jean-Christophe Deschamps. Unifuzz can be used with other SQLite managers that support extensions, including the command-line shell sqlite3.exe but not, regrettably, SQLiteSpy. This is not simply a renamed equivalent of…
This is NOT SQLite! Rather, RMÏ€ (RMpi) is a little application that tweaks a GEDCOM file you want imported into RootsMagic for potentially more complete data transfer. More development may come later but it could be useful now, especially to early emigres from The Master Genealogist 9.0.3 and earlier. Perhaps equally importantly for exchanges between…
Background RootsMagic 4+ has an internal, proprietary collation sequence called RMNOCASE that controls the order in which names of people, places, sources, etc. are sorted. Fields that are defined to use this collation cannot be sorted by an external SQLite tool without overriding it with another collation sequence, e.g.: NOCASE, nor can they be edited…
I installed SQLite Expert Personal Edition Version 5.2.2.240 (x64). ve3meo Nov 12, 2017 What is your OS? Is it 32 or 64 bit. You can install 32 or 64 bit programs on a 64 bit OS but you cannot install a 64 bit program on a 32 bit system. 32 bit programs on a 64…
There is growing interest in the RootsMagic user community in being able to run SQLite Tools for RootsMagic scripts under the Apple MacIntosh operating system. If RootsMagic Inc succeeds in releasing a multi-platform version, then there will undoubtedly be a surge in the number of native-Mac OS users of RootsMagic and corresponding pursuit by some…
You need a SQLite manager such as SQLiteSpy to read and modify a RootsMagic database using the queries or scripts from this wiki. That’s because RootsMagic incorporates the SQLite 3 database engine to write and read its database files. SQLite acts on the database in response to SQL statements or commands it is given. These…
This page has not been updated since 2012 but many scripts have been added since. The tag cloud on the home page and the search control are two good ways to find pages of interest. RootsMagic Queries Many of these were developed around RootsMagic 4 and should also work on RootsMagic 5 and 6 with…
SQLite Management Tools : a comprehensive table for multiple operating systems but not updated since 2011. The following table describes a few tried by one member of this wiki. The page SQLite Managers for Mac OS looks into some for the Mac. Win Mac Product Review Rating TomH Y N SQLite Expert Personal Free subset…