Support for PostgreSQL

[bronislav]

I see that some SQL queries and migration are designed primary for MySQL and won't be able on PostgreSQL out-of-the-box.

Do you guys interested in supporting postgres? Will you accept PR?

[jnunemaker]

We only use MySQL so that is our aim for github-ds. That said, I don't think we are opposed to a solid, well-tested PR for postgres support if it doesn't cause too much complexity. I'd really have to see it, but I'm definitely game to see it. 😄

[bronislav]

@jnunemaker OK. Got it.

[jnunemaker]

Its worth noting that GitHub::SQL pretty much works out of the box. See this gist for getting cast operators to work.

https://gist.github.com/jnunemaker/123be8db3d95d8386fc258f99e7fd99a

Also, I have a pg kv implementation sitting around somewhere. I'll try to find it and drop the link. I don't think it was perfectly compatible with github-ds kv, but supported the stuff that I needed.

[jnunemaker]

Here is the postgres kv version.

https://gist.github.com/jnunemaker/f3954a1b82ac97750979389a37c573f2

I used jsonb to make it possible to query within the serialized value.