Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-02 Thread Larry Brasfield
joe.fis...@tanguaylab.com wrote: Is there some way to load a ".csv" file into a SQLite database table when the first row (record) of the file contains headers? Awhile ago, I published a modification of the SQLite shell which I wrote specifically to solve this problem. When headers are turned

[sqlite] Fwd: How do you load a ".csv" and skip the first line?

2012-09-02 Thread joe.fis...@tanguaylab.com
Here's a hack solution in Windows OS. more +1 test.csv > parsed.csv sqlite3.exe test.db .separator , .import parsed.csv ld_assay Original Message Subject:How do you load a ".csv" and skip the first line? Date: Sat, 01 Sep 2012 12:19:09 -0700 From:

Re: [sqlite] some questions about sqlite

2012-09-02 Thread Jay A. Kreibich
On Sat, Sep 01, 2012 at 11:56:33PM -0700, J Decker scratched on the wall: > On Sat, Sep 1, 2012 at 8:24 PM, Jay A. Kreibich wrote: > > On Sat, Sep 01, 2012 at 07:37:04PM -0700, J Decker scratched on the wall: > >> On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin

Re: [sqlite] Setting initial database size.

2012-09-02 Thread Mohit Sindhwani
Hi Roger On 1/9/2012 10:46 PM, Roger Binns wrote: You can use sqlite3_file_control. See: http://www.sqlite.org/c3ref/c_fcntl_chunk_size.html SQLITE_FCNTL_CHUNK_SIZE would be the most useful - set it to something you have measured as useful to your data patterns and filesystems. This

Re: [sqlite] Database size

2012-09-02 Thread Simon Slavin
On 2 Sep 2012, at 8:15am, Keith Medcalf wrote: > On Saturday, 01 September, 2012, at 20:28 Ted Rolle, Jr. wrote: > >> Remember Y2K? That was caused by a three-letter blue company. They >> wanted to save 1 (one!) byte by not storing the century in critical >> operating

Re: [sqlite] some questions about sqlite

2012-09-02 Thread Keith Medcalf
> but about the second question，I write java code，and find if the connection > exceeds 17990，then will throws exception > SQLite.Exception: unknown error in open > at SQLite.Database._open4(Native Method) > at SQLite.Database.open(Database.java:37) > at

Re: [sqlite] Database size

2012-09-02 Thread Keith Medcalf
On Saturday, 01 September, 2012, at 20:28 Ted Rolle, Jr. wrote: > This is so true! > Remember Y2K? That was caused by a three-letter blue company. They > wanted to save 1 (one!) byte by not storing the century in critical > operating system fields. The comments were (1960s) "Well, we won't be

Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-02 Thread Dominique Pellé
joe.fis...@tanguaylab.com wrote: > Is there some way to load a ".csv" file into a SQLite database table when > the first row (record) of the file contains headers? > > This does not work? > -- > .separator , > .import

Re: [sqlite] some questions about sqlite

2012-09-02 Thread Simon Slavin
On 2 Sep 2012, at 7:56am, J Decker wrote: > the point would be 'and not have concurrancy issues that I'd have to > solve myself...' Apache runs one process for each request it's serving [1]. I have multiple Apache processes -- i.e. multiple web page requests -- accessing

Re: [sqlite] some questions about sqlite

2012-09-02 Thread J Decker
On Sat, Sep 1, 2012 at 8:24 PM, Jay A. Kreibich wrote: > On Sat, Sep 01, 2012 at 07:37:04PM -0700, J Decker scratched on the wall: >> On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin wrote: >> > On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote: > >> >>