Analyzing ELF symbols using SQL

This looks like an interesting and useful approach, but there&#x27;s no need to overdo the claims:<p>&gt; Which library that I load is providing function foo?<p>&gt; The state of the art (prior to sqlelf) of how to retrieve this diagnostic information is using LD_DEBUG environment variable and trolling through the large dump of logs it emits<p>That&#x27;s far from the state of the art. Just use a tool like ldd or otool to get a list of dependencies, loop a call to nm over that and grep for the symbol you want. It&#x27;s a one liner that gives you the answer (and tells you which other libraries export the same symbol, in case you need to reorder the library loading).<p>Nevertheless I regret not putting higher resolution file metadata support into bfd. Objdump is more oriented to the <i>content</i> of the sections, and some section metadata, but there&#x27;s a lot of interesting and fun stuff in the ELF file header (not that ELF existed back then)

In my ideal world all system utilities (and many applications) output relational tuples, and the shell includes a relational algebraic query tool --equivalent to SQL, but with a more composable syntax. Instead of awk&#x27;ing and grepping, we&#x27;d be doing Restrict, Join, Union, and Project on the output of <i>anything</i>, and there&#x27;d be no need to be dumping into a separate database system just to be able to have access to the kind of recomposable, queryable, consistent, discoverable information management that is every user&#x27;s right since Codd first penned <i>“A Relational Model of Data for Large Shared Data Banks.”</i> in <i>1970</i>.<p>Sorry, old-man-me is feeling unwell today, back to bed to take a nap.

static analysis | filters | sql_db ## done that<p>this reads running binaries and gets link symbols? linux