Re: [sqlite] how can I import CSV file into SQLite quickly

Thanks to all give response to help. This is my solution using the luanguage I familiar.(http://www.r-project.org). I use the code to read a 11819x807 csv file and it takes 10 minus.I think is not too slow .(My PC:1.7G,512M RAM) #code begins rm(list=ls()) f<-file("D:\\wvsevs_sb_v4.csv","r")#134M

Re: [sqlite] Closing sqlite and deleting the .db file

At 22:01 04/01/2006, you wrote: I'm trying to close a database and then delete the .db file. I call sqlite3_finalize(...) and then sqlite3_close(...) but when I try to delete the .db file I get an exception. This is in Win32. Thanks, Steve Just wait a few minutes. Windows is updating the

Re: [sqlite] Feature Request: Open from fd

[EMAIL PROTECTED] wrote: Peter Bierman <[EMAIL PROTECTED]> wrote: Related to a project I'm working on, it would be useful for me to be able to open a database file via passing an already open file descriptor to the sqlite open() call. sqlite3_openfd(). That is not possible. SQLite needs

Re: [sqlite] Feature Request: Open from fd

Peter Bierman <[EMAIL PROTECTED]> wrote: > Related to a project I'm working on, it would be useful for me to be > able to open a database file via passing an already open file > descriptor to the sqlite open() call. sqlite3_openfd(). > That is not possible. SQLite needs to know the name of

Re: [sqlite] Feature Request: Open from fd

At 3:53 PM -0600 1/4/06, Aaron Laffin wrote: On 1/4/06, Peter Bierman <[EMAIL PROTECTED]> wrote: Related to a project I'm working on, it would be useful for me to be able to open a database file via passing an already open file descriptor to the sqlite open() call. sqlite3_openfd(). It

Re: [sqlite] Feature Request: Open from fd

Aaron Laffin wrote: On 1/4/06, Peter Bierman <[EMAIL PROTECTED]> wrote: Related to a project I'm working on, it would be useful for me to be able to open a database file via passing an already open file descriptor to the sqlite open() call. sqlite3_openfd(). It seems to me that this would

Re: [sqlite] Feature Request: Open from fd

On 1/4/06, Peter Bierman <[EMAIL PROTECTED]> wrote: > Related to a project I'm working on, it would be useful for me to be > able to open a database file via passing an already open file > descriptor to the sqlite open() call. sqlite3_openfd(). It seems to me that this would cause problems with

Re: [sqlite] specifying field type, any benefit?

Got it, thank you very much all, Mark On 1/4/06, Henry Miller <[EMAIL PROTECTED]> wrote: > > On Wednesday 04 January 2006 02:54 pm, Mark Wyszomierski wrote: > > Hi all, > > > > I switched to sqlite from mysql awhile ago, I maintained the field types > > in my sqlite implementation such as: > >

[sqlite] Feature Request: Open from fd

Related to a project I'm working on, it would be useful for me to be able to open a database file via passing an already open file descriptor to the sqlite open() call. sqlite3_openfd(). I need this because I'd prefer to resolve some filesystem permissions access issues in a separate process

Re: [sqlite] specifying field type, any benefit?

On Wednesday 04 January 2006 02:54 pm, Mark Wyszomierski wrote: > Hi all, > > I switched to sqlite from mysql awhile ago, I maintained the field types > in my sqlite implementation such as: > > create table students (first_name TEXT, age INTEGER); > > I'm just wondering if there is any point

Re: [sqlite] specifying field type, any benefit?

Mark Wyszomierski <[EMAIL PROTECTED]> wrote: > Hi all, > > I switched to sqlite from mysql awhile ago, I maintained the field types > in my sqlite implementation such as: > > create table students (first_name TEXT, age INTEGER); > > I'm just wondering if there is any point to specifying the

Re: [sqlite] specifying field type, any benefit?

On Wed, Jan 04, 2006 at 03:54:49PM -0500, Mark Wyszomierski wrote: > Hi all, > > I switched to sqlite from mysql awhile ago, I maintained the field types > in my sqlite implementation such as: > > create table students (first_name TEXT, age INTEGER); > > I'm just wondering if there is any

Re: [sqlite] specifying field type, any benefit?

http://www.sqlite.org/datatype3.html

[sqlite] Closing sqlite and deleting the .db file

I'm trying to close a database and then delete the .db file. I call sqlite3_finalize(...) and then sqlite3_close(...) but when I try to delete the .db file I get an exception. This is in Win32. Thanks, Steve

[sqlite] specifying field type, any benefit?

Hi all, I switched to sqlite from mysql awhile ago, I maintained the field types in my sqlite implementation such as: create table students (first_name TEXT, age INTEGER); I'm just wondering if there is any point to specifying the field type as if I try adding a string type into the age

[sqlite] [PATCH] WinCE compilation

Hi everyone, I'm a happy user of SQlite for a project I just started to make a multimedia database (a bit like the DB in iTunes). The idea is to make it as cross-platform as possible and free. I tried to make it work under Windows CE but run into a few problems when compiling with Embedded

[sqlite] Sqlite 3.3 schedule?

I was evaluating Sqlite for use in an application but ran into the problem mentioned in posting to this group that is listed here… http://www.mail-archive.com/sqlite-users@sqlite.org/msg12137.html “Beginning with version 3.3.0, you will be able to configure SQLite so that multiple

[sqlite] RE: [RBL] [sqlite] JDBC driver

Just a word of advice, make your binding to SQLite dynamic - it's more code but ultimately you won't have to keep releasing new versions of your driver everytime SQLite changes. Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg] On Behalf Of gnorman22 Sent: 31