SQLite Forum

Timeline
Login

6 forum posts by user Maxulite occurring on or before 2020-06-02 09:59:02.

More ↑
2020-06-02
09:59 Post: Unexepected commit result with two threads application (artifact: ba6f754fc2 user: Maxulite)
Hi

I met an unexpected Sqlite behavior in my note-taking application on Windows. But I may have wrong assumptions about how locking is working so maybe a fix in the code is needed.

The application basically uses the same db in two threads. But each one opens a separate db connection (the same db physical path). 
- Thread 1 is about all general information retrieval and change (UI thread).
- Thread 2 is for quick search in the search box in order to show a popup list of the phrases met a search criteria while the user is typing. 

The problem is when the application want to commit in the main thread (after several Update statements), but quick type search is still searching, the overall consequence looks like a rollback effect: commit returns SQLITE_OK, no new changes in the data, the rollback file is gone and the date of the main db file is the one that was before this change was tried.  

I checked this with 3.32.01 version, Windows 7, 32 bit app 

Do I expect too much about auto-locking handling and probably still need some inter-thread locking mechanism despite the fact that the connections are different? 

Max
2020-05-12
10:58 Post: matrix subpath at sqlite.org (artifact: 1139196f52 user: Maxulite)
Hi,
I noticed some kind of mirror content at sqlite.org. 

For example
  https://www.sqlite.org/index.html
is identical to
  https://www.sqlite.org/matrix/

The confusion starts when search engines currently index both often offering the results as different entries. Try googling [sqlite download] for example. 

Is this some kind of ongoing migration? If so, maybe it's better to forbid one of them with robots.txt? 

Thanks

Max
2020-04-05
12:23 Reply: PSA: All books in the ACM digital library are free to download for the next 3 months (artifact: f1cdee089e user: Maxulite)
Thanks for sharing, and thanks ACM for this great gesture. Plenty of great books and publications. 

Of course, I queried Sqlite, also interesting research books and papers. Found a past year interview with drh
  [Richard Hipp Speaks Out on SQLite]
  https://dl.acm.org/doi/10.1145/3377330.3377338
It was probably behind the paywall since the publication date, at least some very interesting direct quotes from it are not discoverable by Google.
2020-03-30
09:33 Reply: progress handler from user functions (artifact: a762001840 user: Maxulite)
I thought maybe for some reasons, the context of calling the progress handler and user function might be different for sqlite. But according to the docs, the progress handler is already quite restricted in what it can do (no database connection modification). Also common sense hints that both are quite "external" for Sqlite. 

Probably the main concern for me in this case is to get the progress handler I registered previously. In my case it's not global, but specific for particular database connection oop object. I'm sure there's no sqlite3_get_progress_handler or something like this in api, so probably I will have to implement some global registration to obtain the handler of a database connection from the global context of user functions.
2020-03-29
17:35 Post: Seach engine crawling of new forum posts (artifact: 5fd0acff89 user: Maxulite)
Hi,

I usually made a site-bound search of sqlite mailing list archives before posting about some specific topic. With the new forum I have to add a new step for searching on this new forum. I see that there is full-text search enabled on the site, but I sometimes prefer using Google. But currently, despite the fact that the forum already a couple of weeks old, the query 

  site:https://sqlite.org/forum/

as well as 

  site:https://sqlite.org/forum/forumpost/

in Google don't show any post results. 

Is this intentional or just some unexpected disagreement between the site and the search engine? This couple of week delays is not a big deal for an average site, but sqlite.org is too important resource to crawl with low priority imho.

Thanks

Max
17:08 Post: progress handler from user functions (artifact: 03c94975a1 user: Maxulite)
Hi

My function might wait for some condition to be met (even as simple as delay), but I would like to software still be responsive during these period. Can the user function use the progress handler that was registered with sqlite3_progress_handler directly? And if it's not a good idea, is there some sqlite3_ call I might invoke in order to achieve this?

Thanks 

Max