[sqlite] toupper/tolower

version? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] toupper/tolower

to that API something like external tolower/toupper methods, that could be registered from within TCL? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing

Re: [sqlite] toupper/tolower

, and because of this, the better way - if possible - would be suggested completion of TCL API. Even that I'm aware, that such external method will be slower. -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] toupper/tolower

I'm sorry: totally missed `The function method' :( So, it seems, that the problem's solved. :) -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list

Re: [sqlite] SQLite version 3.6.12

#v- -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.6.12

(?) -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.6.12

configure 3.6.11 generated by GNU Autoconf 2.63 [..] ...and so on... (a few more) Could the above have negative influence? -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] SQLite version 3.6.12

. Is it possible to just use the Makefile from sqlite-3_6_12-tea.tar.gz with sources provided by sqlite-3.6.12.tar.gz ? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users

Re: [sqlite] SQLite version 3.6.12

Sorry, checked it again, and noticed now, that this kind of tarball seems to be kinda abandoned: :( The Makefile and configure script in this tarball are not supported -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] SQLite version 3.6.11

. :) -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.6.11

| grep 3.6 /Programs/SQLite/3.6.11/lib 3.6.10 #v- How could I fix it? Where's held the release number 3.6.10? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users

Re: [sqlite] SQLite version 3.6.11

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

Re: [sqlite] SQLite version 3.6.11

deleted before new compilation, the present one not yet installed). Is it right? If so - how should it be fixed? (BTW: gcc version 4.3.3) -- pozdrawiam / regards Zbigniew Baniewski

[sqlite] Copy database from memory to disk - sometimes works, sometimes not

? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Copy database from memory... [resolved]

Sorry for noise: the problem was in quite other place. -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] Faster (can be shallow) integrity_check?

that PRAGMA quick_check is currently an undocumented experimental feature. It has been present for almost a year though. But will it be present for steady from now on? -- pozdrawiam / regards Zbigniew Baniewski

[sqlite] Faster (can be shallow) integrity_check?

to make a much shorter test, for just very obvious cases, like incomplete database file (when f.e. there has been taken just part of the database file during downloading)? -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] SQLite ISO8859-x characters (Linux, C)

Wow, a whole lot of material... thanks. Starting to read it all... -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] SQLite ISO8859-x characters (Linux, C)

(Linux) could be considered as most convenient? Perhaps there's a doc with explanation (in the context of SQLite-usage)? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite

Re: [sqlite] Speeding up the simplest queries

in the case of non-existence it has to scan the table to the end anyway. But still it's better than count(*). -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing

Re: [sqlite] Speeding up the simplest queries

significant boost (for sharp conditions). I'm afraid, one has just to wait in the case of all the LIKE-s, unfortunately. -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users

Re: [sqlite] Speeding up the simplest queries

? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] The old bug strikes back

tclsqlite.c) fixed the problem (I guess). -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Speeding up the simplest queries

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

[sqlite] Speeding up the simplest queries

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

Re: [sqlite] Speeding up the simplest queries

of the larger table. -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Speeding up the simplest queries

given condition. Is it possible to make it fast _not_ using count(*)? I need just a boolean result of 1/0 (yes, there is at least one / there aren't any). -- pozdrawiam / regards Zbigniew Baniewski

[sqlite] VACUUM trouble

, SQLite 3.6.1, 256 MB RAM -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] VACUUM trouble

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

Re: [sqlite] VACUUM trouble

OK, the mystery has been solved: didn't notice, that disk just reached 100% usage... :D -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite

Re: [sqlite] SQLite TCL: A SELECT from one-column table

a [lindex [dbcomm eval SELECT a_string FROM something] 0] -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] Recommended (Windows/Linux) SQLite utilities

/ -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 3.5.7 TCL: undefined symbol: sqlite3StrICmp

for pre-built binaries. -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

[sqlite] 3.5.7 TCL: undefined symbol: sqlite3StrICmp

? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 3.5.7 TCL: undefined symbol: sqlite3StrICmp

On Thu, Apr 03, 2008 at 09:54:15PM -0500, John Stanton wrote: Install TCL Another one? What for? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list

[sqlite] Faulty date function

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

Re: [sqlite] Faulty date function

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

Re: [sqlite] Conversion string - date

that. -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] TCL tester.tcl question

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

[sqlite] Improvment suggestion for BOOLEAN-type fields

, and not as TEXT for example. What do you think? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Improvment suggestion for BOOLEAN-type fields

each) for binary-sort variables (and not niet, nein, off...) - does it not? Additional f / t can be added for PHP. So: no worries... ;) -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

libraries to pass to the linker, e.g. -llibrary #v- So, you can set it all *before*. -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

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

Re: [sqlite] Beginners bad luck

= sqlite_open($db) or die(Could not open database); Perhaps try to point full path to database file, then use something like: $handle = sqlite_open($path$file, 0666, $error) -- pozdrawiam / regards Zbigniew Baniewski

[sqlite] Impossible to catch locked state (SQLite 3.5.6 TCL)

return a value 0. There'll be following lines printed on the console instead: database is locked while evaluating {source ./main.tcl} -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] Impossible to catch locked state (SQLite 3.5.6 TCL)

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

Re: [sqlite] which is faster, PHP or SQLite?

) - where are, actually, any benefits from using SQL database engine? Using plain file you can have about the same: open/read_all/close... done. -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] SQLite 3.5.5 on OpenBSD running on HPPA (HP9000) make test

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

Re: [sqlite] Serious problem: lower/upper malfunction

It's OK, found a README... :] -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Serious problem: lower/upper malfunction

/ext/icu/icu.c Yes, took that file - how to integrate that file with SQLite 3.5.4, to make lower/upper/LIKE properly working? -- pozdrawiam / regards Zbigniew Baniewski

[sqlite] Serious problem: lower/upper malfunction

? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Parameter suggestion for Makefile...

Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] To VACUUM - or not to VACUUM?

VACUUM? If I'm correct - attached database, when DETACH-ed, will be saved into real database file from the beginning to end, thus no fragmentation there at all? -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] Re: To VACUUM - or not to VACUUM?

- or I'm wrong about it? -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: To VACUUM - or not to VACUUM?

need VACUUM at all? -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Re: To VACUUM - or not to VACUUM?

water mark size (the size reflecting the largest amount of data it ever held). Thanks, that's I was afraid of: that there's something subtle, I'm missing. -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] SQLite character comparisons

... ;) -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite character comparisons

Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite character comparisons

Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Variable substitution (TCL SQLite)

is no valid place to use application variables, so SQLite does expand it there. How is the definition of the valid place? -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] Variable substitution (TCL SQLite)

on there. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Variable substitution (TCL SQLite)

some_table } ...which seems to be quite legal SQL statement. It seems, there's something I'm still missing(?). -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] SQLite character comparisons

are different strings, anyway. Can't recall now, does there any setting to change this - but you can easily find out at their website. -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] SQLite character comparisons

;) - and you were asking about SQLite. I'm trimming it all anyway... ;) -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email

[sqlite] Variable substitution (TCL SQLite)

the entire procedure. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite -- PostGres

(didn't write, that there are profits in Postgres' case), I read the concluding response from dr. Hipp already, where is a _real_ argument it can break compatibility. -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] Re: always-trim - feature suggestion

*will* be a massive mess. Keep your flamewar just to yourself, will you? Thank you. -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] always-trim - feature suggestion

the development of the applications be stopped then? OK, as I wrote already, it was just a proposal. The others may suggest this or that - so I made use out of my freedom to make the same. -- pozdrawiam / regards Zbigniew

Re: [sqlite] always-trim - feature suggestion

. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] always-trim - feature suggestion

Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] always-trim - feature suggestion

dumb Bas--rds using SQLite alone! I gave it up yesterday already. What's your point, exactly? -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] always-trim - feature suggestion

a flamewar here *after* I ended the discussion *yesterday* already. Are they bored, and looking for some doubtful fun? But why exactly here? -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] Can't we all just get along? [Was: RE: [sqlite] always-trim - feature suggestion]]

-- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: always-trim - feature suggestion

Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] always-trim - feature suggestion

this - I had to express my own first. It's all. Thanks for all your efforts, which, of course, are greatly appreciated - what I would do on this list otherwise? -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] always-trim - feature suggestion

to trimming. It could (perhaps even should) be off by default. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email

Re: [sqlite] always-trim - feature suggestion

anybody; as I wrote, it would be an option. But I'm pretty sure, many can (and will) appreciate that. Never seen that in any other database server (or engine). -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] always-trim - feature suggestion

. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: always-trim - feature suggestion

. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: always-trim - feature suggestion

Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] always-trim - feature suggestion

? What do you think? -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Tcl: sharing a variable using SQLite - could be possible?

Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite]:Using sqlite3_progress_handler for GUI application

/ regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: :Using sqlite3_progress_handler for GUI application

Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: :Using sqlite3_progress_handler for GUI application

, or can I skip it. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Compiling Problem With SQLite 3.5.4

sqlite3] -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

3.5.4 -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Problem installing TCL bindings

: sqlite3StrICmp It looks for a libraries mismatch to me. It's very likely, that he cannot proceed without compilation from the sources on his own. -- pozdrawiam / regards Zbigniew Baniewski

[sqlite] Any advantages of varchar() over text?

establishing such limit on the field length reasonable? -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL

Re: [sqlite] Re: Any advantages of varchar() over text?

Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Any advantages of varchar() over text?

then. Less things to take care of. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Any advantages of varchar() over text?

Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Any advantages of varchar() over text?

)? -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Multi-User confusion

Yes, found it: no support for that in 3.3.8. :( Must compile newer version. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe

Re: [sqlite] Multi-User confusion

the database - nobody else has access. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Multi-User confusion

On Mon, Sep 17, 2007 at 02:29:58PM +, [EMAIL PROTECTED] wrote: http://www.sqlite.org/pragma.html#pragma_locking_mode Oh, boy... missed entire set of pragma commands. Thanks. -- pozdrawiam / regards Zbigniew

[sqlite] An example for progress method?

Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] attach database

: contents into main database file. Will it be automatically saved when DETACH-ing :memory: ? I'm afraid, no? -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] Multi-User confusion

) Doesn't it mean, that database is protected enough already by it's internal design, and there's no need to take care about that dot locks? -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] Re: attach database

/drh.html -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

  1   2   >