'orning!

o/

It’s not correct terminology unless you can pronounce it in correct characters ;P

Interestingly Toyota also do FP, only in Elixir. Maybe we should ask them how they manage those teams XD

Moin moin

Morning

måning

if each of those 1500 μsvcs has its own cassandra keyspace in a single cassandra cluster then they are quite a long way outside cassandra's documented limits for # of active tables (a few hundred)

although i guess many of those tables may be small and low traffic, so it might be ok

\o

bad news == didn't listen

poor Cassandra

oh I only just read the wikipedia page > According to legend, Cassandra had dark brown curly hair and dark brown eyes, and though beautiful and clever, was considered insane

We're moving away from Cassandra for most of our stuff

PostgreSQL FTW!

Keepin It Simple

I have some serious luuurve for postgres

Would you be interested in attending ClojureX if it still went ahead? Please fill out this form to gauge interest, thanks https://forms.gle/YCCBzPuUKxNnRT2p9

@dharrigan i like cassandra... there's lots of stuff it's not good for though. what prompted your shift ?

In the end, we found that postgresql does what we need, plus it's far easier to query

we also use redshift for terabytes of data

yeah, we're dumping from cassandra to redshift for analytics queries. postgresql window functions are a thing of wonder

they are indeed 😉

slight tangent; what's feeling here about database triggers in Postgres? Personally I dislike them and I'm trying to untangle a project that has used them in unexpectted places

i've always been a bit nervous of them, but i might use them. i suspect that used well they could be simplifying things, and they can probably dig you out of a hole too... but they are quite opaque and could lead to difficult to comprehend emergent behaviours

I've had systems fall over because another team inserted a trigger (that then started to fail), aborting the entire transaction and that soured me on them

hmm perhaps that scales out into how I feel about reactive programming generally

I'd rather play 'Follow the leader' than 'Chinese Whispers' Easier to troubleshooot

I use database triggers

Only one mind, but still very useful

why choose a trigger, rather that do it from the clojure code?

saves a roundtrip on network

I would have to do a select, pull back the results, evaluate it, then do an upsert

whereas, with the tigger, it happens within the same transaction of the insert, and happens there and then on the instance

and this trigger has to fire for every row

for when INSERT... ON CONFLICT ... just doesn't cut it

the tigger is doing a calculation

I've been burned too many times by code in a database

re:cassie - it is really good at what it is good at, but not good for things like adhoc analysis (but then you don't really want to do analysis on your operational db anyway)

We have a breakfast event on the 21st of Nov coming up in Canary Wharf, aimed at the FinTech audience https://www.linkedin.com/events/6592788975490998272 - please come along if you'd find it useful.

Guys / Girls - I am having a senior moment and a complete failure of Google-Fu at the same time. How do I run a REPL using Tools / Deps that has pulled in my dependencies..?

https://clojure.org/guides/deps_and_cli#_running_a_repl_and_using_libraries here’s the relevant docs

at the moment I run clj and I know that the dependencies are not coming down 'cos the REPL starts immediately without a download notice, but I have never used this library ever before.

should just be clj

is your deps file correct?

I think so...

Try deleting the .cpcache folder

and rerun the repl

{:paths ["src"]
 :deps
 {org.clojure/clojure {:mvn/version "1.10.0"}}
 {libpython-clj {:mvn/version "1.6-SNAPSHOT"}}
}

does that ^^ look well-formed?

ah the deps need to be in a single map

{:paths ["src"]
 :deps
 {org.clojure/clojure {:mvn/version "1.10.0"}
  libpython-clj {:mvn/version "1.6-SNAPSHOT"}}}

Oh shit... Thx - rubber ducking strikes another victory for time-savings, but also unmasks n00bs...

😄

we’re all n00bs at toos.deps I think

I am a professional n00b with 20 years of experience!

Fair point both of you 🙂

The older I get, the less I know

esp when it comes to Javascript frameworks

Now all I have to do is figure out why I can't get libpython-clj to initialize

😞

(it is at least downloaded and I can require it in)

can I lower the tone with a Postgres windowing question; I want to run somethin like

SELECT max(reg.id), reg.zone
FROM
...
GROUP BY reg.zone;

SELECT NTH_VALUE(reg.id, 3)
       OVER (PARTITION BY reg.zone ORDER BY reg.id DESC),
       reg.zone
FROM ...

Anyone here heard from @guy recently? I haven't seen him online in a while and want to check that he's okay

anyone here use ssh with certificate authentication, instead of authorized keys?

nope

I've worked somewhere that did - the BBC - but I have no idea how it was implemented I just know that I installed my cert and I was good to go.

(not that I had a lot of access tbh)

I also worked there! The BBC has an internal CA that issues the certs

@yogidevbear I'll drop him a facebook message if you like.

Done

He should now feel the love

Thanks @wesley.hall 👍

🙂 np.

I've tested out my own using certs rather than authorized keys, seems to be the way forward!

@yogidevbear He's OK. Got some personal stuff going on that's keeping him a bit occupied, but he's doing alright.

I missed the conversation about recruitment but if anyone here ever has a bad experience with a FunctionalWorks recruiter, let me know about it please :cop: