Comment by sanderjd
4 years ago
I think we have just done most of our data work in different environments.
When I'm trying to query stuff, the first question is "which service's database is that in?", so I can guess "user_service" (or whatever I think it is called), but I have no idea what they call anything in their schema, but now that the autocomplete system knows what table I'm interested in, it can help me figure that out.
I'm used to emacs, with a global namespace. Such that I'm used to searching all variables globally. Feels that searching all columns would be just as easy, all told.
That said, I want to be clear that I think both methods are valid and work.
Yeah, it's just that I don't know what the columns are called. The namespaces (databases and tables) are what guides me to the columns, not vice versa.
I can think back to projects / companies where this may have been different, basically just with fewer different distinct schemas, but it just isn't my recent experience.
(I appreciate your magnanimity in these later comments by the way.)