Looking for a solution to connect directly from a PostgreSQL database to a SQLite database. We need PostgreSQL for it's Window/Analytic functions and other features that SQLite doesn't have. Yet, SQLite is great for collecting data.

Every one of our experiments adds 300MB to the SQLite database. Rather than exporting to CSV and then importing to PostgreSQL, we'd like to directly access SQLite from PostgreSQL.

Does anyone have good experience using 'Foreign Data Wrapper for sqlite' or another method?
https://github.com/gleu/sqlite_fdw


Joe Fisher
Oregon State University

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to