Re: [sqlite] load_extension() and extension-functions .c

Oliver Peters writes: > > Hello out there, > ...snip... > q1: > > I used gcc version 3.4.5 (mingw-vista special r3) to compile > "extension-functions.c" with the following options > > gcc -shared -fPIC -I "c:\Programme\SQLite" -o libsqlitefunctions.so > extension-functions.c > (I copied sq

Re: [sqlite] Compile warnings

throw up those warnings since the usage is not checked. Regards, MikeW PS. yes, I am looking at cleaning up our SQLite build output ! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.6.14.1

minor bug fixes" ?! Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] multiple row insert

ment once for each row. > > Igor Tandetnik Or wrap both (all?) in a transaction if you want atomicity ... MikeW gmane-padding-gmane-padding-gmane-padding-gmane-padding-gmane-padding ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] parameters

program). > > If anyone can suggest what I am doing wrong I would really appreciate your > help. > > meerkat Have you tried just a basic 1-term query first of all ? That should establish that you are calling the API (whatever it is for .js) correctly. An

Re: [sqlite] datetime as integer

. (http://en.wikipedia.org/wiki/Julian_day#History) > > You are possibly thinking of Archbishop Ussher's creation estimate of 23 > October 4004 BC. (http://en.wikipedia.org/wiki/Dating_Creation). > > Cheers, > John Sorry, I meant to say _before_ the beginning of tim

Re: [sqlite] datetime as integer

in Greenwich on November 24, 4714 > B.C., using the Proleptic Gregorian calendar: SNIP "noon in Greenwich on November 24, 4714 BC" - presumably that's the beginning of time for Creationists ... MikeW ;-) ___ sqlite-users mailing list sq

Re: [sqlite] Develop SQLite with Eclipse

se to give it more memory to start with. Can't remember - look them up, or Google ! Cheers, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [SQLITE] Require Help

ly my previous 'helpful' suggestion to him was not good enough ... MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] REquire help!! - in debugging

ry running it on e.g. a Windows platform. However it may be that your libraries are faulty or not linked, or some other target system issue. Use a single-step debugger or a tool like 'strace' to discover why your program "crashes" - I pre

Re: [sqlite] Group by week

e last step in the calculation is taking residue modulo 7. However, if you don't do this, but instead, integer divide by 7, then results sharing the same quotient should be in the same week. If your week starts on a different day-of-week from Zeller, add the appropriate number of

Re: [sqlite] Adding Custom Column Data Types

a to convert it back into the native format the environment > uses. > > Or is there a better way? > > Thanks, > > Mike > An alternative is to use the sqlite3_column_decltype() http://www.sqlite.org/c3ref/column_decltype.html

Re: [sqlite] Adding Custom Column Data Types

a to convert it back into the native format the environment > uses. > > Or is there a better way? > > Thanks, > > Mike > Another separate field for the data type ? MikeW == gmane padding === == gmane padding === == gmane padding === == gmane padding === == gmane paddi

Re: [sqlite] codepages

and http://www.sqlite.org/lang_corefunc.html#like You might wish to implement your own Arabic-aware like(). MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What is the advantage of using native c API over ODBC

goldy writes: > > Hi All, > > What are the basic advantage of using SQLite with C API over ODBC. Whereas the advantage of ODBC is having the same(?) interface to different database systems. Horses for courses ... MikeW ___ sqlite-u

Re: [sqlite] How many tables can a database hold?

ing this is that separate tables should not usually be used just to group sets of otherwise identically-structured data records. Search keywords: database schema design entity relationship Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Lock SQLite file by overwriting bytes and then un-lock?

RB Smissaert writes: > > Thanks for the tip, but does that work on a Windows Mobile device? > > RBS Don't know - also look at http://www.freeotfe.org/ (Google: encrypted files windows mobile) Cheers, MikeW ___ sqlite-users mailing

Re: [sqlite] Lock SQLite file by overwriting bytes and then un-lock?

be too careful with sensitive data like this. Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Leading/trailing whitespace overrides Numeric type affinity - workarounds ?

Roger Binns writes: > > > MikeW wrote: > > I guess one approach would be to compile with SQLITE_ENABLE_COLUMN_METADATA > > and then to read the column type from there rather than from > > sqlite3_column_type(). > > Or just call sqlite3_column_dec

Re: [sqlite] Leading/trailing whitespace overrides Numeric type affinity - workarounds ?

Roger Binns writes: > > > MikeW wrote: > > I note that in the codebase, sqlite3IsNumber() will return False if an > > otherwise numeric value has leading and/or trailing whitespace, > > *overriding the table schema*. > > Such is dynamic typing ! > >

[sqlite] Leading/trailing whitespace overrides Numeric type affinity - workarounds ?

, overriding the table schema. Such is dynamic typing ! Are there any workarounds to this behaviour short of adding custom exceptions to the use of sqlite3IsNumber() ? Thanks, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] Date datatype

Hoover, Jeffrey writes: > ... > Be nice if it understood some other formats, too, such as 02-JAN-09 or > 11/17/2004... But both those two examples are potentially ambiguous !! MikeW ___ sqlite-users mailing list sqlite-users@sqlite

Re: [sqlite] How to port sqlite to uc/os

.. > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Have a look here: http://www.sqlite.org/cvstrac/wiki?p=HowToCompile As long as you have the compilers etc. it should not be too hard. MikeW ___ sqlite-users maili

Re: [sqlite] Date datatype

`retries` int(10) NOT NULL); > > sqlite> select date from envelope where date > '2009/01/20' limit 3; > 2009/1/7 > 2009/1/7 > 2009/1/7 > > why? > It's a string comparison, '2009/' is identical in each ca

Re: [sqlite] How to use BEGIN & COMMIT in my C program?

UPDATE. > > Igor Tandetnik Or more specifically, *SQL* statements. MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite3 database creation very slow when chang es Linux OS version

32-bit emulation and alignment fixups of 32-bit software? I remember it had to do this for Itanium running Win64, and it was 30% of the speed. MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cross compilation

nt should let your 'make' use the arm-gcc compiler, or whatever is the name of your Arm compiler, Get a bit more familiar with your cross-compiler tools, check they run OK from the command line and find out why building SQLite in the documented w

Re: [sqlite] Cross compilation

writes: > > Hello MikeW > All the information in that link to cross compile sqlite > for ARM is Sqlite-3.3.7. > > But now i am using sqlite-3.6.7. I am unable to find the lines to comment in > the latest configure script. > > and I need to gener

Re: [sqlite] db collation not working in the tcl interface

t; insert into test values ('ё-моё'); > ...snip... > Best regards, Alexey. Surely this is a problem with Tcl's ability to sort non-ASCII characters rather than SQLite ? How about using Tcl_UniCharNcasecmp rather than 'string compare' ? Хорошо! MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A quick question

ke things work in the > current environment. > Thanks for the info so far. > > Regards, > J. R. Also, Eclipse has a CVS client of sorts, "Team SynchoniZing View", but have not used it in anger. MikeW ___ sqlite-users mailing

Re: [sqlite] A list as an SQL paramater - correction

MikeW writes: > > If your list values are relatively small you could use a set > of bits for your IN clause and use > bitwise: WHERE ((1< encodes the required elements as bits set to 1. > ..snip.. > > Regards, > MikeW Oops, that shoul

Re: [sqlite] A list as an SQL paramater

Sam Thursfield writes: > > Hello everyone, > I have a question which I'm hoping someone who knows a bit about > SQlite's internals can answer easily. > > I have a query such as this: > > SELECT * FROM local INNER JOIN foreign ON local.foreign_id = > foreign.id WHERE foreign.id IN (4, 3, 6, 7)

Re: [sqlite] What does "PRAGMA integrity_check" actua lly do?

ite. > > - Richard Klein Sounds like concurrent-update issues ? Try a mutex on writes to the DB ! SQLite just uses a Big Lock ! (ok, ok, not really) MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A quick question

er interface from the Windows API with no thought to back-compatibility. You could try http://www.wincvs.org/ MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cross compilation

writes: > > Hello all > > How can i cross compile tcl and sqlite for arm and ppc > > Tahnks in advance > > Chandru K http://www.sqlite.org/cvstrac/wiki?p=HowToCompile MikeW ___ sqlite-users mailing list sqlite-users@sqli

Re: [sqlite] week number - feature request - extend strftime for ISO week?

PooLpi writes: > > Thanks MikeW, > > Is there a way to do strftime %W with another function. > It don't seems to be possible with datetime. > > Thanks > > PooLpi The Linux 'date' command does support %G/%g/%V referring to ISO week num, which sug

Re: [sqlite] Hi, a question from Colombia

Ribeiro, Glauber writes: > > Carlos, > > If you don't mind, I'll answer through the list, because there are > people there who know much more than I do. > > > glauber > Hey, glauber, you didn't say wh

Re: [sqlite] week number

does not use the ISO definition of week number, but rather the more simplistic Unix one. Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 600ms for simple query: How to optimize it?

here? How can I speed up > this query? > > Thank you very much in advance, > Luke Silly question I know - presume this time does not include the prepare (which should be done in advance) ? MikeW ___ sqlite-users mailing list sqlite-use

Re: [sqlite] Exporting database to CSV file

Jonathon writes: > > Awesome. Thanks for the quick reply Deech :) > > J "Awesome" ? You must be easily impressed/scared ! ;-) MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Inserting an image file?

; thanks, > deech But obviously holding the image within the DB means your DB file gets bigger, reducing the effectiveness of memory caching. You could have INSERT and DELETE triggers (and maybe an extra table) to manage the image files, and ju

Re: [sqlite] newie question

Oscar Alejandro Alvarado Prieto <[EMAIL PROTECTED]> writes: > > how can I retrieve the result of a "SELECT COUNT(*) FROM atable" statemen? > thanks > Please use a better Subject line !! ___ sqlite-users mailing list sqlite-users@sqlite.org http://

Re: [sqlite] Request to check UNICODE support

http://www.sqlite.org/faq.html#q18 Search the newsgroup ... start here: http://thread.gmane.org/gmane.comp.db.sqlite.general/41826/focus=41843 MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_bind_parameter_*() usage

MikeW <[EMAIL PROTECTED]> writes: > Your bind parameters VALUES (?, ?) have not been given names, > see http://www.sqlite.org/c3ref/bind_parameter_name.html > "Parameters of the form "?" without a following integer have no name and are > also referred to as &

Re: [sqlite] sqlite3_bind_parameter_*() usage

meter_name( stmt, 2 ); > return( 0 ); > } > Your bind parameters VALUES (?, ?) have not been given names, see http://www.sqlite.org/c3ref/bind_parameter_name.html "Parameters of the form "?" without a following integer have no name and are also referred to as "anonymous parameters"." RTFM ?! Cheers, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Another set of questions - subject line

Christophe Leske <[EMAIL PROTECTED]> writes: > > > Any chance that you could hint at the subject matter of the questions in the Subject line ? In this case it would appear to be Performance ... Helps to get your questions answered ! ;-)

Re: [sqlite] SQLite file security

rambles it, then uses SQLite on an in-memory DB. When it closes after any DB changes it rescrambles it and writes back to disc. Obviously anyone analysing your app would eventually be able to work out the process ... the devil is in the detail !! Cheers, MikeW ___

Re: [sqlite] Recommended method of atomically inserting if data is not present

<[EMAIL PROTECTED]> writes: Can't make the 'name' column > 'unique' as two clients may have the same name. Can't make > the 'id' column 'unique' as a client may have more than one > name... However you can specify that the

Re: [sqlite] Condition on several tables

u will just generate all possible combinations of rows from the tables - not really what you want ! Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_bind_text problem

ecify a column list in your INSERT statement ... Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Recursive Query

Alexander Yap <[EMAIL PROTECTED]> writes: > > Hi All, > I just want to know if WITH RECURSIVE query is supported by SQLite. > > Thanks in advance. > > Regards, > > Alex http://www.sqlite.org/lang_select.html MikeW

Re: [sqlite] look up by row on ordered table... must be very fast

n. Or have I missed a reference somewhere ? Cheers, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] look up by row on ordered table... must be very fast

erhead of the SELECT by retrieving more than one row, as many as your working storage would allow. MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Delete based on timestamp very slow - vacuum

file rather than just reusing the dead space. Doing it /before/ will just mop up any residues, and will have less work to do, and I believe it also does a bit of a 'defrag' - hence you should not do it too often if execution time of the operation is important. MikeW ___

Re: [sqlite] Delete based on timestamp very slow

is old" with a valid criterion matching your requirements. You would also need a fallback INSERT in case there was no available 'old' record to be replaced. This is where your size criterion could be examined most effectively too. Just a thought ... MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Re-title, enhance SQLite FAQ item on Unicode ?

htly e.g. http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/icu/README.txt so that 'drive-in' users can get going under their own steam with the resources on the site? [Not that I mind posting links to earlier answers ...!] Best regards, MikeW

Re: [sqlite] LIKE operator to support GREEK

g/gmane.comp.db.sqlite.general/42112 Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] offical full list of valid data types?

says it all - so what is the point of your question ? Or do you want to map fields from another database system ? Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "SQL logic error or missing database" with multithreaded program

s it not matter as long as it's before the step() ?) Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unhappy with performance

ao, MM > Speaking as a non-indexed person ! from other posts here I would suggest it's the fact that you have an index on the field you are updating that takes the time. Remove the index on that field and see how long it takes. Some people have even suggested (in a non-flash-

Re: [sqlite] sqlite3_open() problem for ARM

is > running without problems. > Please help > > NOTE: the same appplication compiled for linux PC is working fine. > > Best regards > Leandro > Could be a compiler issue - try turning OFF optimisation: "-O0" MikeW _

Re: [sqlite] Problem : SQLite Database error

ce that people will > become annoyed and will not help you. > > Thank you for your consideration. > > Mihai Limbasan FYI - http://article.gmane.org/gmane.comp.db.sqlite.general/41794/match=bluephoneelite MikeW ___ sqlite-users mailing li

Re: [sqlite] Separating error conditions that are all lumpe d as SQLITE_ERROR

Roger Binns <[EMAIL PROTECTED]> writes: > > > MikeW wrote: > > Having looked at the source code, looks like the best way to do this > > /would/ be to add another (!) numerical parameter to sqlite3ErrorMsg() indicating > > the extended error code that corres

Re: [sqlite] insert speeds slowing down as database size in creases (newb)

(default is 2000). > > > > I forgot to mention I use JDBC to access sqlite from a java app. Is there > an equivalent line of code to execute from within java/jdbc to do the same > thing? Or a configuration somewhere? see here http://article.gmane.org/gmane.comp.db.sqlite.general/42

Re: [sqlite] How to speed up read-only databases?

Julian Bui <[EMAIL PROTECTED]> writes: > > Hey MikeW, > > The article you posted seems like something I might want to try. I am > currently using JDBC to embed sqlite in my java app. Do you know if there > are equivalent statements for java? > > Please let

Re: [sqlite] Separating error conditions that are all lumpe d as SQLITE_ERROR

MikeW <[EMAIL PROTECTED]> writes: ... > But without a suitable extended error number, that is what I think is the only > solution ... > would be nice to have sqlite3_ext_errcode() to get a better view. > > (The existing extended error code system is restricted to I/O errors

[sqlite] Separating error conditions that are all lumpe d as SQLITE_ERROR

restricted to I/O errors ...) Any better ideas ? Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Rewriting contents of a column?

tputting values (or producing a report) reformat according to currency. E.g. if Currency == dollar, separator = '.' ... if Currency == euro, separator = ',' (could also be done in the TRIGGER above too, with another field) etc. ! Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite3 delete action is too slow

PennyH <[EMAIL PROTECTED]> writes: > > > Thank you MikeW. I try to use transaction, still slow. Use limit clause is > good idea, but the help is limited. Dose number of index affect speed too? > How many index on one table is better? > > Regards, > > Penny >

Re: [sqlite] unexpected database growth

> On Oct 26, 2008, at 10:01 PM, Julian Bui wrote: > > > Hi Dr. Hipp, > > Julian, I think it's "D.R. Hipp" - unless you know better ! But I'm sure Richard appreciates the accolade !! Regards, MikeW ___ sqlite-user

Re: [sqlite] UTF8 support?

am that "implements full UNICODE support". So I'm a little > confused. > > - > William Kyngesburye > Search the newsgroup ... start here: http://thread.gmane.org/gmane.comp.db.sqlite.general/41826/focus=41843 Regards, MikeW

Re: [sqlite] How to speed up read-only databases?

Christophe Leske <[EMAIL PROTECTED]> writes: > How about the cache size? or does this only pertain to databases which > get inserts? > > Christophe Leske Speedup tip: http://article.gmane.org/gmane.comp.db.sqlite.general/41990 You may hav

Re: [sqlite] rtree cast warnings on 64bit OS - strange parameter use

e callback is invoked. > > A lot of compilers throw a warning when they encounter this. In my > opinion (having never had anything to do with compiler design or > implementation) they shouldn't. > > Dan. See also (e.g.) http://gcc-hcs12.com/documnets/gcc_hcs12_helps/gcc_4.html#SE

Re: [sqlite] how to add multiple columns at a time

Jonas Sandman <[EMAIL PROTECTED]> writes: > > I don't think you can add multiple columns in just one command. > > /Jonas You could consider wrapping the commands in a transaction, if you want all-or-nothing ... Regards, MikeW _

Re: [sqlite] Compressing read-only dbs?

Christophe Leske <[EMAIL PROTECTED]> writes: > > > > How about storing the DB file in a cramfs filesystem > Forgot to say that this is Windows XP, sorry. > Erm, compressed attribute under NTFS ? Maybe 25%-30% redu

Re: [sqlite] Compressing read-only dbs?

gt; > Thanks, > How about storing the DB file in a cramfs filesystem ? http://en.wikipedia.org/wiki/Cramfs http://sourceforge.net/projects/cramfs/ Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:808

Re: [sqlite] Sqlite3 delete action is too slow

e place, would be to add a LIMIT clause to your deletion. http://www.sqlite.org/syntaxdiagrams.html#delete-stmt-limited You would then do deletes, some other work, more deletes, ... until all your required records were deleted. Regards, MikeW __

Re: [sqlite] Vacuum needed?

e it in the records deleted state and let > SQLite reuse the memory as it goes along. > > Best regards > Mohit. Though if your db has reached a steady-state size you might consider running a VACUUM just *before* deleting the records, to avoid peaks persisting ... and

Re: [sqlite] SQLITE_CORE use for ??

ing compilation. So this must be a case where I need to set it manually !? Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Formatting to

Igor Tandetnik <[EMAIL PROTECTED]> writes: > > Are you sure you would be happy with "Uncle tom's cabin", or "Adventures > of tom sawyer", or "Oliver twist" ? > > Igor Tandetnik > Yes - whatever happened to Title Case ? MikeW _

Re: [sqlite] about sqlite3_prepare()

_prepare() on your SQL, you bind the values and do a _step(): much quicker for multiple updates ... read the documentation ( http://www.sqlite.org/c3ref/bind_blob.html ) Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to speed up read-only databases?

s the résumé though ... and your ninja status ! Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Default Row value

ou which fields are empty (zero-length string) vs. NULL Cheers, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why is subselect much faster than join?

cuumed and analyzed. > Have you tried asking it to EXPLAIN ? It may be that the JOIN does the join on the whole tables first, then applying the WHERE, whereas the subselect is working on a much reduced subset of data. Google for "subselect faster than join" - some int

Re: [sqlite] CURRENT_DATE Behavior

MikeW <[EMAIL PROTECTED]> writes: > > jonwood <[EMAIL PROTECTED]> writes: > >> Greetings, >> ... >> Is there ANY way to override this behaviour? Or must I simply initialize all >> such fields explicitly if I would like to set it to the current date

Re: [sqlite] CURRENT_DATE Behavior

in or across different countries. It also means you can subtract two times and always get the right answer for elapsed time ! Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Case Insensitive Comparison for Double Byte Characters

g/gmane.comp.db.sqlite.general/41826/focus=41843 Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Can you perform an ATTACH-type operation just using DB handles ?

r-off between separate COMMITs BEGIN; ... UPDATE db1 BEGIN; ... UPDATE db2 ... all well so far ... COMMIT db1; ... still OK ... hope no power fail here ! COMMIT db2; ... made it ... Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Transaction across different DB handles return s SQLITE_INTERNAL

7;s the best way, given I have two separate handles ? Make them separate Transactions and do a ROLLBACK on the first if the second exec fails, possibly ? Thanks, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best tutorial on sqlite/relational databases?

t (with some implementation dependencies ...) so don't ignore sections that reference e.g. Linux, the principles are pretty much the same. MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Questions about "analyze"

Thanks for feedback! > Don't have the source to hand, but it's possible that SQLite does indexes by hash, in which case it wouldn't "know" that the field values are all the same, just that they had the same hash-value, hence it will have to do a

Re: [sqlite] Multiple Selects

iciently accessed container in memory ... Incidentally, I trust your query is "SELECT name FROM table WHERE id = ?" and you are doing a sqlite3_bind() each time, no need to re-prepare the statement every time !! Regards, MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to install SQLite on a shared linux hosting

ite.org/sqlite.html for manual queries - but this is not a server, as you say ! MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to speed up read-only databases?

o there is always a tradeoff. (Techie note http://20bits.com/2008/05/13/interview-questions-database-indexes/) MikeW ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to speed up read-only databases?

was set ? The doc suggests this speeds things up ... You are not clear about which aspect is slow - are you already using sqlite3_bind_x() and placeholders (?) in your SQL statements ? Doing a sqlite3_prepare every time you do a query can slow things down. Sorry if you are alre

Re: [sqlite] Can you perform an ATTACH-type operation just using DB handles ?

John Belli <[EMAIL PROTECTED]> writes: > > On Thu, 16 Oct 2008 17:54:52 + (UTC), MikeW > <[EMAIL PROTECTED]> wrote: > > >My code has two pre-opened DB connection handles, and would like to > >perform an SQL operation over the two databases. > >The DB

[sqlite] Can you perform an ATTACH-type operation just using DB handles ?

My code has two pre-opened DB connection handles, and would like to perform an SQL operation over the two databases. The DB filenames are not available at this point, hence an ATTACH is not feasible. Is there any way to achieve this by applying an ATTACH at the handle level ? Regards, MikeW