Why CockroachDB and PostgreSQL Are Compatible

Re:Why CockroachDB and PostgreSQL Are Compatible by jpgvm on Thursday December 17, 2020 @07:59AM (#25455154)

PostgreSQL enums don't have a binary encoding AFAIK. This is partially why they aren't considered that useful in many contexts vs a fact table.

From memory this is because there is no natural binary encoding, you could use the int number of the member in the enum but then you would need to communicate the enum members to the client in some way. PostgreSQL network protocol currently doesn't have such out of band information/metadata support.

[ Parent | on HN ]

Re:Why CockroachDB and PostgreSQL Are Compatible by latch on Thursday December 17, 2020 @08:37AM (#25455415)

Whatever the issue, it's compatibility related, as Elixir's PostgreSQL driver (Postgrex) works with PostgreSQL enums but not CockroachDB's enums, and it has to do how the driver encodes the values.

[ Parent | on HN ]

Re:Why CockroachDB and PostgreSQL Are Compatible by kitotik on Thursday December 17, 2020 @01:44PM (#25458764)

Are Postgrex/Ecto usable with cockroach now?

I’m about to start a new project, and would very much like to utilize an existing cluster.

[ Parent | on HN ]

Re:Why CockroachDB and PostgreSQL Are Compatible by latch on Thursday December 17, 2020 @07:45PM (#25462447)

We just use Postgrex directly. Not sure about Ecto.

[ Parent | on HN ]