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
sqlite-users
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 sugges
-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 u
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 crash if they ran out o
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
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] I
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.
___
sqli
-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 .autoimport
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, Petite
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
http:
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
http://sqlite.org:8080/cgi-bin/mailman/l
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 data, of course.
B
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, and any
columns yo
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- hh24:mi:ss'
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
got
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 database's storage to be ab
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;',
> n
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,
>>
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 SQLite.MyDay.main(
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 in SQLite for connectio
> 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, wrote:
> than
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:
>
>> >> 2??how many user connections the sqlite
22 matches
Mail list logo