Stack overflow sql8/30/2023 Don’t use skills other than the ones suggested to you.Two rules to remember for language/skills input: As you start typing, the page will automatically suggest the tags and these tags are the ones used by stack overflow. Like nodejs will return results but inputs like node.js, node js, etc won’t return any results. It is important to understand the format that stack overflow uses. These languages are specific tags that are used to make questions and answers more organized. By our estimate, there are close to 400,000 different locations in stack overflow! Besides, a lot of users have kept their location empty so there’s that to struggle with as well! Step 2: Enter the skills you want in this candidate and the skill levelĮnter the languages these candidates have used. So when you search Bay Area, also include places like San Francisco, San Jose, Silicon Valley, etc. Remember, that in stack overflow location is a free text field. Head on over to SQL query generator for data.StackExchange, Step 1: Create Location FiltersĮnter Locations that you want to search these users for. How to use SQL query to source candidates on stack overflow? Step 4: Head over to data.StackExchange.Step 2: Enter the skills you want in this candidate and the skill level.How to use SQL query to source candidates on stack overflow?.Thankfully, the awesome folks at stack overflow let users query their internal database in an SQL format that can give you specifically people who have written answers/asked questions for nodejs! However, SQL is not as easy as boolean and most of us recruiters and sources have been so obsessed with boolean(i hate it if you ask me!) that we have never even taken a second look at SQL-based stack overflow database.Īlso, check out The hidden treasure of exceptional developers you never knew aboutīoolean search ranks users based on their total inbound links(not a very good proxy for skill, or overall ranking) instead of the community points they have earned on a particular skill. But when you write a boolean query, these users will get a higher search rank compared to someone who has written a few nodejs answers but doesn’t rank so highly.Īlso, check 6 awesome recruiting websites to hire top-notch developers However, they might even have answered just one question on nodejs! So s/he is not the nodejs champion you are looking for. This means that s/he will probably have a lot of questions and answers on Django and python that will be linked a lot. Let’s say developer A is a real rockstar working on python and Django frameworks. This is not necessarily the best way to unearth candidates. Google’s algorithm runs on incoming hyperlinks and thus it will automatically surface candidates that have links to their answers and where people spend more time. Boolean search on google to source candidates from stack overflow is an extremely inefficient way of searching for candidates.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |