[sqlite] test DBD::SQLite 1.30_04 - write-ahead logging

All, I am pleased to announce that DBD::SQLite (Self Contained RDBMS in a Perl DBI Driver) version 1.30_04 has been released on CPAN (by Adam Kennedy). http://search.cpan.org/~adamk/DBD-SQLite-1.30_04/ This developer release bundles the brand-new SQLite version 3.7.2, which (since 3.7.0)

[sqlite] Fw: Re: SQlite JDBC driver - need help

Hello,     Can some one please help me how do I connect to SQLite from a JSP page with windows authentication mode?   Thank you,   Dev --- On Wed, 8/25/10, Richard Hipp wrote: From: Richard Hipp Subject: Re: SQlite JDBC driver - need help To: "Dev Movva"

[sqlite] Bug with large file support in IBM AIX

It seems that IBM's AIX is finicky with large file support, at least on the system I'm working on. Out of the box, large file support will be disabled for aix when compiling the sqlite3 amalgamation. I had to make the following changes in sqlite3.c: #ifndef SQLITE_DISABLE_LFS # define

Re: [sqlite] Why the deadlock?

On Aug 25, 2010, at 11:04 PM, Pavel Ivanov wrote: >> Prior to version 3.6.5 SQLite used to delay committing the >> transaction until all SELECT statements had finished. But that >> behavior was deemed to be less intuitive. > > But this is the current 3.7.1 documentation >

Re: [sqlite] Why the deadlock?

> Prior to version 3.6.5 SQLite used to delay committing the > transaction until all SELECT statements had finished. But that > behavior was deemed to be less intuitive. But this is the current 3.7.1 documentation (http://www.sqlite.org/lockingv3.html): If multiple commands are

Re: [sqlite] Why the deadlock?

On Aug 25, 2010, at 10:40 PM, Pavel Ivanov wrote: > Nikolaus, > > I've traced your application a bit (with SQLite 3.6.18 sources) and > it looks like SQLite does some nasty thing nobody in this thread > expected. For some reason while doing first delete SQLite actually > commits transaction and

Re: [sqlite] Why the deadlock?

Nikolaus, I've traced your application a bit (with SQLite 3.6.18 sources) and it looks like SQLite does some nasty thing nobody in this thread expected. For some reason while doing first delete SQLite actually commits transaction and degrades lock to SHARED. Then of course second delete cannot

Re: [sqlite] Length=10

So simple. I never thought of using the command-line sqlite3... > in the sqlite3 shell, set output mode to file, and then select as > above. All your select output will go to your file. > > ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Length=10

On Wed, Aug 25, 2010 at 10:05 AM, Ted Rolle Jr. wrote: > I have a table of UPCs with lengths varying from 6 to 12.  I'd like to > print those with length=10 to a file for printing. > SELECT * >  FROM UPCs >  WHERE LENGTH(UPC)=10; > works just fine.  But when I export the table

[sqlite] Length=10

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a table of UPCs with lengths varying from 6 to 12. I'd like to print those with length=10 to a file for printing. SELECT * FROM UPCs WHERE LENGTH(UPC)=10; works just fine. But when I export the table I naturally get the whole table. Would

Re: [sqlite] Why the deadlock?

Doug Currie writes: > On Aug 24, 2010, at 10:57 AM, Nikolaus Rath wrote: > >> Nikolaus Rath >> >> writes: >>> Still no one able to clarify the issues raised in this thread? >>> >>>

Re: [sqlite] Why the deadlock?

Hi, I only saw http://article.gmane.org/gmane.comp.db.sqlite.general/58835, was there anything else? -Nikolaus Gerry Snyder writes: > Er, did you not see Dan Kennedy's comments a fed days ago?? > > On 8/24/10, Nikolaus Rath

Re: [sqlite] SQLite 3.7.x for Pocket PC 2003 SDK (VS2005) does not compile

There have been several posts on this issue just this week, and suggested workarounds. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joachim Wickman Sent: Wednesday, August 25, 2010 12:37 AM To: sqlite-users@sqlite.org

Re: [sqlite] Stitching together Text Files into a New Database

1. Define a separate file in SQLite for each campaign, with the three columns you need: CAMPAIGN1 Time number (assuming the values are always numbers; use TEXT if they contain a mix of letters/numbers) TagA number TagB number CAMPAIGN2 Time TagA TagB Etc. 2. Import each of your text files

Re: [sqlite] Stitching together Text Files into a New Database

Lorenzo Isella writes: [...] if you've no idea where a db can help you and if you don't have time to investigate this and the possibilities a db offers you my suggestion is: import your 3 or 5 files into a spreadsheet, add a column for your different campaign and that's it

[sqlite] Stitching together Text Files into a New Database

Dear All, I am quite new to databases in general and sqlite in particular. I have a number of data files which are nothing else than text files with a pretty simple simple structure: there are only 3 columns of integer numbers, something along these lines 123 1000 199 123 1100 188 125

[sqlite] SQLite 3.7.x for Pocket PC 2003 SDK (VS2005) does not compile

Hello, FYI, Compiling for Pocket PC 2003 stopped to work since version 3.7.1 and 3.7.2. So using 3.6.23.1 for now until it gets fixed. 1>Compiling... 1>sqlite3.c 1>..\..\Common\sqlite3\sqlite3.c(30471) : error C2065: 'LOCKFILE_EXCLUSIVE_LOCK' : undeclared identifier