Re:Doing a database join with CSV files
by kragen on Thursday January 02, 2020 @01:27PM
(#21938126)
This isn't "without importing anything". This is "importing all the data again every time you run a query".
[ Parent
| on HN ]
Re:Doing a database join with CSV files
by atombender on Thursday January 02, 2020 @01:34PM
(#21938190)
No, "import" means "create state from data". It's not creating any persistent state at all.
But it's an important nuance for another reason, because you can operate on the original files in real time. You can update the underlying files and your queries will reflect the changes.
The downside is since the data is streamed at query time, it's less efficient and doesn't allow indexes to be created.