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 ma

Re: [sqlite] toupper/tolower

;compact", 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 Zbign

Re: [sqlite] toupper/tolower

ocase_compare #v- Perhaps could be possible to add to that API something like external "tolower/toupper" methods, that could be registered from within TCL? -- pozdrawiam / regards Zbigniew Baniewski __

[sqlite] toupper/tolower

ould be such change introduced in new 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] 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

Re: [sqlite] SQLite version 3.6.12

sqlite-3.6.12.tar.gz package. 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 _

Re: [sqlite] SQLite version 3.6.12

uot;;; esac cat <<\_ACEOF [..] sqlite configure 3.6.11 generated by GNU Autoconf 2.63 [..] ...and so on... (a few more) Could the above have negative influence? -- pozdrawiam / regards

Re: [sqlite] SQLite version 3.6.12

ther compilation. Perhaps I missed something(?) -- 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

ead #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.11

e has been 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

Re: [sqlite] SQLite version 3.6.11

rds 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 ___ sq

Re: [sqlite] SQLite version 3.6.11

s well. :) -- 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

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

Any ideas, what can be the reason? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

e file). > Note 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

[sqlite] Faster (can be shallow) "integrity_check"?

Does there exist any possibility 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

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

/ 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

nces to "strcasecmp" (file tclsqlite.c) fixed the problem (I guess). -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] Speeding up the simplest queries

just because of the limits forced by the storage? -- 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

ing gives 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 _

Re: [sqlite] Speeding up the simplest queries

ed. "Partial" - because 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

Re: [sqlite] Speeding up the simplest queries

record meeting 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 Zb

Re: [sqlite] Speeding up the simplest queries

be inconvenient in the case 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

[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

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

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

[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] Recommended (Windows/Linux) SQLite utilities

itestudio.one.pl/ -- 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 & TCL: A "SELECT" from one-column table

ring FROM something"] dbcomm eval {UPDATE something SET a_string=$a} Of course, should have been: set a [lindex [dbcomm eval "SELECT a_string FROM something"] 0] -- pozdrawiam / regards Zbigniew

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

ving older libraries, than the ones used for pre-built binaries. -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlit

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 mail

[sqlite] 3.5.7 & TCL: "undefined symbol: sqlite3StrICmp"

t any cure? -- 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

e"-d by tester.tcl? -- pozdrawiam / regards 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

t;? Actually... yes, one can live without 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] Faulty "date" function

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

[sqlite] Faulty "date" function

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

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

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

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

nonstandard directory LIBSlibraries to pass to the linker, e.g. -l #v- So, you can set it all *before*. -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-user

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

es 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 ___ 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

s it does contain ("f", "false", 0, "no"). Of course, only in the case, when "checkIt" has been declared as "BOOLEAN", and not as "TEXT" for example. What do you think? -- pozdrawiam / regards

Re: [sqlite] Beginners bad luck

h$file", 0666, $error) -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

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

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

eems - "catch" won't return a value > 0. There'll be following lines printed on the console instead: database is locked while evaluating {source ./main.tcl} -- pozdrawiam / regards

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

uot;SELECT * FROM xyz") - 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

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

pozdrawiam / regards 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

cvstrac/fileview?f=sqlite/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

[sqlite] Serious problem: lower/upper malfunction

r than english. Any schedule for a fix? -- 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...

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

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

ing the high 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 Zbi

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

me ...detaching it in the end: DETACH app So, back to my question: do I need VACUUM at all? -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

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

ve... is it really working the way, I'm supposing - or I'm wrong about it? -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] To VACUUM - or not to VACUUM?

rk - does there exist any need to perform 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

Re: [sqlite] SQLite character comparisons

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

Re: [sqlite] SQLite character comparisons

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

Re: [sqlite] SQLite character comparisons

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

Re: [sqlite] Variable substitution (TCL & SQLite)

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

Re: [sqlite] Variable substitution (TCL & SQLite)

.] > Your usage fails, because the select list is no valid place to use > application variables, so SQLite does expand it there. How is the definition of the "valid place"? -- pozdrawiam / regards

Re: [sqlite] Variable substitution (TCL & SQLite)

ntents of $columns (TCL variable) - because the variable names are "compatible". So - that was my assumption - we've got now: { SELECT column1, column2, column3 FROM some_table } ...which seems to be quite legal SQL statement. It seems, there's something I

[sqlite] Variable substitution (TCL & SQLite)

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

Re: [sqlite] SQLite character comparisons

ill talking about Postgres ;) - and you were asking about SQLite. I'm trimming it all anyway... ;) -- pozdrawiam / regards Zbigniew Baniewski

Re: [sqlite] SQLite character comparisons

= 'str '; ?column? -- f (1 row) Those 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

Re: [sqlite] SQLite --> PostGres

, where is a _real_ argument "it can break compatibility". -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

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

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

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

opinion about 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 Zbign

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

(not so well, still working on this) english is to blame, but I'm not native speaker - consider this, reading any of my posts -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

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

ht to have my own opinion. I can't understand all that people tryin' to start a flamewar here *after* I ended the discussion *yesterday* already. Are they bored, and looking for some doubtful "fun"? But why exactly here? -- pozdrawiam / reg

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

h DB and > leave us poor dumb Bas--rds using SQLite alone! I gave it up yesterday already. What's your point, exactly? -- pozdrawiam / regards

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

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

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

e should it going to, when I already wrote "OK, no problem". -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

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

eds. Besides: (almost) every introduced feature makes the code more complex. Should 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 Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

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

or two years and the result *will* be a massive mess. Keep your flamewar just to yourself, will you? Thank you. -- pozdrawiam / regards Zbigni

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

;DB's job of storage" at all, anyway. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

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

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

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

need to escape them first (very convenient! :) 7. It won't hurt 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

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

just "for those about to trimming". It could (perhaps even should) be "off" by default. -- pozdrawiam / regards Zbigniew Baniewski ---

[sqlite] "always-trim" - feature suggestion

g "pragma") as "default" seems to be logical? 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?

anyway, right? And I'm wondering, if database could be "active" side, not just "waiting for query". Could be something like this possible at all? -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

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

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

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

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

Re: [sqlite]:Using sqlite3_progress_handler for GUI application

me_ columns are covered by example1 anyway? -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Compiling Problem With SQLite 3.5.4

5.4 [list load /usr/local/lib/tcl8.5/sqlite3/libtclsqlite3.so 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

so: undefined > symbol: 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

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

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

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

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

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

more comfortable 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"?

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

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

anything, that makes establishing such limit on the field length reasonable? -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe,

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

[sqlite] An example for "progress" method?

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

Re: [sqlite] Multi-User confusion

not just transaction. I mean: when I'm using a program which is accessing the database - nobody else has access. -- pozdrawiam / regards Zbigniew Baniewski -

Re: [sqlite] Multi-User confusion

filesystem assure enough protection? -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: "attach database"

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

Re: [sqlite] Multi-User confusion

archive.com/sqlite-users@sqlite.org/msg18342.html ) 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

  1   2   >