2

I'm starting to use the StackExchange Data Explorer, which is a cool tool.

Apart from the web interface, is there a CLI way to connect to the StackExchange SQL engine without downloading the whole data dump to a local SQL database.

What I want to do is: I want to run a few separate queries in a (shell-)script and save the result-CSVs in the script automatically to disc.

Community
  • 1
  • 1
halloleo
  • 9,216
  • 13
  • 64
  • 122
  • 1
    The answer is no. What you need to do is create the queries from the web interface, then create a script to log in and download the data. – double-beep Feb 13 '23 at 16:38

1 Answers1

0

To answer this question, Stack Exchange offers an API that covers a lot of REST operations. You can find it and more information on it here.

DJanssens
  • 17,849
  • 7
  • 27
  • 42
  • Thanks, but that is not exactly what I'm after. I rather want to kick off my queries from a CLI tool. I guess I can build a CLI tool using the REST API myself though. – halloleo Jul 07 '15 at 06:37
  • I believe that's the only way, since I never heard of a project like that before. Perhaps you can make it open-source and others can contribute ;) – DJanssens Jul 07 '15 at 08:55