[sqlite] Hot journal file won't go away

[Clemens Ladisch]

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 of the interrupted transaction fails, it should not be
possible to even read from the database.

Are you sure that the journal is still hot?  Might the journal mode be
something other than "delete"?


Regards,
Clemens

[sqlite] Hot journal file won't go away

[Drago, William @ CSG - NARDA-MITEQ]

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-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Clemens Ladisch
> Sent: Tuesday, April 21, 2015 4:30 PM
> To: sqlite-users at mailinglists.sqlite.org
> Subject: Re: [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 of the interrupted transaction fails, it should not be
> possible to even read from the database.
>
> Are you sure that the journal is still hot?  Might the journal mode be
> something other than "delete"?
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

[sqlite] Hot journal file won't go away

[Drago, William @ CSG - NARDA-MITEQ]

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 that doesn't work 
anymore.



Thanks,

--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com


CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

[sqlite] json_* functions in sqlite

[Ashish Sharma]

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 are needed for this?

Thanks
Ashish

[sqlite] building SQLite DLL with Visual C++

[Jay Smith]

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 am attempting to run " LIB  /DEF:sqlite3.def "

I get error This error "LIB is not recognized as an internal or external
command."

What am I doing wrong?

On Mon, Apr 20, 2015 at 10:21 AM, Jay Smith  wrote:

> 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 am attempting to run " LIB  /DEF:sqlite3.def "
>
> I get error This error "LIB is not recognized as an internal or external
> command."
>
> What am I doing wrong?
>
> Jay
>

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

[Jingfei Hu]

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
accordingly. BTW, I don't receive an independent reply for the topic of
myself. Only digest email is received. Is it because I choose to? Anyway I
only leave the message I want here and comment in line. Thanks.

--

Message: 4
Date: Sun, 19 Apr 2015 17:22:06 -0700
From: "Joe Mistachkin" 
To: "'General Discussion of SQLite Database'"

Subject: Re: [sqlite] System.Data.Sqlite with EF6 and VS2013 not
working with asqlite database file
Message-ID: <16CD11762DDC441E9DAFF33904AE7DC7 at LACHRYMOSE>
Content-Type: text/plain;   charset="us-ascii"


Jingfei Hu wrote:
> 
> I have a VS2010 project from one of my friends. The project contains a
> sqlite3 database file containing some tables and some views. According to
my
> friend, the database file is working properly with Visual Studio 2010 at
> that time. Also I can see the edmx file and generated code files from the
> VS2010 project. And I also find out it still uses provider
> System.Data.Sqlite instead of System.Data.Sqlite.EF6.
> 

What version of System.Data.SQLite is he using?  Recent versions should
default
to the System.Data.SQLite.EF6 provider.
Jingfei: The version information has been lost because my friend is not an
IT guy. And the project, you know, has been through a lot transitions. Apart
from that, which version does it start from that the Sytem.Data.SQLite use
System.Data.SQLite.EF6 provider as the default? I download a
sqlite-netFx40-setup-bundle-x86-2010-1.0.82.0 from another website because
this system.data.sqlite.org doesn't maintain the old version. And that
version still uses System.Data.SQLite as the default. 
> 
> And when I open the project with Visual studio 2013 and compile it, it has
a
> failure saying 'the provider System.Data.Sqlite has not been registered in
> app.config or machine.config'. To fix this, first I complete the following
> installations
> 

That error message makes sense.  The System.Data.SQLite.EF6 provider should
be
used when EF6 support is wanted.

> 
> Then open the edmx file with Xml editor and manually change the
> 'System.Data.Sqlite' to 'System.Data.Sqlite.EF6' and then compile it, the
> error message changes to be like 'Object not reference an instance'. After
> that I try another way, delete the existed edmx file (starting from
> scratch). When I use 'New ADO.Net Entity Model' wizard of VS2013 to create
a
> model in a new console project, everything appears fine, but actually not.
> One of the view I need heavily is not auto-generated with the below
warning
> message
> 

Using an EDMX generated with one version of Visual Studio with a different
version seems unlikely to work, at least from my personal experience.

> 
> warning 6013: The table/view 'main.xxx does not have a primary key defined
> and no valid primary key could be inferred. This table/view has been
> excluded. To use the entity, you will need to review your schema, add the
> correct keys, and uncomment it.
> 

If the table actually does have a primary key defined, maybe the EDMX from
the
other version of Visual Studio is incompatible?

Jingfei: No, the view doesn't have a primary key defined. I recheck the
schema using sqlite console tool and it doesn't have.  However, in Visual
Studio 2010, it can infer a primary key for the view from the database file.
So I wonder whether it's the version of VS or the version of
System.Data.Sqlite that causes this difference.

--
Joe Mistachkin