Re: [sqlite] Getting an advance list of RowIDs for a query result set

Simon, I’ve no users. I’ve been teaching myself c++ (and SQLite) during a lengthy illness so this is just experimentation for me. This subject touches on a previous question of mine you were involved in regarding redundant tables. The following may jog your memory create table TblA(A

Re: [sqlite] Help . . . I want to Export my Firefox Bookmarks to .CSV in one click, using SQLite3 in a .BAT file

You have to do two things to run SQL statements from a batch file: 1. Use quotes so that all parameters to sqlite3.exe are a single parameter; and 2. Use quotes so that SQL strings are delimited correctly. e-mail wrote: > sqlite3.exe -csv "C:\...\places.sqlite" "SELECT ... >

[sqlite] Help . . . I want to Export my Firefox Bookmarks to .CSV in one click, using SQLite3 in a .BAT file

This "view" works in "DB Browser for SQLite" to get my Firefox Bookmarks . . . I then export them to Desktop as a .CSV, and run an Excel macro on them . . . SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/100,"unixepoch","localtime") AS Date FROM moz_bookmarks AS a

[sqlite] Bug: When it's needs quotation on csv mode in WIN32, The columns is not converted by winUnicodeToMbcs.

Hello, Everyone. I'm Akira. I found a bug. I use sqlite3 on windows. I figure out that odd character on CSV mode when I use Mbcs. I understood that the columns is not converted by winUnicodeToMbcs when it's needs quotation on csv mode in WIN32 Please see lines from 2553 to 2558 below

[sqlite] Simple read-only program very slow

I'm pretty new at SQLite, so this may seem obvious to you. Be kind. I'm using Python on Ubuntu Linux 16.04 LTS, and the sqlite that is built into Python. The database is using WAL. I've got a database of some 100 million records, and a file of just over 300 thousand that I want represented in

Re: [sqlite] Getting an advance list of RowIDs for a query result set

This is fixed in the current head of trunk. Although the implementation may change, it will appear in the next release. https://www.sqlite.org/src/timeline?n=50 --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume.

Re: [sqlite] Compiling on Xcode

>Hi, ALL, >Right now my C Language option on the Xcode 5.1.1 is set to "GNU99". >When using this option I am getting a lot of different warnings like: > >Value Conversion Issue >Implicit conversion loses integer precision. > >I know its just a warning, but I prefer the code to be compiled clean.

[sqlite] fts5CreateTokenizer pUserData destruction in case of failure

I have been working on a custom FTS5 tokenizer using SQLite 3.21.0. I noticed that in fts5CreateTokenizer() if the call to sqlite3_malloc() fails SQLITE_NOMEM is returned, however xDestroy (if present) is not called. A similar situation is handled differently in sqlite3_bind_pointer(); in that

Re: [sqlite] More timeline changes.

On 25 Nov 2017, at 1:41pm, Richard Hipp wrote: > Web developers - help me with this: For item (3) above, how can I > make the ellipsis or icon to "show more detail" configurable using > CSS? Declare two different CSS classes: one is the "hidden" one which does not show the

Re: [sqlite] fts5CreateTokenizer pUserData destruction in case of failure

On 11/25/2017 02:57 AM, Stephen F. Booth wrote: I have been working on a custom FTS5 tokenizer using SQLite 3.21.0. I noticed that in fts5CreateTokenizer() if the call to sqlite3_malloc() fails SQLITE_NOMEM is returned, however xDestroy (if present) is not called. A similar situation is

[sqlite] Get wal page count out of context of wal_hook?

Dear all, I'm looking for a mean to query the current WAL page count (at other times than at commit through the wal_hook() callback). Did I overlooked something in the C API which would allow me to query this? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia

Re: [sqlite] Getting an advance list of RowIDs for a query result set

A trivial example of what I'm trying to do. Given select * from AwfyBigTbl where ACol=?; I'd run the query select RowID from AwfyBigTbl where ACol=?; step through the records and store the values in a std::vector called ID. I could then retrieve n records starting at TopRecNo (0 based) with

Re: [sqlite] Getting an advance list of RowIDs for a query result set

On 25 Nov 2017, at 1:15pm, curmudgeon wrote: > Given a select where a 'base table' is attached to lookup tables > how can I determine which of the lookup tables can be removed from the table > such that > > select BaseTbl.RowID from ... where ... order by ... > > will

Re: [sqlite] Getting an advance list of RowIDs for a query result set

Sorry, in last post select * from (select Value from carray(ID+?1, ?2, 'int64')) inner join AwfyBigTbl on AwfyBigTbl.RowID = _Value; by setting ?1 = TopRecNo and ?2 = n. should read select * from (select Value from carray(*?1*, ?2, 'int64')) inner join AwfyBigTbl on AwfyBigTbl.RowID = _Value;

[sqlite] More timeline changes.

In the latest code on https://www.fossil-scm.org/fossil/timeline and at https://sqlite.org/srcx/timeline has a "Declutter" button on the sub-menu bar to simplify the screen. In the simplified timeline, there is a "Details" button to get all the details back again. I'm not done with this

[sqlite] Wrong mailing list..... Was: More timeline changes.

Please ignore. This post was intended for fossil-us...@lists.fossli-scm.org, not for the SQLite users mailing list. My appologies.. On 11/25/17, Richard Hipp wrote: > In the latest code on https://www.fossil-scm.org/fossil/timeline and > at https://sqlite.org/srcx/timeline

Re: [sqlite] "BIGINT" doesn't act like INTEGER on table creation [Bug]

Are people here talking about UUIDs or things that just look like UUIDs? It sounds like the latter. UUIDs are actually structured objects, with embedded type bits. There are multiple UUID generation schemes, one of which is based on random numbers, others are based on hashes, and there is the

Re: [sqlite] "BIGINT" doesn't act like INTEGER on table creation [Bug]

Ah, I see someone else has already brought up version 1 UUIDs. > What about invalid and reused MAC addresses and devices with no MAC address > at all? Not an issue with SQLite since that part of the UUID is a constant within a given database. It would be reasonable to simply pick "0" then set

Re: [sqlite] "BIGINT" doesn't act like INTEGER on table creation [Bug]

>> What about time resets to the epoch which are not restored, user time >> changes, > > I know some systems at least increment the node each time a time change is > detected. It will take 2^47 time changes to roll over. Since the node part is > not relevant to SQLite, this is perfectly safe.