[sqlite] Hot journal file won't go away

Drago, William @ CSG - NARDA-MITEQ wrote: > What is the recommended procedure for clearing a hot journal file? Just opening the database should be enough. > I used to do a "SELECT..." but since I upgraded from System.Data.SQLite > 1.0.93.0 to 1.0.96.0 that doesn't work anymore. If the rollback

[sqlite] Hot journal file won't go away

Never mind. It was my own stupidity causing the problem. -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- >

[sqlite] Hot journal file won't go away

All, What is the recommended procedure for clearing a hot journal file? I used to do a "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name" and "SELECT name FROM sqlite_master WHERE type='index' ORDER BY tbl_name" but since I upgraded from System.Data.SQLite 1.0.93.0 to 1.0.96.0

[sqlite] json_* functions in sqlite

Hi Many times I store JSON data in sqlite. It will be useful if sqlite came with functions which understand JSON. Presto has a nice set https://prestodb.io/docs/current/functions/json.html I have two questions 1. Will sqlite overlords consider adding this to sqlite core? 2. If so, what steps

[sqlite] building SQLite DLL with Visual C++

Dear sir Before I sent the last message I had signed up to become a user. My previous message was bounced. WHY copy of previous message: I am new to SQLite. I have a book I am learning from and I am a novice. I have a fairly good handle on SQL I want to include SQLite in my VS2012 program. I

[sqlite] System.Data.Sqlite with EF6 and VS2013 not working with a sqlite database file

Hi all, First I need your instructions about how to reply a daily digest email because if I reply it directly, it seems the email carries a lot of topics which doesn't belong to me and also it would bother others. And it's not very easy for me to locate my topic if there are many and reply it