search

dinedal / textql

Execute SQL against structured text like CSV or TSV
MIT License
9.07k stars 300 forks source link

Support primary key #121

Closed typeless closed 3 years ago

typeless commented 4 years ago

Examples:

$ textql -header -sql '*' -pkey 'Company name'

Composite primary key can be specified with comma-separated string:

$ textql -header -sql '*' -pkey 'name,birth day'
dinedal commented 3 years ago

Can I ask why? do you see some performance gain with it?

typeless commented 3 years ago

My memory is a bit vague. I remember I used textql as the front end of my data pipeline, where the output was then processed by other tools which may need primary keys. I ended up writing dedicated programs for that task.