in the /db directory:
migrate up
sqlite3 funds.db < import.sql
- csv parsing in go
- common go mistakes
- channels are not enough
- when to use pointers
- go interfaces
- go memory pools
- go style guide - receiver names (READ ALL OF THIS)
index_funds2 ranking query:
select funds.symbol, funds.name, funds.type, avg(diff)*100 as performance_percent
from annual_returns
inner join funds on annual_returns.fund_id = funds.id
group by annual_returns.fund_id order by performance_percent desc