[sqlite] INSERT OR REPLACE in a virtual table implementation....

2014-10-17 Thread dave
uniqueness constraint, and return an error SQLITE_CONSTRAINT_UNIQUE, which I presume is the right thing to do. So, my question is, is this the right thing to do to get INSERT OR REPLACE on a virtual table, or something else, or maybe that syntax is not supported on virtual tables? Than

Re: [sqlite] INSERT OR REPLACE in a virtual table implementation....

2014-10-17 Thread dave
... > On 10/18/2014 01:07 AM, dave wrote: > > I have a virtual table implementation, and I would like to > use the INSERT OR > > REPLACE syntax to simplify actions for the user. In my > xUpdate method, for > > the case where insertion is occuring, > > ... >

Re: [sqlite] Full outer joins

2014-10-21 Thread dave
other posts is useful in a pinch, though it would be messy in my case because I am joining 4 tables. -dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is msvcrt coupling now unavoidable (3.8.7)?

2014-10-22 Thread dave
l. Oh well, there's always 3.8.6 while you wait for a fix. -dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] quasi-bug related to locking, and attached databases....

2014-10-24 Thread dave
e more clever to know about aux being an alias for main, and effectively translate the query shown to it's functional equivalent of: insert or replace into main.dest ( name, value ) values ('allow',(select value from main.source where name = 'allow')); which does work (or both to 'aux' as we

Re: [sqlite] quasi-bug related to locking, and attached databases....

2014-10-24 Thread dave
> -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin ... > On 24 Oct 2014, at 9:54pm, dave <d...@ziggurat29.com> wrote: > > > Can locking be made more clever to know about aux

Re: [sqlite] quasi-bug related to locking, and attached databases....

2014-10-24 Thread dave
sqlite> insert or replace into main.dest ( name, value ) values ...> ('allow',(select value from aux.source where name = 'allow')); SQL error: database is locked sqlite> Looking forward to hearing back from folks. Maybe I should have put this thread on 'dev

Re: [sqlite] How to enable icu for sqlite shell

2014-10-25 Thread dave
leg-up on the process, in particular related to the ICU extension. -dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] quasi-bug related to locking, and attached databases....

2014-10-25 Thread dave
ng,and > attached databases ... > > Simon, FYI: this is the "'main' db aliasing" problem i > brought up a couple > months ago, which we solved by using your suggestion: re-attach the db > directly after opening it, so that (as Dave said) all DBs > have well-known &

[sqlite] bug, or misuse? crash using sqlite3_mutex_alloc()...

2014-10-25 Thread dave
ase the 'id side-steps init()' logic is done for some reason I don't understand. Otherwise, it looks like a logic error to me. Any advice appreciated. tia, -dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailm

Re: [sqlite] New kids on block the SQLite Master Suite.

2014-10-29 Thread dave
FYI, you can support XP when building with VS2012 if you have VS2012 SP3 installed (which you probably do if you've installed current stuff), and set the 'platform toolset' (under project properties, configuration properties, general) to 'v110_xp' (I don't have it in front of me, this is from

Re: [sqlite] New kids on block the SQLite Master Suite.

2014-10-30 Thread dave
sers-boun...@sqlite.org] On Behalf Of Billy Huynh ... > Hi Dave, > Thank you for info. I'm aware of this. in fact, you could > built an app that run all version of Windows with vs2012 but > you have to install vs2008, vs2010, then vs2012. Since > acquiring license from microsoft with

Re: [sqlite] New kids on block the SQLite Master Suite.

2014-10-30 Thread dave
sers-boun...@sqlite.org] On Behalf Of Billy Huynh > Sent: Thursday, October 30, 2014 11:15 AM > To: 'General Discussion of SQLite Database' > Subject: Re: [sqlite] New kids on block the SQLite Master Suite. > > > Thanks Dave, > I have update 3 (there is no service pack anymore with &

[sqlite] Can I copy one column of data to another table?

2015-03-07 Thread Dave
I am fairly new at this although I have wanted to learn and tried again and again...But I have a problem. I created a database and probably did it wrong and I am trying to fix it. I made a database with 7 tables in it all with a primary key and a record ID that matches the primary key. Now

[sqlite] Can I copy one column of data to another table?

2015-03-07 Thread Dave
well, I had my app data "hard coded" in the past and decided to use a database to make it easier. I am sure it will be, once I get more experience. schemer On 3/7/2015 11:59 AM, Simon Slavin wrote: > On 7 Mar 2015, at 4:42pm, Dave wrote: > >> I am fairly new at this although

[sqlite] Can I copy one column of data to another table?

2015-03-07 Thread Dave
and got an answer within 30 minutes. :-) Thanks, schemer On 3/7/2015 1:35 PM, Paul Sanderson wrote: > Dave > > I'm not sure exactly what you are trying to do from your description - > the schema of the tables you have and those that you want may help. > > But as a general idea

[sqlite] Can I copy one column of data to another table?

2015-03-07 Thread Dave
progress, but have a long way to go. Good thing for me is I plan to use my database (for now) as basically a "flat file" where my app will just use the related data in click events to further process. Thanks again, schemer On 3/7/2015 1:42 PM, R.Smith wrote: > > > On 2015-0

[sqlite] Can I copy one column of data to another table?

2015-03-07 Thread Dave
On 3/7/2015 1:42 PM, R.Smith wrote: > > Hi Dave, you did not give us the schemata so I'm going to guess you > have tables like this: > > CEATE TABLE T1("ID" INT PRIMARY KEY, "val1" TEXT); > CEATE TABLE T2("ID" INT PRIMARY KEY, "val2"

[sqlite] Can I copy one column of data to another table?

2015-03-07 Thread Dave
. Thanks for understanding and having been where I am now. It make me feel better already. :-) Dave On 3/7/2015 2:44 PM, R.Smith wrote: > > > On 2015-03-07 10:32 PM, Dave wrote: >> Ryan, >> Thanks for your reply. As I mention in my last post: >> >> I got it sort

[sqlite] Can I copy one column of data to another table?

2015-03-07 Thread Dave
. Thanks again, Dave On 3/7/2015 3:06 PM, R.Smith wrote: > > > On 2015-03-07 10:55 PM, Dave wrote: >> Ryan, >> I have been to the link below but was under the impression that SQL >> and SQLite are two different things so I usually just look up SQLite >> help. I can do

[sqlite] restructuring databases (was Re: Can I copy one column of data to another table?)

2015-03-08 Thread Dave
On 3/7/2015 7:18 PM, Darren Duncan wrote: > On 2015-03-07 9:59 AM, Simon Slavin wrote: >> On 7 Mar 2015, at 4:42pm, Dave wrote: >> >>> I am fairly new at this although I have wanted to learn and tried >>> again and again...But I have a problem. I created a database an

[sqlite] restructuring databases (was Re: Can I copy one column of data to another table?)

2015-03-08 Thread Dave
t; too. So that makes its use more like hard coded data which I want and need. When I learned VB years ago I got stumped often but over time things started to "click". I am waiting to hear those clicks with SQLite soon. :) Thanks, Dave (also in Florida) On 3/7/2015 8:03 PM, Jim Callahan wrot

[sqlite] Can I copy one column of data to another table?

2015-03-09 Thread Dave
Thanks for the help Igor. :-) Dave On 3/7/2015 1:37 PM, Igor Tandetnik wrote: > > > On 3/7/2015 11:42 AM, Dave wrote: >> Now when trying to use the database I see that I should have made 1 >> table with all the related data (I think) and am trying to copy one >&g

Re: [sqlite] Error with xBestIndex

2014-09-10 Thread dave
hen I was initially developing because of that behaviour. Good luck! -dave > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of > Dominique Devienne > Sent: Wednesday, September 10, 2014 7:14 AM > To: Gen

Re: [sqlite] Error with xBestIndex

2014-09-11 Thread dave
Yep, same one as me, glad the info helped. I think I may file a bug on that. Delphi, I do remember that, and have had rare occasion to use it, though I've never linked c obj in (or are you using sqlite as a dll?). Good luck on the rest of you implementation! -dave > -Original Mess

Re: [sqlite] Expose struct Mem and struct Vdbe to other application

2014-09-23 Thread dave
sqlite_column functions by type. Then your record binding would be a vector of those, and you could wrap sqlite_step() to additionally invoke all transfer() methods. Have fun hacking! -dave > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-u

Re: [sqlite] Results of Joins in sqlite

2014-09-24 Thread dave
It does sound like that, like an Object Relational Mapping. And maybe someone has already done this. Googling "ORM sqlite c++" Yields a lot of existing ORM projects that support sqlite, so maybe Prakash doesn't need to work so hard on implementing that part of his project himse

Re: [sqlite] A new extension for sqlite to analyze the stringmetrics

2014-09-25 Thread dave
easily be wrong; I can't take a peek at the lib myself right now; but I mention this now on the chance that it saves some time debugging. -dave > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gert Van Assc

Re: [sqlite] A new extension for sqlite to analyze the stringmetrics

2014-09-25 Thread dave
. -dave > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dave > Sent: Thursday, September 25, 2014 11:59 AM > To: 'General Discussion of SQLite Database' > Subject: Re: [sqlite] A new extension for

Re: [sqlite] A new extension for sqlite to analyze the stringmetrics

2014-09-25 Thread dave
the existing dll for the benefit of the community. -dave > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gert Van Assche > Sent: Thursday, September 25, 2014 12:47 PM > To: General Discussion of SQLite Dat

Re: [sqlite] A new extension for sqlite to analyze the stringmetrics

2014-09-26 Thread dave
than gcc_blabblahblah.) Even if your checking in of the dll binary was a error, you might consider continuing it, since it makes it possible for folks like Gert to try it out (since he is user rather than a developer). Thanks for making it! -dave > -Original Message- > From: sqlite

Re: [sqlite] A new extension for sqlite to analyze the stringmetrics

2014-09-28 Thread dave
monge_elkan monge_elkan_custom needleman_wunch overlap_coefficient overlap_coefficient_custom qgrams_distance qgrams_distance_custom smith_waterman smith_waterman_gotoh soundex

[sqlite] SQLite and VB.Net Questions

2011-11-21 Thread Dave
of the installers and kept getting the following error message: Which download would be the correct one for me? Thanks, Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Followup: Added Missing error message to past post.

2011-11-21 Thread Dave
of the installers and kept getting the following error message: Failed to Install Microsoft Visual C++ Runtime vcredist_x64_2010_SP1.exe, Asia Which download would be the correct one for me? Thanks, Dave ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Followup: Added Missing error message to past post.

2011-11-21 Thread Dave
from VB6 Classic and finally making the move to .NET as I didn't like the looks of it when it came out and I actually bought it. It should have settled down by now. Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Followup: Added Missing error message to past post.

2011-11-22 Thread Dave
Thanks Taleeb, That will get me going until the next question. :-) Dave On 11/21/2011 11:25 PM, Taleeb Anwar wrote: Download the x64 mixed-mode assembly compiled statically against the .NET Framework 3.5 (as you are using VS2010 on a 64 bit computer). Regarding targetting x86 users you can

[sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
: SQLite Error no such table: MyTableName I have the database in the project folder on my Win7 64 Pro system. The app, when run, creates an empty database file of the same name as my database file which is 13KB in size. My SQLconnect.ConnectionString = "data source =C:\Users\Dave\Docu

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
On 11/28/2011 3:59 PM, Igor Tandetnik wrote: On 11/28/2011 4:52 PM, Dave wrote: I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
On 11/28/2011 3:59 PM, Igor Tandetnik wrote: On 11/28/2011 4:52 PM, Dave wrote: I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
that is created just has an icon that looks like a sheet of paper. Dave On 11/28/2011 4:09 PM, Igor Tandetnik wrote: On 11/28/2011 5:08 PM, Dave wrote: I just checked and the 0K file that is created is the same name except it has .db3 added to it's name. Why is this suprising? Your connection

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
Ok, I switched that and now my original database file has a .db added whereas the one created by my app stays the same. Thanks, Dave On 11/28/2011 4:14 PM, Igor Tandetnik wrote: On 11/28/2011 5:13 PM, Dave wrote: I just looked again and renamed my original database file back to add the .db3

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
Thanks John. On 11/28/2011 4:18 PM, John Drescher wrote: You probably have "Hide extensions for known types enabled in windows" When this is enabled windows does not display the extension for known types so that if you have more than 1 file with the same base name they will appear as the

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
and that doesn't help any. Cheers, Dave On 11/28/2011 4:32 PM, Igor Tandetnik wrote: On 11/28/2011 5:23 PM, Dave wrote: Ok, I switched that and now my original database file has a .db added whereas the one created by my app stays the same. It doesn't have .db added. It had it all along, you just

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
Thanks Simon, Actually, I knew that. Just having a bit of a multiple crash course...all at once. I just recently built this pc and have been on XP until recently too. I do some graphic stuff and have many same named pics with the various .jpg, .bmp, .gif extensions. Dave On 11/28/2011 4:37

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
On 11/28/2011 4:59 PM, Simon Slavin wrote: On 28 Nov 2011, at 10:44pm, Dave wrote: On 11/28/2011 4:37 PM, Simon Slavin wrote: Just to stress that the filename includes the bit after the '.'. You can have any number of files with the same part before the '.' but different extensions

Re: [sqlite] Newbie question on Data Source

2011-11-29 Thread Dave
for free and some costing in the thousands. Dave On 11/29/2011 6:17 AM, Black, Michael (IS) wrote: I'll note a few things here... #1 If you want to learn about "database design" or "how to code in language X" get a book on those and not on a particular product (you may want

Re: [sqlite] EXT :Re: Newbie question on Data Source

2011-11-29 Thread Dave
. Small world. Thanks, Dave On 11/29/2011 8:57 AM, Black, Michael (IS) wrote: You don't need to pay moneythe concepts are available all over the place For example: http://search.4shared.com/postDownload/AHGWfQwG/Database_Design_For_Mere_Morta.html If you ran a BBS on a C64 you may have

Re: [sqlite] EXT :Re: Newbie question on Data Source

2011-11-29 Thread Dave
Michael, I found the info on your BBS there too: http://www.zimmers.net/bbs/aabbs.html Dave On 11/29/2011 8:57 AM, Black, Michael (IS) wrote: You don't need to pay moneythe concepts are available all over the place For example: http://search.4shared.com/postDownload/AHGWfQwG

Re: [sqlite] sqlite3 & importing mysql-dumps: "SQL error: database disk image is malformed"

2005-07-26 Thread dave
will try helping tracing it down. i really wonder, what might be wrong with hoary, so those unpredictable strange error occur... thanks anyways dave

[sqlite] multithreading

2004-02-25 Thread dave
mostly reads and occasionally updates rows, while the network thread loads new messages and inserts them. Will that work, or do I just misunderstand how SQLite does multithreading? Many thanks, -Dave - To unsubscribe, e-mail

Re: [sqlite] more performance questions

2004-03-17 Thread dave
On Mar 17, 2004, at 5:44 PM, D. Richard Hipp wrote: Dave Hayden wrote: > I'm inserting a bunch of data loaded off the network into a table. Here at > the office, SQLite keeps up pretty well; at home on the cable modem, it's a > huge bottleneck. Is the database file on a network f

[sqlite] like, but not equal?

2004-07-24 Thread dave
dom'; 0 sqlite> select count(*) from newsgroups where name like 'rec.arts.anime.fandom'; 1 How can a string be like something that has no wildcards, but not equal to it? My hunch is it has something to do with character encoding, but is that really how it should work? Thanks, -Dave

Re: [sqlite] like, but not equal?

2004-07-24 Thread dave
On Jul 24, 2004, at 2:45 AM, Paolo Vernazza wrote: [EMAIL PROTECTED] wrote: How can a string be like something that has no wildcards, but not equal to it? My hunch is it has something to do with character encoding, but is that really how it should work? Like is not case sensitive... Hey, I never

[sqlite] sqlite3 crashing on OS X

2004-07-24 Thread dave
(pStmt=0x55e340) at ../src/vdbeapi.c:159 #7 0xa36c in sqlite3_exec (db=0xc9, zSql=0x280ac40 "", xCallback=0, pArg=0x40dbc, pzErrMsg=0x0) at ../src/legacy.c:79 and here's the code (XCode 1.2 project): http://www.opaque.net/~dave/dbtest.tgz Can another OS X user give this a try, see if

Re: [sqlite] Deadlock when doing threaded updates and inserts

2004-08-11 Thread dave
On Aug 11, 2004, at 3:48 PM, Dave Hayden wrote: Since only one of the competing threads will have completed a write (right?), can't the others "postpone" their transactions somehow until they can get a write lock? That is, postpone the "begin transaction" action. Since they

Re: [sqlite] Building an SQLite Extension: How to check if a table exists in the database?

2012-03-11 Thread Dave
Once you have ascertained whether the table exists, what are you wanting to do next? Exit? Or create it and then continue with inserts and so on? If the latter, you can just do CREATE TABLE IF NOT EXISTS and then keep going. ~~~ On Sun, Mar 11, 2012 at 8:21 AM, Wei Song 2

[sqlite] eponymous vtables, xBestIndex, and required parameters...

2017-10-04 Thread dave
is far! And thanks even more if anyone can advise on how to deal with xBestIndex and required constraints on an eponymous vtable acting as a table-valued function! Cheers; -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] eponymous vtables, xBestIndex, and required parameters...

2017-10-05 Thread dave
l > table are in reasonable proportion, everything should work fine. Thanks! I like the idxNum tweak for the error message; I'll add that stuff in. And the info about relative costs _on_the_same_virtual_table_ is very enlightening because I suppose the converse is true, that the e

[sqlite] xRowid and read only virtual tables....

2017-10-16 Thread dave
in particular because implementing it will be quite awkward for the underlying implementation in my case, and I'd very much prefer to skip it. Even a 'without rowid' table would imply specifying some primary key, which in a few cases would also be awkward. Thanks in advance, -dave

Re: [sqlite] xRowid and read only virtual tables....

2017-10-17 Thread dave
> On 10/16/17, dave <d...@ziggurat29.com> wrote: > > Hi, I am building a system which involves a number of virtual table > > implementations. They are all read-only, but will be > involved in a bunch of > > joins amongst themselves. My question is this: > &

Re: [sqlite] [EXTERNAL] xRowid and read only virtual tables....

2017-10-17 Thread dave
jects I've definitely used the counter trick before, caching the underlying data (to support updates and transactions) but those were known to be small datasets. This stuff coming from APIs could be big, so I wanted to avoid caching it all. But one does what one must Thanks for all the feedb

Re: [sqlite] [EXTERNAL] xRowid and read only virtual tables....

2017-10-17 Thread dave
les. > Thanks for your input as well; I somehow missed it until just now. Cheers! -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] very sqlite3 noobie error

2017-10-23 Thread dave
er host language you are going to build the product in, because all the various language bindings (except for C) are separate projects and they differ. Just a thought; cheers -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://m

Re: [sqlite] API, sqlite3_value_bytes and sqlite3_value_blob...

2017-12-13 Thread dave
> -Original Message- > Behalf Of J Decker ... > <peter.nichvolo...@gmail.com> wrote: > > > Dave. The documentation contains many such catch-all > statements which do ... > > The current decision tree of the particular catch-all > documentation c

[sqlite] API, sqlite3_value_bytes and sqlite3_value_blob...

2017-12-13 Thread dave
, 613; 616, 617 (I stopped grepping at this point; this list is not comprehensive). Anyway, just wondered if the api documentation's advice is maybe out-of-date with current reality. Thoughts/comments? Cheers! -dave ___ sqlite-users mailing list sq

[sqlite] readfile/writefile extensioln, and UTF8 on Windows....

2017-12-11 Thread dave
builds. Attached herewith. Cheers! -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] readfile/writefile extensioln, and UTF8 on Windows....

2017-12-11 Thread dave
recently had some trouble using the readfile() ... > > Attached herewith. > > Cheers! > > -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] readfile/writefile extensioln, and UTF8 on Windows....

2017-12-11 Thread dave
to the ones I used * etc. Cheers, -dave //fileio.patch start === 18a19,21 > #if defined(WIN32) || defined(WIN64) || defined(WINDOWS) > #include > #endif 29a33,73 > #if defined(WIN32) || defined(WIN64) || defined(WINDOWS) > const char* zName; > int

Re: [sqlite] [EXTERNAL] xRowid and read only virtual tables....

2017-10-20 Thread dave
it has it's reasons. I should study the query planner implementation one day when I have some time Cheers! -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Configuring csv extension to use '; ' as column delimiter instead of ',' ?

2018-05-01 Thread dave
AL TABLE CSV (...) So maybe one would just need to modify the csvtabCreate to process some additional parameters and propagate those settings to the implementation. -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://maili

[sqlite] virtual tables, and theTrue meaning of pIdxInfo->estimatedCost, pIdxInfo->estimatedRows, and pIdxInfo->idxFlags...

2017-10-19 Thread dave
inking? Thanks in advance; cheers! -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] virtual tables, and theTrue meaning of pIdxInfo->estimatedCost, pIdxInfo->estimatedRows, and pIdxInfo->idxFlags...

2017-10-20 Thread dave
guides the query planner more strongly in some direction. It also sounds like what I was doing (described in my first message, here elided), was fine. Thanks, and cheers! -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] kooky thought: a vm-only build (for embedded). feasible?

2018-04-18 Thread dave
gt; able to create a valid sqlite3_stmt pointer from bytecode > stored somewhere. > > -Urspr√ľngliche Nachricht- > Von: sqlite-users > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im > Auftrag von dave > Gesendet: Sonntag, 15. April 2018 20:55 > An: sqlite-use

Re: [sqlite] kooky thought: a vm-only build (for embedded).feasible?

2018-04-18 Thread dave
gt; -- > D. Richard Hipp > d...@sqlite.org Ah, groovy. Well, at least that is validation of the concept. So it sounds like I have a side project for my copious free time! -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] kooky thought: a vm-only build (for embedded). feasible?

2018-04-15 Thread dave
for the whole system). Anway, has this been discussed before? Or is it a fool's errand? Cheers! -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] kooky thought: a vm-only build (for embedded).feasible?

2018-04-15 Thread dave
to approach the surgery. -dave > -Original Message- > From: sqlite-users > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Simon Slavin > Sent: Sunday, April 15, 2018 2:06 PM > To: SQLite mailing list > Subject: Re: [sqlite] kooky tho

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

2018-04-18 Thread dave
Wouldn't it be as simple as subscribing to the mailing list and harvesting the emails directly from the inbound content? Because as it is, everyone's real email already comes to me in the list messages I receive (as 'sqlite-users on behalf of x...@yyy.com') The spam message I just received used

Re: [sqlite] copmile SQLite with extension?

2018-04-26 Thread dave
on * you can make that registration more transparent by using the sqlite3_auto_extension() mechanism HTH -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] virtual tables, xBestIndex, pIdxInfo->aConstraint[].op, and 'NOT'...

2018-10-17 Thread dave
point I'll assume the 'NOT' variant of MATCH, LIKE, GLOB, REGEXP are currently /not/ supported in xBestIndex, and just hope that maybe someday they will be. Cheers, and thanks for all the feedback! -dave ___ sqlite-users mailing list sqlite-users@mailin

Re: [sqlite] [EXTERNAL] virtual tables, xBestIndex, pIdxInfo->aConstraint[].op, and 'NOT'...

2018-10-16 Thread dave
f the behaviour of 'is' in sqlite. And if anyone has comnments regarding the first two issues I mentioned, namely the absence of support of NOT MATCH, NOT LIKE, NOT GLOB, NOT REGEXP in xBestIndex() And also the meaning/use of SQLITE_INDEX_CONSTRAINT_FUNCTION, that would be super helpful. Che

Re: [sqlite] [EXTERNAL] virtual tables, xBestIndex, pIdxInfo->aConstraint[].op, and 'NOT'...

2018-10-13 Thread dave
but I'm guessing that SQLite extends it's meaning. Interestingly a search condition "where name is true" parses and runs, but does /not/ cause invocation of xBestIndex at all. Cheers! -dave > -Original Message- > From: sqlite-users > [mailto:sqlite-users-boun...@ma

[sqlite] virtual tables, xBestIndex, pIdxInfo->aConstraint[].op, and 'NOT'...

2018-09-23 Thread dave
the operator set in some way to present the negative clauses at some release in the future? Thanks for any info! -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] virtual tables, xBestIndex, pIdxInfo->aConstraint[].op, and 'NOT'...

2018-09-24 Thread dave
with those embedded extensions relative to the implementation in 3.20, but this may compell me to do so. (I use shell.c in a special debug build of my product). Thanks! -dave > -Original Message- > From: sqlite-users > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Be

Re: [sqlite] sqlite segfault on INNER JOIN ON (...) + WHERE fieldIN (list, of, items)

2019-02-19 Thread dave
s for the info. I wonder if it makes sense for me to include the SQLITE_DEBUG in all debug configurations of my product? Does it have any untoward effect other than maybe slowdowns etc? -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite

Re: [sqlite] sqlite segfault on INNER JOIN ON (...) + WHERE field IN (list, of, items)

2019-02-19 Thread dave
State * p, char * zSql, _iobuf * in, int startline) Line 16106 sqlite3.exe!process_input(ShellState * p) Line 16206 sqlite3.exe!wmain(int argc, wchar_t * * wargv) Line 16959 Hth a little. Cheers, -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite segfault on INNER JOIN ON (...) + WHERE fieldIN (list, of, items)

2019-02-19 Thread dave
ULL Lastly, if it helps, converting the query to: SELECT a.id FROM t AS a INNER JOIN t as b ON a.id = b.id WHERE a.id = 1 or a.id = 2 or a.id = 3; Does /not/ crash. (and nice work on the bisect! Lol) -dave ___ sqlite-users mailing list sqlit

Re: [sqlite] virtual table xBestIndex and SQLITE_CONSTRAINT andzErrMsg

2019-02-19 Thread dave
> On 2/19/19, dave wrote: > > addition, but I have lost a capability relative to the > prior scheme of using > > high query cost along with a special flag communicated in > pIdxInfo->idxNum, > > that being the ablilty to emit contextual info as to why

[sqlite] virtual table xBestIndex and SQLITE_CONSTRAINT and zErrMsg

2019-02-19 Thread dave
rom the previous rejected plan? I don't know if this would cause a problem or not. Cheers! -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] pointer-passing interface, and testing if pointer is correct 'type'....

2019-06-15 Thread dave
*); gets pointer as per usual, and if final parameter is non-null, provide a 'boolean' indicating that it was validly bound. Thanks! -dave ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman

[sqlite] Freelist count after Vacuum

2014-10-09 Thread Dave Wellman
Hi, Is it a reasonable assumption that immediately following a VACUUM command the freelist_count will always be 0, or maybe 1? Cheers, Dave Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118 9740192 www: <http://www.ward-analytics.com>

Re: [sqlite] Freelist count after Vacuum

2014-10-09 Thread Dave Wellman
and Wales. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: 09 October 2014 17:29 To: General Discussion of SQLite Database Subject: Re: [sqlite] Freelist count after Vacuum On Thu, Oct 9, 2014 at 12:25 PM, Dave

Re: [sqlite] damaged database recovery

2015-01-15 Thread Dave Dyer
I have a case of a damaged database, where the only damage appears to be that somehow the index uniqueness constraint is violated. As long as the operations don't touch the index, the db operates without complaint. I was eventually able to construct a copy with good indexes, but 1) the generic

Re: [sqlite] damaged database recovery

2015-01-15 Thread Dave Dyer
> > >> it wasn't possible to drop the index in question > >what happened when you tried ? Were you using your own code or the SQLite >shell tool ? sqlite shell tool. Same complaint, "database corrupted". >My guess is that you actually have file-level corruption which just happened >to

Re: [sqlite] damaged database recovery

2015-01-15 Thread Dave Dyer
The likely cause of corruption is that this is probably a database being accessed on a networked disk. -- sqlite> select * from preference_table where preferenceset='foo'; sqlite> drop index preferenceindex; (11) database corruption at line 52020 of [2677848087] (11) statement aborts at 24:

Re: [sqlite] damaged database recovery

2015-01-15 Thread Dave Dyer
> >Try doing: sqlite3 old-database .dump | sqlite3 fixed-database > >Then verify that "fixed-database" still contains all of your data. This doesn't work on these databases, even undamaged ones. I think it's a buffer size problem with sqlite3. The databases contain some rather long text

Re: [sqlite] sqlite3 tool bug

2015-01-16 Thread Dave Dyer
I have a class of database for which using sqlite3 to create a copy via the "pipe" method fails. Using an explicit intermediate file seems to work ok. I can supply a sample database to anyone interested in investigating. -- F:\2013 YearTech\Yearbook Tools\Resource>sqlite3 -version 3.7.3

Re: [sqlite] sqlite3 tool bug

2015-01-16 Thread Dave Dyer
> >Rather than the full database, can you show us the full schema of this >database, including triggers? It's a very simple database, no triggers or coalitions. The problem is most likely a buffer overrun because of a very long literal string field. I've sent a minimal sample to drh

Re: [sqlite] sqlite3 tool bug

2015-01-16 Thread Dave Dyer
> >The pipe method works fine for me on Linux. > >I'm guess this is a case of the windows command-line shell doing some >character translations in the pipe, rather than just shipping the >bytes through the pipe unaltered. Ouch. That basically means the "pipe" method shouldn't ever be used on

Re: [sqlite] sqlite3 tool bug

2015-01-16 Thread Dave Dyer
> >The pipe method works fine for me on Linux. > >I'm guess this is a case of the windows command-line shell doing some >character translations in the pipe, rather than just shipping the >bytes through the pipe unaltered. Ouch. That basically means the "pipe" method shouldn't ever be used on

Re: [sqlite] sqlite3 tool bug

2015-01-16 Thread Dave Dyer
> >Not, at least, when your database contains string data with unusual >characters that Windows feels like it should translate for you... Who can guarantee what characters are used in all their text strings, much less guarantee what unnamed transformations windows is helpfully doing to pipe

  1   2   3   4   5   >