Re: [sqlite] capturing and testing a hot journal

and hardware don't lie to you, your change is safe. But there are lies of varying magnitude at work. So if it is really important, wait a few minutes until the OS has surely flushed all its buffers and the HDDs did the same. Michael -- Michael Schlenker Software Architect CONTACT Software GmbH

[sqlite] Registering Application IDs?

://www.sqlite.org/src/artifact?ci=trunkfilename=magic.txt) (signed 32-bit integer) and in the PRAGMA documentation (unsigned 32-bit integer). Is this intended? Thanks, Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3

Re: [sqlite] executing queries on normalized database

for your simple structures, but gets pretty ugly if things are more complex. Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m

[sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

how WAL works first. Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

Am 10.01.2013 15:31, schrieb Dan Kennedy: On 01/10/2013 07:11 PM, Michael Schlenker wrote: Hi everyone, [snip] I'm pretty sure there was no DELETE for the missing object, but want to verify what happend by comparing the WAL files. Now i checked the wal with the tool/showwal.c program from

Re: [sqlite] VC++ and SQLite

/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421

Re: [sqlite] Trigger, syntax question

you feel is in violation of the diagram? I cant find anything about SELECT CASE ... END; in the diagram and i dont understand, how it works. Have a look at: http://sqlite.org/lang_expr.html Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421

Re: [sqlite] What does The use of the amalgamation is recommended for all applications. mean, precisely?

to support contracts, you do not want to be forced to depend on those. Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m

Re: [sqlite] feed endless data into sqlite, thru a shell script

://expect.cvs.sourceforge.net/viewvc/expect/expect/example/unbuffer?revision=5.34view=markup Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail

Re: [sqlite] compile warning in tclsql 3.7.5

being set as 'long' sqlite3_int64 ended up being long long int I assumed those 2 types are the same in 64 bit - but apparently not This define looks suspicious. -DTCL_WIDE_INT_IS_LONG=1 Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80

Re: [sqlite] oracle compatibility mode

some ORM like sqlalchemy). Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen

Re: [sqlite] Bug: Umlaut in database filename

the sqlite_open16() call which might be easier on Windows. If you use some kind of wrapper other than the C code, file a bug there. You probably passed some ANSI/OEM codepage filename to sqlite_open() which gets messed up. Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel

Re: [sqlite] cast from pointer to integer of different size

jagjeet singh nain schrieb: Hi, I was compiling sqlite on 64 bit OS and i got following warning message. Its probably an issue of: http://www.sqlite.org/faq.html#q17 Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3

[sqlite] NOT NULL asymetry between CREATE TABLE and ALTER TABLE, why?

with default value NULL Is there a reason for this asymetric behaviour of ALTER TABLE and CREATE TABLE? Its a bit dated version, but current version has doc'ed the limitation that for ALTER TABLE still. Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49

Re: [sqlite] Escaping binary data

need it, you can create blob literals easily yourself, its just the hex string in quotes with a x or X prefixed. http://sqlite.org/lang_expr.html Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49

Re: [sqlite] What languages can include SQLite statically?

/starpacks you can wrap all those things up into single file executables on many platforms easily too. But Python, Lua etc. have useful SQLite bindings too, so pick whatever language you feel comfortable with, most have a working SQLite binding. Michael -- Michael Schlenker Software Architect CONTACT

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

you could use their build of SQLite and download it via the teacup command. But otherwis this looks weird. Check the downloaded .so with ldd if it references any Tcl Library (like libtcl8.4 or something). It should not, if it had been compiled with STUBS enabled. Michael -- Michael Schlenker

Re: [sqlite] Protect against SQL injection inside of the database?

the substitution (or better said convert things to prepared statements and bind values correctly) and not Tcl. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http

Re: [sqlite] Protect against SQL injection inside of the database?

statement myself. Or, do you know of a Tcl command to make strings SQL safe? (Sorry for making this into a Tcl question now..) Its the wrong way. See the mess you get with mysql_real_escape() in PHP and you know its wrong. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH

[sqlite] Older versions of sqlite3 analyzer?

Hi all, is there any pre-built windows sqlite3_analyzer binary for older SQLite Versions (3.5.9 in particular)? The download page only shows the 3.6.1 compatible one. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3

Re: [sqlite] How sqlite will store the data?

? You usually don't. Simply use ORDER BY when retrieving your data, it was made for that. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de

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

hard to write a different output plugin for that Tcl code to write BNFs instead of the syntax diagrams, the info must be in the input data for that anyway. So if you want BNFs back, plugin a different backend to that code. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH

Re: [sqlite] Any advantage to pre-sorting data before loading and indexing it?

is not an issue there. If you do pre-sort you might get blindingly fast range scans (at least until you get hit by disc fragmentation again). Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153

Re: [sqlite] Very slow query execution with SQLite Database

seconds is about 130MB/s, sounds like full read speed of a current harddisk. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m

Re: [sqlite] Testing SQLite on embedded platform with no Tcl

? Might be easier than the work around. Usually Tcl is pretty easy to port as it has very few external dependencies. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen

Re: [sqlite] Finding similar strings

distance, which you might know from PHP http://de3.php.net/levenshtein, n-gram matching http://en.wikipedia.org/wiki/N-gram I would guess that n-gram matching is your best bet... Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener

Re: [sqlite] Which TCL distrabution for Windows XP for running SQLite tests?

should use the ActiveTcl 8.5 offering, unless DRH recommends something older than Tcl 8.5 (which is the current stable branch while 8.4 is getting its last update soon). Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3

Re: [sqlite] [UnicodeEncodeError] Don't know what else to try

into SQLite, to come back to the topic of this mailing list you could either stuff the raw bytes into a BLOB field or find out the encoding and put it in a normal TEXT field. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3

Re: [sqlite] bug? like-search with german umlaut is case-sensitive, should not be

or UTF-8 characters. For example, the expression 'a' LIKE 'A' is TRUE but 'æ' LIKE 'Æ' is FALSE.). But its hard to fix as you would need language information for the data to get the upper/lower thing always correct (just think about the ß - SS anomaly in german). Michael -- Michael Schlenker

Re: [sqlite] Make Test Failure Without tcl.h

, are far more portable than any FFI interface you'll find and putting a Tcl on a box (unless your on really small embedded hardware) should not be a problem anywhere. Actually even GCC is tested with Tcl, via DejaGnu/Expect... Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH

Re: [sqlite] Tcl/SQLite application best practices ???

. Maybe also TAO (http://wiki.tcl.tk/tao). It depends a bit on what you try to write and what other constraints you have or are ok to accept. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421

Re: [sqlite] SQLite version 3.6.4 planned for 2008-10-15

. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: [EMAIL PROTECTED] Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz

Re: [sqlite] best language match for SQLite?

Patrick schrieb: I am a beginner to intermediate Python Programmer. I can use SQLite with it just fine but it is my understanding that relational database and object oriented programming our not the perfect marriage. I was just wondering if anyone had an opinion on the most ideal language

Re: [sqlite] special characters as column names

(10, 'abc')} % db eval {select hits/s from foo} a {parray a} a(*) = hits/s a(hits/s) = 10 Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de

Re: [sqlite] Diacritics (umlaut) select in SQLite

to store all your words in one of the decomposition normalization forms (NFD or KNFD would work, see http://unicode.org/reports/tr15/) than your LIKE match should find o and ö, but you might need to apply some other normalization to compose chars again on output. Michael -- Michael Schlenker

[sqlite] Documentation for the register based VM?

did some stowing away of values via OP_StoreMem/OP_LoadMem and those have been replaced by OP_Copy etc. in the register VM. So how many registers are available in the VM to push away some intermediate results? Maybe i should just RTFS... Michael -- Michael Schlenker Software Engineer CONTACT

[sqlite] Scope of sqlite3_changes(), how to reset it?

modify it. 4. Throw away the broken interface. Would like to, but cannot do it here for API stability reasons. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http

Re: [sqlite] Binding values for IN ?

Dennis Cote schrieb: Michael Schlenker wrote: Or would i have to create a dynamic query with appropriate number of bind variables myself and have to pay the price of reparsing each time? # like this values = [uuid1,uuid2] binders = ,.join(?*len(values)) cursor.execute(SELECT * FROM t

Re: [sqlite] Binding values for IN ?

Dennis Cote schrieb: Michael Schlenker wrote: Basically i have to check a larger number (might be around 10.000 or more, but usually far less) of ids against my (incomplete) metadata catalogue to find out if those ids are locally available or need to be fetched from a remote (slow

Re: [sqlite] Variable substitution (TCL SQLite)

Zbigniew Baniewski schrieb: On Thu, Jan 17, 2008 at 11:13:59PM -0500, D. Richard Hipp wrote: The rules of TCL parsing are that text within {...} gets passed into its command exactly as written with the outermost {...} removed. [..] In other words, the $columns was *not* expanded by TCL. It

Re: [sqlite] Variable substitution (TCL SQLite)

Zbigniew Baniewski schrieb: On Fri, Jan 18, 2008 at 02:54:40PM +0100, Michael Schlenker wrote: $name is an application variable if it appears in a place where an application variable is valid. [..] Your usage fails, because the select list is no valid place to use application variables, so

Re: [sqlite] table list

Ged Murphy schrieb: How can I get a list of all tables programmatically in a given SQLite database? Do a SELECT on the sqlite_master table and pick the info you need. Michael - To unsubscribe, send email to [EMAIL

Re: [sqlite] SQlite in PDA with Windows CE

noel frankinet schrieb: Jorge Rodríguez Pedrianes a écrit : Hello, Anybody Knowk to use sqlite embeden in a PDA??, I saw that i can download a .dll to windows, but can I use this dll in PDA? I saw the documentation but don't find anything about this. Anybody can I help me?? If your happy

Re: [sqlite] PATCH: compound query column naming and resolving (Ticket #2822)

Joe Wilson schrieb: --- Trevor Talbot [EMAIL PROTECTED] wrote: On 12/10/07, Robert Wishlaw [EMAIL PROTECTED] wrote: IBM DB2 9.5 select a AS foo from t1 union select b from t1 order by foo SQL0206N FOO is not valid in the context where it is used. SQLSTATE=42703 The problem here is with

Re: [sqlite] INSERT: how to include CR LF symbols in a string constant?

a different binding it might be a little more complex. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: [EMAIL PROTECTED] Sitz der

Re: [sqlite] Suggests for improving the SQLite website

[EMAIL PROTECTED] schrieb: We are looking at renovating the design of the SQLite website and would love to have suggestions from the community. If you have any ideas on how to improve the SQLite website, please constribute either to the mailing list or directly to me. Among the comments

Re: [sqlite] How to implement xLock()?

Richard Klein schrieb: Joe Wilson wrote: --- Richard Klein [EMAIL PROTECTED] wrote: Joe Wilson wrote: Just implement it and run the test suite. It's easier to respond to a specific problem than a hypothetical. Is the test suite available only in Tcl? Or is there a C version as well? Tcl.

Re: [sqlite] Re: CAST

lines of code using the wrapper you have a problem with the sqlite approach. (its a problem with the wrapper APIs/usage, not really with SQLite) Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49

Re: [sqlite] Re: CAST

be the 'declared type' for create table and is registered in the master table. But those declared types are not used for deriving types in expressions, so if any non trivial expression is used in the query you only get the predefined SQLite types (most often Strings). Michael -- Michael Schlenker

Re: [sqlite] Re: CAST

. Windows COM scripting with VARIANTS). So as a compile time option it would surely be a great addition for all those that have to maintain wrappers. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49

Re: [sqlite] another test suite failure under Windows

It lists values for tcl_platform for various OS. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: [EMAIL PROTECTED] Sitz der

Re: [sqlite] Can i store DER encoded Certificate data in sqlite

encoding is binary data, so use a BLOB. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: [EMAIL PROTECTED] Sitz der

Re: [sqlite] Soft search in database

of the keywords. This falls outside the usual scope of SQL, but would still seem a relatively common problem to tackle. Any ideas (pointers) how to tackle this? You have come to the right place. Take a closer look at: http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex Michael -- Michael

[sqlite] Table Info Pragmas as Virtual Table?

schema info for a table with a single statement). Or did some already do something like that? Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de

Re: [sqlite] sqlite / tcl syntax help

] and [5]) especially and SQLites quoting rules... set dataType [$db onecolumn {select typeof($colName) from $table}] should do what you want. Note the {} instead of the , which prevent early substitution, so sqlite can use the $colName as a bind variable. Michael -- Michael Schlenker Software

Re: [sqlite] sqlite / tcl syntax help

Jeff Godfrey schrieb: - Original Message - From: Michael Schlenker [EMAIL PROTECTED] set dataType [$db onecolumn {select typeof($colName) from $table}] should do what you want. Note the {} instead of the , which prevent early substitution, so sqlite can use the $colName as a bind

[sqlite] PRIMARY KEY / NOT NULL enforcement

TABLE foo (a INTEGER NOT NULL, b TEXT, PRIMARY KEY(a) ); Inserting a NULL into column a works fine, this does not raise an error. INSERT INTO foo VALUES (NULL,'bar'); Is the only workaround creating a trigger that calls RAISE(FAIL,...)? Michael -- Michael Schlenker Software Engineer CONTACT

Re: [sqlite] Triggers+callbacks = GUI?

Wesley W. Terpstra schrieb: I intend to write a GUI application backed by SQL. Several of the windows display status that would best be represented as a database view. What I've been thinking about is how to update the GUI when the view changes. [snip] Thus, a window simply provides the

Re: [sqlite] SQLite / php - Using REGEXP

Cecilia VIGNY schrieb: Hi, I'm developing a Php program which uses a SQLite database. I want to execute an SQL request : select * from dicsupp WHERE supp regexp 'test'; It doesn't work... What's wrong ? Thank you ! ;) There could be all sorts of things wrong. Your SQL code looks correct

Re: [sqlite] how can i speed up inserts ?

Dennis Cote schrieb: ohadp wrote: holy smokes that pragma just made my several hundred inserts take half a second compared to 30 seconds earlier. thanks! Yes, but now your database can be corrupted by a power failure or OS crash. Wrapping several hundred inserts in a transaction will be

Re: [sqlite] How to specify collating sequences in an expression.

[EMAIL PROTECTED] schrieb: SQLite has supported collating sequences since version 3.0.0. A collating sequence is really a specification on how comparison operators work on strings. You can have arbitrary collating sequences in SQLite. But for the sake of this discussion, lets focus on just

Re: [sqlite] Does julianday work according to the manual?

info schrieb: Hi, The manual states that the function julianday returns the number of days since noon in Greenwich on November 24, 4714 B.C. That would imply that the statement: Select julianday('-4714-11-24 12:00:00'); Should return 0.0. But it doesn't, it returns -365.0 Does this mean,