Thanks a lot .. this helped..
On Fri, Jul 3, 2015 at 10:16 PM, Simon Slavin wrote:
>
> On 3 Jul 2015, at 5:16pm, Kumar Suraj wrote:
>
> > So whats the solution here. I am giving 4 statements because i need
> insert
> > to be transactional. Some other process could be inserting in the same db
>
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.
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. Th
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 c
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 almost
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 pgdatabase
Is there a way (free, open source, Ubuntu) to convert a
PostgreSQL-database with data in it to a sqlite database?
7 matches
Mail list logo