Re:CockroachDB 2.0 released
by caleblloyd on Wednesday April 04, 2018 @01:00PM
(#16756643)
I do not have a particular project in mind, but think it would be good to have an easily containerizable, replicated OLTP database in my toolkit. I do some work with Entity Framework Core providers and am thinking about trying to implement a provider for CRDB.
[ Parent
| on HN ]
There is already some work towards this with http://www.npgsql.org/
I haven't gone back to try the full entity framework recently, but if you find any bugs, please let us know. If you want to roll your own, we're here to help too.
Re:CockroachDB 2.0 released
by manigandham on Wednesday April 04, 2018 @04:36PM
(#16758789)
CRDB is using the Postgresql wire transport and already works with npgsql + ef core.
Re:CockroachDB 2.0 released
by caleblloyd on Wednesday April 04, 2018 @10:35PM
(#16761329)
Are you sure? I know that the NPGSQL DB driver works with CRDB. Data types, DDL, and supported features are a big part of EF Core providers though. I have not researched it yet but I was pretty sure the NPGSQL EF Core Provider implemetation was just for PG.
Re:CockroachDB 2.0 released
by manigandham on Wednesday April 04, 2018 @11:09PM
(#16761474)
CockroachDB uses the same PostgreSQL wire protocol and SQL dialect so it just looks and works like a pg database. There are some minor differences but DDL and data types are already included in the syntax: https://www.cockroachlabs.com/docs/stable/porting-postgres.h...
It's great if you want to contribute though but I'd recommend just working on the PG EF Core provider which already has some work towards CRDB specific features: https://github.com/npgsql/Npgsql.EntityFrameworkCore.Postgre...
Re:CockroachDB 2.0 released
by caleblloyd on Thursday April 05, 2018 @08:32AM
(#16764190)
Great, thanks for the info. I have worked with @roji before on EF Core upstream issues, NPGSQL EF Core is very good. I will reach out to him!