Re: [sqlite] Inspect WAL file?

rg/src/artifact/ec79959834f7b21f It allows you to look at the WAL.., but not sure if it fits your problem. Michael -- Michael Schlenker Senior Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen E-Mail:

[sqlite] regression in 3.12.0 vs. 3.11.0, column type information in PRAGMA missing

ma). Now we either have to add additional configuration just for SQLite (because similar code works fine for Oracle and MS SQL Server), or hope that case 3 works. btw. would be nice to have an INFORMATION SCHEMA style view for this info instead of a pragma. Michael -- Michael Schlenker Senior Software

[sqlite] Detect if db is already opened by another process?

Am 23.09.2015 um 18:09 schrieb Richard Hipp: > On 9/23/15, Michael Schlenker wrote: >> Hi, >> >> i just wondered if there is an API to detect if a sqlite database file >> is already opened by another process. > > Maybe try to change in or

[sqlite] Detect if db is already opened by another process?

: Karl Heinz Zachries, Ralf Holtgrefe Court of register: Amtsgericht Bremen HRB 1321 -- Michael Schlenker Senior Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Stra?e 1-3 Fax:+49 (421) 20153-41 28359 Bremen E-Mail: michael.schlenker

Re: [sqlite] capturing and testing a hot journal

our 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 Tel.: +49 (421) 20153-80

[sqlite] Registering Application IDs?

://www.sqlite.org/src/artifact?ci=trunk=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

a second table. But that kind of defeats the normalization... Might work 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 Fa

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

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

out 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: Bre

Re: [sqlite] VC++ and SQLite

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

Re: [sqlite] Trigger, syntax question

//sqlite.com/lang_createtrigger.html >> >> Which part do 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 Mic

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

ken libs for you, fine. But if you must fix them yourself due 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-4

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

ference/ManPages/man1/expect.1.html See for the script: http://expect.cvs.sourceforge.net/viewvc/expect/expect/example/unbuffer?revision=5.34=markup Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:

Re: [sqlite] compile warning in tclsql 3.7.5

pointer to function > from incompatible pointer type > > > on 64 bit suse (and redhat) > > seems to be saying that Tcl_WideInt != sqlite3_int64 > > Tcl_WideInt ended up being set as 'long' > sqlite3_int64 ended up being long long int > > I assumed those 2 typ

Re: [sqlite] oracle compatibility mode

f higher level mapper (for example 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

Re: [sqlite] Bug: Umlaut in database filename

the sqlite_open() call (e.g. UTF-8) or use 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

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 St

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

ror: Cannot add a NOT NULL column 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 S

Re: [sqlite] Escaping binary data

sqlite3_bind etc. But if you really 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 Wiene

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

/Tk is one solution with an easy syntax and good sqlite support. If you used starkits/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

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

source/browse/trunk/Domains/SqlQ.tcl 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: B

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

roblem? I'm using ActiveTcl 8.5.4. If your using ActiveTcl 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

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

Fredrik Karlsson schrieb: > On Thu, Jul 16, 2009 at 1:20 PM, Michael Schlenker<m...@contact.de> wrote: >> Your working far too hard. The sqlite Tcl binding already does all thats >> needed. >> >> This is perfectly safe: >> set result [db1 eval {select * fro

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

X where label = $myStringValue and id > $compId}] But you MUST use {} to quote your query and not "", so sqlite gets to do the substitution (or better said convert things to prepared statements and bind values correctly) and not Tcl. Michael -- Michael Schlenker Software Engineer CONTACT Sof

[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?

re in the same way as insertion? > 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

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

e syntax itself. > I guess it wouldn't be too 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 Softw

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

rted loading 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:

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

exists to speed it up). So your probably I/O bound, 1.5 GB in 12 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:+4

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

porting Tcl just to run the > regression tests? 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:

Re: [sqlite] Finding similar strings

igrams of letters and match those Typical thing to look for is Levenshtein 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 Enginee

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

ore and the port is old and strange. So, guess you 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

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

about the ß -> SS anomaly in german). 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:

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

to put data 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 Wiene

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

ose Tcl tests work, 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 CON

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

d maybe the gridplus gui tools. 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

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

e-dev is the right place. 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 Ges

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

Re: [sqlite] special characters as column names

" INTEGER, "some-thing" TEXT)} % db eval {select "hits/s" from foo} a {parray a} % db eval {insert into foo values (10, 'abc')} % db eval {select "hits/s" from foo} a {parray a} a(*) = hits/s a(hits/s) = 10 Michael -- Michael Schlenker Software Engineer

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

but you might need to apply some other normalization to compose chars again on output. 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-Mai

Re: [sqlite] Documentation for the register based VM?

D. Richard Hipp schrieb: > On Apr 10, 2008, at 11:47 AM, Dennis Cote wrote: >> Michael Schlenker wrote: > > That is correct, but it is not the whole story. Registers have to be > allocated. > The canonical way to do this is to increment the Parse.nMem field.

Re: [sqlite] Documentation for the register based VM?

Dennis Cote schrieb: > Michael Schlenker wrote: >> The old code 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 r

[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: > >> 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 f

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 = &quo

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] 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] 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

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

f you have 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]

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?

Re: [sqlite] Re: CAST

type' may 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

Re: [sqlite] Re: CAST

e some 100k 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:

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

ls, take a look at: http://wiki.tcl.tk/tcl_platform 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/

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

occurance 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

[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

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 s

Re: [sqlite] sqlite / tcl syntax help

m#M11 , [4] 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 -- Michae

[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,