Fork me on GitHub
#clojure-nl
<
2019-05-17
>
thomas07:05:03

mogge... more Excel to SQL translating

Dmytro Bunin07:05:46

fun week thomas

mitchelkuijpers07:05:50

Morning, working on some drag and drop to re-order lists

thomas07:05:05

yes... one could say that... but the end is getting closer now. So hopefully done today. šŸ¤ž

thomas07:05:33

but it also demonstrated that relational databases are not particularly good at describing relations. I do wonder if Graph databases would (a lot of) value in surprisingly lots of cases.

gklijs07:05:24

Do you have a lot of many to many relations?

helios07:05:40

If the core of your database is modeling relations, probably yes šŸ˜„

thomas07:05:00

not really... but we have are describing a tree structure in a table.

gklijs07:05:21

thats sounds more like the data model is wrong then?

thomas07:05:45

and we are effectively moving nodes in the tree.

thomas07:05:57

most likely, but it is what it is.

helios07:05:31

If there is very deep hierarchy I can imagine that is a PITA. I have dealt with also a DB in which relations were the most important bit but essentially there were only two main entities, then a table with just two columns A,B, and when the row exists means an edge between two entities was effective enough

thomas07:05:53

not that it ever was envisaged that this was needed of course.

thomas07:05:51

I have been playing a bit with Neo4J and I have the impression something like that would solve quite a few of our problems in this case... but I am not certain, just a hunch.

thomas07:05:33

and there will be no time to go and figure it out of course if something like that would be a viable alternative. (not that I propose to rewrite the application)

gklijs08:05:52

I just open-sourced the code for running/testing the (kafka) bank application https://github.com/openweb-nl/open-bank-mark still need to go through the readme some time, most of it is a year old. And only two weekends left to prepare for the Kafka Meetup presentation.

šŸ‘ 8
borkdude08:05:56

@thomas Neo4jā€¦ why not Datomic? šŸ˜„

borkdude08:05:54

or the new shiny thing that was announced at Clojure North..

thomas08:05:59

I went to a presentation 2(?) years ago where someone from Neoj4 held a rather convincing (sales) talk.

thomas08:05:11

yes, Crux sounds very interesting as well.

thomas08:05:03

in my app I don't really care about time though... nor changing state as such.

thomas08:05:17

and I do care more about relations... and in this case a RDBMS would be fine I think. just for the work thing I am wondering if a graph DB would make sense

borkdude08:05:33

ok, cool. we do have a triplestore aside from our rdbms exactly for this problem