[Tutor] make a sqlite3 database from an ordinary text file

[Roel Schroeven]

Op 20/06/2022 om 4:39 schreef dn:
> I'm +1 after @Alan. Although we often see it in programming texts, I've
> NEVER initialised a DB/TBL this way. Easy for me to say: I learned RDBMS
> and SQL very early in my career, and therefore know to use the tools
> from that eco-system. (the rationale in books is the exact opposite -
> presuming the reader has never used DB-tools). Use the best tool for the
> job!
I don't really agree with this. I quite often use Python to read data 
from some file, perhaps process it a bit, then store it in SQL. If any 
kind of processing on the data is needed, Python is much easier and 
flexible to do it than SQL (at least to me). And if no processing is 
needed, well, I often use a Python script anyway because I know how to 
do that; doing it using the RDBMS tools would involve me starting to 
look up things left and right, and would be different between different 
RDBMS systems.

-- 
"Peace cannot be kept by force. It can only be achieved through understanding."
         -- Albert Einstein