That was a throw back to years ago. I was trying to protect against y2k
by making each dbf for 1 calendar year. Also, these files are about
800k in size, so I was worried about storage and search time. Storage is
not an issue anymore. I will know about search time after learning
about sql databases. Sometimes over the last 45 years I have changed
the dbf structure. This way I only change starting at the year in
question, then change the program to work with the structure modification.
John
On 11/22/2016 12:33 AM, Christoph P.U. Kukulies wrote:
Just a thought about your TABLE named "log16":
I'm not at all a database expert but from the idea what a table is, I
would take a more general approach. CREATE a TABLE log with
columns year, logtext, timestamp a la:
CREATE TABLE LOG (logtext TEXT, timestamp TEXT, year INTEGER PRIMARY KEY)
Just my 2cts.
Christoph
Am 21.11.2016 um 19:08 schrieb John R. Sowden:
Thank you all for your answers and direction for further information.
Hopefully, I will not bring these subjects up again. :)
John
On 11/21/2016 09:29 AM, John R. Sowden wrote:
First of all, I come from the dBASE/Foxpro world. There is no
distinction between a table and a database. I understand that with
Sqlite a database includes tables and other items. The scenario
that I do not understand, is: say I have a log file with about 7
fields totaling about 80 characters per record. How do I name the
database and table. Currently I say log16 for the year 2016.
Secondly, I have 2 "front ends" for Sqlite on my Ubuntu 16.04
computer. Neither one allows me to set the length of the text
fields in the table creation process. How does the Sqlite know how
long each record should be, same with integers.
No help found in the documentation on the Sqlite web site.
John
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users