Skip to content

Instantly share code, notes, and snippets.

View darthwalsh's full-sized avatar

Carl Walsh darthwalsh

View GitHub Profile
@darthwalsh
darthwalsh / _ExportAntennaPod.md
Last active April 20, 2020 19:36
How to export played state from AntennaPod

AntennaPod is a great podcast player, but you might want to migrate to another app. In order to export your data, you might try the HTML export, but that only includes a list of your subscriptions, and not the played/unplayed state of each episode.

Exporting played/unplayed state

  1. From Settings export the database, and then copy it to your computer
  2. Install sqlite, with i.e. scoop install sqlite
  3. Run sqlite3 -header -csv back.db < export.sql > export.csv
  4. Open export.csv in a CSV viewer i.e. Microsoft Excel
@darthwalsh
darthwalsh / wpowershell.vbs
Created October 6, 2016 08:36
WPowerShell
CreateObject("WScript.Shell").Run "powershell.exe -nologo -file """ & WScript.Arguments.Item(0) & """" ,0
@darthwalsh
darthwalsh / MinimalCSharp.md
Last active August 25, 2022 21:55
Minimal C# .NET Framework project - CS CSPROJ SLN

Note, this is for .NET Framework! Nowadays you probably want to use dotnet new cli to make a dotnet core project.

If you've ever started a simple C# project in Visual Studio, it creates a lot of cruft in your project.

These are a minimal set of files that you can start writing a C# programs. I deleted most lines from a starter CSPROJ and SLN file to get this starter template.

These files open and build cleanly in:

  • msbuild
  • Visual Studio
  • Visual Studio Code