[sqlite] Incorrect results set?

I am thoroughly confused as to why the following simple query doesn't return the proper result set but instead returns the 15 records with a coursekey starting with '0E'. Do I need to escape something? SQLite version 2.8.15 Enter ".help" for instructions sqlite> .schema CRS_2004_001 CREATE

[sqlite] 'cating' sqlite databases

Hi, We are working on a potential architecture by which many sqlite databases are created. There may be a need to aggregate data between databases and I was wondering if it's possible to quickly just 'cat' the databases together or will they need to be recreated into a single sqlite file.

[sqlite] Slowness issues running on SCSI vs. IDE

Hi, I am currently using sqlite version 2.8.4 on RedHat Linux 7.3 on an IBM x.220 - x.345. During a recent testing on the above platforms we discovered a performance issue when using both the perl sqlite module as well as the standard sqlite client. When attempting to perform a large number