Re: [sqlite] some questions about sqlite

> thanks a lot， > but about the second question，I write java code，and find if the connection > exceeds 17990，then will throws exception This probably happened because your OS restricts number of open file descriptors or something like that. Pavel On Sat, Sep 1, 2012 at 7:52 PM,

Re: [sqlite] some questions about sqlite

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: > >> 2??how many user connections the sqlite can handler > > > > There is no limit

Re: [sqlite] some questions about sqlite

thanks a lot， 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] some questions about sqlite

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: > >> 1、Do the sqlite support job like oracle or sqlserver,such as >>variable job1 number; >>begin >>sys.dbms_job.submit(job => :job, >>

Re: [sqlite] some questions about sqlite

On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote: > 1、Do the sqlite support job like oracle or sqlserver,such as >variable job1 number; >begin >sys.dbms_job.submit(job => :job, >what => 'prc_g_test;', >

Re: [sqlite] Database size

This is so good to hear! The advances in database theory and practice have put the old ideas to rest. Hooray for today! Ted On 09/01/2012 07:08 PM, Richard Hipp wrote: > On Sat, Sep 1, 2012 at 6:34 PM, Ted Rolle, Jr. wrote: > >> Back in the olden days we predicted a

Re: [sqlite] Database size

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 around to fix it...wink, wink, nudge, nudge." I was. Most companies

[sqlite] some questions about sqlite

1、Do the sqlite support job like oracle or sqlserver,such as variable job1 number; begin sys.dbms_job.submit(job => :job, what => 'prc_g_test;', next_date => to_date('22-10-2008 10:06:41', 'dd-mm-

Re: [sqlite] Database size

On 1 Sep 2012, at 11:34pm, "Ted Rolle, Jr." wrote: > Back in the olden days we predicted a database's storage to be about 5 > times the size of the data. > By 'olden' I mean IBM's IMS, VSAM, DB2. ..., 70s, 80s. Back in the old days you had 72 or 80 columns to a punched card,

Re: [sqlite] Database size

On Sat, Sep 1, 2012 at 6:34 PM, Ted Rolle, Jr. wrote: > Back in the olden days we predicted a database's storage to be about 5 > times the size of the data. > By 'olden' I mean IBM's IMS, VSAM, DB2. ..., 70s, 80s. > I hope this is still not the case... > A lot depends on your

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

Text editor to remove the offending line(s)? This way you can see what you've removed. The other solutions (tail, less, more) would work better for LARGE files. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Database size

Back in the olden days we predicted a database's storage to be about 5 times the size of the data. By 'olden' I mean IBM's IMS, VSAM, DB2. ..., 70s, 80s. I hope this is still not the case... Ted ___ sqlite-users mailing list sqlite-users@sqlite.org

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

If all else fails - after the import issue DELETE FROM XYZ WHERE ID = 'id' ; But - yes - adding the "skip=y" and "load=x" parameters (skip the first y rows in the .csv file, and stop after loading x rows) - to the .import utility would be most desirable. On Sat, Sep 1, 2012 at 12:31 PM,

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

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/09/12 12:19, 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? You may want to consider using the APSW shell. It has a

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

On Sep 1, 2012, at 9:19 PM, 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? On *nix, any of tail +2, more +2, etc would do.

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

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 test.csv ld_assay Here's my database / table: CREATE TABLE [ld_assay] ( [id]

[sqlite] Compiling SQLite on VxWorks 6.3 (DKM)

Hi all. Finally got Sqlite 3.7.13 working on VxWorks 6.3 in DKM. Thanks for all the help. Shaun ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Setting initial database size.

On 1 Sep 2012, at 3:46pm, Roger Binns wrote: > What tool did you use to work out that this is a problem? Actually I've done it myself on a handsized device which didn't have good error testing. It had an 8 Meg SD card and various other parts of the system would simply

Re: [sqlite] Setting initial database size.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 31/08/12 05:28, kjell.gunnars...@sungard.com wrote: > Does somebody know if it's possible to set an initial database size > when the database is created ?. (A large file doesn't have to be > incremented in size when records are inserted). You can

Re: [sqlite] Setting initial database size.

Hi Kjell, On 31/8/2012 8:28 PM, kjell.gunnars...@sungard.com wrote: Hi, Does somebody know if it's possible to set an initial database size when the database is created ?. (A large file doesn't have to be incremented in size when records are inserted). I have never seen any thing that

[sqlite] Setting initial database size.

Hi, Does somebody know if it's possible to set an initial database size when the database is created ?. (A large file doesn't have to be incremented in size when records are inserted). Rgds Kjell Gunnarsson ___ sqlite-users mailing list