Re: [sqlite] Example of implementing undo/redo using sqlite3?

sting work: https://github.com/dustin/kvtest/blob/master/sqlite-base.cc#L160 -- dustin sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Will SQLite supports UnQL?

ost will appear to occur considerably sooner than anything happening at "the same time" on the west coast. -- dustin sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] backup api database is locked?

finish. I seem to have misunderstood. Is there a recommendation for something I can do to ensure my backups can actually finish (other than just retry continuously and indefinitely)? -- dustin sallings ___ sqlite-users mailing list sqlite-users@

Re: [sqlite] WAL for production use

On Feb 2, 2011, at 8:14, Duquette, William H (318K) wrote: > In SQLite 3.7.4/3.7.5, does WAL seem to be stable enough for production use? I'm using it very, very heavily right now. -- dustin sallings ___ sqlite-users mailing lis

Re: [sqlite] How can we put check constraints on a column

wise? I did a google search for "sql check constraint'' and pasted in the first results and it worked as expected. -- dustin sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL on a separate filesystem?

e reduced if a WAL existed on a different partition -- whether there are any assumptions WAL makes that would be invalid across a filesystem boundary. -- dustin sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL on a separate filesystem?

g it. This is more about how the file is used. If I could convince SQLite to open the WAL in a location other than in the same location as the main db, would this cause reliability problems? -- dustin sallings ___ sqlite-users mailin

[sqlite] WAL on a separate filesystem?

Is it possible without violating any assumptions that would lead to reliability problems to have a DB's WAL exist on a separate filesystem? -- dustin sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:808

Re: [sqlite] Using WAL?

handles this using Read Committed; Can the same thing be > achieved using SQLite for an in-memory database? Which oracle in-memory database are you referring to? -- dustin sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Using WAL?

d mutate state? I imagine this would be the shortest path to success and definitely the easiest to prove correct. -- dustin sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using WAL?

application. I don't think this makes much sense. Where would the log live? The answer to all of your questions are in the docs here: http://sqlite.org/pragma.html#pragma_journal_mode -- dustin sallings ___ sqlite-u

Re: [sqlite] Just compiled SQLite in Visual Studio

(and a few other things that are really convenient, but have got in my way in attempts to port c code to c++). -- dustin sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] When is corruption acceptable?

; command from command line utility. Thank you for the suggestion. This looks like it's going to be helpful to get a lot of the data out. -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] When is corruption acceptable?

1. When is it acceptable for sqlite to leave a corrupt database that can't be used? 2. Is there any way to recover the data that didn't get corrupt (which should be lots)? -- Dustin Sallings ___ sqlite-users mailing list sql

Re: [sqlite] programmatic way of determining fragmentation?

some of your > SELECT and maybe evaluate it on per record basis. If it's more like some > threshold value, ok, peform VACUUM This sounds like a *really* awesome idea. I know exactly what operations I'm doing that *shouldn't* generally seek and I can keep some sta

Re: [sqlite] When does "begin transaction" fail?

On Oct 22, 2010, at 14:56, Simon Slavin wrote: > Are you asking for circumstances where a 'BEGIN' could issue an error message > ? This one. When might "begin" return an error code and fail to begin a transac

[sqlite] When does "begin transaction" fail?

le of times with my software on someone else's machine), but I'd like to know what would make it happen as I start getting a bit defensive in the area. -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.o

Re: [sqlite] programmatic way of determining fragmentation?

t understand the file layout all that well right now, so I don't completely understand how the index is traversed. -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] programmatic way of determining fragmentation?

ree hours. Select * from a reconstructed table (insert into select from) in a new database took 57 seconds. -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] programmatic way of determining fragmentation?

your code can be quick and crude. I've seen this, and that's my last resort. I figured I'd ask because it feels like something someone would have done other than sqlite3_analyzer. Thanks. -- Dustin Sallings ___ sqlite-u

Re: [sqlite] programmatic way of determining fragmentation?

nd you could consider > PRAGMA auto_vacuum = 0 | NONE | 1 | FULL | 2 | INCREMENTAL; The problem with auto_vacuum is that it's documented to make the problem worse. -- Dustin Sallings ___ sqlite-users mailing list sqlite-users

[sqlite] programmatic way of determining fragmentation?

27;s been done before. -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Many many tables... performance wise?

d be helpful to have some more detailed pointers as to why the intuition is wrong here. -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] When do I need SQLITE_THREADSAFE?

ave I miss something? Look for bCoreMutex and bFullMutex. bFullMutex is in use when SQLITE_THREADSAFE=1 and bCoreMutex is in use for 1 or 2. -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-

Re: [sqlite] When do I need SQLITE_THREADSAFE?

if =2 was for concurrent access to a single database only. It sounds like the answer is ``just do it anyway.'' Thanks. -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] When do I need SQLITE_THREADSAFE?

ation. Specifically, is there any global state that will conflict? -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to use raise() in a trigger?

n begin select raise(rollback) when exists (select * from ); end -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] processing a sql script from the C API?

On Sep 27, 2010, at 23:20, Richard Hipp wrote: > See http://www.sqlite.org/c3ref/complete.html Thank you very much. That was exactly what I need. Sorry to have overlooked that. -- Dustin Sallings ___ sqlite-users mailing list sql

[sqlite] processing a sql script from the C API?

orary triggers (which naturally contain ';' characters) in one of these scripts and that sort of fell apart. Is there any way to run a sql script, or perhaps hand sqlite a chunk of text and ask ``is this a query yet?'' -- Dustin Sallings _

Re: [sqlite] usleep bug?

ery > platform SQLite is expected to run on. I think that makes sense. It also means you don't need a comment describing that it's intended to sleep for exactly ten seconds. :) -- Dustin Sallings ___ sqlite-users mailing li

[sqlite] usleep bug?

n all platforms, but it could very well reduce to a quick function that just sets errno if usleep fails. -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ATTACH and WAL

with the older file-based journal types. Is it expected that I would only have one wal and shm file for this configuration? -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] SQLite file Validation

wrong, you'll never get to a solution, regardless of how quick it appears. :) -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite file Validation

the difference between code and data "magically" in a new layer). -- Dustin Sallings ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] dealing with IO errors

running and try my best to keep my on-disk data sane? (a variation of this was also posted to SO and may have some useful commentary around it: <http://stackoverflow.com/questions/2842752/how-should-i-deal-with-sqlite-errors> ) -- Dustin Sallings _