An oral history of Bank Python (2021)
78 points
by tosh
6 hours ago
| 12 comments
| calpaterson.com
| HN
elemeno
4 hours ago
[-]
To the best of my knowledge much of this originated with SecDB/Slang at Goldman - SecDB (securities db I believe) being the object store and slang the somewhat quirky C like language that ran with it (also the only language I’ve used professionally that let you have spaces in the variable names).

Some of the folk that built that (or worked on it) ended up at JPM and Merrill where they built the Python centric version - Alpha and Quartz respectively. Barclays Capital has/had a similar system as well I think, but it’s not one I know about offhand - they did though, memorably, have a system that was pretty much Haskell-in-Excel.

reply
Thrymr
2 hours ago
[-]
JPM's version was Athena (not Alpha) [0]

[0] https://www.slideshare.net/slideshow/managing-python-at-scal...

reply
axus
5 hours ago
[-]
What a well-written account of "how things are done".

> Time to drop a bit of a bombshell: the [Barbara] source code is in Barbara too, not on disk. Remain composed. It's kept in a special Barbara ring called sourcecode.

reply
tsukikage
3 hours ago
[-]
When first encountering these ecosystems and looking at the various pieces they contain, one may repeatedly ask: "why didn't they just use <off-the-shelf solution> for this problem instead of writing this component/subsystem from scratch"?

The answer is often that the battle-hardened mature off-the-shelf solution did not exist at the time the code was written. You're doing software archaeology.

reply
lmm
2 hours ago
[-]
That's only half the answer. These large investment banks' value-add is partly that they can integrate everything they know into these closed-world environments (kind of like a Smalltalk image), which is something that simply isn't done in the wider world because you can't accrete it out of smaller pieces and it doesn't make sense at all for smaller entities.
reply
horticulturist
1 hour ago
[-]
> This is because clients generally do not ring up about pennies.

I’ve had clients ring up about pennies… it can be crazy what some people are motivated by

reply
TZubiri
1 hour ago
[-]
Precision?

Quite common in accounting, the accounting equation must balance, it's like a checksum

reply
mhh__
3 hours ago
[-]
People turning up in hedge funds (i.e. much smaller) and trying to rewrite the bit of a bank they used to work in's equivalent of this article is so annoying.
reply
piinbinary
5 hours ago
[-]
reply
skissane
3 hours ago
[-]
I think it is a pity they’ll likely never open source any of this stuff

Of course, financial institutions have a lot of “secret sauce” - such as financial models - you’d never expect them to release.

But this kind of underlying infrastructure isn’t really “secret sauce”

reply
lmm
2 hours ago
[-]
Morgan Stanley's version is open-source at https://github.com/morganstanley/optimus-cirrus , although I don't know how practical it is to actually run yourself. (They don't go quite as far as having the code itself be bitemporal and kept in the datastore, but most of the stuff in the article exists there)
reply
Jianghong94
1 hour ago
[-]
Well I doubt these solutions are very useful outside; from what I read what they have is a universal data store (that isn't hard to implement using current off-the-shelf OSS), something for financial instruments that has a compositional nature (you won't encounter much of that in the outside world), plus some other quirky features.
reply
veqq
55 minutes ago
[-]
This infrastructure is more secret sauce than the financial models, which change rapidly.
reply
jgalt212
2 hours ago
[-]
> I think it is a pity they’ll likely never open source any of this stuf

The more they use cloud-hosted LLMs, the more likely it will get leaked into training data.

reply
coredog64
5 hours ago
[-]
And I thought rewriting 3rd party packages to work with AFS was crazy
reply
Havoc
3 hours ago
[-]
I've seen similar inside large financial orgs - what struck me was how there are these huge amounts of people that spend their entire working life inside this alternate IT reality. It's not unlike SAP consultants where their skillset is tied to one company.

Also...these things tend to have fuckin terrible documentation. Good luck figuring any of this out. And you can't google it and your AI is just as lost as you

reply
Jianghong94
1 hour ago
[-]
lolol. Actually, I find AI has a reasonable chance to figure it out, as long as you point to the right source code. BTW to me these quirks actually can be used as some kind of job security. If it takes a year to onboard someone to do meaningful work, it sure raise the cost of firing.
reply
TZubiri
5 hours ago
[-]
>Applications also commonly store their internal state in Barbara - writing dataclasses straight in and out with only very simple locking and transactions (if any).

Right out of the gates, it's crazy how this contrasts with Mercury's Haskell infra

https://blog.haskell.org/a-couple-million-lines-of-haskell/

reply
lmm
3 hours ago
[-]
It sounds pretty similar actually. Barbara fills the same role that Temporal is doing at Mercury.
reply
TZubiri
1 hour ago
[-]
I may be reading between lines, but temporal seems to be a virtual machine like the evm, it handles computation.

Barbara is a company wide database, it handles data storage.

When I read about internal app state being stored in Barbara I'm interpreting that the policy is for the data to be centralized for more vertical control.

While the Temporal thing sounds like if something is written, it's done so in a containerized like manner, and other processes can't just read it.

reply
devin
5 hours ago
[-]
Eh, to be fair, this post is about a _bank_, and the one you've linked is about _fintech_. They are not even close to the same space, even though they both deal with money.

But also I suppose you may be saying exactly this?

reply
monknomo
4 hours ago
[-]
to be fair, it is a fintech that wants to become a bank
reply
TZubiri
1 hour ago
[-]
It's a bank, that is, a bank in all but name for regulatory purposes.
reply
roywiggins
4 hours ago
[-]
Weirdly not dissimilar from MUMPS systems.
reply
jgalt212
2 hours ago
[-]
> but the default ring is more or less a single, global, object database for the entire bank.

Is this really the case? I'm sure there are plenty of transactions that for umpteen different reasons must not be exposed on a global level.

reply
Jianghong94
1 hour ago
[-]
What I imply from the description is that, the default ring contains some shared global public data (e.g. a cache of bloomberg informations), and each individual team will have their own rings. Afterall there's no that many you can fit into 16mb
reply