These are chat archives for damianh/Cedar

18th
Jun 2015
Dan Barua
@danbarua
Jun 18 2015 13:30
oh hai
Cedar.EventStore.Postgres or wack it in and ilmerge npgsql...
João Bragança
@thefringeninja
Jun 18 2015 13:31
@damianh how are we doing rdbms specific libraries for Cedar.EventStore?
So definately a Cedar.EventStore.Postgres project. send PR to https://github.com/damianh/Cedar.EventStore i don't think we want this scattered all over the interwebs
Dan Barua
@danbarua
Jun 18 2015 13:32
cool
i'll get cracking
smoke me a kipper, i'll be back for breakfast
Damian Hickey
@damianh
Jun 18 2015 13:32
Yo Dan
Dan Barua
@danbarua
Jun 18 2015 13:33
yo
Damian Hickey
@damianh
Jun 18 2015 13:33
Delighted you'd like to contrib
João Bragança
@thefringeninja
Jun 18 2015 13:34
seriously, fuck all that generic sql bullshit in neventstore
Damian Hickey
@damianh
Jun 18 2015 13:34
I think I'd advise to hold off first a bit though, make sure I get the MsSql one working
Dan Barua
@danbarua
Jun 18 2015 13:34
no prob
Damian Hickey
@damianh
Jun 18 2015 13:34
and when it's working, then check it's not completely retarded.
there is always a chance of that.
Dan Barua
@danbarua
Jun 18 2015 13:34
i've got a couple of weeks to make some tech decisions
Damian Hickey
@damianh
Jun 18 2015 13:35
I'd like to get the subscribtion API twerking first too.,
Am following GES behaviour but don't know yet how much I can replicate and how leaky it will be.
Dan Barua
@danbarua
Jun 18 2015 13:35
hmm
Damian Hickey
@damianh
Jun 18 2015 13:36
I rather people not expend effort, unless, you really have to scratch that itch.
Am relatively close to behaviour compatibility though
Dan Barua
@danbarua
Jun 18 2015 13:37
i don't mind having a play with it
Damian Hickey
@damianh
Jun 18 2015 13:37
Except the idempotency handling, not sure how to do that yet.
Dan Barua
@danbarua
Jun 18 2015 13:37
it's this or NES5/6/whatever or maybe even GES or roll my own
Damian Hickey
@damianh
Jun 18 2015 13:38
I'd value your opinion on this either way.
If you can use GES why not go for it?
Dan Barua
@danbarua
Jun 18 2015 13:38
good question
i have two datacentres, where does node #3 go
should i run it on linux or windows
we're shipping postgres in an on-premise product, so there is a bit of experience in house with that
Damian Hickey
@damianh
Jun 18 2015 13:39
We'd like to use GES, but we definitely have to deploy on-prem against RDBMS, hence my motivation.
Dan Barua
@danbarua
Jun 18 2015 13:39
and i'm moving our read model from Redis to PGSQL anyway
Damian Hickey
@damianh
Jun 18 2015 13:39
So GES in the datacentre for us.
Dan Barua
@danbarua
Jun 18 2015 13:39
yeah as the.fridge.ninja mentioned
longer term we're looking at akka.net and akka.persistence either with pgsql or GES
Damian Hickey
@damianh
Jun 18 2015 13:40
Been tempted to use PGSQL for read models. Does it have a good xcopy delploy story?
Dan Barua
@danbarua
Jun 18 2015 13:40
i think if you have the right vc++ runtime installed you migh tjust be able to xcopy it
the installer has plenty of cmdline flags to override settings etc
we bundle it in our installer
i don't think it relies too much on crap in the registry or environment variables it's all conf files
João Bragança
@thefringeninja
Jun 18 2015 13:44
no embedded story though :(
Dan Barua
@danbarua
Jun 18 2015 13:44
oh that would be nice
Damian Hickey
@damianh
Jun 18 2015 13:45
Yeah the embedded story is really sweet.
Maybe the nanocontainer stuff will provide relief for non- .net external process.
nuget install ourpostgrescontainer
or something
João Bragança
@thefringeninja
Jun 18 2015 13:51
@damianh you wanted feed back on command handling 162
so far so good, didn't break much from what I can see
Damian Hickey
@damianh
Jun 18 2015 13:51
deadly
Dan Barua
@danbarua
Jun 18 2015 13:55
yeah i've pretty much decided i'm using this over NES
JsonData NVARCHAR(max)
-> JsonData json
vs VARBINARY
throw that crappy WPF event browser app in the sea
woohoooooooooo
Damian Hickey
@damianh
Jun 18 2015 13:55
Yeah, this is more ops friendly
if you need all that compression / encryption in the store stuff, you've got bigger problems and should pay to build your own.
the metadata bits will need to change too, fyi.
Dan Barua
@danbarua
Jun 18 2015 13:58
no prob
happy to spike and dogfood
it's a moving target but a small one
Damian Hickey
@damianh
Jun 18 2015 13:59
There are failing tests in the MsSql atm, WIP.
João Bragança
@thefringeninja
Jun 18 2015 14:02
@damianh are any of the incantations of the PollingClient tested? I need to throw some tests over it or you will complain
Damian Hickey
@damianh
Jun 18 2015 14:08
there is no polling client on CES side yet
Don't get you...
João Bragança
@thefringeninja
Jun 18 2015 14:08
right but remember I'm baking it somewhere. it has no test coverage
because you know tests are for chumps
trying to find the right way to test it
Damian Hickey
@damianh
Jun 18 2015 14:10
Start client, append event, wait for notification, get event
Dan Barua
@danbarua
Jun 18 2015 14:11
before i spike it, would using postgres' NOTIFY feature be a dumb idea...
Damian Hickey
@damianh
Jun 18 2015 14:11
Not at all
Am going to use SqlDependency or whatever it is
Dan Barua
@danbarua
Jun 18 2015 14:12
sweet, not barking up the wrong tree then
Damian Hickey
@damianh
Jun 18 2015 14:12
to reduce latancy for client
this is why I'm heading down the path of store independent impls
João Bragança
@thefringeninja
Jun 18 2015 14:12
remember now that there's no more generic sql flavor nonsense in there. you absolutely should be using database specific features
Damian Hickey
@damianh
Jun 18 2015 14:12
to leverage these things.
Dan Barua
@danbarua
Jun 18 2015 14:12
CREATE TYPE dbo.NewStreamEvents AS TABLE what is this sorcery?
Damian Hickey
@damianh
Jun 18 2015 14:12
^^
Dan Barua
@danbarua
Jun 18 2015 14:13
that's what i was thinking
Damian Hickey
@damianh
Jun 18 2015 14:13
That'll be a database specific feature :)
Dan Barua
@danbarua
Jun 18 2015 14:13
right
Damian Hickey
@damianh
Jun 18 2015 14:13
Table Valued Paramaters
Dan Barua
@danbarua
Jun 18 2015 14:13
is that for your notifications
ok
Dan Barua
@danbarua
Jun 18 2015 14:14
cool, i think we have something similar in postgres
i'm abusing it to flatten out a key-value column into a view for reporting
Damian Hickey
@damianh
Jun 18 2015 14:20
cool
Dan Barua
@danbarua
Jun 18 2015 15:28
looks like we'll be waiting for Npgsql to support custom user types
Damian Hickey
@damianh
Jun 18 2015 15:28
guess it'll be a generated multiple insert statement then.
Dan Barua
@danbarua
Jun 18 2015 15:30
(╯°□°)╯︵ ┻━┻
Damian Hickey
@damianh
Jun 18 2015 15:30
Am open to other ideas for multiple insert in a transaction
I'll prob have to do change something for idempotency shizzle.
Dan Barua
@danbarua
Jun 18 2015 15:34
events -> csv -> bulk insert maybe?
Damian Hickey
@damianh
Jun 18 2015 15:36
I.. have no idea :|
Dan Barua
@danbarua
Jun 18 2015 16:11
warning: horrible hacky code
João Bragança
@thefringeninja
Jun 18 2015 16:13
indenting is wrong. pull request denied.
Dan Barua
@danbarua
Jun 18 2015 16:13
haha
Dan Barua
@danbarua
Jun 18 2015 16:20
is this running some fancy new version of xunit?
Damian Hickey
@damianh
Jun 18 2015 16:20
2.0
Dan Barua
@danbarua
Jun 18 2015 16:20
no worky in R# 7 then
Damian Hickey
@damianh
Jun 18 2015 16:20
no idear
João Bragança
@thefringeninja
Jun 18 2015 16:20
um
Damian Hickey
@damianh
Jun 18 2015 16:20
am on R#9
and I use ncrunch mostly
this should be ncrunch friendly
Dan Barua
@danbarua
Jun 18 2015 16:23
ok fuck it installing trial
can you debug tests in ncrunch?
oh hi ncrunch, it's been a while
Dan Barua
@danbarua
Jun 18 2015 16:28
hm strange it's not picked up my tests
Damian Hickey
@damianh
Jun 18 2015 16:38
got to split ttyl