{"repo":"svenvc/P3","free":true,"listed":false,"github":"https://github.com/svenvc/P3","clone":"git clone https://github.com/svenvc/P3.git","description":"A lean and mean PostgreSQL client for Pharo","language":"Smalltalk","stars":81,"topics":["pharo","smalltalk","postgresql","database-driver","glorp"],"license":"MIT","category":"databases-storage","readme_excerpt":"P3 P3 is a modern, lean and mean PostgreSQL client for Pharo. P3Client uses frontend/backend protocol 3.0 (PostgreSQL version 7.4 [2003] and later), implementing the simple and extended query cycles. It supports plaintext, md5 and scram-sha-256 password authentication. When SQL queries return row data, it efficiently converts incoming data to objects. P3Client supports most common PostgreSQL types. P3Client can be configured manually or through a URL. Not all properties need to be specified, the minimum is the following URL. P3Client has a minimal public protocol, basically #query: (#execute: is an alias). Opening a connection to the server (#open) and running the authentication and startup protocols (#connect) are done automatically when needed from #query. P3Client also supports SSL connections. Use #connectSSL to initiate such a connection. Alternatively you can add sslmode=require to the connection URL, as in 'psql://username:password@localhost:5432/databasename?sslmode=require' . Through the #prepare: message, you can ask P3Client to prepare/parse an SQL statement or query with parameters. This will give you a P3PreparedStatement instance than you can then execute with specific parameters. Polymorphic to this there is also P3FormattedStatement which you create using the #format: message. These work at the textual, client side level. Basic Usage Here is the simplest test that does an actual query, it should return true. This is how to create a simple table with some rows ","default_branch":null,"files":null,"tree":[],"storefront":"/r/svenvc","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/svenvc/P3/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}