SQLite Tutorial 5, Using SQL with Mint Personal Financial Data
From Richard Price
-- This tutorial shows how you can use SQLite Studio using data exported from Mint.com,
-- a personal financial planning tool that aggregates financial data from various accounts.
-- I include as attachments some sample transactions in .csv format (as exported from Mint)
-- and in .txt format (tab-delimited was less problematic). Also attached is a .sql file
-- with the commands demonstrated in the video.
See the attachments tab for text files with transactions (both csv and txt format) and for the SQL file containing the SQL commands.
Note, to download SQLite Studio, go to sqlitestudio.pl. If you want to download the text-based version of SQLite, go to sqlite.org/download.html and download the sqlite-tools-win32-x86... file for Windows, which will include the sqlite3.exe file. Download the OSX version for a Mac.