4 ms·
Copy pasting my comment[1] from an earlier thread. A couple of years ago I spent quite some time trying to evaluate the tech stack (and general engineering cul
by vishnugupta 6y ago
Copy pasting my comment[1] from an earlier thread.
A couple of years ago I spent quite some time trying to evaluate the tech stack (and general engineering culture) of merger/acquisition targets of my employer. It was quite a fun exercise, all said and done. I encountered all sorts; from a small team start up who had their tech sorted out more or less to a largish organisation who relied on IBM's ESB which exactly one person in their team knew how it worked!!
I discovered this exact method during the third tech evaluation exercise. When the team began explaining various modules top-down and user-flows etc., I politely interrupted them and asked for DB schema. It was just on a whim because I was bored of typical one way session interrupted by me asking minor questions. Once I had a hang of their schema rest of the session was literally me telling them what their control and user flows were and them validating it.
Since then it's become my magic wand to understand a new company or team. Just go directly to the schema and work backwards.
Conversely, I've begun paying more attention to data modelling. Because once a data model is fixed it's very hard to change and once enough data accumulates the inertia just increases and instead if changing the data model (for the fear of data migration etc.,) the tendency is to beat the use cases to fit the data model. It's not your usual fail-fast-and-iterate thing.
[1] https://news.ycombinator.com/item?id=24137997 https://news.ycombinator.com/item?id=24137997
- macando 6y ago> I politely interrupted them and asked for DB schema. In order of importance: 1. DB schema 2. List of dependancies 3. List of 3rd party integrations Depending on the domain, 2. and 3. can be switched.
- macintux 6y agoMany years ago, my employer was transitioning ERP systems from...something CA-owned whose name escapes me and I'd probably have pretty awful memories dredged up if I actually went looking for it. Anyway, we were lucky enough to have a very talented intern who was assigned the task of understanding the database schema behind the CA product in order to migrate our data to the new system. It was...horrific. Absolute nightmare of spaghetti. I'd like to say I've seen worse, but I've never seen anything even in the same ballpark. I think we finally gave up after weeks of digging into it and just started over with a mostly clean slate.