Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

I just installed the sources (not the amalgamation ones) and it works fine. what's wrong with the amalgamation package? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

I don't know if it is important, but I am running ubuntu 10.04 64 bit ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

I made a small c program for testing the libs... #include #include int main() { printf("version %s\n",sqlite3_libversion()); return 0; } it returns 3.6.22 why do I compile and install a previous version? (is it linked to ubuntu?) best regards, Sylvain >

[sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

Hi, I downloaded, compiled and installed the sqlite3 3.7.01 from the sources (amalgamation). however I have the sqlite3 version 3.6.22 installed in /usr/local/bin when I do "make install" >.libs/sqlite3 --version 3.6.22 however something strange, it creates a sqlite3 on the folder (same level

Re: [sqlite] [PATCH] Fix locale-unsafe usage of tolower (upstreaming Chromium change)

On Wed, Aug 4, 2010 at 16:30, Scott Hess wrote: > You should probably pull the current SQLite code and make sure the > patch even applies, and if not, check to make sure that the problem > hasn't already been fixed. ext/fts3 should no longer have the flaw in > question, as

Re: [sqlite] threading error in sqlite 3 in python

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/04/2010 11:39 AM, Chris Hare wrote: > I have 3.6.12 in use. So how do I get around this error message> It > prevents part of my code from executing Easy - do no create SQLite objects (connections, cursors) in one thread and use them in

Re: [sqlite] [PATCH] Fix locale-unsafe usage of tolower (upstreaming Chromium change)

Pawel, You should probably pull the current SQLite code and make sure the patch even applies, and if not, check to make sure that the problem hasn't already been fixed. ext/fts3 should no longer have the flaw in question, as that code was heavily rewritten. Chromium's SQLite was last synced

Re: [sqlite] How to update many rows efficiently?

Dominique Pellé wrote: > For example, given 2 tables t1 and t2, both with 2 columns as follows... > > Table t1: > >ID name >-- >1 >2NULL >3NULL >4 >(~1 million records) > > Table t2: > >ID name >

[sqlite] [PATCH] Fix locale-unsafe usage of tolower (upstreaming Chromium change)

I'm attaching a suggested patch to fix locale-unsafe usage of tolower in FTS code. The goal is to make Chromium closer to the upstream, so if you have a better solution, that's great. This is upstreaming a Chromium patch

[sqlite] How to update many rows efficiently?

Hi I'm new to SQLite and I'm still learning. It's unclear to me how to update many records efficiently in a table. For example, given 2 tables t1 and t2, both with 2 columns as follows... Table t1: ID name -- 1 2NULL 3NULL 4 (~1

Re: [sqlite] Index Help

On 4 Aug 2010, at 6:38pm, Alexander Spence wrote: > CREATE TABLE [CommentIndex] ( >[CommentKey] TEXT UNIQUE, >[ThreadPath] TEXT PRIMARY KEY, >[ParentThreadPath] TEXT, >[ParentCommentKey] TEXT, >[NumberOfReplies] INT

Re: [sqlite] threading error in sqlite 3 in python

On Wed, Aug 04, 2010 at 01:00:02PM -0500, Chris Hare scratched on the wall: > How do I figure out what version of sqlite3 is actually installed > in the python install? (It is python2.6) If it isn't too old: SELECT sqlite_version(); -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H >

[sqlite] threading error in sqlite 3 in python

I think this is a version problem based upon the FAQ, but I get this error when a thred timer fires in python and I then try to access my sqlite3 database ProgrammingError: SQLite objects created in a thread can only be used in that same thread.The object was created in thread id

[sqlite] Index Help

Hey guys, I am writing a comment index database and need some help optimizing the indices. Here is my table schema and a list of the possible queries. Please note that they could be Ascending or Descending order by's. This will be used in an enterprise level social media app that must be

[sqlite] SQLite version 3.7.0.1

SQLite version 3.7.0.1 is now available on the SQLite website: http://www.sqlite.org/ http://www.sqlite.org/download.html Version 3.7.0.1 is a patch release that fixes a bug in version 3.7.0 that can lead to database corruption if the same database file is written alternately by

[sqlite] Please cease sending emails

Thank you. Graham Haggar ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Re Populating a database from a file

On 4 August 2010 14:57, john knops wrote: > Thanks for the prompt reply. > What form should the file take. I've tried enclosing the data for each > column in double quotes and separating them with either a comma, tab or > space but I get an error "expected 5 columns

Re: [sqlite] Content filtered message notification

I can reproduce your problem. I still don't know what is causing it, but I'm sure we will be able to fix it prior to 3.7.0. We are currently chasing a more serious issue with 3.7.0 seen here: http://www.sqlite.org/src/info/51ae9cad317a1 We will have a patch release (3.7.0.1) out shortly.

[sqlite] Re Populating a database from a file

Thanks for the prompt reply. What form should the file take. I've tried enclosing the data for each column in double quotes and separating them with either a comma, tab or space but I get an error "expected 5 columns but only found 1. Using | I get "datatype mismatch" Also when I use .dump does

Re: [sqlite] delete constraint

BareFeetWare wrote: >>> SELECT RAISE(FAIL,'album has songs cannot be deleted') >>> WHERE (SELECT count(album_fk) FROM songs WHERE (album_fk = OLD.id) > 0); >> >> Or simply >> >> where old.id in (select album_fk from songs) > > Or most efficiently: > > where exists

Re: [sqlite] Command line tool always return the first column in a select

I upgraded to 3.7.0 and it fixes the problem. Thanks! Ben On Wed, Aug 4, 2010 at 8:07 AM, Black, Michael (IS) wrote: > I just ran your code on 3.6.23.1 and it works just fine. > > Can you try a newer version? > > x.sql: > create table mytable (id VARCHAR(255), name

[sqlite] warning message when compiling on 64-bit SPARC

I get the following warning from sqlite3.c:109910:20: warning: cast from pointer to integer of different size when building on a Sun Blade 1000 with dual 900 MHz UltraSPARC III+ processors. I'm sorry to say this was with version sqlite-3.6.22, so you may have corrected it now. Since by

Re: [sqlite] General questions from a newbe

On 3 Aug 2010, at 10:20pm, jeff archer wrote: > Generally, in the past I have always used normalized data but thought I read > this might not always be most efficient in SQLite. Is there any "rule of > thumb"? Generally speaking, don't worry about it. Do whatever makes your programming

Re: [sqlite] Command line tool always return the first column in a select

I just ran your code on 3.6.23.1 and it works just fine. Can you try a newer version? x.sql: create table mytable (id VARCHAR(255), name VARCHAR(255), address VARCHAR(255), PRIMARY KEY(id)); insert into mytable (id, name, address) VALUES ('123abc','charlie', '123 st'); insert into mytable

Re: [sqlite] Inserting a large amount of data into a large indexed table

I love email lists like this when people ask questions that make me want to test stuff and confirm my hypotheses. Gives me some much needed practice... Dropping your index and recreating every time you add rows is NOT the best thing to do. Quite obviously your time to create an index is

Re: [sqlite] Populating a database from a file

On 3 August 2010 14:52, john knops wrote: > If I'm using MySQL I can populate a database with "Load data infile > '/tmp/data.txt' into table table_1" > Is there a similar way of loading data into a sqlite3 database? > > Thanks > >From sqlite shell use

Re: [sqlite] Content filtered message notification

The problem is possibly caused by this bug: http://www.sqlite.org/src/info/8011086c85 Please recompile using -DSQLITE_OMIT_AUTOMATIC_INDEX. Or recompile using a recent snapshot from http://www.sqlite.org/draft/download.html. If either of these remediations fix the problem, then bug 8011086c85

[sqlite] Command line tool always return the first column in a select

Everytime I select something from a table I always get the first selected field only. Here's what I mean: # sqlite3 mytable.db SQLite version 3.6.22 Enter ".help" for instructions Enter SQL statements terminated with a ";" *sqlite> .show* echo: off explain: off headers: off mode:

[sqlite] General questions from a newbe

I'm new to SQLite but have some experience with MS SQL Server.  I am looking for a quick confirmation from expert that my planed use of SQLite is reasonable and maybe point out if there are any gotchas.  I've done some prototyping and tried most of this out but it is based on how I've done

Re: [sqlite] Repairing a Database.

Thanks for your reply. I was afraid that may be the case. This is for my application that uses an SQLite database to store 3D data so it would be difficult to find out which set of binary data is corrupt and which is not. I do encourage my clients to backup the database, it is even stored in

[sqlite] Populating a database from a file

If I'm using MySQL I can populate a database with "Load data infile '/tmp/data.txt' into table table_1" Is there a similar way of loading data into a sqlite3 database? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Inserting a large amount of data into a large indexed table

Paul, the WAL mode or SSD will be helpful. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users