Re: [sqlite] JSON indexing

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

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] 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 the reasoning behind it nor

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

-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

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] 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,length from table where start = @input order by binary desc

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

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 when using this syntax. -- Cory Nelson http://int64.org ___ sqlite

Re: [sqlite] Faster query result

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

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 Nelson http://int64.org ___ sqlite

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? -- Cory Nelson http

Re: [sqlite] A matter of UNIQUEness

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?

be avoided early in the design, why not? Okay. I'm done bike shedding ;) -- 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?

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 treat blobs as 0-terminated strings. -- Cory Nelson http://int64.org

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

. 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 please don't use is nonsense. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] SQLite Amalgamation

with LTO turned on will give the same effect as the amalgamation. (ie. faster and smaller code) -- 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] Feature request: Fuzzy searching

with LCMapString/LCMapStringEx, I'm sure ICU has a similar API. -- 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] How to Use an Apostrophe in a Text Field?

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. -- Cory Nelson http://int64.org

Re: [sqlite] Extremely large values error

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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

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 and recently some of my complex queries where I

Re: [sqlite] Capitalisation

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()

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. -- Cory Nelson http://int64.org

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

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

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

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

be deleted. Hi Ian, Try WHERE idpreviousid 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

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

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, run CREATE INDEX manually. -- Cory Nelson http://int64.org

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 query that will do a full table

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

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 even has another option -- an indexed view. -- Cory Nelson http://int64.org ___ sqlite-users

Re: [sqlite] partial index?

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-users@sqlite.org http

Re: [sqlite] partial index?

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] Statistics on integer primary key

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. -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] composite PK vs. single PK

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 name. -- Cory Nelson http://int64.org

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 gotcha, any disadvantage (query complexity, db size, query

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

, 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] 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 SQLite can take, please? SQLite

Re: [sqlite] SQLite performance with lots of data

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?

* 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

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

(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] STL and SQLite

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] server process gives better concurrency - why?

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] ANN: SQLite 3.6.16.C#

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 list sqlite-users

Re: [sqlite] toupper/tolower

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 ?

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 databases depend on. -- Cory Nelson http://int64.org

Re: [sqlite] SQLite version 3.6.14

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)

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 list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] Vacuum needed?

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@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

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

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?

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

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 drh's version. -- Cory Nelson

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

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:8080/cgi-bin/mailman/listinfo

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

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] wrote: On Sun, Aug 24, 2008 at 12:07 AM, Derek

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

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 mailing list sqlite

Re: [sqlite] sqlite DB creation performance

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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] What is faster?

___ sqlite-users mailing list 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

Re: [sqlite] Unicode searches

-- 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] 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:42 PM, Cory Nelson [EMAIL PROTECTED] wrote

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

appreciate a couple of tips so I can get back on track with my project. Not without digging through the internals. You might be interested in Berkeley DB. -- Cory Nelson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

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

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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

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

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 ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Sorting Japanese records

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?

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. -- Cory Nelson

Re: [sqlite]For best Fragementation

-trees (the internal file structure sqlite uses) work, it is very hard to use up 100% of the space. Vacuuming will only free empty pages and won't solve this. -- Cory Nelson http://www.int64.org - To unsubscribe, send

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

it. -- Cory Nelson http://www.int64.org

Re: [sqlite] benchmarking UTF8 vs UTF16 encoded databases

that would be encoded with = 2 UTF-8 code units. -- Cory Nelson

Re: [sqlite] Trying to build a static library

no reason for that to fail. -- Cory Nelson - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Proposed sqlite3_initialize() interface

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 useful failure information on platforms which can err. -- Cory Nelson

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

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

Re: [sqlite] Unicode Capabilities in Simple Terms

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?

. 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 errors a commit should always succeed. -- Cory Nelson

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

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 yourself define. -- Cory Nelson

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

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?) Thanks, Miguel Fuentes -- Cory Nelson - To unsubscribe

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

correct, ive been getting the occasional weird SQLite error, I was just wondering if my build is not a bit buggy, I have added the THREADSAFE in the defines though so I don't think it is, just don't want to corrupt my db's. The warnings are normal - the author thinks they are spurious. -- Cory

Re: [sqlite] Is SQLite Case Sensitive?

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

Re: [sqlite] strategy adding indexes

, Bharath Booshan L. -- Cory Nelson - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] sqlite internationalization

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

Re: [sqlite] sqlite3_open (new Win32 thread)

use the syntax CREATE TABLE IF NOT EXISTS? - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cory Nelson http://www.int64.org

Re: [sqlite] massive insert

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

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

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

Re: [sqlite] building sqlite.lib

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

Re: [sqlite] Re: speeding up a query

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

Re: [sqlite] starting with unicode

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

Re: [sqlite] concurent writes and locks

-- --- | Eric van der Maarel | | [EMAIL PROTECTED]| ---^[ZZ -- Cory Nelson http://www.int64.org

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 things may give unexpected results if you use it. Oh really

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 reliably in my experience. SQLite

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 respect the current locale and use

Re: [sqlite] RE: UNICODE Support

- 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.int64

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?

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

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

, is BETWEEN in general faster when using SQLite? The second question is what happens with the statement BETWEEN 1 AND 1. It seems to be that this statement using SQLite is identical with the equality operator. But on another SQL system I made the experience that this is not the case. Hartwig -- Cory

Re: [sqlite] Delete performance vs. Insert performance

come the delete operation is independent of cache size? I think the updating indices costs are almost same in both insert and delete operations. Can anybody explain the reason? -- Insun Kang -- Cory Nelson http://www.int64.org

Re: [sqlite] What wrapper for SQLite?

used to worrying about. I don't think it's right to recommend using it when there are wrappers tailored to keep the dev thinking in their own lang. You certainly don't gain anything by using the flat API over a wrapper, unless the wrapper is bloated/buggy! -- Cory Nelson http://www.int64.org

Re: [sqlite] scary warnings

test suite with sqlite I'm not concerned. This is much more rigrourous than most any other product I've worked with. -- Cory Nelson http://www.int64.org

Re: [sqlite] scary warnings

On 5/22/06, Nuno Lucas [EMAIL PROTECTED] wrote: On 5/22/06, Cory Nelson [EMAIL PROTECTED] wrote: The warning is likely because size_t can be 64bit and int is always 32bit. Either way, it should be casted. Not really, size_t can be 64 or any other size in bits and same with int's. He

Re: [sqlite] MMAP

know the performance impact of having a considerable number of mmap'd files attached to a single process in Unix/Linux and Windows? Has anyone tried such a strategy? My guess is that the impact is not great, but I have no evidence in support. JS -- Cory Nelson http://www.int64.org

Re: [sqlite] Probably, bug in SQLite (Or, what is wrong with this query?)

) where D1.product_name D2.product_name group by D1.product_name, D2.product_name But (IMHO) original query is also correct. Is I'm mistaken? -- Best regards, Alexandermailto:[EMAIL PROTECTED] -- Cory Nelson http://www.int64.org

[sqlite] case insensitive index

Is this possible? I want to index a column so doing col = 'cAt' will match with 'cat'. -- Cory Nelson http://www.int64.org

  1   2   >