You can now query a Postgres database from the new GT. The initial code is available here: https://github.com/feenkcom/gt4p3
It currently looks like this: Cheers, 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 "What is more important: To be happy, or to make happy?"
