[sqlite] Setting a "profile" callback cause empty result

Using the Tcl interface with the "profile" callback set, "onecolumn" and "exists" returns empty result. In the code, in DB_EXISTS/DB_ONECOLUMN branch, Tcl_SetObjResult() is called before dbEvalFinalize(), inlike in the DB_EVAL branch. The profile callback is probably called inside

Re: [sqlite] SQLite in Android N

Official, but slightly vague: https://developer.android.com/preview/behavior-changes.html#ndk >From Xamarin: https://developer.xamarin.com/releases/android/xamarin.android_6/xamarin.android_6.0/ -- E On Mon, Jun 6, 2016 at 12:40 PM, Jason H wrote: > > It is my understanding

[sqlite] SQLite in Android N

It is my understanding that Android N will no longer allow apps to use the system-installed SQLite library (unless they go through the Android Java API, android.database.sqlite). This is unfortunate, as many existing Android apps do access libsqlite3 directly and will crash on Android N. Apps

Re: [sqlite] Fastest way to add many simple rows to a table?

ar case, but being able to insert straight from json is something I will definitely use knowing it's faster than doing it with code (all APIs that revolve around running queries on input data would be a perfect fit). Eric On Tue, May 31, 2016 at 3:32 PM, Gabriel Corneanu <gabrielcorne...@gmai

[sqlite] Version issues on Mac after updating

is executing the wrong version, would be very welcome. Thanks, Eric Kestler ekest...@gmail.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fastest way to add many simple rows to a table?

rings. So "insert from select" seems to have some avantage, and I was wondering if there are other ways to leverage it? On Fri, May 27, 2016 at 12:29 AM, Dominique Pellé <dominique.pe...@gmail.com > wrote: > Richard Hipp <d...@sqlite.org> wrote: > > > On 5

[sqlite] Fastest way to add many simple rows to a table?

isfy my need, but I am curious is there is another approach that could be suggested? (without involving a custom function) Eric ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

ort of a "War As I Knew It" but for programming. :-) And if any of you know of other programmer role models of Richard's caliber, please do share pointers! Eric

[sqlite] Extended Text Functions

. For the record, I'm not a C programmer, and have no idea how to go about compiling and linking external function libraries using u*ix; I use a Mac, and while OS/X has a u*ix ancestor, there are no clear step-by-step instructions on how to compile and link on a Mac that I've found. Thank you, Eric

[sqlite] Fwd: ImportError: /usr/lib/libgdal.so.1: undefined symbol: sqlite3_column_table_name

Make sure SQLITE_ENABLE_COLUMN_METADATA is on when you compile SQLite. Eric -Original Message- From: "Tinashe Mudavanhu" <tinam...@gmail.com> Sent: ?3/?30/?2016 8:57 AM To: "sqlite-users at mailinglists.sqlite.org" Subject: [sqlite] Fwd: ImportError: /usr/l

[sqlite] custom collation sequence for numeric columns?

. Anybody care about this besides me? Thanks! Eric

[sqlite] Are BLOB stored inline with the rest of the record fields?

inal Message- > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > > bounces at mailinglists.sqlite.org] On Behalf Of Eric Grange > > Sent: Thursday, March 03, 2016 3:16 AM > > To: SQLite mailing list > > Subject: Re: [sqlite] Are BLOB stored inline wi

[sqlite] Are BLOB stored inline with the rest of the record fields?

> All BLOBs are stored inline. The only complication comes when the total row length is longer than a page. Ok thanks! That is besides my original question but what is the complication in that case? Is the blob partially stored in the row, or is some indirection to other pages used, with only

[sqlite] Are BLOB stored inline with the rest of the record fields?

Hi, I am wondering if very small BLOBs are stored inline with the record fields (in the same page) or in another page? So far I had not worried about it, but now I have a usage case where I need to store 128 and 256 bit integers (numbers, not IDs or hashes), SQLite does not support such large

[sqlite] Encrypt the SQL query

reat you are trying to mitigate. Eric

[sqlite] MIN/MAX of column loses decltype

can tell). We have written our own SQL date functions anyway. So maybe I can just avoid this issue entirely. Eric -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Monday, Februa

[sqlite] MIN/MAX of column loses decltype

mmon I suspect) case of the simple MIN() or MAX() of a column, it's just not possible to preserve the decltype? Thanks! Eric

[sqlite] determining is-leap-year in sqlite

> > > select 2, 28 + (CAST(strftime("%j", c.year||"-12-31") AS INTEGER) % 365) > Here you assume that all years have either 365 or 366 days. Would that it were so! Look at the year 1752 -- you may notice something odd happened that September. :-) Eric

[sqlite] Performance comparison between SQLite and SQL Server?

IME when SQLite is applicable (mostly the one writer limit), it usually runs circles around to server DBs, provided: - you have comparable CPU - you have enough cache memory, or free RAM for OS disk caching, to be in a comparable memory scenario - you do not have a virtualisation layer, especially

[sqlite] Performance comparison between SQLite and SQL Server?

Just for fun: I know a friend who has a Ferrari. It is faster than my Ford F-150. Unless we are racing with both vehicles pulling a 7,000 pound trailer uphill. Then I would probably win. Thousand-mile trip? Take a sports car. Moving a couch a thousand miles? Use a pickup truck. SQLite is

[sqlite] CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP

they are documented on the Date And Time Functions page even though they are technically keywords. Thanks! Eric

[sqlite] Can't create LEFT or RIGHT functions with sqlite3_create_function()

That's fair. Thanks for looking into it. I can create JLEFT and JRIGHT or something, or just direct people to SUBSTR. There are reasonable workarounds. Thanks, Eric -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun

[sqlite] Can't create LEFT or RIGHT functions with sqlite3_create_function()

am trying to support SQL syntax that users of my product are already familiar with. But if it just has to be this way, I'll live. Thanks, Eric

[sqlite] json1 not escaping CRLF characters

Thanks! I can make do with replace() for now (as in my particular case, I only have CRLF & TAB to replace) On Thu, Feb 4, 2016 at 11:39 AM, Richard Hipp wrote: > On 2/4/16, Richard Hipp wrote: > > On 2/4/16, Eric Grange wrote: > >> Hello, > >> > >&

[sqlite] json1 not escaping CRLF characters

oded as \r and \n respectively. Is it by design or an oversight? Is there a way around using the replace() function to fix it? (though I guess other control characters will have the issue, so multiple replace() would be needed) Eric

[sqlite] 10 minute Avg

A string's > storage needs at least one byte per character in the string. And the > format you're using for date/time stamps is longer than 8 characters long. > To be pedantic, an integer can take up to 9 bytes. https://www.sqlite.org/fileformat.html#varint Eric

[sqlite] Backing up SQLite DB with unbuffered I/O

ot be used for the source drive. Eric

[sqlite] SQLite database becomes corrupt on iOS

https://www.sqlite.org/howtocorrupt.html I know you said you already checked this, so just ignore the following remark: iOS is one of the easiest platforms to accidentally end up with "Multiple copies of SQLite linked into the same application". Just sayin'. -- E On Thu, Aug 13, 2015 at 2:04

[sqlite] Lawyers, encryption, and RC4

of RC4, it could perhaps shortcut these legal discussions for others. Thanks again! Eric -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, August 11, 2015 10:11 AM

[sqlite] Lawyers, encryption, and RC4

online that would suggest that is a valid position, but I'm wondering if this has come up before and if you have any good ammunition for dealing with such an argument. Thanks, Eric

[sqlite] Schema-less JSON SQLite DB?

r open source publication if there is enough interest. Eric

[sqlite] Segmentation faults when calling sqlite3_step

If you are calling sqlite3_bind_ to bind parameters, what are you passing as the last parameter? Try SQLITE_TRANSIENT to force SQLite to make a copy of the value right away. Maybe currently you have values going out of scope before step is called. Eric

[sqlite] Virtual tables/xBestIndex: Is this a bug?

called it all when there are no usable constraints). But perhaps there are still scenarios where an unusable constraint will show up. Eric -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Dan

[sqlite] Virtual tables/xBestIndex: Is this a bug?

ell game with this information. Thanks very much! Eric

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

rder SQLite dislikes. Thanks very much! Eric -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Hick Gunter Sent: Monday, June 08, 2015 10:21 AM To: 'General Discussion of SQLite Database' Subject: Re: [s

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

0f t5 (0,1) f 00400 N 1 cost 0,42,0 *** Optimizer Finished *** Thanks, Eric

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

Sorry, scratch that. T2 was not a virtual table when I ran this query. My bad. Told you I was a noob. Eric -Original Message- From: Eric Hill Sent: Wednesday, May 20, 2015 12:32 PM To: 'General Discussion of SQLite Database' Subject: RE: [sqlite] Virtual Table query - why isn't

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

Eric had said: >> But then what about a query like this: >> >>SELECT * FROM T1 >>LEFT OUTER JOIN T2 ON ( T2.a = T1.a ) AND ( T2.b = T1.b ) AND >> ( T2.c = T1.c ); >> >> xBestIndex will get called here for T1 with 3 constraints, c

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

g "Tell me about indexes that you already have available so I can take advantage of them", but in my case, I have *no* indexes, but I am willing to make whatever indexes would be most helpful, if I could just figure that out. Thanks again, Eric -Original Message- From:

[sqlite] SQLite not using primary key index anymore

While it happened I tested on 3.8.10.1 and 3.8.8.1 The DB is using WAL mode, and there were several connections to it, I suppose this might have interfered with the index or stats? On Tue, May 19, 2015 at 10:50 AM, Clemens Ladisch wrote: > Eric Grange wrote: > > I recently added a

[sqlite] SQLite not using primary key index anymore

this would not be too practical. On Tue, May 19, 2015 at 10:15 AM, Eric Grange wrote: > Hi, > > I recently added a field and index to an existing table, and now SQLite > seems to be using that index in place of the primary key, even on simple > queries > > Table declarat

[sqlite] SQLite not using primary key index anymore

appears. I did a pragma integrity_check, and it came out clean. This is with the precompiled sqlite.dll. Any ideas? Eric

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

Per Richard's request, I have produced the WhereTrace for the query that uses virtual tables and the same query that is not using virtual tables. That output is at the end of this message. Ultimately, I think my question is, how should I respond to xBestIndex such that SQLite will perform the

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

7 SEARCH TABLE actor AS t7 USING AUTOMATIC COVERING INDEX (actor_id=?) So, when SQLite has all the data, it figures out that it needs to use indexes, but when using my virtual tables, for some reason it doesn't. Still working under the assumption that it is my fault. Thanks, Eric

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

can do to make the debugger work? I will postpone index creation until the call to xFilter, I reckon, once I work out these other issues. Thanks for the tip! Eric -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

tables, it is taking > 25 seconds. Any thoughts on what I can do to convince SQLite to use my indexes? Thanks, Eric

[sqlite] xBestIndex() implementation question

SQLite enough information to optimize the query. Eric From: Jilong Kuang<mailto:jilong.ku...@samsung.com> Sent: ?Wednesday?, ?May? ?13?, ?2015 ?10?:?05? ?PM To: General Discussion of SQLite Database<mailto:sqlite-users at mailinglists.sqlite.org> Hello, I'm working on a project

[sqlite] Please confirm what I THINK I know about blobs

This approach: CREATE TABLE blob_table ( ModelNo TEXT, SerialNo TEXT, VSWR BLOB_DOUBLE ) involves comments? I don't see how. Nothing wrong with the comments approach, but this is an approach that just takes advantage of the fact that SQLite does not have fixed data types. Eric From

[sqlite] Please confirm what I THINK I know about blobs

understand it, SQLite only scans those type names to choose a column affinity, so you are free to be as creative with them as you want. sqlite3_column_decltype() will return whatever you put as the type. HTH, Eric Sent from Windows Mail From: William Drago<mailto:wdr...@suffolk.lib.ny.us>

[sqlite] What software is deployed more than SQLite?

Last time I asked myself this question, I ended up in the same place you did: zlib, libpng and libjpeg may be the only candidates in the same ballpark as SQLite. See also: https://news.ycombinator.com/item?id=4616740 -- E On Sun, May 3, 2015 at 1:18 PM, Richard Hipp wrote: > I'm trying to

[sqlite] json_* functions in sqlite

On Wed, Apr 22, 2015 at 2:17 PM, Eric Rubin-Smith wrote: > > On Tue, Apr 21, 2015 at 9:09 PM, Ashish Sharma > wrote: > >> Many times I store JSON data in sqlite. It will be useful if sqlite came >> with functions which understand JSON. Presto has a nice set >> ht

[sqlite] Regression in 3.8.9.0? Same row and rowid returned 2-3 times in SELECT with two ORDER BY keys

(Apologies if this gets posted twice.) The following ORDER BY query returns between 0 and 2 duplicates of each row, for 1 to 3 copies total, in 3.8.9 for Linux (CentOS). Otherwise, the returned rows are complete and correctly ordered. This database worked fine under 3.8.6. I can test other OSes

[sqlite] json_* functions in sqlite

endencies on other bits of my infrastructure and publish it somewhere. Let me know. Eric json2sqlite(1) Aterlo Networks, Inc. json2sqlite(1) NAME json2sqlite - convert JSON to SQLite database rows SYNOPSIS json2sqlite [OPTION]... DESCRIPTION Read arbitrary J

[sqlite] Multi-table index ersatz?

ot; solution. > It might be possible to write a virtual table module that does the same > as your index on C, but with C being a view. I had a look that way, but AFAICT virtual tables do not support indexing, so I would have to index manually. On Tue, Mar 3, 2015 at 4:57 PM, Dan Kennedy w

[sqlite] Multi-table index ersatz?

Yes A2 & B2 are already indexed (individually and in composite indexes) The problem is that this indexing is not selective enough when taken in isolation. Le 3 mars 2015 12:36, "Simon Davies" a ?crit : > On 3 March 2015 at 11:10, Eric Grange wrote: > > > > Hi, &

[sqlite] Multi-table index ersatz?

ther composite indexes. Is there a better way that would not involve duplicating the data? Eric

[sqlite] Appropriate Uses For SQLite

les to breakup a complex query in several simpler steps. I would say SQLite is perfectly suited for "front line" web servers that serve, present and generally make accessible live data coming from other systems. Eric

Re: [sqlite] unreached code in sqlite3.c?

compiler flag. In this case, I’d argue that the compiler is doing expressly what it was instructed to do. ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] write internal blob vs external file

sure that the file bytes are correct? And so on. All of those considerations are right in SQLite's wheelhouse -- I'd hate not to be able to take advantage of it. -- Eric A. Rubin-Smith ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] write internal blob vs external file

interested in the delete path. It seems like SQLite doesn't have much hope of competing with a native filesystem unlink(2) call to delete a file that is many gigabytes long, for example. Is that right? Eric References: http://sqlite.1065341.n5.nabble.com/Internal-v-External-BLOBs-td15515.html http://www.

Re: [sqlite] Final preparations for the release of System.Data.SQLite v1.0.94.0 have begun...

Hi, The issue I found about indexes on another column than the primary key is now corrected, I obtain the desired results. Thank you for your efficiency and your quickness. Eric DAVID -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De

Re: [sqlite] MS open source Portable Class Library for SQLite

I would describe the msopentech PCL wrapper as "slightly thick" (because it's trying to be higher level than the sqlite3 API itself), and "quite narrow" (because it covers only a small part of the underlying sqlite3 API). Related and possibly of interest: My own C# wrapper is a fork of the one

Re: [sqlite] Cross-Platform ADO wrapper for iOS, Android and Win 8.1 WP 8.1?

Short answer: no. Longer answer: Microsoft does not (yet?) support ADO on WinRT or WP8, much less on Xamarin platforms. But it looks like the future holds a glimmer of hope. Their vNext project seems to be heading toward portable ADO, and also includes SQLite support:

Re: [sqlite] SQLite version 3.8.6 coming soon

FWIW, the Zumero test suite is fairly abusive and it passes all test cases with 3.8.6 beta. -- E On Thu, Aug 7, 2014 at 11:59 AM, Richard Hipp wrote: > On Thu, Aug 7, 2014 at 10:01 AM, E.Pasma wrote: > > > I have a case where a primary key index is no

Re: [sqlite] System.Data.Sqlite

juillet 2014 10:49 À : sqlite-users@sqlite.org Objet : Re: [sqlite] System.Data.Sqlite Eric DAVID wrote: > Well, It seems to be impossible to join files to mails. So, here are > the statements : > > CREATE TABLE Lignes (lig_id INTEGER PRIMARY KEY AUTOINCREMENT NOT > NULL, lig_no

Re: [sqlite] System.Data.Sqlite

...@sqlite.org] De la part de Eric DAVID Envoyé : mardi 29 juillet 2014 01:40 À : 'General Discussion of SQLite Database' Objet : Re: [sqlite] System.Data.Sqlite Here is the list of all sql statements in the file Base.sql, included INSERT Statements. I think the issue comes from the index idx_Pylones_lig_id

Re: [sqlite] System.Data.Sqlite

Here is the list of all sql statements in the file Base.sql, included INSERT Statements. I think the issue comes from the index idx_Pylones_lig_id. Eric DAVID -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Joe Mistachkin

Re: [sqlite] System.Data.Sqlite

À : 'General Discussion of SQLite Database' Objet : Re: [sqlite] System.Data.Sqlite Eric DAVID wrote: > > SELECT * FROM Pylones P > JOIN Lignes L ON L.lig_id = P.lig_id > JOIN idx_Pylones_pyl_geom I ON P.pyl_id = I.pkid WHERE L.lig_id = 3; > Is the above query the one that has t

Re: [sqlite] System.Data.Sqlite

with System.Data.Sqlite 3.8.5 when it exists an index on another column than the primary key. Regards. Eric DAVID - CREATE TABLE Lignes (lig_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, lig_nom TEXT NOT NULL); SELECT AddGeometryColumn('Lignes', 'lig_geom', 2154, 'LINESTRING', 'XY'); SELECT CreateSpatialIndex

Re: [sqlite] System.Data.Sqlite

ailto:sqlite-users-boun...@sqlite.org] De la part de Simon Slavin Envoyé : lundi 28 juillet 2014 15:43 À : General Discussion of SQLite Database Objet : Re: [sqlite] System.Data.Sqlite On 28 Jul 2014, at 1:01pm, Eric DAVID <ericdav...@orange.fr> wrote: > I have a problem using Syst

[sqlite] System.Data.Sqlite

.5) So, I would like to know if there is a bug in System.Data.SQLite or if I don't understand something using this assembly. Eric DAVID ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Hexadecimal integer literals

would have been pretty sexy to have gotten it all done in SQL. Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] capturing and testing a hot journal

ceives individual emails from this list does either. If you can't stay on topic, don't participate in the topic at all. That being said, enjoy this, flame it and don't expect a response, because I don't want to be any more hypocritical than I already am by posting this in the first place.

Re: [sqlite] v3.8.4.3 download

Eric Rubin-Smith wrote: > The docs don't get versioned like that AFAICT. There's just one central > set of docs. If behavior changes from one version to the next, that is > called out with text inside the documentation and in the change logs. > Some of the more major changes ha

Re: [sqlite] v3.8.4.3 download

to the next, that is called out with text inside the documentation and in the change logs. Some of the more major changes have their own special pages in the docs. -- Eric A. Rubin-Smith ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.o

Re: [sqlite] think I need better error-handling guidance in the C API

asking with apologies to be corrected and directed to what I missed or misread. But people familiar with the library mostly seem to agree with my material point. So! Just looking for a ticket, so the relevant material can be added at the pleasure and convenience of the docs maintainers. --

Re: [sqlite] think I need better error-handling guidance in the C API

am, apply online. :) Hehe well I'd be more than happy to do that, if I understood the API... -- Eric A. Rubin-Smith ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] think I need better error-handling guidance in the C API

rror codes will be raised, or what the SQLite authors believe is appropriate subsequent client behavior. A vague citation to a million anonymous programs of unknown quality is not a convincing reason to think otherwise. And you and I both know that a random sample of 1 million programs will contain

Re: [sqlite] think I need better error-handling guidance in the C API

ut the API docs for sqlite3_step(), sqlite3_exec(), and sqlite3_prepare_v2()? I think the criticisms can be extended to other API calls. If the authors do not disagree then can we create a ticket against the docs? On Mon, Jun 30, 2014 at 2:47 PM, Eric Rubin-Smith <eas@gmail.com> wro

Re: [sqlite] think I need better error-handling guidance in the C API

ecause I don't understand the semantics of the error codes, in turn because (I think) the documentation is insufficient. It is not healthy to bake such ignorance into the application if I can help it -- again, I would rather just cure my ignorance (preferably not by digging through the code and reachin

[sqlite] think I need better error-handling guidance in the C API

ologies if I have missed some of the docs. Any pointers, or especially example C code that the SQLite devs consider perfectly robust and complete API usage, are much appreciated. Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] slowish R*Tree performance

your scheme will not find ::/0. And simple extensions of your scheme involve searching through the whole set to find ::/0. -- Eric A. Rubin-Smith Money is the root of all wealth. ___ sqlite-users mailing list sqlite-users@sqlite.org http://s

Re: [sqlite] slowish R*Tree performance

e. I'll see if I can get an apples-to-apples performance comparison going (and will reply back with the results, in case folks are still interested). Thank you! -- Eric A. Rubin-Smith I'm just glad it'll be Clark Gable who's falling on his face and not Gary Cooper. -- Gary Cooper on

Re: [sqlite] slowish R*Tree performance

h <= 8 is chosen. I.e. we are creating a lot of large bounding boxes that likely cover smaller ones, and that may or may not reflect reality. -- Eric A. Rubin-Smith Computer programs don't like being anthropomorphized. ___ sqlite-users mailing lis

Re: [sqlite] slowish R*Tree performance

my own programming > language than it was to build as SQLite functions. Yeah, I agree that the performance of a dedicated data structure will be far better. Again, just wondering if I can stretch SQLite to solve this problem, because it would be

Re: [sqlite] slowish R*Tree performance

line segment [0, 2^128-1], and store those intervals in a 1-dimensional R*Tree (which works great for IPv4, btw). -- Eric A. Rubin-Smith I still maintain the point that designing a monolithic kernel in 1991 is a fundamental error. Be thankful you a

Re: [sqlite] slowish R*Tree performance

On Sun, Jun 15, 2014 at 9:47 AM, Eric Rubin-Smith <eas@gmail.com> wrote: > Richard Hipp wrote: > > > What does this query return? > > > > SELECT count(*) FROM ipIndex > > WHERE minD1 <= 1220818432 and 1220818432 <= maxD1 > >

Re: [sqlite] slowish R*Tree performance

D3 > AND minD4 <= 1685755328 and 1685755328 <= maxD4 > AND minD5 <= 538331072 and 538331072 <= maxD5; Hm, it returns 1645. This indicates a bug (the max expected value is 128). I'm now highly suspicious of my mathematical reasoning o

[sqlite] slowish R*Tree performance

TE TABLE "ipIndex_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER) table|ipIndex_parent|ipIndex_parent|4|CREATE TABLE "ipIndex_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) table|routeTarget|routeTarget|5|CREATE TABLE routeTarget( id INTEGER PRIMARY KEY, prefix TEXT NOT NULL, target TEXT NOT NULL ) index|routeTargetIdxPrefix|routeTarget|6|CREATE INDEX routeTargetIdxPrefix ON routeTarget(prefix) Is there anything that I am doing obviously wrong? Thanks! Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] lifetime of buffer referred to with SQLITE_STATIC

If I say sqlite_bind_text(...SQLITE_STATIC), I am promising that the buffer is going to stick around for a while. How long am I promising that it will stick around? Til the next statement reset()? Til the statement finalize()? Til the database close()?

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

on it. That does look hopeful, though. Did you just have to force those precompiler defines for it to compile properly? Thanks, Eric -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mattias Kindborg Sent: 13 May, 2014 05:07

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

? -- Eric -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mattias Kindborg Sent: 9 May, 2014 06:03 To: General Discussion of SQLite Database Subject: Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Hi Eric. Then I

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

Among the binaries all I see is for .NET Compact Framework 3.9 (the latest from Microsoft, but not supported prior to their collection of operating systems that were released last year, so it doesn't work with WinCE 6). I have compiled for ARM with .NET CF 3.5 in VS2008, but not x86. -- Eric

[sqlite] Compiling System.Data.SQLite for .NET CF 3.5 (VS2008 & WinCE 6) on x86

the right SQLite.Interop.092.dll for x86. Every Interop library that it depends on that I've tried errors out with "Can't find PInvoke DLL 'SQLite.Interop.092.dll'" or a version mismatch. Thank you for any assistance, Eric ___ sqlite-users ma

Re: [sqlite] SQLite3_create_collation

Does this mean all your interaction with SQLite is happening through Core Data? E On Apr 2, 2014 1:05 PM, "Donald Steele" wrote: > I am working in iOS (aka ObjC) so I am using it's built in framework for > all my SQLite calls. > > > On Apr 2, 2014, at 10:58 AM, Simon

[sqlite] Should System.Data.SQLite.EF6.SQLiteProviderServices be public?

After reading this: http://msdn.microsoft.com/en-us/data/jj680699.aspx about Code-based Configuration in EF6, I wonder if System.Data.SQLite.EF6.SQLiteProviderServices needs to be public (instead of internal), so that people could do something like this: public class

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

Joe, The 1.0.91.0 beta you gave me works perfect in my scenario. Thanks so much! Any plan for when the final will be out? Eric On Mon, Feb 3, 2014 at 3:12 PM, Joe Mistachkin <j...@mistachkin.com> wrote: > > Eric Schultz wrote: > > > > I can't seem to build the

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

of "Unable to find an entry point named 'sqlite3_config_log_interop' in DLL 'SQLite.Interop.dll'." I assume something changed in SQLite.Interop.dll between the version you provided and the one I'm so I THINK everything is fine. Eric On Sat, Feb 1, 2014 at 4:27 PM, Joe Mistachkin <sql.

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

tion. I'd be happy to make a patch if it's one you'd accept. Eric -- Eric Schultz, Developer Advocate, Outercurve Foundation http://www.outercurve.org eschu...@outercurve.org cell: 920-539-0404 skype: ericschultzwi @EricOutercurve ___ sqlite-use

[sqlite] System.Data.SQLite Preloading and ASP.Net debugging

embly (which I can't in this case). Thanks, Eric -- Eric Schultz, Developer Advocate, Outercurve Foundation http://www.outercurve.org eschu...@outercurve.org cell: 920-539-0404 skype: ericschultzwi @EricOutercurve ___ sqlite-users mailing list sqlite-u

<    1   2   3   4   5   6   >