ad-hoc inspecting SQLite files

pistonvines · October 2020

I have lots (100s, potentially 1000s) of sqlite files lying around, and I'd like to be able to open them in linqpad to have a look at what is going on, and then move on. Is there some way of invoking linqpad with

Linqpad6.exe --type sqlite --temporary my_db.sqlite

Which then open linqpad, and set up the connection just for that session?

pistonvines · October 2020

I got most of what i want done by writing out a .linq file with the connection in, then launching that. That's probably good enough for now.

nescafe · October 2020

For 100 or 1000s of sqlite files, why don't you iterate the files and dump the tables?

var files = Directory.EnumerateFiles(@"D:\Projects", "*.sqlite", SearchOption.AllDirectories);

foreach (var file in files)
{
  var builder = new SqliteConnectionStringBuilder { DataSource = file };

  using (var conn = new SqliteConnection(builder.ConnectionString))
  using (var cmd = conn.CreateCommand())
  {
    conn.Open();

    cmd.CommandText = "SELECT name, sql FROM sqlite_master WHERE type='table' ORDER BY name";

    using (var reader = cmd.ExecuteReader())
    {
      reader.Dump(file);
    }
  }
}

pistonvines · October 2020

I mean there are lots that I could potentially look at, but a couple that I want to look at now, but then possibly never again. I don't want to have to set up and remove connections for them each time.

nescafe · October 2020

Ah yes, then the ad hoc .linq file approach fits best I think.

NetMage · October 2020

It would be nice if there was a way to create the connection in the query dynamically using a LINQPad driver...

ad-hoc inspecting SQLite files

Comments