I'm able to access a remote PostgreSQL table from my server. However, the PostgreSQL table contains around 50 mio. records, and I have a certain column ID which I only need.
I would like to replicate the PostgreSQL table (including a WHERE clause) to a in-memory SQLite database, which will sync/update every 30 minutes (or so). In reboot etc. the replication may start over. How would be the best approach to such a challenge? I've actually never worked with SQLite before. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users