Fork me on GitHub
#clojure-uk
<
2020-06-11
>
dharrigan07:06:22

Good Morning!

folcon12:06:02

Morn’ =)…

Ben Hammond13:06:16

how are everyone's viroids today? Still keeping them to yourself?

Conor13:06:07

I have to, school's still closed

dharrigan13:06:08

I'm doing okay. Still very much in mongoland, but I hope to surface by end of the month.

Ben Hammond13:06:54

what is the native language for working with Mongo? is it JS?

Ben Hammond13:06:37

I guess you don't get to cljs it

mccraigmccraig13:06:05

on the db front, i realised a couple of days ago that i've not been keeping up, and there are some quite interesting new(ish) databases around https://www.yugabyte.com/ https://www.cockroachlabs.com/

mccraigmccraig13:06:03

and now i'm thinking on how i'm going to rework our db client so that it's agnostic about which cloud db it's running against... it's probably not so very hard to do, since it just maps queries, modelled as simple clojure structures, to streams of clojure maps

Conor14:06:58

Cockroach is pretty good, I used it at a previous gig

Conor14:06:05

Also miles cheaper than Spanner

mccraigmccraig14:06:20

what's the postgresql compatibility like ?

Conor14:06:34

Pretty good, on the whole

Conor14:06:41

There were some weird bits down in the weeds

Toby Worland15:06:51

What are jobs like in the uk for clojure? Is it realistic to get one after graduating university?

rickmoynihan15:06:28

@tobyw2248: I think most of the active members of this channel have a job involving clojure — so you’re in a good to place to find one, there’s quite a few but by no means loads of places using it.

rickmoynihan15:06:43

not sure how many of these companies are in the UK: https://clojure.org/community/companies

Toby Worland15:06:32

@rickmoynihan Cheers. I'll take a look at the list.

alexlynham16:06:31

although also true that many of us do clj / then other stuff / then back to clj -> pays to be a bit versatile cos 'tis niche

dharrigan17:06:48

oh mongo mongo

dharrigan17:06:02

when doing a dump, be sure to use the master, not replicas.

💩 8
dharrigan17:06:17

You know, to prevent corruption of the restore....

dharrigan17:06:29

sorry, just venting a bit of my mongo-rage 🙂

dharrigan17:06:00

if you do a dump of a collection, from a read replica, then try to restore that dump back to a pristine db, it can fail with a corruption message.

dharrigan17:06:44

so, when you do a dump, you have to explicitly say which is the master to dump from

seancorfield19:06:32

Not so much "eventually consistent" as "eventually corrupted"...

seancorfield19:06:08

We used to use MongoDB heavily. I used to go to a lot of MongoDB conferences. After hearing all the horror stories, sorry "experience reports", of what it took to keep MongoDB running correctly without corrupting data, we migrated all that stuff back to MySQL/Percona...

dominicm19:06:25

I'm grating against sql a little right now. Analytical SQL is hard to do at a transactional (e.g. per account) level. I've resorted to saying "eh, this'll probably fit in memory. Lets just fetch it and process with Clojure"

dominicm20:06:05

@mccraigmccraig specific case was that I had a delta change of things per day throughout history, and I wanted to get the totals per day for the last 30 days. Doing windowing and stuff for this was pretty tough.

thom03:06:40

What about your schema made this hard?

dominicm06:06:17

Not sure I understand the question.

dominicm20:06:15

reductions made mincemeat of it though.

mccraigmccraig20:06:54

nice! i don't think I've ever used reductions