Jump to content


Photo

SQLite now supports recursive queries

sqlite

  • Please log in to reply
No replies to this topic

#1 TomH

TomH

    Advanced Member

  • Members
  • PipPipPip
  • 6256 posts

Posted 15 April 2014 - 08:53 PM

For SQLite users, some good news: as of Feb 2014 ver 3.8.3 of SQLite introduced support for recursive queries which now makes it possible to climb genealogical trees quickly and efficiently without having to do the recursion in a high level programming language. I have worked up some examples at http://sqlitetoolsfo...t?tag=recursive


Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.