I'm new to both SQL and SQLite, not to mention the various Delphi wrappers and database work in general. I have a good idea of what I want to achieve in my various projects, but need a feel for how some things are done.
At this point, I can create database files, use basic SQL to create structure and add/access data. 1. Is there a way using SQL code alone to open databases, or will that always be done by my native (Delphi) code calling the DLL? I suppose another way to ask that question is: Would "scripts" which could manage ALL database activities require embedded SQL in another language, or could SQL do the job alone? 2. If I wish to write and test SQL code "live" can/should I open one or more databases (however) and manipulate them via SQL at leisure, or should each invocation of SQL code open, run, then close the files? 3. If I want to exchange data between files, what's the general algorithm for opening, doing transactions, then closing? As an extension to this question, if one wished to backup data by doing a record-for-record copy during application idle time, what would be a good strategy for doing this quickly yet safely (given the possibility of premature computer power-down)? Thanks Nathan
