[sqlite] convert a PostgreSQL to sqlite

Is there a way (free, open source, Ubuntu) to convert a PostgreSQL-database with data in it to a sqlite database?

[sqlite] convert a PostgreSQL to sqlite

On 5 Jul 2015, at 1:44pm, c.buhtz at posteo.jp wrote: > Is there a way (free, open source, Ubuntu) to convert a > PostgreSQL-database with data in it to a sqlite database? Dump the Postgres database to a text file of SQL commands. Then use the SQLite command-line tool to .read that text file.

[sqlite] Slow real world performance - Any suggestions please (warning long)

On Fri, 3 Jul 2015 11:35:21 +0100 Rob Willett wrote: > It basically has taken no time to run 10,551 selects. This implies > that we had issues on the database before with either fragmentation > or indexes being poorly setup. Perhaps you said so and I missed it, but to me it's clear that

[sqlite] convert a PostgreSQL to sqlite

On Sun, Jul 5, 2015 at 7:44 AM, wrote: > Is there a way (free, open source, Ubuntu) to convert a > PostgreSQL-database with data in it to a sqlite database? > If you're looking for something already done, I am not aware of anything that will do that "out of the box" convertPGtoSQLite

[sqlite] convert a PostgreSQL to sqlite

Welcome to SQLite3! Make sure SQLite3 is appropriate for your use; for some use cases a client-server database like PostgreSQL is recommended: "Situations Where A Client/Server RDBMS May Work Better ...If there are many client programs sending SQL to the same database over a network, then use a

[sqlite] convert a PostgreSQL to sqlite

Are you using an PostgreSQL add-ins such as "PostGIS" or an object relational mapper? In that case I would recommend an intermediate program or language. For example, if you are using the PostGIS add-in I would recommend going through a GIS program such as ESRI's ArcGIS or the open source QGIS.