Marten with CockroachDB

[jinhong-]

Did anyone try this before? Seems to have API compatibility with Postgres's API specifications

[mysticmind]

@jinhong- This is very interesting. CockroachDB fully supports PostgreSQL wire protocol and also supports JSONB since v2.0. I don't think anyone in the Marten community tried this. It will be worth trying out...

https://www.cockroachlabs.com/docs/stable/jsonb.html

[jinhong-]

I personally have yet to try this. Was hoping someone here already have experience with it

[jinhong-]

Just a quick update, i deployed cockroachdb and attempted to hook it up with marten. Immediately after i attempted to run it, i get the following error: unknown function: pg_get_functiondef(). So i guess it's a no go

[mysticmind]

@jinhong, can you please go ahead and close this issue?

[jinhong-]

Will do. was hoping someone with more expertise on marten could give more insights and get it working

[mysticmind]

Even though CockroachDB has wire compatibility, Marten via Npgsql uses many pg_* functions for schema management etc which won't be available in CockroachDB. Besides we also use JavaScript functions via plv8 extensions. I think it will be difficult to get it working with CockroachDB.

…

On Wed 12 Sep, 2018, 7:46 AM Jin, ***@***.***> wrote: Will do. was hoping someone with more expertise on marten could give more insights and get it working — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#1075 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ACu0UJX8upzMdCp6XOHIkWg4Qcorhub0ks5uaG5xgaJpZM4WLKJK> .

[dbist]

JasperFx/weasel#78