But before the company launched Einstein Analytics in 2017, it overhauled the backend and rebuilt it almost entirely on Google's popular Go, or 'Golang', programming language.
SEE: Six in-demand programming languages: Getting started (free PDF)
According to Salesforce principal architect Guillaume Le Stum, before Salesforce launched Einstein Analytics, the query engine and dataset creation tools that eventually became Einstein Analytics were written in C "for performance" and a Python wrapper that provided functionality like parsing queries, and a REST API server.
"In essence, the product was built to have the best of both worlds," explains Le Stum in a post on Stack Overflow.
"Python is great for quickly writing higher-level applications but doesn't always deliver the high performance needed at an enterprise level. C creates highly performant executables, but adding features takes a lot more time."
But before launch, Le Stum says the guts of Einstein Analytics started to show performance slowdowns because any new feature that wasn't part of the core query engine got loaded onto the Python wrapper.
So, while Salesforce could quickly develop and deploy features with Python, eventually the approach made it sluggish.
"Python doesn't do multi-threading very well, so the more the wrapper was being asked to do, the worse it performed," explains Le Stum.
Go, on the other hand, is built for huge applications suitable for Google's production systems, so Salesforce decided to shift Einstein Analytics from a hybrid C-Python application to a completely Go application.
Le Stum also identifies two more downsides of staying with Python, despite some of its advantages.
"First, Python uses loose typing, which was great for a small team rapidly developing new ideas and putting them into production –but less great for an enterprise-scale application that some customers were paying millions of dollars for," he writes.
"Second, we foresaw a vast dependency nightmare on the horizon, as deploying the right Python libraries, versions, and files would become a chore. So in 2014, we decided to port the Python wrapper to Go."
Le Stum says the strength of Go include its built-in tooling, quick compile times and deploys, and easy troubleshooting, as well as the way it makes code easy to understand.
"In Python, you could write super-elegant list comprehensions and beautiful code that's almost mathematical. But if you didn't write the code, then that elegance can come at the expense of readability," he explains, noting that in enterprise software, engineers spend more time reading code than writing it.
The group still had questions over Go's performance compared with C for the query engine. However, a proof of concept written in Go enabled them to proceed, and the Go version of Einstein Analytics reached general availability in 2018.
One of the big advantages is that Go's cross-platform features make porting code easy.
"If we ever need any of this code in a mobile app, we can cross-compile it to iOS or Android and it will just work," Le Stum notes.
The sole part of Einstein Analytics that isn't built with Go is the cluster manager, which is written in Java.
Update: Salesforce has asked ZDNet to point out an inaccuracy in the company's original Stack Overflow piece. While Salesforce did indeed port the Einstein Analytics query engine from a C-Python hybrid to Go, Einstein Analytics is built on other languages besides Go and Java, although Salesforce declined to say what these other languages are.
More on programming languages
- Python-inspired Nim: Version 1.0 of the programming language launches
- Microsoft TypeScript 3.7: Programming language beta lands with all these features
- Google: Take our free Kotlin programming language courses to build Android apps
- Microsoft: We want you to learn Python programming language for free
- Oracle: Programming language Java 13 is out, it'll make you more productive
- Google: Dart 2.5 programming language SDK will 'supercharge' developers
- Raspberry Pi gets MIT's Scratch 3 programming language for Raspbian
- Julia programming language: Users reveal what they love and hate the most about it
- Programming language Python's 'existential threat' is app distribution: Is this the answer?
- Is Julia fastest-growing new programming language? Stats chart rapid rise in 2018
- Python vs R for data science: Professor rates programming language rivals
- Programming languages: Python predicted to overtake C and Java in next 4 years
- Python developer, data scientist or DevOps: Which tech jobs pay best?
- Netflix: Python programming language is behind every film you stream
- Is Julia the next big programming language? MIT thinks so, as version 1.0 lands TechRepublic
- Mozilla's radical open-source move helped rewrite rules of tech CNET