Re: [sqlite] SQLite 3 file format changed?

2006-02-20 Thread Firman Wandayandi 
On 2/20/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Version 3.3.0, 4th bullet:  "More efficient coding of boolean
> values resulting in a smaller database file"
>
> --
> D. Richard Hipp   <[EMAIL PROTECTED]>
>

Oh that's it! But seems doesn't like file format log changed :-)

On 2/20/06, Jens Miltner <[EMAIL PROTECTED]> wrote:
> 3.3 changed the database format, but can read/write any 3.x format.
> However, once you create or vacuum a database with 3.3.x, the format
> is updated to the newest format and older implementations can't read
> it any more.
> See  for details
>

I just found it. Nice 3.3 can read/write 3.x, but no PDO_SQLITE
updated yet ATM, the latest is 3.2.8, so the problem is PDO_SQLITE
then I need to wait someone updated it.

Thanks for the infos.
--
Firman Wandayandi
Never Dreamt Before: http://firman.dotgeek.org/
Wishlist: http://www.amazon.com/gp/registry/1AAN8NZBHW2W9

Re: [sqlite] SQLite 3 file format changed?

2006-02-20 Thread Jens Miltner 


Am 20.02.2006 um 06:33 schrieb Firman Wandayandi:


Hi,

I use PHP PDO_SQLITE extension with SQLite 3.2.8 library, I try to
open a database version 3 which I use SQLiteSpy 1.5.2 with SQLite
3.3.4 library, then PDO said error message like "unsupported file
format". I tried to use sqlite3 console which is version 3.2.6 for
open it, same error message given.

I suspected there was file format has been changed again, but I can't
found any log on http://sqlite.org/changes.html told about that.
What's wrong exactly?


3.3 changed the database format, but can read/write any 3.x format.  
However, once you create or vacuum a database with 3.3.x, the format  
is updated to the newest format and older implementations can't read  
it any more.

See  for details

Re: [sqlite] Older sources

2006-02-20 Thread Jens Miltner 


Am 20.02.2006 um 10:08 schrieb Manfred Bergmann:



Am 20.02.2006 um 19:12 schrieb Jose Da Silva:


On February 19, 2006 06:45 pm, Manfred Bergmann wrote:

Hi there.
I would need the sources of an older version (3.1.2) of SQLite.
Are they still available for download?


If nobody has it, go to google and search for these 3 words:
sqlite 3.1.2 rpm
or
sqlite 3.1.2 tar.gz

The response is many mirror sites, so here's the link for above.
watch for line-wrap if line too long shown here:
http://www.google.ca/search?hl=en&ie=ISO-8859-1&q=sqlite+3.1.2 
+rpm&btnG=Search&meta=


Ok, thx. I thought there is a "official" place where they are  
accessible.


I'm pretty sure you can fetch them from cvs. Check the timeline at  
 and search for the 3.1.2  
release milestone. Once you've found it, click it's link and you'll  
be taken to the milestone details page. There's a navigation link  
"[Tagging/Branching]", which will display the cvs commands to use to  
create a tag for this milestone. You can use the date specified for  
this tag to checkout the sources for that release...


(Unless there are tags for the releases, in which case you'd only  
need to find the appropriate tag and cvs checkout with this tag).


HTH,

Re: [sqlite] SQLite 3 file format changed?

2006-02-20 Thread drh 
"Firman Wandayandi" <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I use PHP PDO_SQLITE extension with SQLite 3.2.8 library, I try to
> open a database version 3 which I use SQLiteSpy 1.5.2 with SQLite
> 3.3.4 library, then PDO said error message like "unsupported file
> format". I tried to use sqlite3 console which is version 3.2.6 for
> open it, same error message given.
> 
> I suspected there was file format has been changed again, but I can't
> found any log on http://sqlite.org/changes.html told about that.
> What's wrong exactly?
> 

Version 3.3.0, 4th bullet:  "More efficient coding of boolean
values resulting in a smaller database file"

--
D. Richard Hipp   <[EMAIL PROTECTED]>

Re: [sqlite] Older sources

2006-02-20 Thread drh 
Manfred Bergmann <[EMAIL PROTECTED]> wrote:
> Hi there.
> 
> I would need the sources of an older version (3.1.2) of SQLite.
> Are they still available for download?
> 

All SQLite source code going back to version 1.0 and even
before that is available via CVS.  Instructions at
http://www.sqlite.org/download.html

--
D. Richard Hipp   <[EMAIL PROTECTED]>

Re: [sqlite] Disable index?

2006-02-20 Thread drh 
Jim Dodgen <[EMAIL PROTECTED]> wrote:
> one simple trick I first started using with oracle and also use with 
> sqlite is to do the following  on the where clause
> for numerics
> where filda = fldb+0
> 
> for strings
> 
> where flda = fldb||""
> 
> this would cause a index on fldb to be ignored during optimization
> 

That trick works, but it imposes a run-time overhead because 
SQLite actually has to evaluate the +0 and the ||"".  If you
just say:

   where filda = +flda

The unary "+" operator is a no-op in SQLite, it works with both
numbers and strings, and there is no run-time penalty (other than
the fact that an index will not be used.)  On the other hand,
I have no idea if oracle supports a unary "+" operator or not.
--
D. Richard Hipp   <[EMAIL PROTECTED]>

[sqlite] More sqlite databases in temp folder. Was: help

2006-02-20 Thread drh 
"SnapinPop" <[EMAIL PROTECTED]> wrote:
> dont want this on my pc. found sqlite files in my temp solder that wont be 
> deleted as in use by other program and dont know which one. shred it but 
> comes back as a new one. never was there. b4. how to delete sqlite.

SQLite is not an application.  It is a component that
is built into other applications.  You must be running
some other application that is creating these SQLite
database files. 

SQLite is public domain software so anybody can built
it into their application, and many companies have done
so.  We do not have a list of what applications us it.

What other applications are you running?

--
D. Richard Hipp   <[EMAIL PROTECTED]>

[sqlite] unsubsribe

2006-02-20 Thread Oliver Manthey 

unsubsribe

Re: [sqlite] Best way to get rowID of SELECT DISTINCT

2006-02-20 Thread Denis Sbragion 
Hello Marco,

On Mon, February 20, 2006 09:56, Marco Bambini wrote:
> I have also tried this:
> CREATE VIEW v1 AS SELECT DISTINCT Artist FROM trax;
> SELECT rowid FROM v1

may be:

CREATE VIEW v1 AS SELECT Artist, min(rowid) as firstid FROM trax GROUP BY 
Artist;

This view will provide you the first rowid for any Artist in the trax view.

Bye,

-- 
Denis Sbragion
InfoTecna
Tel: +39 0362 805396, Fax: +39 0362 805404
URL: http://www.infotecna.it

Re: [sqlite] Older sources

2006-02-20 Thread Manfred Bergmann 


Am 20.02.2006 um 19:12 schrieb Jose Da Silva:


On February 19, 2006 06:45 pm, Manfred Bergmann wrote:

Hi there.
I would need the sources of an older version (3.1.2) of SQLite.
Are they still available for download?


If nobody has it, go to google and search for these 3 words:
sqlite 3.1.2 rpm
or
sqlite 3.1.2 tar.gz

The response is many mirror sites, so here's the link for above.
watch for line-wrap if line too long shown here:
http://www.google.ca/search?hl=en&ie=ISO-8859-1&q=sqlite+3.1.2 
+rpm&btnG=Search&meta=


Ok, thx. I thought there is a "official" place where they are  
accessible.



regards,
Manfred






___ 
Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de

[sqlite] Best way to get rowID of SELECT DISTINCT

2006-02-20 Thread Marco Bambini 

I need to get rowid of DISTINCT records, but so far all my test fails.

I have also tried this:
CREATE VIEW v1 AS SELECT DISTINCT Artist FROM trax;
SELECT rowid FROM v1

but the rowid column is empty...

Any help is really appreciated...

---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/

Re: [sqlite] Older sources

2006-02-20 Thread Jose Da Silva 
On February 19, 2006 06:45 pm, Manfred Bergmann wrote:
> Hi there.
> I would need the sources of an older version (3.1.2) of SQLite.
> Are they still available for download?

If nobody has it, go to google and search for these 3 words:
sqlite 3.1.2 rpm
or
sqlite 3.1.2 tar.gz

The response is many mirror sites, so here's the link for above.
watch for line-wrap if line too long shown here:
http://www.google.ca/search?hl=en&ie=ISO-8859-1&q=sqlite+3.1.2+rpm&btnG=Search&meta=

Re: [sqlite] using sqlite3 in php

2006-02-20 Thread Firman Wandayandi 
On 2/20/06, Lloyd Thomas <[EMAIL PROTECTED]> wrote:
> sqlite3 is available in 5.1 using the pdo extensions.
> have a look at www.php.net/pdo
> I had the same problem with an app I wrote in delphi to insert records and
> used php front end to select records
>

The lastest SQLite library on PDO is 3.2.8, the file format of SQLite
3.3.0 has been changed, take a look
http://www.sqlite.org/formatchng.html for detail.

> Lloyd
>

--
Firman Wandayandi
Never Dreamt Before: http://firman.dotgeek.org/
Wishlist: http://www.amazon.com/gp/registry/1AAN8NZBHW2W9