Relative Content

Tag Archive for sqldatabase-designduckdb

Getting around link table with cyclic reference in duckdb

I’m working on a financial data app where I want to track different types of securities (stocks, options, futures, bonds, etc.) and corresponding daily quotes. Currently I have a separate table for each type of security, e.g. for stocks the table looks like: