Re: [sqlite] Direct PostgreSQL to SQLite connection?

2013-09-26 Thread danap
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:

Re: [sqlite] Direct PostgreSQL to SQLite connection?

2013-09-26 Thread a . furieri
On Thu, 26 Sep 2013 00:01:06 -0700, Alex Mandel wrote: Spatialite I think has a Virtual Postgres table tool too. (You can probably ignore that these are mostly for spatial data, should work fine on regular tables) I'm glad to confirm: SpatiaLite effectively supports a VirtualPG extension modul

Re: [sqlite] Direct PostgreSQL to SQLite connection?

2013-09-26 Thread Alex Mandel
http://www.gaia-gis.it/OpenLite/ ogr2ogr from gdal.org can probably do it on the command line Spatialite I think has a Virtual Postgres table tool too. (You can probably ignore that these are mostly for spatial data, should work fine on regular tables) Honestly a small python script to read from s

Re: [sqlite] Direct PostgreSQL to SQLite connection?

2013-09-25 Thread Vivien Malerba
Hi! Using Libgda (http://www.gnome-db.org) you can create virtual connections which "aggregate" several other connections (meaning all the tables from all the connections can be used in single SQL queries and you could copy data using an "INSERT INTO XXX SELECT ... FROM YYY" query), in your case y

[sqlite] Direct PostgreSQL to SQLite connection?

2013-09-25 Thread joe.fis...@tanguaylab.com
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 databas