How do I handle a large word list for a vocabulary app?

[SteveJG]

@wordworker

a more efficient way to query a long list of words?

A very good FREE Sqllite extension is here:

[FREE] SimpleSqlite - an extension for working with SQLite Databases

This is a fork/rework/remix of Tom Bennedum's open-sourced aix-SQLite extension. (all Credits to Tom!) I have stripped it back to a bare-bones/expert version, without (hopefully) affecting functionality. The key to working with this extension/sqlite is: being clear about which database file and also which database you are working with remembering to OPEN the database to carry out data operations (SELECT etc) remembering to CLOSE the database to carry out file operations (IMPORT/EXPORT etc) t…