Garage, Glorp, PostgreSQL and Cursors
Hello, I was trying the version of Glorp ported to Garage, and I must say it runs smoothly, nice job! I am reading large amount of data from a Postgres db, and I was curious about the use of cursors. I remember that the old version of Glorp for Pharo did not support cursors in Postgresql, has this changed in Garage? I tried to run some tests, using a query like: (Query readManyOf: MyClass) collectionType: GlorpCursoredStream; yourself. but with a large number of rows (~300k), the whole image crashes. Is this still not supported, or am I doing something wrong? Thanks, Tommaso
I'm little bit shy, but what is Garage? 2015-08-03 15:33 GMT+03:00 Tommaso Dal Sasso <tommaso.dalsasso@gmail.com>:
Hello,
I was trying the version of Glorp ported to Garage, and I must say it runs smoothly, nice job!
I am reading large amount of data from a Postgres db, and I was curious about the use of cursors. I remember that the old version of Glorp for Pharo did not support cursors in Postgresql, has this changed in Garage?
I tried to run some tests, using a query like:
(Query readManyOf: MyClass) collectionType: GlorpCursoredStream; yourself.
but with a large number of rows (~300k), the whole image crashes.
Is this still not supported, or am I doing something wrong?
Thanks, Tommaso
I'm little bit shy, but what is Garage?
Good question! Alexandre
2015-08-03 15:33 GMT+03:00 Tommaso Dal Sasso <tommaso.dalsasso@gmail.com <mailto:tommaso.dalsasso@gmail.com>>: Hello,
I was trying the version of Glorp ported to Garage, and I must say it runs smoothly, nice job!
I am reading large amount of data from a Postgres db, and I was curious about the use of cursors. I remember that the old version of Glorp for Pharo did not support cursors in Postgresql, has this changed in Garage?
I tried to run some tests, using a query like:
(Query readManyOf: MyClass) collectionType: GlorpCursoredStream; yourself.
but with a large number of rows (~300k), the whole image crashes.
Is this still not supported, or am I doing something wrong?
Thanks, Tommaso
Am 03.08.2015 um 15:11 schrieb ЮÑий ÐиÑоненко <assargaddon@gmail.com>:
I'm little bit shy, but what is Garage?
http://pharo.org/news/garage-database <http://pharo.org/news/garage-database> Norbert
2015-08-03 15:33 GMT+03:00 Tommaso Dal Sasso <tommaso.dalsasso@gmail.com <mailto:tommaso.dalsasso@gmail.com>>: Hello,
I was trying the version of Glorp ported to Garage, and I must say it runs smoothly, nice job!
I am reading large amount of data from a Postgres db, and I was curious about the use of cursors. I remember that the old version of Glorp for Pharo did not support cursors in Postgresql, has this changed in Garage?
I tried to run some tests, using a query like:
(Query readManyOf: MyClass) collectionType: GlorpCursoredStream; yourself.
but with a large number of rows (~300k), the whole image crashes.
Is this still not supported, or am I doing something wrong?
Thanks, Tommaso
participants (4)
-
Alexandre Bergel -
Norbert Hartl -
Tommaso Dal Sasso -
ЮÑий ÐиÑоненко