Re: [sqlite] New word to replace "serverless"

lf, using the callers stack, then returns control to the caller. > > So what do I call this, if I can no longer use the word "serverless" > without confusing people? > > "no-server"? > "sans-server"? > "stackless"? > "

Re: [sqlite] Defect: Redundant CTE table materialization gives wrong answer.

>> > | query than an ordinary subquery. >> > >> > This is an implementation detail of Postgres, and it is not required by >> > the SQL specification. SQLite chose the other side of the coin. >> > >> > >>

Re: [sqlite] Yes, NULL is zero, is it?

t; I’m not saying this is the problem here, merely that it deserves a mention. If you're in any slightly modern compiler, always use nullptr instead of NULL. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite

Re: [sqlite] Bug: SQLite's include guards are reserved identifiers

he C > standard, this is a reserved identifier, leading to undefined behavior: While uncommon, it is not unheard of for apps to use include guards to check for a library's existence. While it is indeed not in compliance, in practice fixing this may affect existing SQLite users

Re: [sqlite] Currency & SQLite

ant arithmetic on the value, because although your low precision offers quite a lot of wiggle room, the error could in theory grow large enough to be a problem if you're not careful. -- Cory Nelson ___ sqlite-users mailing list sqlite-users@mailinglists.

[sqlite] Why SQLite take lower performanceinmulti-threadSELECTing?

on to have parallel I/Os and can make a big difference depending on your storage type. SSDs can read multiple NAND chips at once, HDDs can start moving the head to the next location as soon as possible, etc. Though, I'm not sure how applicable this is to iOS development. -- Cory Nelson http://int64.org

Re: [sqlite] JSON indexing

cumentDB modifies SQL to work pretty well with unstructured JSON. This might provide some inspiration. http://azure.microsoft.com/en-us/documentation/articles/documentdb-sql-query/ -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GROUP BY: ambiguous column name?

at 2:02 PM, Mark Lawrence <no...@null.net> wrote: > On Thu Sep 25, 2014 at 01:43:20PM -0500, Cory Nelson wrote: > > > GROUP BY works on your input data, not output data. You want to GROUP > > BY COALESCE(x.id, y.id) > > That describes the behaviour I demonstrated, but not

Re: [sqlite] GROUP BY: ambiguous column name?

id > > ; > > Sorry, that should read GROUP BY of course. > > -- > Mark Lawrence > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Cory Nelson http://int64.org _

Re: [sqlite] Is 32bit SQLite limited to 1900mb RAM in windows?

__ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] slowish R*Tree performance

On Wed, Jun 18, 2014 at 3:00 PM, Eric Rubin-Smith <eas@gmail.com> wrote: > Cory Nelson wrote: > > > Expand the prefix into the full feed:beef::etc > > > > Insert into a table (start binary(16), mask_length int) > > > > select top 1 binary,len

Re: [sqlite] slowish R*Tree performance

, mask_length int) select top 1 binary,length from table where start <= @input order by binary desc Check if the row is inside the range returned. This will take a single index seek. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] select 1 where 1 - 1;

ion that doesn't have any non-standard features or quirks. As an Open Source project, you're always develop patches. I think pluggable parsers would actually be pretty interesting. Alternately, you might inquire ways to contribute to documentation what to expect

Re: [sqlite] Faster query result

query will perform 31 comparisons. - Dates are not strongly-typed in SQLite, so this will perform string comparisons without any special handling. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 4

Therefore I'm very interested in an early idea about performance. > Even if it's not ready, I could at least prepare it better for a later > switch. A daily amalgamation would be pretty cool. I'd love to start playing around with LSM. -- Cory

Re: [sqlite] Which C++ data structures might one use to cache a sqlite query result?

On Thu, Jan 24, 2013 at 9:31 AM, Frank Chang <frankchan...@gmail.com> wrote: > Could anyone suggest which C++ data structure to use to cache a sqlite > query result? Thank you for your help This is too vague, you'll need to provide more information. What have you tried so far? --

Re: [sqlite] A matter of UNIQUEness

n those columns used in the key. it doesn't do anything to affect transactions. primary keys are unique, yes. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Consequences of lexicographic sorting of keys in SQLite4?

etween two (often disconnected) databases. Admittedly 3 bytes of overhead in this case is probably not going to be a huge deal, but if a 19% overhead can be avoided early in the design, why not? Okay. I'm done bike shedding ;) -- Cory Nelson http://int64.org

Re: [sqlite] Consequences of lexicographic sorting of keys in SQLite4?

phical ordering of the keys to correspond to what the > user wants out of ORDER BY. So indices can still be used for fulfilling > ORDER BY. > What is the rationale for the 7-bit BINARY encoding? The performance impact will surely outweigh any convenience of being able to t

Re: [sqlite] SQLite4 (don't scream)

-in replacements available here: > http://code.google.com/p/msinttypes/ stdint was made available in VC++ 2010, though inttypes is still missing. Probably not an issue -- I'm not sure how a public API would need inttypes anyway. Also, perhaps you are seeing size_t be misused. A blanket "

Re: [sqlite] SQLite Amalgamation

"not recommended". > > > The compile will take longer, but using the non-amalgamation source with LTO turned on will give the same effect as the amalgamation. (ie. faster and smaller code) -- Cory Nelson http://int64.org ___ sql

Re: [sqlite] Feature request: Fuzzy searching

/389336 > Such functionality requires a good bit of Unicode support and can be locale-dependent. I doubt such a large feature would ever get built into SQLite. However, all is not lost -- this behavior can be had easily in SQLite as-is, using custom collations or sort keys. I'm currently using th

Re: [sqlite] How to Use an Apostrophe in a Text Field?

n? I'm guessing you're making a statement like INSERT INTO foo VALUES('Goin' Down the Road Feelin' Bad'), which obviously won't work. You should instead use prepared statements, which do not have this problem. An alternative is to escape your input, but that is still error-prone and slower. --

Re: [sqlite] Extremely large values error

On Tue, Mar 29, 2011 at 4:05 AM, Cory Nelson <phro...@gmail.com> wrote: > On Tue, Mar 29, 2011 at 1:48 AM, Max Vlasov <max.vla...@gmail.com> wrote: >> Hi, >> >> I sometimes use repeated digits as test data, for example 123456789 repeated >> multiply times

Re: [sqlite] Extremely large values error

deep investigation especially for long queries to understand what is > going on. Not a bug. The REAL datatype (which FLOAT maps to) is an 8-byte IEEE "double". It supports a maximum of about 16 digits -- nowhere near your 310. -- Cory Nelson http://int64.org

Re: [sqlite] Capitalisation

can enable ASCII case-insensitivity using COLLATE NOCASE in your SELECT statement, or as a property of the column in your CREATE TABLE statement. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Windows performance problems associated with malloc()

egrated with the low-frag heap. It might be work investigating a new allocator for sqlite that calls HeapCreate and related stuff to get its own low-frag heap, however my understanding is that on some versions of Windows there are heuristics to automatically switch over from the default. --

Re: [sqlite] Windows performance problems associated with malloc()

ciency improvement would be a plus. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] UTF-8

Just a quick note -- TCHAR is not always UTF-16, and sqlite3_bind_text16 takes a void* so it will happily take whatever you give it. You should be using wchar_t directly instead of TCHAR, so an error can be caught when you use GetWindowText. -- Cory Nelson http://int64.org On Thu, Dec 16, 2010

Re: [sqlite] Incrementing a counter vs adding a row

ed to do a SELECT first. Do an UPDATE SET number=number+1, and check the returned number of modified rows. If it returns 0, do the INSERT. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Create Read-only Database

e a choice between the > two options. -- Darren Duncan +1 -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting the next row

antee that id + 1 exists, as it may be deleted. > Hi Ian, Try WHERE id>previousid ORDER BY id LIMIT 1. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Performance problems and large memory size

f how i tweaked batch size, context lifetime, and garbage collection. I'm sure there's a way around it documented somewhere--perhaps it's related to change tracking. Maybe you're running into the same issues. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Automatic index detail

On Wed, Sep 15, 2010 at 8:25 PM, Roger Binns <rog...@rogerbinns.com> wrote: > On 09/15/2010 06:00 PM, Cory Nelson wrote: >> SQLite doesn't support automatic indexing, > > And your basis for that claim is? > This might not be doing what you think it is. When you have a q

Re: [sqlite] Automatic index detail

DEX on (weight, colour) > > This would make it a lot easier to manually or automagically create indices > if I know my queries in advance. SQLite doesn't support automatic indexing, are you sure SQLite is what you're using? If you already know which columns to create an index on,

Re: [sqlite] returning smaller subset of columns: index vs trigger

ce in the future? Both are commonly used in the wild. Indexes have the added bonus over triggers that you'll have less of your own code to test and maintain, so I usually end up using them if I can. I reserve triggers for more complex operations. SQL Server

Re: [sqlite] partial index?

d by it is acceptable. Ie. if 99% of your rows have "isindexed=1", you've got a lot of redundant columns taking up space and might investigate JOINing with another smaller table instead. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] partial index?

here's not really any good solution. You can create a separate table with the subset in it, that's pretty much it. But that has some overhead too, and can complicate your queries. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-

Re: [sqlite] Statistics on integer primary key

dexes on a(num) and b(num) and analyzing the database both > queries take 0.0. > > Why SQLite does not maintain statistics for rowid indexes? I can't remember where I saw it, but such optimizations were left out of SQLite intentionally -- it's expected that the programmer should optimize things

Re: [sqlite] SELECT query performance : One big table Vs many small tables

The exception being that if your tables are stored on separate disks, you may be able to get better concurrent performance. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] composite PK vs. single PK

On Fri, Jun 25, 2010 at 7:39 AM, P Kishor <punk.k...@gmail.com> wrote: > Thanks Cory. > > On Fri, Jun 25, 2010 at 9:07 AM, Cory Nelson <phro...@gmail.com> wrote: >> On Fri, Jun 25, 2010 at 6:49 AM, P Kishor <punk.k...@gmail.com> wrote: >>> Is there any

Re: [sqlite] composite PK vs. single PK

mposite keys don't have any penalty over single-column keys. Single integer primary keys you get for free. They take no extra storage or complexity because in SQLite every table already has one even if you don't use it (called a "rowid"). Specifying one merely gives it a new na

Re: [sqlite] SQLite performance with lots of data

On Fri, Oct 2, 2009 at 12:34 PM, Cory Nelson <phro...@gmail.com> wrote: > On Fri, Oct 2, 2009 at 9:45 AM, Francisc Romano <fran...@gmail.com> wrote: >> Wow. I did not expect such a quick answer... >> Is there somewhere I can read exactly how fast and how big databases

Re: [sqlite] SQLite performance with lots of data

mplexity. Every time your dataset doubles in size, worse-case performance will be halved. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Comparing two tables?

re complex (but still pretty simple) join. SELECT * FROM t_foo EXCEPT SELECT * FROM t_bar; -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite database on a certain high-performance "SSD"

concurrent reads might help. And of course, make sure you're using transactions to group operations. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] server process gives better concurrency - why?

FS and the like -- if you wanted to keep it an embedded library (with no server), you'd have to drop support for that. PS. please stop top posting! -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] server process gives better concurrency - why?

Multiple processes has nothing to do with it, other than the usual increases in complexity that would be added to any app. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] STL and SQLite

more portable, you can easily use SQL types directly. create table foo(key integer, value integer); create index foo_keys on foo(key); -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ANN: SQLite 3.6.16.C#

can be pretty slow and is not portable. Another, it is basically a direct port of the C code -- it is using goto all over the place, which probably hampers optimization as opposed to exceptions. -- Cory Nelson http://int64.org ___ sqlite-users mailing

Re: [sqlite] toupper/tolower

equire locale support and passing in a string pointer, not a char. Even a wide character can't store all the information needed to make something upper/lower. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite on a Virtual Machine of Microsoft's Hyper-V ?

would be if the (essential) file locking > and sync/commit commands will still do the intended job > within a virtual machine. > > Any experience with this ? > My experience has been that VMs strongly focus on correctness and reliability, and will obey sync orders and everything else

Re: [sqlite] SQLite version 3.6.14

ee INSERT DELAYED)? Or maybe "deferred", I always thought that was a better name for it. Thanks for the new release! -- Cory Nelson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

t to database.tell me if there any > wrapper classes which I can use and also provide me documentation about > those clases and functions present in it and how to use them. > Wtf, is this a joke? :/ -- Cory Nelson ___ sqlite-users mailing lis

Re: [sqlite] Vacuum needed?

database size by removing empty pages. sqlite will normally reuse empty pages - so vacuum is only useful if you don't plan to insert anything else, otherwise it will be slower. -- Cory Nelson http://www.int64.org ___ sqlite-users mailing list sqlite-users@sql

Re: [sqlite] How to bind a tinyint so that actually uses 1 byte?

in a variable-length encoding. 1 byte stores 7 bits, 2 stores 14 bits, etc. 9 bytes maximum. -- Cory Nelson http://www.int64.org ___ 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?

menting the cache size for Sqlite do > something? > > Grateful for any info, > > -- > Christophe Leske -- Cory Nelson http://www.int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] equality searches and range searches with encrypteddata

this to learn and will really be storing people's credit cards and socials: you are not knowledgeable enough in this area to be writing any production encryption code. Doing so would be a disservice to any customers. Definitely use available tested code in this case, like d

Re: [sqlite] equality searches and range searches with encrypted data

ou thinking it needs to decrypt the entire database for each query? If so - that's not the case. XTS (or some method like it) is used, where each page can be decrypted by itself so you end up with the exact same amount of I/O as a non-encrypted DB. > > Cory Nelson <[EMAIL PROTECTED]&

Re: [sqlite] equality searches and range searches with encrypted data

ss the column data for each record... > no functionality is lost. pages already need to be parsed - encryption can just be thought of as another phase of this parsing. -- Cory Nelson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] sqlite3 3.5.9 floating point division seems odd

oating point expressions in a way that might trivially change the output while being faster. so (a * b + a * c) would be transformed into (a*(b+c)), which could give different results due to rounding. -- Cory Nelson http://www.int64.org ___ sqlite-users

Re: [sqlite] sqlite DB creation performance

tore a duplicate of the data they are indexing, so each of those indexes are copying a large portion of data. One way to improve size might be to have a separate table just mapping strings to integers, and use integers in your main table. -- Cory Nelson http://www.int64.org __

Re: [sqlite] What is faster?

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

Re: [sqlite] Unicode searches

They are one and the same. Look up collations. On Sat, Apr 5, 2008 at 2:55 PM, Keith Stemmer <[EMAIL PROTECTED]> wrote: > That was not was I was talking about. I was not talking about Sort Order but > about Searches. > Keith > > > > On Sat, Apr 5, 2008 at 11

Re: [sqlite] Unicode searches

sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Cory Nelson http://www.int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there direct (non SQL) table access?

es["Classification"] = "Retired"; > pDB->Post(); > } > pDB->Next(); > } > > fclose(fp); > sqlite3_close(pDB); > > I'd really appreciate a couple of tips so I can get back on track with my > project. Not without digging th

Re: [sqlite] [3.5.4] Why doesn't filesize change?

f clusters, ie. pre-reserved space, which > would explain this? SQLite allocates space in pages. If an insert doesn't require allocating a new page, the file size won't grow. -- Cory Nelson ___ sqlite-users mailing list sqlite-users@sqlite.org h

Re: [sqlite] deleting syntax w/ PHP's PDO

bove. Where > might I go to learn more about the ? way of doing a delete? > It is not any more secure, just more foolproof. You don't have to worry about injection attacks and it might even be faster, especially if you re-use the statement. -- Cory Nelson ___

Re: [sqlite] Sorting Japanese records

e, as both are in lexicographical order (ie, あかさたなはまやらわ) which is what sqlite uses by default. -- Cory Nelson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How Does NOT NULL produce NULLs?

uce the following data: > > > > (null)|(null)|(null) > > > > I am unable to replicate the problem. Are you sure you don't > have a bug in *your* code? It looks to me like he is passing a null pointer to printf. -- Cory Nelson - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Performance of Unique Index

On Jan 28, 2008 2:45 PM, Alexander Batyrshin <[EMAIL PROTECTED]> wrote: > Hello All, > Is there any difference in speed of access for unique and usual index? no, it is only a constraint when inserting. --

Re: [sqlite]For best Fragementation

gt; file. > Can any one please help. > > > Best Regards, > A.Sreedhar. > > The way b-trees (the internal file structure sqlite uses) work, it is very hard to use up 100% of the space. Vacuuming will only

Re: [sqlite] Possible UNICODE LIKE, upper(), lower() function solution

s that there is no One solution. Locales are there for a reason - different places can use different sort orders and case conversions. Your blog makes using locales seem as a detriment, but I'm not sure how you can get around it. -- Cory Nelson http://www.int64.org

Re: [sqlite] benchmarking UTF8 vs UTF16 encoded databases

y good if you have a lot of text that would be encoded with >= 2 UTF-8 code units. -- Cory Nelson

Re: [sqlite] Trying to build a static library

as C++. Otherwise I see no reason for that to fail. -- Cory Nelson - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Proposed sqlite3_initialize() interface

ng that an > > application invoke: > > > > int sqlite3_initialize(...); > > > > I am not sure about the systems that you are trying to support, but for > gnu tool chain you can do: You may have noticed that the purpose of this function is to return some usefu

Re: [sqlite] any way to SELECT the 100th-104th row of a table?

gt; -- > PGP/GPG: 5C9F F366 C9CF 2145 E770 B1B8 EFB1 462D A146 C380 > > - > To unsubscribe, send email to [EMAIL PROTECTED] > ----- > > -- Cory Nelson http://www.int64.org - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Unicode Capabilities in Simple Terms

ex/sort text according to a language you will need to give it a custom collation (which is not hard) otherwise it will use an ordinal comparison. -- Cory Nelson - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Can I simulate a COMMIT?

tegrity checks should be deferred until a > COMMIT. Is there a way to tell whether the COMMIT will succeed under the > current conditions so that I can safely delete the file? My understanding is that if your first insert succeeds you hold a write lock on the table and barring any exceptional err

Re: [sqlite] Re: select round(98926650.50001, 1) ?

gt; libc does it by default, but the official sqlite compiled version > (which IIRC is linked with the old Microsoft C runtime DLL) doesn't. it is defined by the compiler to indicate that it conforms. it is not something that you you

Re: [sqlite] Sqlite 3.4.2 and VC++ : lib size too big

I don't know if that really makes > any difference) > > It's quite big comparing to the .exe supplied for windows > ( by the way, how was sqlite3.exe - - compiled? which compiler and settings > were used?) > >

Re: [sqlite] SQLite Build in M$ Visual Studio 250+ warnings

uthor thinks they are spurious. -- Cory Nelson - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Is SQLite Case Sensitive?

> To unsubscribe, send email to [EMAIL PROTECTED] > ----- > > -- Cory Nelson http://www.int64.org - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] strategy adding indexes

,b,c,d) will be used to help with queries testing either (a), (a,b), (a,b,c), or (a,b,c,d). > Regards, > > Bharath Booshan L. -- Cory Nelson - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] realloc size smaller than malloc size?is it error in vc6?

.zhang -- Cory Nelson - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] sqlite internationalization

il has the best spam protection around http://mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cory Nelson http://www.int

Re: [sqlite] sqlite3_open (new Win32 thread)

but is there a reason you can't use the syntax CREATE TABLE IF NOT EXISTS? - To unsubscribe, send email to [EMAIL PROTECTED] ----- -- Cory N

Re: [sqlite] massive insert

ano.cu/ - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cory Nelson http://www.int64.org

Re: [sqlite] Concurrency with writer and read-only processes

eciated. Thank you. Liam - To unsubscribe, send email to [EMAIL PROTECTED] ----- -- Cory N

Re: [sqlite] building sqlite.lib

l to [EMAIL PROTECTED] ----- -- Cory Nelson http://www.int64.org - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: speeding up a query

ps://edu.osgeo.org/ > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/ Open Source Geospatial Foundation https://edu.osgeo.org/ - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cory Nelson http://www.int64.org - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] starting with unicode

[EMAIL PROTECTED] ----- -- Cory Nelson http://www.int64.org - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] concurent writes and locks

ocedure in thread A correct: just wait and recall the >> sqlite3_step(). Maybe this is the reason of the behaviour we see in >> thread >> B? How to overcome that situation then? >> >> Eric >> > > > -- ------- | Eric van der Maarel | | [EMAIL PROTECTED]| ---^[ZZ -- Cory Nelson http://www.int64.org

Re: [sqlite] UNICODE Support

On 8/4/06, Trevor Talbot <[EMAIL PROTECTED]> wrote: On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote: > But, since you brought it up - I have no expectations of SQLite > integrating a full Unicode locale library, however it would be a great > improvement if it would respe

Re: [sqlite] UNICODE Support

On 8/4/06, Nuno Lucas <[EMAIL PROTECTED]> wrote: On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote: > IE, using memcmp() to compare strings. I've been bitten by this > before, with SQLite producing unexpected results when using UTF-8. > Using UTF-16 has worked more reli

Re: [sqlite] UNICODE Support

On 8/4/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Cory Nelson" <[EMAIL PROTECTED]> wrote: > On 8/3/06, RohitPatel <[EMAIL PROTECTED]> wrote: > > I recommend using utf-16 in the database - sqlite doesn't fully > support utf-8, and some thing

Re: [sqlite] RE: UNICODE Support

tabase - sqlite doesn't fully support utf-8, and some things may give unexpected results if you use it. Thank you for any help. Rohit -- View this message in context: http://www.nabble.com/UNICODE-Support-tf58444.html#a5644461 Sent from the SQLite forum at Nabble.com. -- Cory Nelson http://www

Re: [sqlite] UTF8

ASCII is completely valid UTF-8, so no conversion is necessary. On 7/26/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: How can i know if a given text is UTF8 or ascii? and how can i convert between ascii to UTF8? -- Cory Nelson http://www.int64.org

Re: [sqlite] locked implies exception?

efault is to return SQLITE_BUSY immediately. -- Cory Nelson http://www.int64.org

Re: [sqlite] Is BETWEEN faster than comparison operators?

se. Hartwig -- Cory Nelson http://www.int64.org

  1   2   >