Re: [ANN] shadow-pgsql: PostgreSQL without JDBC

2014-10-17 Thread Thomas Heller
I meant to do a proper release announcement for quite some time now but simply don't have the time to do it properly. That being said I have now been using shadow-pgsql [1] in production for well over a month and it has been working as expected and "stable". A couple million Queries were execut

Re: [ANN] shadow-pgsql: PostgreSQL without JDBC

2014-09-03 Thread Thomas Heller
Hey, No. I was not aware that redshift is PostgreSQL under the hood. Based on the docs it is based on PostgreSQL 8.0.2 and might not support some features I use to get the type thing working. It might be possible to make it work but you'll probably lose most of the features I implemented shadow-p

Re: [ANN] shadow-pgsql: PostgreSQL without JDBC

2014-09-03 Thread Ludwik Grodzki
Hi. Have you tried it with Amazon's redshift? Regards. Ludwik. On Thursday, 21 August 2014 19:00:11 UTC+1, Thomas Heller wrote: > > Hey Clojure Folk, > > I'm close to releasing the first alpha version of > https://github.com/thheller/shadow-pgsql a "native" interface to > PostgreSQL I wrote.

Re: [ANN] shadow-pgsql: PostgreSQL without JDBC

2014-08-25 Thread Thomas Heller
http://commons.apache.org/proper/commons-pool/ 2.2 The clojure end should manage connection handling for you, if you need to keep a connection open (or transactions) there are (shadow.pgsql/with-connection db ...) and (shadow.pgsql/with-transaction db ...) macros, you should never actuall

Re: [ANN] shadow-pgsql: PostgreSQL without JDBC

2014-08-24 Thread Shashy Dass
What does the library do for connection pooling? Thanks, Shashy On Saturday, August 23, 2014 8:05:37 PM UTC-4, Thomas Heller wrote: > > EDN/Transit on the backend might be nice, but a little much for me. I'll > take it if you feel like a lot of C. jsonb in 9.4 will have to do for now. > > Transp

Re: [ANN] shadow-pgsql: PostgreSQL without JDBC

2014-08-23 Thread Thomas Heller
EDN/Transit on the backend might be nice, but a little much for me. I'll take it if you feel like a lot of C. jsonb in 9.4 will have to do for now. Transparent encoding/decoding is already built-in to the client though, even with array support to encode a clojure set to postgres text[] and back.

Re: [ANN] shadow-pgsql: PostgreSQL without JDBC

2014-08-23 Thread Jason Jackson
This makes me wonder if it would make sense to create a Postgresql plugin that adds a keyword type and other similar types, that would allow for a more precise roundtrip between Clojure and Postgres. Jason On Sat, Aug 23, 2014 at 11:23 AM, Thomas Heller wrote: > Hey Kyle, > > thanks for the Feed

Re: [ANN] shadow-pgsql: PostgreSQL without JDBC

2014-08-23 Thread Thomas Heller
Hey Kyle, thanks for the Feedback. Appreciate it. I think you misunderstood the meaning of a "type" in shadow-psql. A "type" is merely the format of how a given value is represented on the wire since the backend needs to understand what we send it. Postgres supports 2 different Wire Formats: T

Re: [ANN] shadow-pgsql: PostgreSQL without JDBC

2014-08-23 Thread Kyle Cordes
On Thursday, August 21, 2014 at 1:00 PM, Thomas Heller wrote: > Hey Clojure Folk, > > I'm close to releasing the first alpha version of > https://github.com/thheller/shadow-pgsql a "native" interface to PostgreSQL I > wrote. > > Its an implementation of the native binary protocol without any

[ANN] shadow-pgsql: PostgreSQL without JDBC

2014-08-21 Thread Thomas Heller
Hey Clojure Folk, I'm close to releasing the first alpha version of https://github.com/thheller/shadow-pgsql a "native" interface to PostgreSQL I wrote. Its an implementation of the native binary protocol without any intent to ever support JDBC. Mostly because that provides a bunch of features