Learn

Quick Start for Dummies – starting from ground zero…
How to Query RootsMagic – Experiences of novice users and an example using SQLiteSpy to do a database integrity check.
Four Little Queries – Plunge right in, if you have an idea of what you are doing.
Problem Queries – Post your problem for discussion.
SQLite Managers – Choose from one of these tools to run your queries.
MS Access – Or connect to your database with Access and Excel for great looking reports.
Open Office – Use the same ODBC driver as described for MS Access to connect OpenOffice to a RM database. Not recommended!
A Sample Query Created with Views – Jerry Bryan’s excellent Lego-block building technique to break complex queries down into simpler elements.

External Resources

RootsMagic SQLite GEDCOM 5.5.1
Home Home Standard
Forums Wiki Torture Files
Support Management Tools
Users Mailing List
PoorSQL formatter

The PoorSQL formatter does a pretty good job of cleaning up scripts to make them more readable but is written for T-SQL so does not support SQLite SQL fully. It puts a space between double character operators such as <<, >>, ==; these can be readily searched and replaced in a text editor such as PSPad.