Hello, I'm currently working on a feature to MyJSQLView that allows DB to DB table creation for use with creating in memory or local file data for anaylsis. The feature is really being made to facilitate the oposite of your goal of SQLite to PostgreSQL, but rather PostgreSQL/MySQL/Other to something like SQLite, HSQL or Derby.
Have no experience with a foreign data wrapper like mentioned, but usually some of these scipts do not fit most specific case uses that are desired. I think I'm with some others. This would a be simple script or a plugin for MyJSQLView to perform the SQLite to PosgreSQL insertions that does exactly what is desired. Seems like a good task for a post graduate student. Dana Proctor MyJSQLView Project Manager. > Subject: [sqlite] Direct PostgreSQL to SQLite connection? > Message-ID: <5243132b.10...@tanguaylab.com> > Content-Type: text/plain; charset=UTF-8; format=flowed > > 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