github-ds icon indicating copy to clipboard operation
github-ds copied to clipboard

Published 20 hours ago • verified publisher icon github

Support for PostgreSQL

Open bronislav opened this issue 7 years ago • 4 comments

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?

bronislav avatar May 18 '17 14:05 bronislav

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. 😄

jnunemaker avatar May 22 '17 13:05 jnunemaker

@jnunemaker OK. Got it.

bronislav avatar May 22 '17 13:05 bronislav

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 avatar Dec 03 '21 15:12 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.

jnunemaker avatar Dec 03 '21 15:12 jnunemaker