[sqlite] Does vacuum command improves the sqlite3 write/store transactions

al statements. But case studies are still useful. -- D. Richard Hipp drh at sqlite.org

[sqlite] Does vacuum command improves the sqlite3 write/store transactions

On 5/4/15, Richard Hipp wrote: > On 5/4/15, Mayank Kumar (mayankum) wrote: >> Hi All >> I am thinking about measuring the performance of sqlite3 write >> transactions >> after lot of delete transactions have been performance but vacuum has not >> been performe

[sqlite] howto shrink files in wal mode

On 5/5/15, Zaumseil Ren? wrote: > > Is there a way to shrink the file when it is still open in WAL mode? > Run "PRAGMA wal_checkpoint=TRUNCATE;" in SQLite 3.8.8.2 or later. -- D. Richard Hipp drh at sqlite.org

[sqlite] SQLite queries

On 5/6/15, Amit Golhani wrote: > -client server architecture SQLite is an embedded SQL database. Client/Server is a completely different thing intended to solve a completely different problem. -- D. Richard Hipp drh at sqlite.org

[sqlite] saving :memory:database to disk

ackup" command in the command-line shell provides you with a sample implementation. -- D. Richard Hipp drh at sqlite.org

[sqlite] Testing problem

en at the starting of each file but i > dont find them useful. > can anyone help me regarding this? > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org

[sqlite] Testing problem

On 5/8/15, Sairam Gaddam wrote: > Is sqllogictest a program which can be downloaded and installed? https://www.sqlite.org/sqllogictest/doc/trunk/about.wiki > > On Fri, May 8, 2015 at 5:21 PM, Richard Hipp wrote: > >> On 5/8/15, Sairam Gaddam wrote: >> > I have

[sqlite] Multiple Prepared Statements

case, actually. -- D. Richard Hipp drh at sqlite.org

[sqlite] Please confirm what I THINK I know about blobs

depends on the application. If the field always holds exactly the same thing (ex: a JPEG) then the metadata is not really needed. On the other hand, I have added a separate "mimetype" column to accompany BLOB fields in cases where the BLOB might be different things. -- D. Richard Hipp drh at sqlite.org

[sqlite] TCL tests

On 5/12/15, Sairam Gaddam wrote: > Can anyone kindly help me how to compile and run TCL test scripts ? > All the test scripts are .test files and I need help in executing them. Unix: ./configure; make test Windows: nmake /f makefile.msc test -- D. Richard Hipp drh at sqlite.org

[sqlite] TCL tests

On 5/12/15, Sairam Gaddam wrote: > On Tue, May 12, 2015 at 4:36 PM, Richard Hipp wrote: > >> >> Unix: ./configure; make test >> >> Windows: nmake /f makefile.msc test >> > > I installed both tcl and sqlite but i need help to run .test files which >

[sqlite] TCL tests

On 5/12/15, Sairam Gaddam wrote: > On Tue, May 12, 2015 at 5:05 PM, Richard Hipp wrote: >> >> >> Did you try the commands provided above? >> >> >> yeah I tried those commands and installed both tcl and sqlite but i need > help in executing the .t

[sqlite] emptying tables

at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org

[sqlite] emptying tables

On 5/12/15, Zaumseil Ren? wrote: >>I think that operation will go MUCH faster if you (1) turn off >>auto_vacuum, (2) use journal_mode=DELETE, and (3) put all of the >>DELETE operations inside a single transaction. >> >>D. Richard Hipp > > I have used aut

[sqlite] sqlite3 .dump

int error. > > Wouldn't it make more sense for the CREATE commands to include IF NOT > EXISTS? > No. The script is suppose to recreate a database from scratch. The tables should not already exist. If they do, then something is wrong, and an error is appropriate. -- D. Richard Hipp drh at sqlite.org

[sqlite] sqlite3: sqlite3_step() return SQLITE_FULL error.

s due to no enough cache space for database to prepare the query? > > Please help me in resolving this problem. Thanks. > > Thanks and Regards > Deepak > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org &

[sqlite] sqlite3: sqlite3_step() return SQLITE_FULL error.

o run PRAGMA temp_store_directory and point it to the same directory on multiple processes. It is perfectly safe to have temp_store_directory and the main database directory be the same. -- D. Richard Hipp drh at sqlite.org

[sqlite] Tests regarding custom build of SQLite

my modified file. So can anyone tell why it replaces > with original file and what to do in order to test my custom build. > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org

[sqlite] Patch for build on ppc64le systems

n you please check to see if that clears your problem? -- D. Richard Hipp drh at sqlite.org

[sqlite] Regarding SQLITE_PRIVATE

at linked against them. Furthermore, those functions have not been tested for arbitrary inputs, but only inputs that they could have received when called from inside of SQLite. Hence, you should never, never use an SQLITE_PRIVATE function in your program. -- D. Richard Hipp drh at sqlite.org

[sqlite] Docs suggestion - Attach

ark, Wallingford, Oxfordshire, OX10 8BA, United Kingdom > Registered in England No. 02562099 > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

10x or 100x the cost (45810 or 458100) when not using an index, and see if that helps. -- D. Richard Hipp drh at sqlite.org

[sqlite] Can I define collation-aware SQL functions?

. Which is good, because they have changed once or twice for performance reasons and had they been exposed, those changes would have caused problems. -- D. Richard Hipp drh at sqlite.org

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

ght before you run the problem query. -- D. Richard Hipp drh at sqlite.org

[sqlite] REGEXP pcre DLL for Windows

the regexp.c matcher is guaranteed to run in constant time (relative to the size of the string being scanned) whereas PCREs can run in exponential time for certain pathological cases. -- D. Richard Hipp drh at sqlite.org

[sqlite] cannot read sqlite 3.x DB-File with SQLIte Browser 3.6 (can't either with 2.0b1)

cess your database file. Try that first, and if that doesn't work, send a follow-up message. -- D. Richard Hipp drh at sqlite.org

[sqlite] select * where is/like ?

commands that you used to generate a corrupt database so that we can look into the problem? -- D. Richard Hipp drh at sqlite.org

[sqlite] index broken by insert

On 5/19/15, Roman Fleysher wrote: > Yes, I can provide full schema and data set. As far as I remember this > mailing list does not accept attachments. Would that be OK to send in body > of email? It is not that big. > Yes, please. Send in the body of the email. -- D. Rich

[sqlite] index broken by insert

T INTO "demographics" VALUES('0021','1980-01-03','35','15','Female'); > INSERT INTO "demographics" VALUES('0022','1979-01-05','36','11','Male'); > INSERT INTO "demographics" VALUES('0023','1990-10-28','24','16','Male'); > INSERT INTO "demographics" VALUES('0024','1983-10-13','31','14','Male'); > INSERT INTO "demographics" VALUES('0025','1991-07-10','23','14','Male'); > INSERT INTO "demographics" VALUES('0026','1991-04-28','24','18','Male'); > INSERT INTO "demographics" VALUES('0027','1988-07-05','26','18.5','Male'); > INSERT INTO "demographics" VALUES('0028','1987-04-22','28','21','Male'); > INSERT INTO "demographics" VALUES('0029','1988-08-04','26','18','Male'); > INSERT INTO "demographics" VALUES('0030','1967-12-13','47','16','Male'); > INSERT INTO "demographics" VALUES('0031','1983-11-05','31','16','Male'); > > -- Offending statement: > > PRAGMA foreign_keys=ON; > INSERT OR IGNORE INTO subject(subjectID, dob, gender) >SELECT subjectID, dob, gender FROM demographics; > PRAGMA integrity_check; > > -- Roman > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org

[sqlite] index broken by insert

veID, examID) VALUES > (NEW.subjectID, 'demographicExam', 'time1', NEW.subjectID); > END; > -- D. Richard Hipp drh at sqlite.org

[sqlite] index broken by insert

lite.org/src/fdiff?sbs=1=8775967=6aee8a0=30 to any recent SQLite amalgamation source file in order to clear the problem. -- D. Richard Hipp drh at sqlite.org

[sqlite] Creating an index seems to break table logic

es are needed to address the problem seen here we will add those fixes to the 3.8.10.2 release. -- D. Richard Hipp drh at sqlite.org

[sqlite] Creating an index seems to break table logic

The trouble ticket is here: https://www.sqlite.org/src/tktview/f2ad7de056ab1dc9200d5c364952ac29d7fb035f On 5/20/15, Richard Hipp wrote: > On 5/19/15, Adam Podstawczy?ski wrote: >> sqlite> select * from list_of_numbers where astart < 7169319380 and aend >> > >> 71

[sqlite] Creating an index seems to break table logic

the TEXT in an INT column) is *not* currently detected by PRAGMA integrity_check. That is something we might address in the future... -- D. Richard Hipp drh at sqlite.org

[sqlite] AUTOINC vs. UUIDs

On 5/20/15, Scott Doctor wrote: > > Given a field that is a primary key with auto-increment, does sqlite > store an integer that gets incremented, or does it look at the last row > and increment its value? https://www.sqlite.org/autoinc.html -- D. Richard Hipp drh at sqlite.org

[sqlite] AUTOINC vs. UUIDs

that said, there exist scenarios where using a random number as an ID comes closer to guaranteeing that the ID is unique than any other technique you are likely to invent. -- D. Richard Hipp drh at sqlite.org

Re: [sqlite] ambiguous temporary trigger metadata

shift at unpredictable times. In other words: don't do that. We have updated the documentation at ( http://www.sqlite.org/draft/lang_createtrigger.html#temptrig) to make this clear. Who are your users that you allow them arbitrary control over the DDL and yet you feel the need to pro

Re: [sqlite] ORDER BY DESC after GROUP BY not using INDEX - intentionally?

t; - > 0 0 0 SCAN TABLE test3 USING COVERING INDEX > test3_idx > > > Regards > Fabian > __**_____ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mail

Re: [sqlite] Force float (instead of double) for storage

as 0x123456789ABCDEF0, it is instead > stored as 0x9ABCDEF012345678. Four-byte floating point values are stored > correctly. > Recompile SQLite with the SQLITE_MIXED_ENDIAN_64BIT_FLOAT compile-time option and all will be well. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Help with a Temp view issue

>the main database. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sql

Re: [sqlite] Help with a Temp view issue

ment? Maybe you can provide more details about your problem? > > Any way to notify the temp views to refetch the pages or always refetch > pages before executing a query? > > My VFS is performing a multi-master replication without the knowledge of > SQLite layer. >

Re: [sqlite] Help with a Temp view issue

ur VFS is not returning the correct result for the read from offset=24, length=16? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

ix of those rows before you invoke sqlite3_reset() or sqlite3_finalize()? In that case, no sqlite3_step() call would ever return SQLITE_DONE and so the profile callback would never be invoked. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing l

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

statements that we probably need to be profiling. > We have your request to enhance the sqlite3_profile() mechanism to invoke the profile callback on an early sqlite3_reset(). Unfortunately, there are several higher-priority enhancement requests in queue in front of this, so it might be a while...

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

d the overall program execution time dropped from about 20 minutes to > under 2. Any thoughts on what might be happening here? > > Thanks again for all your help. > > Regards, > > Mike > > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto: > sql

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

definitely explain a lot. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Trigger with WHEN clause error

On Fri, Oct 25, 2013 at 2:10 PM, Louis Jean-Richard < l_jean_rich...@bluewin.ch> wrote: > CREATE TRIGGER atable_updated AFTER UPDATE ON atable > FOR EACH ROW WHEN last_update != date('now') > I think you meant to say "old.last_update" instead of just "last_up

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

ugh to make the difference. Send us the exact text of the index (both the program version and the Firefox version) and its associated table and maybe also the query, then we can tell. Exact text: No changes please. -- D. Richard Hipp d...@sqlite.org ___ sq

Re: [sqlite] possible join bug/regression with sqlite-3.8.1

me direct email to the address shown on my signature line below? Tnx. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQlite Memory Leakage with 65536 Page Size

y executes. > Doubtful. Probably the excess memory is just be used for the page cache. Did you try running "PRAGMA shrink_memory"? http://www.sqlite.org/pragma.html#pragma_shrink_memory - that will force the cache to flush. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] incredibly minor documentation bug

gt; It's off by one: X is actually -9223372036854775808. -9223372036854775807 > is the lowest number *with* a positive 64-bit two complement. > Fixed at http://www.sqlite.org/docsrc/info/9e1d78e903 - the change will be in the next release. Tnx. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] SQlite Memory Leakage with 65536 Page Size

mory" it goes down to 65Mb but doesnt go > below that. > > It might also be that your memory allocator is holding onto freed memory rather than releasing it back to the OS. Have you tried running with valgrind to see it shows any leaks? -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] SQlite Memory Leakage with 65536 Page Size

turns that space to the operating system or keeps it around to satisfy future malloc() calls is a detail of the implementation of free(). SQLite has no control over that. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

rds initially populated. After manually dropping and recreating the > index (as described above) statement execution time dropped to about 1 ms. > > > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto: > sqlite-users-boun...@sqlite.org] On Behalf

Re: [sqlite] SQlite Memory Leakage with 65536 Page Size

t; > Sir, anyway to be sure of that ? > > In the command-line shell, do ".stats on". Then run your commands. Monitor the "Memory Used:" and "Number of Outstanding Allocations:" answers. What do they tell you? -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] SQlite Memory Leakage with 65536 Page Size

"PRAGMA shrink_memory", SQLite has reduced its memory holdings to 152KB in 79 separate memory allocations.If your OS says the process is using more memory than that, then the extra memory must be used by the application or else be reusable freespace still held by your malloc() implemen

Re: [sqlite] SQlite Memory Leakage with 65536 Page Size

On Mon, Oct 28, 2013 at 3:52 PM, Raheel Gupta <raheel...@gmail.com> wrote: > Sir, is there any way to not allow malloc to hold memory ? I mean shouldnt > free(), be freeing the memory ? > You'lll need to speak with the developers of your libc implementation about that. -- D.

Re: [sqlite] possible join bug/regression with sqlite-3.8.1

elease. The trunk is stable and usable if anybody really needs a fix right away. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database gets locked for other processes

; > Martin > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Android - Occasional Error when closing a database

nts' if anyone wants more explanation or code snippets. > > Thanks in advance. > > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] store image file as blob

te-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] collation for german "Umlaute"

hope for Your help! > > Ulrich > > > -- > Ulrich Goebel > Paracelsusstr. 120, 53177 Bonn > __**_ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] store image file as blob

something like this: CREATE TABLE bigThings(id INTEGER PRIMARY KEY, stuff BLOB); Then store all of your metadata in separate tables and reference the big BLOBs using the short integer ID. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing li

Re: [sqlite] Unused partial index

d: Add an "ORDER BY flags" to the query above. > 0|0|0|SCAN TABLE a > sqlite> EXPLAIN QUERY PLAN SELECT * FROM "a" INDEXED BY "b" WHERE "flags" & > 16; > Error: no query solution > ___ > sqlite-users mailing list > sqlite-users@sqlite.org

Re: [sqlite] Multi thread access for encrypted database bug

supported by the 3rd-party authors, or are unsupported. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Enable WAL on a QNX system

r is getting a SHARED lock, while later process 3 - > writer is trying to get an EXCLUSIVE lock. > > Any suggestion would be appreciated. > > Regards, > Sandu > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.or

Re: [sqlite] Syntax of EXPLAIN QUERY PLAN "detail" column

sqlite.org/src/artifact/f18400f121fd?ln=3049 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite database upgradation

ing the latest SQLite, 3.8.1? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Handling Pictures

t is entirely appropriate to store content files directly in the database, rather than as separate files on disk. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite db getting corrupt on power outage scenarios

o set WAL mode if you have not done so already. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug Report - Analyzer app

lready fixed, or if there is something I'm doing wrong, kindly >> point me in the right direction. >> Thank you >> >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Handling move/rename of an SQLite database file

written, then killing the writer process or turning the power off, can corrupt the database file since it leave the associated journal file with a different name. See http://www.sqlite.org/howtocorrupt.html#unlink for additional information. -- D. Richard

Re: [sqlite] PRAGMA cache_size when copying data from two DBs

two connection's PRAGMA cache_size are different? > It shouldn't make any difference. Are you having problems? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Handling move/rename of an SQLite database file

> _open() and _close() ? > Rollback journal files might be closed and reopened. But the main database file is opened once and held open until sqlite3_close() (or DETACH if the file was originally opened using ATTACH). -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] sqlite db getting corrupt on power outage scenarios

db was originally written by 3.4.0 and > when we upgraded our software the db was written to by 3.7.7.1. Do you > think this scenario could also cause a db corruption. > > Unlikely. That bug was only present in version 3.7.0 and was fixed in 3.7.0.1. -- D

Re: [sqlite] sqlite db getting corrupt on power outage scenarios

fore fsync() to actually occur after one or more writes that were issued after the fsync(). If the cause of corruption is something else, then WAL mode might not help as much. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-user

Re: [sqlite] How to detect "database disk image malformed" in advance?

ror after querying a database file that is unchanged since a successful PRAGMA integrity_check. If you have a contrary example, please send me a copy of the database file via private email. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqli

Re: [sqlite] Row Level Locking as in InnoDB

same in a serverless system like SQLite is rather more difficult and (as far as I can determine) requires debilitating run-time overhead. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] Closing database connection after each transaction?

few processes are using a single DB. > My operating system is Linux and the SQLite 3.7.9 database files are > stored in NAND Flash. > > Regards, > > Carsten > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http:/

Re: [sqlite] Enable WAL on a QNX system (Richard Hipp)

re not present. > There can only be a single connection open on the database file when you change it to WAL mode. Did you try to change to WAL mode while holding multiple connections open? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users maili

Re: [sqlite] Enable WAL on a QNX system (Richard Hipp)

On Tue, Nov 12, 2013 at 8:12 AM, Richard Hipp <d...@sqlite.org> wrote: > > > > On Mon, Nov 11, 2013 at 12:33 PM, Sandu Buraga <sandu.bur...@gmail.com>wrote: > >> Hi, >> >> I took your advice and now I am setting only once the journal_mode=WAL, >>

Re: [sqlite] Internal workings of reading/writing -journal files

does it open it once for writing at the beginning of the > transaction, and open it again for reading at the end of the transaction? > ___ > POSIX functions (read(), write(), etc) are used on Mac. It opens and closes the rollback journal file on

Re: [sqlite] Is access to extension objects synchronized inside sqlite3.dll in serialized mode?

'll need to serialize access to your private data structures yourself. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is access to extension objects synchronized inside sqlite3.dll in serialized mode?

eed to perform any additional serialization > because it is "guarded" by the serialization of the connection. Is this > correct? > Correct. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

Re: [sqlite] How to fix sqlite issue

sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation addition request

s are between all the > alternatives > > OR ROLLBACK/ABORT/REPLACE/FAIL/IGNORE > > are, including which one is the default ? Thanks. > http://www.sqlite.org/lang_conflict.html ABORT is always the default. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Enable WAL on a QNX system

On Thu, Nov 14, 2013 at 4:42 AM, Sandu Buraga <sandu.bur...@gmail.com>wrote: > I am starting to believe that WAL is not a viable choice on a QNX system. > All Blackberry phones and tables use it. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Simple string question

your statement like this: INSERT INTO my_table(col1) VALUES(?1); Then run: sqlite3_bind_text(pStmt, 1, zYourString, -1, SQLITE_TRANSIENT); Then run your statement: sqlite3_step(pStmt); Further information: http://www.sqlite.org/c3ref/bind_blob.html

Re: [sqlite] Intended use case for 'without rowid'?

T ROWID table can get by with only one. However, the second lookup of a rowid table is on a B*-tree table with integer keys and is therefore very fast, so the total speedup is only about 30%, not 50% as you might expect. In summary: Reduction in CPU time: 5% to 30% Reduction in disk u

Re: [sqlite] Index performance

etter performance as the code evolves. Note that SQLite cannot know that there is an average of 50 or more occurrences of each distinct value in the index unless you have run ANALYZE. Hence, the skip-scan algorithm will only be used after ANALYZE has been run. -- D. Richard Hipp d...@sqlite.or

Re: [sqlite] help writing DELETE with JOIN

playlist WHERE EXISTS(SELECT 1 FROM songlist WHERE playlist.playlistID=songlist.playlistID AND songlist.stale); -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] help writing DELETE with JOIN

uot; to the WHERE clause. DELETE FROM playlist WHERE EXISTS(SELECT 1 FROM songlist WHERE playlist.playlistID=songlist.playlistID AND songlist.stale) AND playlistId=$x; -- D. Richard Hipp d...@sqlite.org ___ sqlite-users maili

Re: [sqlite] help writing DELETE with JOIN

I choose the constant 1. > > sorry for my newb-ness, still learning! but fun! > > DELETE FROM playlist > WHERE EXISTS(SELECT 1 FROM songlist > WHERE playlist.playlistID=songlist.playlistID >AND playlist.playlistID=57 >

Re: [sqlite] Intended use case for 'without rowid'?

.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Intended use case for 'without rowid'?

ious schema, but that seems unlikely in practice. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Intended use case for 'without rowid'?

id TEXT); That table has a rowid, but it is completely inaccessible to the application. Does your function return TRUE or FALSE? My point: I think any application that depends on there being a column named "rowid" that is the key to the table is already broken. WITHOUT ROWID does not add

Re: [sqlite] More website typos

Thanks for the documentation bug reports. All will be fixed soon. -- D. Richard Hipp Sent from phone - Excuse brevity On Nov 18, 2013 9:16 AM, "Philip Newton" <philip.new...@pobox.com> wrote: > http://www.sqlite.org/howtocorrupt.html in section "2.2.1 Multiple &

Re: [sqlite] More website typos

s a long while to realize the that real change was the "d" to a "t" in "build". It warms my heart to know that even proof-readers sometimes make typos. :-) -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why must WITHOUT ROWID tables have PRIMARY KEYs?

suggested above) that is simply not exposed to the application layer. Yes, that is theoretically possible. But SQLite does not do that and I do not see any reason to add the capability. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-u

Re: [sqlite] Performance regression 3.7.13 -> 3.8.1

|87|268|0||00| > 249|NotExists|7|268|87||00| > 250|Integer|1|88|0||00| > 251|Column|0|0|89||00| > 252|Column|0|1|90||00| > 253|Column|0|2|91||00| > 254|Column|0|3|92||00| > 255|Column|0|4|93||00| > 256|Column|0|5|94||00| > 257|RealAffinity|94|0|0||00| > 258|Column|0|6|

<    1   2   3   4   5   6   7   8   9   10   >