--- Begin Message ---
Very cool. Thanks!
Doru
> On Dec 31, 2018, at 12:33 PM, Sven Van Caekenberghe <s...@stfx.eu> wrote:
>
> Hi,
>
> I created a new release of P3, the modern, lean and mean PostgreSQL client
> for Pharo.
>
> https://github.com/svenvc/P3
>
> Version 1.1 contains the following changes:
>
> - added support for Postgres Extended Query protocol (P3PreparedStatement)
> (thx Jan @jvdsandt)
> - added support for reading array type values (currently INTEGER[] FLOAT[]
> BOOLEAN[] TEXT[] VARCHAR[])
> - added P3-Tests package and moved all tests there
> - more comments
> - more unit tests
>
> https://github.com/svenvc/P3/releases/tag/v1.1
>
>
> Especially Jan's contribution adds a lot of functionality: the ability to
> work with prepared statements.
>
> Here is an example doing a batch insert of 100 records (which is more
> efficient).
>
> | client statement |
>
> client := P3Client url: 'psql://sven@localhost'.
>
> client execute: 'DROP TABLE IF EXISTS table1'.
> client execute: 'CREATE TABLE table1 (id SERIAL PRIMARY KEY, created_at
> TIMESTAMP DEFAULT NOW(), name TEXT)'.
>
> statement := client prepare: 'INSERT INTO table1 (name) VALUES ($1)'.
> statement executeBatch: ((1 to: 100) collect: [ :index | Array with: ('Text
> #', index printString) ]).
>
> client query: 'SELECT * FROM table1'.
> client execute: 'DROP TABLE table1'.
>
> statement close.
> client close.
>
>
> Season's Greetings to you all.
>
> Sven
>
>
> --
> Sven Van Caekenberghe
> Proudly supporting Pharo
> http://pharo.org
> http://association.pharo.org
> http://consortium.pharo.org
>
>
>
>
--
www.feenk.com
"To utilize feedback, you first have to acquire it."
--- End Message ---
