Thank you, but I am currently in the early learning phase of sql
databases and the sql language. I am starting with Sqlite due to its
relative simplicity, and moving on to H2 to integrate it into Libre
Office. It's commands like analyze that I have never heard of and need
to become familiar with. In the mean time I am reading the Sqlite mail
list, understanding about 40% of it. There seems to be a lot of sql
tutorials on the web. W3schools seems to be popular, so I am trying it.
John
On 11/22/2016 08:30 AM, Igor Korot wrote:
John,
On Tue, Nov 22, 2016 at 11:00 AM, John R. Sowden
<jsow...@americansentry.net> wrote:
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.
Speed is simple:
Just create a table and then create an index as appropriate.
Shows us what query you want to run and we will help with the index creation.
Then you will need to run ANALYZE against the query and EXPLAIN QUERY PLAN.
Simple. ;-)
Thank you.
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
_______________________________________________
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
