[sqlite] proposal for improving concurrency in SQLite

I wrote an article suggesting a method for improving concurrency in SQLite. The main reason I wrote this article is so I can understand SQLite better, not because my proposal is new or usable. I am not an expert in SQLite or databases, so I would appreciate any comments or criticisms. Here

Re: [sqlite] can ignore n lines when .import data file?

2006/1/7, Griggs, Donald <[EMAIL PROTECTED]>: > > Regarding: > > I want to use .import ... but the first line is the variable(fields), so I > want to ignore it. > = > > Possible option #1: > > If it wouldn't violate any database-enforced constraints, why not import

[sqlite] [PATCH] Case-insensitivity for LIKE operator and UTF-8 strings

This patch is aimed to fix the case-insentivity for the LIKE operator, which currently works only for latin-1 ASCII sybmbols. The patch now supports case-insensitivity for the Cyrillic, Latin and Greek alphabets, as well as other individual symbols (such as umlauts in German). Support for other

Re: [sqlite] [PATCH] WinCE compilation

"Robert Simpson" <[EMAIL PROTECTED]> wrote: > > in os_win.c theres: > > static int winFileHandle(OsFile *id){ > return (int)((winFile*)id)->h; > } > > This won't fly on 64-bit platforms. Windows file handles are declared as > HANDLE which is an alias for "void *". int's are 32-bits in

Re: [sqlite] [PATCH] WinCE compilation

Just for the record ... Took me about an hour to figure out how to compile on Windows from the CVS sources, and even then it was guesswork and I wasn't able to do it 100%. The ".in" files I couldn't figure out how to process by hand. nmake on Windows was useless for the makefiles, and

Re: [sqlite] Re: Padding with zeros

I missed replying to the correct email, but this tip from Igor Tandetnik worked beautifully: Igor Tandetnik Thu, 29 Dec 2005 14:50:08 -0800 Brian Johnson wrote: I need to update a char field to add integer prefixes, but I need to pad them with zeroes so I can sort them. I'm not exactly sure

Re: [sqlite] can ignore n lines when .import data file?

On 1/6/06, ronggui wong <[EMAIL PROTECTED]> wrote: > As I see,many CSV files using \t as separator. > And SQLite does not use \t,I have to use sed(or other tools) to change > Tab to |. so My puzzle is why SQLite not support \t? You can set separator to be anything you want, including \t. Use this

Re: [sqlite] can ignore n lines when .import data file?

> > Have you tried "head" or "tail"? > do you means the head command of the OS,say linux ? > Not yet,using "head" or "tail" will be faster than sed? My guess would be yes, though probably not much. It should be pretty simple to test. If it's a very large file you may be limited by your I/O speed,

Re: [sqlite] can ignore n lines when .import data file?

2006/1/7, Jay Sprenkle <[EMAIL PROTECTED]>: > Have you tried "head" or "tail"? do you means the head command of the OS,say linux ? Not yet,using "head" or "tail" will be faster than sed? As I see,many CSV files using \t as separator. And SQLite does not use \t,I have to use sed(or other tools) to

Re: [sqlite] can ignore n lines when .import data file?

2006/1/7, Griggs, Donald <[EMAIL PROTECTED]>: > > Regarding: > > I want to use .import ... but the first line is the variable(fields), so I > want to ignore it. > = > > Possible option #1: > > If it wouldn't violate any database-enforced constraints, why not import

Re: [sqlite] can ignore n lines when .import data file?

Have you tried "head" or "tail"? On 1/6/06, ronggui wong <[EMAIL PROTECTED]> wrote: > I want to use .import to import a data file into SQLite.but the first > line is the variable(fields),so I want to ignore it.delete the first > row of the data is one solution,But the data file is large ,and try

RE: [sqlite] can ignore n lines when .import data file?

Regarding: I want to use .import ... but the first line is the variable(fields), so I want to ignore it. = Possible option #1: If it wouldn't violate any database-enforced constraints, why not import the entire file, then delete the first row via SQL? DELETE

[sqlite] can ignore n lines when .import data file?

I want to use .import to import a data file into SQLite.but the first line is the variable(fields),so I want to ignore it.delete the first row of the data is one solution,But the data file is large ,and try to use sed to delete the first row,it takes long time a|b|c 1|2|3 |3|1 ...

Re: [sqlite] [PATCH] WinCE compilation

I'll test it later today when I get a chance. I know how to add the locking support as well -- so I'll have a go at incorporating those changes and will report the results. Robert - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Friday, January

Re: [sqlite] [PATCH] WinCE compilation

Simon Posnjak <[EMAIL PROTECTED]> wrote: > > Would it be possible if [Steve Lhomme's] port [to WinCE] and the sf > port could be merged together in main line src tree? > I have attempt to do this, but I have no way to test it. Anybody who is able to download the latest from CVS, compile for