[sqlite] Performance regression between SQLite 3.8.4.1 and 3.8.8

Hi, we encountered an issue where a query that performed well using SQLite 3.8.4.1 (i.e. execution time way below 1 second) suddenly took several seconds to execute. Unfortunately, I could not yet reduce the query and database to a sample that I could send along and the real query / database

[sqlite] unreached code in sqlite3.c?

Hi, I'm getting the following two warnings when compiling sqlite3.c with the latest clang tools: > sqlite3.c:116769:39: warning: code will never be executed [-Wunreachable-code] > if( pTerm->wtFlags & TERM_VNULL ) continue; > ^~~~ >

Re: [sqlite] What's the purpose of the "automatic index on" warning message?

Am 07.04.2014 um 18:42 schrieb Richard Hipp <d...@sqlite.org>: > On Mon, Apr 7, 2014 at 11:51 AM, Jens Miltner <j...@mac.com> wrote: > >> We get an sqlite3_log() message with errorCode 284 and message "automatic >> index on ...". >> I assume this i

[sqlite] What's the purpose of the "automatic index on" warning message?

We get an sqlite3_log() message with errorCode 284 and message "automatic index on ...". I assume this is some performance penalty warning, but I have no idea what to make of it: We do have an explicit index on the table and column mentioned in the warning message, so I don't know what to do

Re: [sqlite] Assertion fires in SQLite 3.8.4.1 for rather basic query

o verify that this is the >> correct fix and add new test cases, etc. >> >> Your work-around is to simply compile without -DSQLITE_DEBUG (thus >> disabling all assert() statements) or delete the assert() that is failing. >> >> >> On Thu, Mar 20,

Re: [sqlite] Assertion fires in SQLite 3.8.4.1 for rather basic query

Sorry, forgot to mention that our previous version of SQLite was 3.7.17 and we did not experience the issue there... Am 20.03.2014 um 12:26 schrieb Jens Miltner <j...@mac.com>: > Hi, > > I ran into the following problem after updating the SQLite 3.8.4.1: > > When ex

[sqlite] Assertion fires in SQLite 3.8.4.1 for rather basic query

Hi, I ran into the following problem after updating the SQLite 3.8.4.1: When executing the following (rather basic) SELECT query in a debug build of sqlite3, this will cause an assertion to fire in whereLoopAddBtreeIndex() (sqlite3.c, line 13411): SELECT * FROM t1 WHERE(foo_id=5 AND name IN

Re: [sqlite] assertion in sqlite 3.7.17 for rather simple SELECT query

Am 01.07.2013 um 20:16 schrieb Richard Hipp: > On Mon, Jul 1, 2013 at 9:20 AM, Jens Miltner <j...@mac.com> wrote: > >> I recently updated our SQLite source to SQLite source distribution 3.7.17. >> Since then, we get assertions when running one of our larger queries.

[sqlite] assertion in sqlite 3.7.17 for rather simple SELECT query

I recently updated our SQLite source to SQLite source distribution 3.7.17. Since then, we get assertions when running one of our larger queries. I have stripped down the query to a bare minimum query that produces the same assertion: The following rather simple SELECT query gives me an

Re: [sqlite] handling of BLOB bound parameters

Am 14.10.2010 um 12:56 schrieb Dan Kennedy: > > On Oct 14, 2010, at 5:43 PM, Jens Miltner wrote: > >> I just stumbled across a problem where sqlite would be stuck for >> quite a long time inside sqlite3VdbeExpandSql when using bound BLOB >> parameter

[sqlite] handling of BLOB bound parameters

I just stumbled across a problem where sqlite would be stuck for quite a long time inside sqlite3VdbeExpandSql when using bound BLOB parameters, i.e. my query looks like INSERT INTO foo VALUES (?,?,?,?...) and one of the parameters is a BLOB of about 700k. What I found is that when this query

Re: [sqlite] SQLITE .import

Am 19.04.2010 um 20:11 schrieb P Kishor: >> 3) From a linux box whats the easiest way of backing up the db in perl or >> shell? >> >> Can I lock the $sqlitedb first (how?) and then cp $sqlitedb >> /usr/local/db/backup >> > > There is no concept of locking a db in sqlite. A sqlite db is

Re: [sqlite] Fwd: Sqlite3 crashing on multithreaded program

Am 31.03.2010 um 15:14 schrieb Dan Kennedy: > > > Begin forwarded message: > >> From: "Periasamy, Karthikeyan" >> Date: March 31, 2010 7:52:55 PM GMT+07:00 >> To: "danielk1...@gmail.com" >> Subject: Re: [sqlite] Sqlite3 crashing on

Re: [sqlite] UTF-8 and UTF-16

Am 01.02.2010 um 00:02 schrieb a1rex: > I am planning to store text in a database which has to accommodate a > few international languages. > In this case I have to use UTF-16LE encoding for my TEXT fields. > I know that once an encoding has been set for a database, it cannot > be changed.

Re: [sqlite] Sqlite3 Optimization Question

Am 22.01.2010 um 15:01 schrieb Michael Thomason: > The only problem is that the table is very large. If I list out the > contents of the table in a text file, it is one-third the size of the > database. So, if the text file is 12 MB, the database is 32 MB. You may also want to check the

Re: [sqlite] bug in proxyGetHostID()

Am 16.01.2010 um 19:00 schrieb Thomas Stüfe: > Greetings, > > I think I found a small bug in sqlite 3.6.22 in the function > proxyGetHostID(). > > There, pread() and pwrite() are used to read a host id file. Return > value of these functions is assigned to a size_t variable. size_t is >

Re: [sqlite] [sqlite-dev] Sqlite Query Escaping

Am 31.12.2009 um 18:14 schrieb Kees Nuyt: > In short: if you use the sqlite3_prepare*() and > sqlite3_bind*() interface you don't have to escape single > quotes. Only if you compose a complete SQL statement for the > deprecated sqlite3_exec() call and using the sqlite3 command > line tool, where

Re: [sqlite] usage of indexes - query performance

actually make SQLite use the proper indexes. Thanks a lot! > > On Fri, Dec 18, 2009 at 3:52 AM, Jens Miltner <j...@mac.com> wrote: >> Hi everybody, >> >> consider the following database schema: >> >> CREATE TABLE t1 ( >>id INTEGER PRIMA

[sqlite] usage of indexes - query performance

Hi everybody, consider the following database schema: CREATE TABLE t1 ( id INTEGER PRIMARY KEY, uid, x ); CREATE INDEX t1_idx ON t1(uid); CREATE TABLE t2 ( id INTEGER PRIMARY KEY, t1_id INTEGER, y ); CREATE INDEX t2_idx ON t2(t1_id); Shouldn't

Re: [sqlite] BUG: the rowid column in view is automatically named as id

Am 09.12.2009 um 13:42 schrieb Alexey Pechnikov: > Hello! > > On Wednesday 09 December 2009 15:07:16 Pavel Ivanov wrote: >> It's been said in this list not once already: unless you're using "as >> ..." to name the column it's not guaranteed to have any particular >> name you expect it to. So

Re: [sqlite] Problem with database (SELECT hangs)

Am 21.11.2009 um 04:48 schrieb Phil Longstaff: > sqlite> explain query plan SELECT DISTINCT t.* FROM transactions AS > t, splits > AS s WHERE s.tx_guid=t.guid AND > s.account_guid='e3ea8186deb3a9c160ab3b9409ea618f'; > 0|0|TABLE transactions AS t WITH INDEX > sqlite_autoindex_transactions_1

Re: [sqlite] image upload to db trouble

Am 13.11.2009 um 09:25 schrieb Keith Roberts: > On Fri, 13 Nov 2009, Artur Reilin wrote: > >> To: General Discussion of SQLite Database >> From: Artur Reilin >> Subject: Re: [sqlite] image upload to db trouble >> >>>//echo $images; >>> $db

Re: [sqlite] sqlite3 for Mac OSX 10.5

Am 12.11.2009 um 20:08 schrieb Peter Haworth: > Thanks for all the info. I believe the problem lies within Revolution > since I'm pretty sure it includes its own private library of the > sqlite code. I've reported it to them and hopefully they will fix it. > > I understand the reasons for

Re: [sqlite] sqlite3_analyzer with 3.6.19 distribution

Am 11.11.2009 um 17:45 schrieb D. Richard Hipp: > > On Nov 11, 2009, at 11:24 AM, Jens Miltner wrote: >> >> Is sqlite3_analyzer supposed to work in 3.6.19? >> > > > No. sqlite3_analyzer has been busted for a long time. But the 3.6.0 > version of sq

[sqlite] sqlite3_analyzer with 3.6.19 distribution

Hi, I just tried to build the sqlite3_analyzer from the 3.6.19 distribution on Mac OS X (using 'make sqlite3_analyzer'), but when I run the tool, I get the following error: > Analyzing table agent_registry... > ERROR: invalid command name "btree_cursor_info" > invalid command name

Re: [sqlite] Late data typing. Am I missing something?

Am 29.10.2009 um 14:31 schrieb Simon Slavin: > > On 29 Oct 2009, at 9:36am, John Crenshaw wrote: > >>> Consider the case of an application using an SQLite database to >>> store >>> its settings (like the Windows registry, but portable). The dynamic >>> type system is great for this. >>> >>>

Re: [sqlite] searching sqlite tickets?

Am 19.10.2009 um 09:47 schrieb Dan Kennedy: > > On Oct 19, 2009, at 2:36 PM, Jens Miltner wrote: > >> Before the timeline was migrated to fossil, I was able to search for >> tickets. >> In the current sqlite.org website, I can no longer search for tickets >> -

Re: [sqlite] searching sqlite tickets?

Am 19.10.2009 um 09:47 schrieb Dan Kennedy: > > On Oct 19, 2009, at 2:36 PM, Jens Miltner wrote: > >> Before the timeline was migrated to fossil, I was able to search for >> tickets. >> In the current sqlite.org website, I can no longer search for tickets >> -

[sqlite] searching sqlite tickets?

Before the timeline was migrated to fossil, I was able to search for tickets. In the current sqlite.org website, I can no longer search for tickets - I can only show all tickets, all closed tickets or all open tickets, but I can't search for keywords any more... Is there still a way to

Re: [sqlite] Column headers of result

Am 29.06.2009 um 06:57 schrieb BareFeet: > Hi, > > Is there any way in the command line to get the columns in a query > result? > > For example, given an ad-hoc SQL command, such as: > > begin; > insert into MyTableOrView select * from SomeSource; > select * from MyTableOrView join

Re: [sqlite] which tool do they use to generate the SQL Syntax diagrams?

FWIW - you can still get a textual description at ... Am 20.04.2009 um 15:59 schrieb J. King: > On Mon, 20 Apr 2009 08:59:02 -0400, Jean-Denis Muys > > wrote: > >>> It's a shame: I far preferred the BNF: more compact, not to >>>

Re: [sqlite] Converting BLOB Data type to String

Am 02.04.2009 um 07:45 schrieb SATISH: > Hello Buddies, > >I have written a string into database by converting into > "BLOB Data > Type".writing into database is Ok I got a problem when reading from > the > database to read a blob from the database I am using the function > "const

Re: [sqlite] Wiki page on Management Tools - should it explicitely state Mac OS X support?

Am 03.03.2009 um 22:53 schrieb BareFeet: > Hi, > >>> on the Wiki page listing SQLite Management Tools >>> >>> , there are columns for Web, Windows, Linux and Misc. as supported >>> platforms. Since Mac OS X is a well-supported SQLite

Re: [sqlite] Ticket #3602

Am 23.01.2009 um 12:44 schrieb Dan: > > On Jan 23, 2009, at 5:37 PM, Jens Miltner wrote: > >> Hi, >> >> I filed ticket #3602 a couple of days ago: >> >> Essentially, when using empty test sets ("IN ()" / "NOT IN ()") in >

[sqlite] Ticket #3602

Hi, I filed ticket #3602 a couple of days ago: Essentially, when using empty test sets ("IN ()" / "NOT IN ()") in the WHERE expression of a query, an assert() fires inside the bestIndex function. The assert expects pExpr->pList to be non-NULL and the code actually checks for this to be

Re: [sqlite] segmentation violation in fulltest on Mac OS X

Am 19.01.2009 um 18:42 schrieb D. Richard Hipp: > > On Jan 19, 2009, at 3:50 AM, Jens Miltner wrote: > >> Hello, >> >> I just upgraded to sqlite 3.6.10 and keep getting a segmentation >> violation when running the full tests on Mac OS X: >> The last test

[sqlite] segmentation violation in fulltest on Mac OS X

Hello, I just upgraded to sqlite 3.6.10 and keep getting a segmentation violation when running the full tests on Mac OS X: The last test completed is consistently thread001.1.3. We're using a custom Xcode build of sqlite, so there's a chance that it has to do with our build settings.

Re: [sqlite] Database file size

n your database to see the memory usage of each table, free space, etc. Are you using a stock sqlite3 installation or did you modify/customize it through build settings? > > -Original Message- > From: Jens Miltner [mailto:[EMAIL PROTECTED] > Sent: 28 November 2008 08:38 &

Re: [sqlite] Database file size

varchar size constraints you can actually put any amount of data into a varchar(30) column) ? > > I am actually recreating the whole database (delete file and recreate) > programmatically so vacuuming has not effect. > > Cheers, > S. > > -Original Message- >

Re: [sqlite] Database file size

varchar size constraints you can actually put any amount of data into a varchar(30) column) ? > > I am actually recreating the whole database (delete file and recreate) > programmatically so vacuuming has not effect. > > Cheers, > S. > > -Original Message- >

Re: [sqlite] Database file size

Am 27.11.2008 um 09:12 schrieb Simon Bulman: > I have been playing around with SQLite to use as an alternative to > one of > our proprietary file formats used to read large amounts of data. Our > proprietary format performs very badly i.e. takes a long time to > load some > data; as expected

Re: [sqlite] Sqlite thread safety on iPhone

Am 19.11.2008 um 17:53 schrieb Paul Clarke: > My current understanding, which may well be imperfect, is as follows: > > > > 1) If you open an Sqlite database more than once (i.e. issue > multiple calls to sqlite3_open) for reading and writing then you will > get locking conflicts between the

Re: [sqlite] Terrible performance for one of our tables

Am 19.11.2008 um 13:05 schrieb D. Richard Hipp: > > On Nov 19, 2008, at 3:08 AM, Jens Miltner wrote: > >> Hi, >> >> we're seeing terrible performance problems when fetching data from >> one >> of our tables: >> The table contains roughly 1.2 Millio

[sqlite] Terrible performance for one of our tables

Hi, we're seeing terrible performance problems when fetching data from one of our tables: The table contains roughly 1.2 Million rows and a plain "SELECT COUNT(*) FROM t" query takes 8 minutes to finish. The table contains 10 fields, but the records average to about 100 Bytes of data total.

[sqlite] Ticket #3461

Hi, I just found another issue that looks like it might be related to ticket #3461: The following query returns incorrect data for the column 'column_56f32f43' - it seems to repeat the data from other rows for some rows instead of picking the correct data. SELECT

Re: [sqlite] ATTACH problem

Am 09.10.2008 um 18:21 schrieb [EMAIL PROTECTED]: > > Ok it seems last time I've posted too many errors so I'll try to ask > about this one. Maybe other are just consequences of this. I've > finally received this error also on my computer, but only in release > build. > > - windows XP,

[sqlite] all.test failures on Mac OS X

Hi, I just ran the full test suite (all.test) in our Mac OS X build and got a few failures, but I'm not quite sure what to make of them and whether they're critical failures - they don't seem to be part of the quick tests suite, so I figure they might be less important? Anyway, here's the

[sqlite] sqlite 3.6.2 tests on Mac OS X

Hi, I just merged our code base with the sqlite 3.6.2 distribution and decided to run the tests on Mac OS X (10.5.4). I had two issues: (1) make tests would not properly link the testfixture - it complains about missing Tcl symbols - I guess the libtool link phase does not know about the

Re: [sqlite] plain vanilla memory allocator (was: Moving port from 3.5.1 to 3.5.7...)

Am 28.05.2008 um 17:52 schrieb D. Richard Hipp: > > On May 28, 2008, at 11:25 AM, Jens Miltner wrote: > >> s there any work being done trying to either minimize the >> synchronization needed or provide a memory allocator that doesn't do >> all the alerting > &

Re: [sqlite] SQLite Analyzer OSX

Am 02.06.2008 um 07:17 schrieb Bruce Robertson: > I see that SQLite3 Analyzer for OSX is listed on the download page > but no > instructions are provided and when unzipped it does nothing. > > What are we supposed to do with this? Hmmh - I downloaded and unzipped the archive and launched the

Re: [sqlite] Follow-up: changed default ordering of SELECT queries in 3.5.9?

Am 30.05.2008 um 12:55 schrieb Jens Miltner: > > Am 30.05.2008 um 12:45 schrieb Jens Miltner: > >> Hi, >> >> I've got a question and I don't know exactly whether the behavior >> is standard or expected or not. >> >> Assuming the following

[sqlite] Follow-up: changed default ordering of SELECT queries in 3.5.9?

Am 30.05.2008 um 12:45 schrieb Jens Miltner: > Hi, > > I've got a question and I don't know exactly whether the behavior is > standard or expected or not. > > Assuming the following schema and data: > CREATE TABLE t1 (id, name); > INSERT INTO t1 values (1, 'John');

[sqlite] changed default ordering of SELECT queries in 3.5.9?

Hi, I've got a question and I don't know exactly whether the behavior is standard or expected or not. Assuming the following schema and data: CREATE TABLE t1 (id, name); INSERT INTO t1 values (1, 'John'); INSERT INTO t1 values (2, 'Arnold'); INSERT INTO t1 values (3, 'Zork'); We

Re: [sqlite] Moving port from 3.5.1 to 3.5.7...

I'd like to chime in that we have somewhat similar requirements: Our app is heavily threaded and we had sqlite's memory allocations show up as bottlenecks at times. This happened when the 'new' allocators that allow for high-water marks, etc. appeared first. Since we don't need any of the

Re: [sqlite] Index for Primary Key column missing?

Am 21.02.2008 um 10:30 schrieb Neville Franks: > I have created a table with a column: tag text primary key > > When I do: > sqlite> .indices tags > sqlite_autoindex_tags_1 > > I only see the one index which I assume is for the ROWID clm. No, this is the index for your 'tag' column as can be

Re: [sqlite] bit operations in select statements

Am 20.02.2008 um 11:54 schrieb Jos van den Oever: > Hi all, > > Is it possible to use logic operations on fields, in particular on > integers and on fixed sized blobs (256 bits/32 bytes). > I'd like to do queries like this: > select key where number_of_bits_set(value) = 10; I believe for this

Re: [sqlite] Optimization Question - multithread prepare ?

Am 20.02.2008 um 14:03 schrieb Mark Gilbert: > Folks. > > Our application uses SQlite on Mac OSX. It is a central data hub for > a larger infrastructure and manages data coming in from some clients, > and requests for data from other clients, using our own XML based > protocols via TCPIP. > >

Re: [sqlite] Quick question about multithread and SQLITE_BUSY/SQLITE_LOCKED in 3.5.4

Am 19.1.08 um 03:13 schrieb [EMAIL PROTECTED]: OK I figured out SQLITE_THREADSAFE=0 for the second question... And it seems the answer for the first question is yes, but if you know a simpler way please share it with us, thanks! You could use a read-write mutex to serialize access to your

Re: [sqlite] chickens and egg problem: how to set page size before creating

Am 12.5.07 um 04:26 schrieb Andrew Finkenstadt: It would appear that I need one "sqlite3* handle" in order to execute statements such as "pragma page_size=32768;", but the act of calling sqlite3_open(filename, ) creates the file, which prevents the changing of the page size, as the sqlite

Re: [sqlite] testing with single source file

Am 20.04.2007 um 09:13 schrieb Jens Miltner: Am 01.04.2007 um 20:05 schrieb Iulian Musat: [EMAIL PROTECTED] wrote: [...] In past releases of SQLite, we have made available a ZIP archive with preprocessed source files. In the future, we may change this so that instead of a ZIP archive

Re: [sqlite] testing with single source file

Am 01.04.2007 um 20:05 schrieb Iulian Musat: [EMAIL PROTECTED] wrote: [...] In past releases of SQLite, we have made available a ZIP archive with preprocessed source files. In the future, we may change this so that instead of a ZIP archive full of individual files, we ship a single

Re: [sqlite] how to run tests with amalgamized build?

Am 19.04.2007 um 15:42 schrieb [EMAIL PROTECTED]: Jens Miltner <[EMAIL PROTECTED]> wrote: How do I run the tests with an amalgamized build? You may need to adjust a pathname or two, but the following is the general idea: make sqlite3.c gcc -o testfixure -g -O3

[sqlite] warnings about potentially uninitialized variables when building 3.3.16 with -O3

When I build sqlite3 3.3.16 on Mac OS X with -O3 optimization, I get the following list of warnings about potentially uninitialized variables: gcc 3.3: CompileC build/sqlite.build/Release/sqlite_static_lib.build/Objects- normal/ppc/sqlite3.o sqlite3.c normal ppc c com.apple.compilers.gcc.

[sqlite] how to run tests with amalgamized build?

How do I run the tests with an amalgamized build? I have tried to mingle the Makefile to build libsqlite3 from sqlite3.c, but apparently, testfixture compiles some source files again and I get conflicts of symbols being multiple defined... Since we're not using precompiled binaries, I'd

[sqlite] amalgamation from source distribution

When I recreate the amalgamation from the source tarball using "make sqlite3.c" on Mac OS X, I end up with a slightly different amalgamation file. The differences are (obviously) only in the generated source files and mostly seems to be re-ordered token tables, different token values, etc.

Re: [sqlite] Query Execution speed.

Am 09.08.2006 um 05:51 schrieb Manzoor Ilahi Tamimy: hi All, I have to use SQLite for one of my project as ":memory:" db. // - Can I get a better speed if I change or omit some macros. I saw "

Re: [sqlite] random access table row

Am 08.08.2006 um 13:15 schrieb Lijia Jin: Hi, I am new to sqlite and need some help for random accessing a table row using Sqlite C API. The project I am working on supports network users to query the sqlite database from remote sites. We like to provide an interface so that user can

Re: [sqlite] temp_store=1 performance on Mac OS X vs. Windows

Am 26.07.2006 um 15:41 schrieb [EMAIL PROTECTED]: Jens Miltner <[EMAIL PROTECTED]> wrote: OTOH, our customers might also have antivirus software installed, so this still would not be a solution :( Does anybody have advice on how to make sqlite work smoothly with antivirus so

Re: [sqlite] Reading the same table from two threads

Am 26.07.2006 um 14:43 schrieb Rob Richardson: Greetings! I am starting two threads in quick succession that read the same table. Each thread calls sqlite3_open(), so they are using separate database pointers. The first thread asks for records recorded in the last 24 hours. The second

Re: [sqlite] sqlite3_interrupt() and threads

Am 26.07.2006 um 01:06 schrieb [EMAIL PROTECTED]: Michael Scharf <[EMAIL PROTECTED]> wrote: Rob, I notice in the documentation that the sqlite3_progress_handler() method is marked "experimental". Is that significant? No idea, that's a question Richard Hipp may answer.. I need to

Re: [sqlite] temp_store=1 performance on Mac OS X vs. Windows

(Probably depends on the antivirus software?) Thanks --- Jens Miltner <[EMAIL PROTECTED]> wrote: Hi, we just found that when using file-based temporary storage (compile time macro definition TEMP_STORE=1) vs. memory-based temporary storage (TEMP_STORE=2), on Mac OS X, the performanc

[sqlite] temp_store=1 performance on Mac OS X vs. Windows

Hi, we just found that when using file-based temporary storage (compile time macro definition TEMP_STORE=1) vs. memory-based temporary storage (TEMP_STORE=2), on Mac OS X, the performance almost doesn't degrade at all, whereas on Windows, we're getting a huge performance penalty when

Re: [sqlite] Major projects using SQLite

Am 14.07.2006 um 15:32 schrieb Jon García de Salazar Bilbao: Could you give examples of some major software projects using SQLite? Did you check out the list at ? May not list _all_ the major projects, but sure lists quite a few...

Re: [sqlite] Memory exhaust

Am 13.07.2006 um 14:31 schrieb Robert Wallner: Hi all, I have a software packages managing system that uses an sqlite database. It's written in python using pysqlite2 as the wrapper. The installed version of sqlite is 3.2.7. After upgrading sqlite to the 3.3.x series, every operation against

Re: [sqlite] filter and sort in CREATE VIEW or CREATE TABLE ?

Am 13.07.2006 um 14:10 schrieb Christian Smith: Inline. ditto Jens Miltner uttered: Hi all, I need to create a temporary table holding ID column values from a number of tables, so that I have a unique way to access the data for display purposes: say I have 2 related tables [snip

Re: [sqlite] INT and INTEGER are not same, behaves differently (for PRIMARY KEY) ?

Am 12.07.2006 um 11:16 schrieb RohitPatel: INT and INTEGER behaves differently (for PRIMARY KEY) !!! (SQLite 3.3.4) create table t1 ( id INTEGER PRIMARY KEY ); create table t2 ( id INT PRIMARY KEY ); insert into t1 values(NULL); insert into t1 values(NULL); insert into t2 values(NULL);

Re: [sqlite] SQLite String

Am 10.07.2006 um 10:52 schrieb Ernesto Olmos: I have an SQLite database which I work in memory (:MEMORY) and I have to get the binary text (string) of it. Is there a way to do it without writing it to disk and reading the file? Command ATTACH works good to get and write from disk or to

Re: [sqlite] Question on reading UTF-16 files using sqlite3.exe

Am 03.07.2006 um 03:49 schrieb Ché Gonzalez: From my browsing through the documentation, I have observed the ability to have UTF-16 column names in sqlite3. I would like to use the command-line: sqlite3 ae.db ".read filename.sql" where filename.sql is a UTF-16 encoded file. Is there any

Re: [sqlite] update or insert.

Am 27.06.2006 um 22:15 schrieb [EMAIL PROTECTED]: My brain does not seem to be able to function properly today. I can think of many ways to do what I want to do but none of them I like. I will describe the problem in the most symplistic form. I have two tables. The first table, has a row

Re: [sqlite] use of index in ORDER BY clause

Am 29.06.2006 um 17:17 schrieb Dennis Cote: Jens Miltner wrote: Is there any way to improve the ORDER BY performance for joined queries? From your answer that the intermediate results are sorted, I take it no index won't ever be used when using ORDER BY with a join query

Re: [sqlite] database corruption

Am 30.06.2006 um 00:01 schrieb [EMAIL PROTECTED]: I have never yet found anything useful by analyzing a corrupt database file. Generally, the only way to fix this kind of problem is come up with a reproducible test case. Unfortunately, that may prove difficult, if not impossible :( Anyway,

[sqlite] database corruption

Hi everybody, We have encountered two corrupted databases so far at customers and we have no idea how they could become corrupted (we haven't had any corruption in house so far). (Yes, I've read the "How to corrupt your database files" section, but I don't think any of the methods

Re: [sqlite] use of index in ORDER BY clause

Am 27.06.2006 um 18:06 schrieb Dennis Cote: Jens Miltner wrote: I have a schema similar to this: CREATE TABLE foo (id integer primary key, name text); CREATE TABLE bar (id integer primary key, foo_id integer, something text); CREATE INDEX bar_idx on bar(foo_id, something); When I run

[sqlite] use of index in ORDER BY clause

I have a schema similar to this: CREATE TABLE foo (id integer primary key, name text); CREATE TABLE bar (id integer primary key, foo_id integer, something text); CREATE INDEX bar_idx on bar(foo_id, something); When I run a query like SELECT foo.id AS foo_id, bar.id AS

Re: [sqlite] How to realize the ROWID in a view?

Am 13.06.2006 um 04:14 schrieb PY: Thanks for you reply. I Just want to get a sequence number in a view, that is not the ID field in the table foo. Table foo is a sample of mine. In fact, my table is not only the id and x field. And the x field could be duplicate in the table foo.

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

Am 24.04.2006 um 14:51 schrieb COS: Hi Jens, - Original Message - From: "Jens Miltner" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, April 24, 2006 5:30 AM Subject: Re: [sqlite] Using sqlite3_open or sqlite3_open16? Am 22.04.2006 um 15:4

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

Am 22.04.2006 um 15:48 schrieb COS: Thanks for the info. I did have found in the manual that UTF16 is converted to UTF8 on Windows environments. But one little question: How would one know if the filename is in UTF8 or UTF16? You see, my little application is installed in PC's all around

Re: [sqlite] Re: How to improve performance of SQL DELETE

Am 19.04.2006 um 14:08 schrieb Igor Tandetnik: Kai Wu <[EMAIL PROTECTED]> wrote: 2. The table schema is simple TABLE MID(id VARCHAR(8),scts VARCHAR(12),daddr VARCHAR(20)) the scenario is it needs first select the "id" by select id from MID where scts= .. AND daddr=... after

Re: [sqlite] SQLite3 command line utility crashes on MacOS X

Am 15.04.2006 um 00:50 schrieb Thomas Chust: On Fri, 14 Apr 2006, Will Leshner wrote: On 4/14/06, Thomas Chust <[EMAIL PROTECTED]> wrote: I just downloaded the 3.3.5 distribution tarball and confirmed that the problem occurs with a binary built from that codebase as well. I assume you

Re: [sqlite] How to convert a sqlite table in a sqlite db into a text file?

Am 17.4.06 um 10:58 schrieb 杰 张: Hi,all I just want to implement to download a sqlite table in a sqlite db from IE browser , but I must first convert sqlite format into text format for reading data information of the table. I want to finish the conversion automatically through

Re: [sqlite] Converting ver 2 to ver 3

Am 15.4.06 um 02:36 schrieb Paul Nash: I have taken the plunge and am converting from ver 2.8.16 to ver 3. I used the .DUMP method but found a problem. My char/text fields containg numbers were output as pure numbers without the quotes, so that on input to ver 3 they were stored as

Re: [sqlite] How to verify sqlite file?

Am 14.4.06 um 04:30 schrieb Charlie Li: Is there any way to verify a file is sqlite3 file? When I tried to open a non-sqlite file by sqlite_open(), the system crash. I checked the source codes and found no file type checking. The final trace is toward to page.c file. How to revise

Re: [sqlite] Older sources

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

Re: [sqlite] import

Am 19.2.06 um 15:06 schrieb Randall: Hi, Sorry for the basic queries here... If I ".output" with .mode "tabs" , "lines" etc, the resulting text file or csv file cannot be ".imported" by import, as the EOL is not read? Can I fix this easily? Thanks, Randall You didn't tell what you want

Re: [sqlite] Executing SQL from file

Am 01.02.2006 um 17:10 schrieb deBooza (sent by Nabble.com): Hi I'm using sqlite in a c++ program, using functions sqlite3_open, sqlite3_exec, sqlite3_close etc. I am trying to import a lot of data, probably around 100,000 rows+. I have found it quicker if I format the data into SQL

[sqlite] Ticket #1654

Regarding the checkin comment from the fix for ticket 1654: Always register BINARY collating sequences for UTF-16BE and UTF-16LE both. Formerly we were only registering the native byte order by default. Ticket #1654 . Note: There may still be problems with collating sequence synthesis. (By

Re: [sqlite] Multithreading Question

Am 21.10.2005 um 11:58 schrieb Michael J. Sviridov: Using sqlite 3.2.7 in a multi-threaded C++ application: I've got two thread's (with unique db handles), each thread does the following: BEGIN EXCLUSIVE TRANSACTION; (60,000 INSERT OR REPLACE statements into the same table) COMMIT

Re: [sqlite] Please, please do _not_ remove this feature from SQLite...

Am 12.10.2005 um 12:12 schrieb pilot pirx: P.S. On somewhat related note: since sqlite is written in C - why it does not expose some basic functions from the standard C library (log, exp, sqrt, sin), at least optionally? Understandably, the idea is to keep it 'lite'. But, may be, an

Re: [sqlite] Infinite loop on sqlite3_close()

Am 10.10.2005 um 16:53 schrieb Preston Zaugg: While running some performance tests i ran into a condition where sqlite3_close got caught in an infinite loop. The loop it gets caught in is on line main.c 194: while( pPrev && pPrev->pNext!=db ){ pPrev = pPrev->pNext; } This did not

Re: [sqlite] Transactions

Am 05.10.2005 um 13:17 schrieb Christian Smith: On Tue, 4 Oct 2005, Martin Engelschalk wrote: Hello Christian, thank you, but synchronous is already off. What i aim to avoid is writing the rollback - journal. In order to rollback, some additional writing to disk is surely unaviodable.

  1   2   >