Hi everyone,
Two quick questions:
1) Is there anything special the supplied sqlite3.exe does to create a
database file. I want to programatically create a database file at runtime,
so can I just create an empty xxx.db file, and go ahead with create table
statements to populate it? The documentation says to create a sqlite
database you should use the supplied app (sqlite3.exe). Is just doing that
myself ok?
2) While creating tables, I've been specifying the data type after the
field name:
create table test(field_1 integer, field_2 text);
The only advantage of this is that the database could possible store the
data in a more compact form, correct? If that's not a concern, leaving it
all as text would not make a difference?
Thanks,
Mark
