I have a small project where I need to write a JAVA program that can join two sqlite databases containing the same tables.
Data in the tables of each database are indexed using pseudo-keys, but each item
also has a key that is unique over all databases (global identifier: GID).
Each item is tagged by a "creation date".
When instances of the same record are found with different dates, store only
the most recent (based on creation date).
A separate file (config_file) is provided that specifies fields in each table that correspond to preferences.
Only the newest should be stored (based on the field "preference date").