[sqlite] Replace on fts4 table results in unexpected matchinfo result

number of rows in fts is as expected, body column is correct, and other matchinfo options (pclx at least), seem to function correctly. Is REPLACE not allowed for fts4 tables, or is this a bug? Output of .version in sqlite3: SQLite 3.7.13 2012-06-11 02:05:22

Re: [sqlite] Mailinglist question

at it is a major source of spam to the groups. Eric -- ms fnd in a lbry ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] NOT NULL integer primary key

n IMPLEMENTATION detail) looks just like an auto-increment integer, and behaves like an integer primary key, so if you want an auto-increment PK, overload the syntax to declare it and overload the implementation detail to make it work. Eric -- ms fnd in a lbry ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Good resources for TCL/TK

all be given" page http://wiki.tcl.tk/37862 . Eric -- ms fnd in a lbry ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Starting with TCL

bases/general.sqlite > > puts [db version] > > > But I would prefer to check the version before connecting to a database. Is > this possible? Yes: set ver [package require sqlite3] puts $ver Eric -- ms fnd in a lbry __

Re: [sqlite] difference between 'ID IS NULL' and 'ID = NULL'

eaning. > > Because the use of NULL is not 'reserverd' for SQL, and in SQL it is not > more special than in any other environment. I don't understand what you mean. NULL has a special meaning in SQL (Structured Query Language), and that is what we

Re: [sqlite] sqlite-users Digest, Vol 130, Issue 11

you could ignore the threads you don't want to read, there really is plenty of technical discussion. But since you replied to the digest your post won't be included in the right thread, and nor will this response - rgh! Eric -- ms fnd in a lbry ___

[sqlite] Replication

or database replication. Not realistic for most existing databases though. Eric -- ms fnd in a lbry ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Replication

u happen to have a reference for it? My actual point was that Fossil is now described as blockchain when it predates what we (currently) call blockchain, and so do other similar things. Eric -- ms fnd in a lbry ___ sqlite-users mailing list sqlite-users@mailin

Re: [sqlite] Replication

t that the various implementers got it wrong, including missing out some key points of the Model. 8>< > PS: While I feel some ambivalence towards the subject, I was nodding in > agreement with most of your post, till that line appeared. :) Thankyo

Re: [sqlite] Replication

ckchain.html Hope you enjoy it! Thankyou, I did, except for their use of the word "query" to mean inserts, updates, and deletes :-) Eric -- ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/m

Re: [sqlite] Replication

On Thu, 11 Oct 2018 15:44:23 -0600, Warren Young wrote: > On Oct 11, 2018, at 2:25 PM, Eric wrote: >> >> On Thu, 11 Oct 2018 10:20:08 -0600, Warren Young wrote: >>> On Oct 11, 2018, at 12:26 AM, Darren Duncan wrote: >> 8>< >> >&g

Re: [sqlite] Replication

here was once a short-lived product actually called "The Last One"? > that was going to be closest to the relational model and/or the SQL > standard Just "or", the standard itself contradicts the model. > - right before re

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Tue, 9 Oct 2018 15:17:52 -0600, Warren Young wrote: > On Oct 9, 2018, at 1:56 PM, Eric wrote: > > > > I suppose I must be an "anti-forum type" even though I have never used > > Gmane, but it does rather sound as though you are applying a somewhat > >

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

said most of this before in various places at various times, but this seems like a good time to say it all at once. Eric -- ms fnd in a lbry ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

small number of people. Eric -- ms fnd in a lbry ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Wed, 10 Oct 2018 11:10:24 -0600, Warren Young wrote: > On Oct 10, 2018, at 10:39 AM, Eric wrote: >> >> * mailing lists come to me, I don't have to go and get them > > So do Fossil email alerts. Do they thread? Anyway I have to go and get context, and go elsewhere to

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

; https://fossil-scm.org/forum/forumpost/ba1144bc9f Thanks for that link, I will read it properly. Eric -- ms fnd in a lbry ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

ugh time in the day, it's a lot easier to keep a finger on the pulse without reading everything in mailing lists than it is with forums. I suppose all that amounts to a somewhat blurry feature request ;-) Eric -- ms fnd in a lbry ___ sqlite-users

Re: [sqlite] Is there a way to select using cid?

0 1 > 1 value text0 0 Why on earth would you want to do that? Eric -- ms fnd in a lbry ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Things you shouldn't assume when you store names

number of foreign family names, which probably helps it along. UK postcodes are incredibly fine-grained, compared to most of the rest of the world, where they would be much less useful for identification. Eric -- ms fnd in a lbry ___ sqlite-users mailin

Re: [sqlite] Things you shouldn't assume when you store names

On Wed, 13 Nov 2019 17:18:05 -0700 SQLite mailing list sqlite-users@mailinglists.sqlite.org said 8>< Give up on names and use something else? (SSN, phone number, DOB…) None of the above are safe primary keys. I don't think there is any single combination which is. Eric -- ms fnd in

Re: [sqlite] Things you shouldn't assume when you store names

_any_ minority by applying an abusive label to them. One of these days you may well be a minority in some context or other. Eric -- ms fnd in a lbry ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/c

[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] 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

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

[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

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

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

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 tables/xBestIndex: Is this a bug?

ell game with this information. Thanks very much! 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] 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] Multi-table index ersatz?

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

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

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

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?

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

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

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] Registering Virtual Tables on the spot (when needed)

ould return the unknown column name when the errcode is an unknown field etc. Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bug in sqlite.exe?

this? I'm new with Sqlite, and don't know how to submit a bug. And maybe I screwed up somewhere and the bug is behind this keyboard. Thanks, Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Bug in sqlite.exe?

al Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: November-30-13 11:36 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Bug in sqlite.exe? On 11/30/2013 10:01 AM, Eric Teutsch wrote: > But when I look at the d

Re: [sqlite] Bug in sqlite.exe?

:55 AM, Eric Teutsch wrote: > .Tables doesn't show the 2 new tables. A select statement on one of > those tables says "No such table". And "select * from sqlite_master" > shows the 8 tables and 1 trigger. And ends there. But when using > sqliteodbc, I can run the

Re: [sqlite] Bug in sqlite.exe?

. I have a bunch of DLLs in my VCS that I can extract and put online for your testing. On Sat, Nov 30, 2013 at 10:01 AM, Eric Teutsch <er...@powersoft.ca> wrote: > Hi, I've got a database (3.7.16.1) which has a bunch of tables and 2 > triggers. The order of creation is 8 tables, 2

Re: [sqlite] Bug in sqlite.exe?

>boun...@sqlite.org] On Behalf Of Eric Teutsch >Sent: Saturday, 30 November, 2013 09:56 >To: 'General Discussion of SQLite Database' >Subject: Re: [sqlite] Bug in sqlite.exe? > >.Tables doesn't show the 2 new tables. A select statement on one of >those tables says "No

Re: [sqlite] Bug in sqlite.exe?

Database Subject: Re: [sqlite] Bug in sqlite.exe? On 30 Nov 2013, at 5:43pm, Eric Teutsch <er...@powersoft.ca> wrote: > That is an interesting concept and could explain another weirdness - > my sqliteodbc connection always tells me that the database is > readonly. Is there a

Re: [sqlite] Bug in sqlite.exe?

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: November-30-13 13:13 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Bug in sqlite.exe? On 11/30/2013 11:55 AM, Eric Teutsch wrote: > .Tables doesn't show the 2 new tables. A select statement on one of > those table

Re: [sqlite] Bug in sqlite.exe?

Sorry, should have pointed out that the "missing" tables are: CollectionDevices and CollectionChannels -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Eric Teutsch Sent: November-30-13 14:04 To: 'General Discussion

Re: [sqlite] Bug in sqlite.exe?

e Database Subject: Re: [sqlite] Bug in sqlite.exe? On 30 Nov 2013, at 7:03pm, Eric Teutsch <er...@powersoft.ca> wrote: > I've taken a picture of the odbc tool (showing the tables and the database > name) and sqlite.exe with .database and .table showing. You can see it > here: http

Re: [sqlite] Bug in sqlite.exe?

te.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Simon Slavin >Sent: Saturday, 30 November, 2013 12:15 >To: General Discussion of SQLite Database >Subject: Re: [sqlite] Bug in sqlite.exe? > > >On 30 Nov 2013, at 7:03pm, Eric Teutsch <er...@powersoft.ca> wrote: >

Re: [sqlite] Bug in sqlite.exe? NOT !

Yep, that's the reason. Thanks to Marcus and Clemens (with an extra high-5 for the link) for figuring it out, and everybody for suggestions. Now to figure out where to put the database so that non-admins can see the same file as admins... Eric -Original Message- From: sqlite-users-boun

Re: [sqlite] Bug in sqlite.exe? NOT !

s you do it... but this is a silly thing and it means your program will not be compatible with other user-computers on which it isn't disabled. Cheers, Ryan On 2013/12/01 02:17, Eric Teutsch wrote: > Yep, that's the reason. Thanks to Marcus and Clemens (with an extra > high-5 for the link) for fig

Re: [sqlite] How to get data between two dates in SQLite with C#?

Hi Fatih, not tested, but this should work and is I think what you want. Good luck. "SELECT * from TABLE t where t.Date1 >= @0 AND t.Date2 <= @1", date1.ToString("-MM-dd HH:mm:ss"), date2.ToString("-MM-dd HH:mm:ss") -Original Message- From: sqlite-users-boun...@sqlite.org

[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

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

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

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

[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] 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] 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] 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

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

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

[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] 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

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

À : '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

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

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

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

[sqlite] Getting random data from grouped data in one table

Here is the situation. I have one database table "TB_Patient" with the columns below: PATIENT_ID PATIENT_GROUP FIRSTNAME LASTNAME ADDRESS I want to get PATIENT_ID randomly from certain PATIENT_GROUP. There are 5 PATIENT_GROUP only with total row in the table is about 1 (10K). The number of

[sqlite] Full Table Scan after Analyze

We have an application that has been using SQLite successfully for several years. We use SQLite for various purposes within our product, with a few dozen tables overall. Recently, I started to upgrade from version 3.6.3 to 3.7.5. During that time, I noticed that several previously fast indexed

Re: [sqlite] Full Table Scan after Analyze

> Suggestion: After you run ANALYZE, go back and modify values in > sqlite_stat1 (and sqlite_stat2 if you are using SQLITE_ENABLE_STAT2) with > "typical" values that you would expect to see in most databases. Yes, you > can read and write the sqlite_stat1 and sqlite_stat2 tables. Maybe you can

Re: [sqlite] Is this normal?

hen text replaces a numeric. > My understanding is that if you don't use an ORDER BY clause, you're asking for an unordered set. So SQLite can print your result set in whatever order it likes. Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] substr fails in a query: looks like a bug

d -- it's to return paths in my result set and to the substring test in Python instead of sqlite. But I'd prefer having sqlite run this code. - Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] substr fails in a query: looks like a bug

tr2" as p2_path where the substr clause works. So I do need to create a real table to repro this. On Tue, Apr 5, 2011 at 5:12 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > On 4/5/2011 6:59 PM, Eric Promislow wrote: > > Notice the clause in the middle of the query: > &

Re: [sqlite] substr fails in a query: looks like a bug

Thanks for the interest, but I now can't repro the bug using pure sqlite3, and only trigger it using Python (2.6) with its sqlite3 module. - Eric On Tue, Apr 5, 2011 at 5:21 PM, Eric Promislow <eric.promis...@gmail.com>wrote: > This won't be a trivial case to reproduce -- I need to c

Re: [sqlite] Fastest way to insert MASSIVE data quantities

So, no problem from sqlite's end in my application fwiw. Eric * I'm American -- "billion" == "thousand million" == 10^9. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Slow rollback - possible causes?

not be relevant: count_changes = OFF synchronous = OFF temp_store = MEMORY wal_autocheckpoint = 0 cache_size = 300 Any thoughts or ideas? -Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

  1   2   3   4   5   6   >