Other examples? #1

Activity

1. 1st1 commented on Jul 20, 2016

   

   1st1

   on Jul 20, 2016

   Last edited by 1st1

   Member

   More actions

   Hi @illume,

   We've only open sourced asyncpg yesterday, so I believe there aren't a lot of examples with it that you can find.

   Currently I'm interested in if you can stream results from/to pg?

   Postgres doesn't provide streaming capabilities. The closest thing you can get is to use cursors to efficiently iterate over huge result sets.
2. 1st1

   added

   question

   on Jul 20, 2016
3. illume commented on Jul 20, 2016

   

   illume

   on Jul 20, 2016

   Author

   More actions

   Aha! Well that explains why I can't find anything on the internet about it.

   If I have one row that is about 1MB (bytea https://www.postgresql.org/docs/9.5/static/datatype-binary.html), does that mean I have to wait until it is entirely written in a buffer before getting access to the full buffer? Or can I get access to the buffer with an index of where it is up to? I guess I will look through the source.

   I will also be using LISTEN and NOTIFY ( https://www.postgresql.org/docs/9.5/static/sql-listen.html ).

   Anyway... looking forward to playing with it some more.
4. illume

   closed this as completedon Jul 20, 2016
5. 1st1 commented on Jul 20, 2016

   

   1st1

   on Jul 20, 2016

   Member

   More actions

   I will also be using LISTEN and NOTIFY ( https://www.postgresql.org/docs/9.5/static/sql-listen.html ).

   Yes, see issue #2. We'll implement this shortly.
6. illume commented on Jul 21, 2016

   

   illume

   on Jul 21, 2016

   Author

   More actions

   Oh! Thank you very much :)
7. elprans

   added a commit that references this issue on Nov 7, 2021

   Improve diagnostics of invalid executemany() input

   ...

   2e4f0b6
8. elprans

   added a commit that references this issue on Nov 16, 2021

   Improve diagnostics of invalid executemany() input

   ...

   b3f5c5c