Re: [sqlite] How accept sqlite3 commands from stdin

On 24 Jun 2010, at 4:50am, Peng Yu wrote: > Is there a way to use Shebang for sqlite3 script? > > http://en.wikipedia.org/wiki/Shebang_%28Unix%29 SQLite comes with a command-line tool. You can feed it with individual commands on a Unix command-line or tell it to read commands from a file.

Re: [sqlite] Issue with locked journal file

Ok, I'll expand on that suggestion, try PRAGMA journal_mode=truncate; If you are using TortoiseSVN on the machine than the most likely cause is the TSVNCache process. We had countless issues with it. Best regards, F.N. On Wed, Jun 23, 2010 at 8:18 PM, Pavel Ivanov wrote: >

[sqlite] 64 bit libsqlite for AIX and Solaris

Hi, I am looking for 64 bit libsqlite for AIX and Solaris. Is there a place from where I can get them pre-built ? I have downloaded sqlite-amalgamation-3.6.23.1.tar and building it. But I don't see any option in configure to build it for 64 bits. Will the default library built be 64 bits. ? If

[sqlite] Fwd: CRITICAL bug in sqlite3VdbeExec() code

-- Forwarded message -- From: jur...@ramzes.net To: sqlite-users@sqlite.org Date: Thu, 24 Jun 2010 11:15:20 +0200 Subject: CRITICAL bug in sqlite3VdbeExec() code Dear friends, This is my bug report. sqlite version: 3.6.23.1, Check-in [2e6a462ceb] file: vdbe.c line: 971 function:

Re: [sqlite] Fwd: CRITICAL bug in sqlite3VdbeExec() code

On Thu, Jun 24, 2010 at 6:45 AM, D. Richard Hipp wrote: > -- Forwarded message -- > From: jur...@ramzes.net > To: sqlite-users@sqlite.org > Date: Thu, 24 Jun 2010 11:15:20 +0200 > Subject: CRITICAL bug in sqlite3VdbeExec() code > Dear friends, > > This is my bug

Re: [sqlite] 64 bit libsqlite for AIX and Solaris

You get the default for whatever platform you're compiling on. Though I'm not sure if there's any advantage/disadvantage to 64-bit binaries for sqlite3, is there? Michael D. Black Senior Scientist Northrop Grumman Mission Systems From:

Re: [sqlite] 64 bit libsqlite for AIX and Solaris

What compiler are you using? With GCC, you can use -m64 option. There must be a similar option in other compilers. -- Igor Sushil-15 wrote: > > Hi, > > I am looking for 64 bit libsqlite for AIX and Solaris. Is there a place > from > where I can > get them pre-built ? > > I have downloaded

[sqlite] Development snapshots for SQLite 3.7.0 available

On the download page of the draft website: http://www.sqlite.org/draft/download.html you can now find amalgamations (the sqlite3.c source file) for development snapshots. These snapshots are intended for beta-testing only. Interfaces and file formats in these snapshots are subject to

[sqlite] Force Database Corruption

Hello, I'm needing a corrupted database for test purpose, someone can help me? I want an database with corruption on index like: "rowid [%ld] missing from index %s" or "wrong # of entries in index %s" -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development

Re: [sqlite] sqlite documents in pdf format

HI Peng, you could install PDFCreator (http://en.pdfforge.org/pdfcreator) then open the site and print it with PDFCreator. Then you have a pdf-file. with best wishes Artur - > I only find html format document but not pdf format. In case I miss > anything, could you please

Re: [sqlite] 64 bit libsqlite for AIX and Solaris

Black, Michael (IS) wrote: > Though I'm not sure if there's any advantage/disadvantage to 64-bit > binaries for sqlite3, is there? 64-bit SQLite can cache more than 4Gb of your db. Eric -- Eric A. Smith Finagle's First Law: If an experiment works, something has gone wrong.

Re: [sqlite] 64 bit libsqlite for AIX and Solaris

On 06/24/10 09:07 AM, Sushil wrote: > Hi, > > I am looking for 64 bit libsqlite for AIX and Solaris. Is there a place from > where I can > get them pre-built ? > > I have downloaded sqlite-amalgamation-3.6.23.1.tar and building it. But I > don't see any > option in configure to build it for 64

Re: [sqlite] sqlite documents in pdf format

Hi Artur, I could use acrobat to convert the whole website to pdf. Do you know if there is any particular advantage to use PDF Creator, besides the latter is free? Although I could use a software to convert html to pdf, I'd prefer to have a document in pdf directly. As the pdf file converted

[sqlite] Why is there no test suite for ''make check' ?

I know the SQlite developers take testing quite seriously http://www.sqlite.org/testing.html with 679 times as much test code as actual code in the database. In fact, I've often pointed to the above page when trying to get the developers of the Sage maths software to pay a bit more attention

Re: [sqlite] Why is there no test suite for ''make check' ?

On Thu, Jun 24, 2010 at 9:33 AM, Dr. David Kirkby wrote: > I know the SQlite developers take testing quite seriously > > http://www.sqlite.org/testing.html > > with 679 times as much test code as actual code in the database. > > In fact, I've often pointed to the above

Re: [sqlite] How accept sqlite3 commands from stdin

On Thu, Jun 24, 2010 at 5:05 AM, Simon Slavin wrote: > > On 24 Jun 2010, at 4:50am, Peng Yu wrote: > >> Is there a way to use Shebang for sqlite3 script? >> >> http://en.wikipedia.org/wiki/Shebang_%28Unix%29 > > SQLite comes with a command-line tool.  You can feed it with

Re: [sqlite] How accept sqlite3 commands from stdin

Peng Yu wrote: > On Thu, Jun 24, 2010 at 5:05 AM, Simon Slavin wrote: > > > > On 24 Jun 2010, at 4:50am, Peng Yu wrote: > > > >> Is there a way to use Shebang for sqlite3 script? > >> > >> http://en.wikipedia.org/wiki/Shebang_%28Unix%29 > > > > SQLite comes with a

[sqlite] vim highlight for sqlite script

Hi, The default vim syntax highlight doesn't highlight command like .help that is specific to sqlite3. Does anybody use a vim script that can hightlight those sqlite specific commands? -- Regards, Peng ___ sqlite-users mailing list

Re: [sqlite] How accept sqlite3 commands from stdin

On Thu, Jun 24, 2010 at 09:13:01AM -0500, Peng Yu scratched on the wall: > I was asking whether it is possible to use Shebang with sqlite script. > If it is possible, would you please show me how to modify the > following script to do so? Not possible. Shebang assumes the input file can be

Re: [sqlite] How accept sqlite3 commands from stdin

> I was asking whether it is possible to use Shebang with sqlite script. > If it is possible, would you please show me how to modify the > following script to do so? If you don't mind one error message then you can do it like this: > cat test.sql #!/usr/bin/sqlite3 -init ; create table tbl1(one

Re: [sqlite] How accept sqlite3 commands from stdin

On 24 Jun 2010, at 3:13pm, Peng Yu wrote: > I was asking whether it is possible to use Shebang with sqlite script. > If it is possible, would you please show me how to modify the > following script to do so? > > $ ./main.sql > Error: unknown command or invalid arguments: "/main.sql". Enter >

Re: [sqlite] How accept sqlite3 commands from stdin

On Thu, Jun 24, 2010 at 10:36:20AM -0400, Pavel Ivanov scratched on the wall: > > I was asking whether it is possible to use Shebang with sqlite script. > > If it is possible, would you please show me how to modify the > > following script to do so? > > If you don't mind one error message then

Re: [sqlite] Why is there no test suite for ''make check' ?

On 06/24/10 02:55 PM, Richard Hipp wrote: > On Thu, Jun 24, 2010 at 9:33 AM, Dr. David Kirkby > wrote: > >> I know the SQlite developers take testing quite seriously >> >> http://www.sqlite.org/testing.html >> >> with 679 times as much test code as actual code in the

Re: [sqlite] Why is there no test suite for ''make check' ?

Try one directory up. It's not in the src directory Makefile. Michael D. Black Senior Scientist Northrop Grumman Mission Systems From: sqlite-users-boun...@sqlite.org on behalf of Dr. David Kirkby Sent: Thu 6/24/2010 10:10 AM To: General Discussion of

Re: [sqlite] Why is there no test suite for ''make check' ?

On 06/24/10 04:20 PM, Black, Michael (IS) wrote: > Try one directory up. It's not in the src directory Makefile. There is only one directory - there is no 'src' directory at all. If you look at the path what I posted below, you do see 'src' but that is part of the directory structure in

Re: [sqlite] Why is there no test suite for ''make check' ?

On Thu, Jun 24, 2010 at 12:03 PM, Dr. David Kirkby wrote: > On 06/24/10 04:20 PM, Black, Michael (IS) wrote: > > Try one directory up. It's not in the src directory Makefile. > > > There is only one directory - there is no 'src' directory at all. If you > look at > the

Re: [sqlite] How accept sqlite3 commands from stdin

On Thu, Jun 24, 2010 at 9:19 AM, Eric Smith wrote: > Peng Yu wrote: > >> On Thu, Jun 24, 2010 at 5:05 AM, Simon Slavin wrote: >> > >> > On 24 Jun 2010, at 4:50am, Peng Yu wrote: >> > >> >> Is there a way to use Shebang for sqlite3 script? >> >> >> >>

[sqlite] Why null is not printed?

According to The Definitive Guide to SQLite (page 120), if I type "select null=null;" in a sqlite3 session, I should get 'NULL' printed. http://apress.com/book/view/9781590596739 But I tried it in sqlite3, only an empty line is printed. Is it the cases that sqlite3 change the way to show null

Re: [sqlite] Why null is not printed?

On Thu, Jun 24, 2010 at 1:34 PM, Peng Yu wrote: > According to The Definitive Guide to SQLite (page 120), if I type > "select null=null;" in a sqlite3 session, I should get 'NULL' printed. > > http://apress.com/book/view/9781590596739 > > But I tried it in sqlite3, only an

Re: [sqlite] Why null is not printed?

On Thu, Jun 24, 2010 at 12:34:18PM -0500, Peng Yu scratched on the wall: > According to The Definitive Guide to SQLite (page 120), if I type > "select null=null;" in a sqlite3 session, I should get 'NULL' printed. > > http://apress.com/book/view/9781590596739 > > But I tried it in sqlite3, only

Re: [sqlite] Why is there no test suite for ''make check' ?

On 06/24/10 05:13 PM, Richard Hipp wrote: > On Thu, Jun 24, 2010 at 12:03 PM, Dr. David Kirkby > wrote: > >> On 06/24/10 04:20 PM, Black, Michael (IS) wrote: >>> Try one directory up. It's not in the src directory Makefile. >> >> >> There is only one directory - there is

Re: [sqlite] sqlite documents in pdf format

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/24/2010 06:08 AM, Peng Yu wrote: > It is very common that software provide > document in many different format. For example, python, GNU make. Not really the case. The software that provides documentation in PDF has usually done so because the

Re: [sqlite] Force Database Corruption

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/24/2010 05:10 AM, Israel Lins Albuquerque wrote: > I'm needing a corrupted database for test purpose, someone can help me? > I want an database with corruption on index like: > "rowid [%ld] missing from index %s" or "wrong # of entries in

Re: [sqlite] Why is there no test suite for ''make check' ?

Replying to an earlier post, I remember "make test" working for SQLite when I tried it in the past. I'm actually used to running that, this practice ingrained as standard behaviour with Perl and Perl modules, and I usually expect any other projects to have a "make test" too. Besides Perl, I

[sqlite] understanding the logic of licensing various parts of the sqlite family

I am simply curious, and want to expand my knowledge of this -- 1. sqlite3 code is in public domain. 2. sqlite mark is trademarked. 3. sqlite3 encryption extension is licensed and for a fee, and comes with a contract to not distribute it further. 4. sqlite code tests are available as long as they

Re: [sqlite] understanding the logic of licensing various parts of the sqlite family

On Thu, Jun 24, 2010 at 3:58 PM, P Kishor wrote: > I am simply curious, and want to expand my knowledge of this -- > > 1. sqlite3 code is in public domain. > 2. sqlite mark is trademarked. > 3. sqlite3 encryption extension is licensed and for a fee, and comes > with a

Re: [sqlite] understanding the logic of licensing various parts of the sqlite family

On Thu, Jun 24, 2010 at 3:04 PM, Richard Hipp wrote: > On Thu, Jun 24, 2010 at 3:58 PM, P Kishor wrote: > >> I am simply curious, and want to expand my knowledge of this -- >> >> 1. sqlite3 code is in public domain. >> 2. sqlite mark is trademarked. >> 3.

Re: [sqlite] understanding the logic of licensing various parts of the sqlite family

On Thu, Jun 24, 2010 at 4:15 PM, P Kishor wrote: > > Right then. That explains #3 above. Are you saying that #5 is > available for a fee? And, is there a description of #5 and how it > differs from #4? Not that I will understand the differences, nor will > I ever need it. I

Re: [sqlite] understanding the logic of licensing various parts of the sqlite family

On Thu, Jun 24, 2010 at 3:19 PM, Richard Hipp wrote: > On Thu, Jun 24, 2010 at 4:15 PM, P Kishor wrote: > >> >> Right then. That explains #3 above. Are you saying that #5 is >> available for a fee? And, is there a description of #5 and how it >> differs from

Re: [sqlite] Why is there no test suite for ''make check' ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/24/2010 12:38 PM, Darren Duncan wrote: > The test suite being AFAIK > essentially an application that links against the already-compiled SQLite, Not quite the case. The test suite includes large amounts of code to induce various faults, track

Re: [sqlite] What is the sqlite3 script suffix?

On Wed, 23 Jun 2010 22:41:55 -0500, Peng Yu wrote: >I'm trying to following the convention. If I'm going to save sql >commands in a script and run them as needed, could you let me know >what suffix people in general use? I'm thinking of the suffix '.sql', >but I'm not sure

Re: [sqlite] Why is there no test suite for ''make check' ?

Does the TEA tarball have the tests? -- __ 3.14159265358979323846264338327950 Let the spirit of pi 2884197169399375105820974944592307 spread all over the world! 8164062862089986280348253421170679 http://pi314.at PI VOBISCUM!

Re: [sqlite] Oracle joins the SQLite Consortium

I can't see anything good coming out of this if there are lawyers involved. -- __ 3.14159265358979323846264338327950 Let the spirit of pi 2884197169399375105820974944592307 spread all over the world!

Re: [sqlite] Oracle joins the SQLite Consortium

On 24 Jun 2010, at 10:38pm, Ted Rolle, Jr. wrote: > I can't see anything good coming out of this if there are lawyers > involved. Big North American companies like Oracle don't do /anything/ without lawyers. It can't be helped in a country like the USA. Not all lawyers are evil: almost all

Re: [sqlite] Oracle joins the SQLite Consortium

On Fri, 25 Jun 2010 01:46:08 +0100 Simon Slavin wrote: > > On 24 Jun 2010, at 10:38pm, Ted Rolle, Jr. wrote: > > > I can't see anything good coming out of this if there are lawyers > > involved. > > Big North American companies like Oracle don't do /anything/ without >

Re: [sqlite] sqlite documents in pdf format

On Thu, Jun 24, 2010 at 2:32 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 06/24/2010 06:08 AM, Peng Yu wrote: >> It is very common that software provide >> document in many different format. For example, python, GNU make. > > Not really