[sqlite] Trivial typo in queryplanner.html docs

Hi all, reading through queryplanner.html today I notice a trivial typo in section 1.6, line 5: If there were a third column, it would be used to break ties for the first to columns. If there were a third column, it would be used to break ties for the first tWo columns. ^^^ It doesn't spoil

[sqlite] another typo in planner.html

Seection 2.0 line 4 SQLite processes this by gather all the output of query and then running ... SQLite processes this by gathering all the output of query and then running ... A ^^^ ___ sqlite-users

[sqlite] Matchinfo FTS4 token position

Hi all, I need to implement a ranking that considers the search result's token distance (so either the actual character offset, or token offset from the beginning of the text). Is it possible to get/query this distance from the FTS4 index (either directly or via ft4saux), or would I have to

[sqlite] Running sqlite script in Sqlite db using C++

Hi all, I have some sqlite scripts with some sqlite commands like: - .headers ON - .mode CSV etc. Is there anyway of running this script in SqliteDB using Sqlite interface for C++, instead of redirecting the file to sqlite using sqlite command line shell? Thanks

Re: [sqlite] Matchinfo FTS4 token position

On Mon, May 13, 2013 at 12:25 PM, Stadin, Benjamin < benjamin.sta...@heidelberg-mobil.com> wrote: > Hi all, > > I need to implement a ranking that considers the search result's token > distance (so either the actual character offset, or token offset from the > beginning of the text). Is it

Re: [sqlite] Matchinfo FTS4 token position

On 05/13/2013 11:25 PM, Stadin, Benjamin wrote: Hi all, I need to implement a ranking that considers the search result's token distance (so either the actual character offset, or token offset from the beginning of the text). Is it possible to get/query this distance from the FTS4 index

Re: [sqlite] Running sqlite script in Sqlite db using C++

On Tue, May 14, 2013 at 1:53 AM, Dulini Atapattu wrote: > Hi all, > > I have some sqlite scripts with some sqlite commands like: > >- .headers ON >- .mode CSV etc. > > Is there anyway of running this script in SqliteDB using Sqlite interface > for C++, instead

Re: [sqlite] Running sqlite script in Sqlite db using C++

If you are dealing with CSV files, there is a simple API I wrote you can use. https://github.com/fnoyanisi/sqlite3_capi_extensions I was looking for .import functionality for C API, but I ended up writing my own fınctions. On 14/05/2013, at 9:39 PM, Richard Hipp wrote: > On

Re: [sqlite] Matchinfo FTS4 token position

Ok, thanks. I understand offset will come with a performance slowdown, but should be ok for my purpose. However, how can I get the offset(s) as part of the rank function implementation? The FTS offsets function is private: SQLITE_PRIVATE void sqlite3Fts3Offsets(sqlite3_context*, Fts3Cursor*);

Re: [sqlite] Running sqlite script in Sqlite db using C++

If anyway I omit these sqlite commands from script, so is there anyway of providing the script file to API? On Tue, May 14, 2013 at 6:07 PM, wrote: > If you are dealing with CSV files, there is a simple API I wrote you can > use. > >

Re: [sqlite] Running sqlite script in Sqlite db using C++

You may want to consider writing a bash/msdos-batch file and do your stuff from your OS command line Bıt C API is quite handy, you can do most of the stuff with it. On 14/05/2013, at 10:29 PM, Dulini Atapattu wrote: > If anyway I omit these sqlite commands from

[sqlite] Malformed database recovery

Hi everybody. Somehow my database got malformed, and journal file is unfortunately nowhere to found. Suprisingly, I'm able to open it in Sqlite Database Browser, and read stored values. There is only minor data loss, as I can't really see what got missing. I've also managed to figure which

Re: [sqlite] Malformed database recovery

Where there any errors on .read dump_all.sql ? was PRAGMA integrity_check; on the new file or the old one? On Tue, May 14, 2013 at 10:29 AM, Marcin wrote: > Hi everybody. > > Somehow my database got malformed, and journal file is unfortunately > nowhere to found. > >

Re: [sqlite] Running sqlite script in Sqlite db using C++

On 14 May 2013, at 1:59pm, Dulini Atapattu wrote: > If anyway I omit these sqlite commands from script, so is there anyway of > providing the script file to API? If you strip out the lines which start with a dot, everything else in the script should be a legitimate

Re: [sqlite] Compiling libtclsqlite3.so on Cygwin

Warren, thanks, that built the tclsqlite3.o correctly, and a libsqlite3 file also: -rw-r--r-- 1 kchristian Domain Users 39279 May 14 08:47 tclsqlite3.o -rwxr-xr-x 1 kchristian Domain Users 173214 May 14 08:47 libsqlite3.7.16.2.dll Another question, with a small test script, this error is

Re: [sqlite] Malformed database recovery

No errors, but tshockfixed.sqlite is empty, and in the end of file dump_all.sql there is "ROLLBACK; -- due to errors". It's was check of tshock.sqlite, old one. ignac8 Sent: Tuesday, May 14, 2013 4:43 PM Subject: Re: [sqlite] Malformed database recovery Where there any errors on .read

Re: [sqlite] Malformed database recovery

If you can get the errors, by say redirecting the output from the .read to a file, the error message will likely be enlightening. When I recover corrupt db files, there are often some records with a conflicting primary key. In those cases I have to edit the input to fix the old one. Naturally,

Re: [sqlite] Malformed database recovery

Ok, I had a great idea, and propably somehow managed to repair it. I opened dump_all.sql in notepad, deleted two "/ ERROR: (11) database disk image is malformed */", changed ROLLBACK into COMMIT, and it is working so far. ignac8 Sent: Tuesday, May 14, 2013 5:48 PM Subject: Re:

Re: [sqlite] Malformed database recovery

On 14 May 2013, at 4:54pm, "Marcin" wrote: > Ok, I had a great idea, and propably somehow managed to repair it. I opened > dump_all.sql in notepad, deleted two "/ ERROR: (11) database disk image > is malformed */", changed ROLLBACK into COMMIT, and it is working so far.

Re: [sqlite] Malformed database recovery

Of course, I understand that I haven't recovered everything, but as I said before, I don't find any big ammount of data lost ;) Sent: Tuesday, May 14, 2013 5:59 PM Subject: Re: [sqlite] Malformed database recovery On 14 May 2013, at 4:54pm, "Marcin" wrote: Ok, I had a great

Re: [sqlite] Compiling libtclsqlite3.so on Cygwin

On 5/14/2013 09:14, Keith Christian wrote: couldn't load file "./tclsqlite3.o": Exec format error From the Tcl manual: http://tmml.sourceforge.net/doc/tcl/load.html "...such as a .so file under Solaris or a DLL under Windows." Not *.o! My Tcl is awfully rusty, but I managed to get it to

[sqlite] Beginning database question

I am new to database and SQLite too. I found this in archive. What if I would like GUI, where I would go? Thank you, Roman I assume when you say "discrete" you actually mean "bracketed" as there are lots more than 10 heights and weights. I don't know what Excel has to do with this unless

Re: [sqlite] Compiling libtclsqlite3.so on Cygwin

OK Warren, you've helped greatly, thanks again for the assistance, will check other forums if the shared object / dll problems continue. Keith On Tue, May 14, 2013 at 10:53 AM, Warren Young wrote: > On 5/14/2013 09:14, Keith Christian wrote: > >> >> couldn't load file

Re: [sqlite] Beginning database question

On May 14, 2013, at 10:12 AM, Roman Fleysher wrote: > I am new to database and SQLite too. I found this in archive. What if I would > like GUI, where I would go? You could give the Firefox plugin "SQLite Manager" a try: https://addons.mozilla.org/En-us/firefox/addon/sqlite-manager/ Regards,

[sqlite] Question about the changes to e_select.test

Recently several of the expected results in the test e_select.test were changed to results that look very odd. Basically the numbers that were returned by the query were replaced with lots of "#". For example, test 4.10 went from: # EVIDENCE-OF: R-14926-50129 For the purposes of grouping

Re: [sqlite] Question about the changes to e_select.test

On Tue, May 14, 2013 at 3:39 PM, Lauren Foutz wrote: > test 4.10 went from: > "SELECT group_concat(y) FROM b2 GROUP BY x" {0,1 3 2,4} > > To: > > "SELECT group_concat(y) FROM b2 GROUP BY x" {/#,# 3 #,#/} > The other change (that you didn't notice) is that

[sqlite] bind field name?

Hi, is it possible to bind a field name to a sqlite query? For example, WHERE @field1 > @param1 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] bind field name?

On 5/14/2013 7:47 PM, E. Timothy Uy wrote: Hi, is it possible to bind a field name to a sqlite query? For example, WHERE @field1 > @param1 No. A parameter may only appear where a literal would be allowed. -- Igor Tandetnik ___ sqlite-users mailing