Welcome to the Lounge

31-Oct-23 2:27

The guides did an excellent job of keeping us away from protestors, we didn't get to do everything on the list but it was an excellent trip.

But on the way home I started to feel a bit sick and the next day Covid, for the second time and this time seems worse than the first.

I don't think before I open my mouth, I like to be as surprised a everyone else.
PartsBin an Electronics Part Organizer - Release Version 1.3.0 JaxCoder.com
Latest Article: SimpleWizardUpdate

Gary Wheeler31-Oct-23 6:23

Gary Wheeler

31-Oct-23 6:23

Yikes; take care, Mike.

I've had it once, and that was more than enough (my sense of smell is still iffy).

Software Zen: delete this;

Choroid31-Oct-23 8:19

Choroid

31-Oct-23 8:19

Mike this is not Medical Advice nor Not jumping to conclusions
You might like to watch this
TWiV 1056: Clinical update with Dr. Daniel Griffin - YouTube[^]

Take Care Hope it is a mild case

Kevin Marois31-Oct-23 8:28

Kevin Marois

31-Oct-23 8:28

Where in Panama did you go?

In theory, theory and practice are the same. But in practice, they never are.”
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.

Mike Hankey31-Oct-23 8:37

31-Oct-23 8:37

We started and ended in Panama City, went through the canal on a fairy and went to the Gatun Rain Forest and did the ?trolly? (not sure that's what it is called, a 4-6 person open cage that went though the rain forest).

I don't think before I open my mouth, I like to be as surprised a everyone else.
PartsBin an Electronics Part Organizer - Release Version 1.3.0 JaxCoder.com
Latest Article: SimpleWizardUpdate

Nelek31-Oct-23 10:34

Nelek

31-Oct-23 10:34

Mike Hankey wrote:
for the second time and this time seems worse than the first.

Hopefully was the first very soft and this is just medium Smile | :)

Recover good and fast Rose | [Rose]

M.D.V.

If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.

Mike Hankey31-Oct-23 10:45

31-Oct-23 10:45

Thanks, 3 days in and still feel like a truck ran over me.

I don't think before I open my mouth, I like to be as surprised a everyone else.
PartsBin an Electronics Part Organizer - Release Version 1.3.0 JaxCoder.com
Latest Article: SimpleWizardUpdate

Christian Graus31-Oct-23 12:39

Christian Graus

31-Oct-23 12:39

That sucks. On the other hand, I reach down, between my legs, ease the seat back.....

Sander Rossel31-Oct-23 23:57

Sander Rossel

31-Oct-23 23:57

Did you get some of that famour Panama paper I've been hearing about?
Apparently it's top notch!

Get well soon.

Best,
Sander

Azure DevOps Succinctly (free eBook)
Azure Serverless Succinctly (free eBook)
Migrating Apps to the Cloud with Azure
arrgh.js - Bringing LINQ to JavaScript

SQLite

milo-xml31-Oct-23 2:04

milo-xml

31-Oct-23 2:04

So yesterday an article lauding the benefits of SQLite was sent out in the Daily Insider email. We have one application that uses it and we've had database corruption issues with it. I'm curious to everyone else's experience with it.

Richard MacCutchan31-Oct-23 2:23

Richard MacCutchan

31-Oct-23 2:23

I have used SQLite a lot and never had a problem. If this is a major issue for you then you could open a proper technical discussion at Database Discussion Boards[^] or https://www.codeproject.com/Questions/ask.aspx[^].

Mike Hankey31-Oct-23 2:23

31-Oct-23 2:23

I've used it on several projects and not had any problems with it.

The only time I had a problem was when I first started using it I would open the DB and leave it open and had corruption problems.

I don't think before I open my mouth, I like to be as surprised a everyone else.
PartsBin an Electronics Part Organizer - Release Version 1.3.0 JaxCoder.com
Latest Article: SimpleWizardUpdate

milo-xml31-Oct-23 2:27

milo-xml

31-Oct-23 2:27

This is a third party application and I think that's what they were doing. We have a newer version and I'm hoping they've taken care of this.

dandy7231-Oct-23 4:01

dandy72

31-Oct-23 4:01

Mike Hankey wrote:
The only time I had a problem was when I first started using it I would open the DB and leave it open and had corruption problems.

I wouldn't stop using whatever working database solution is currently being used in a project in favor of something that will corrupt itself by misusing its API. That sort of thing needs to be rock-solid before it can become a serious contender as an alternative to anything else.

raddevus31-Oct-23 3:16

raddevus

31-Oct-23 3:16

I've had great success with it. It's an amazing little database.
The technology and the guy who created it is a really interesting story too.
Here's a fantastic podcast that tells the story (interview with Richard Hipp original creator) : The Untold Story of SQLite With Richard Hipp - CoRecursive Podcast[^]

pkfox31-Oct-23 3:39

pkfox

31-Oct-23 3:39

As others have stated, always close the connection when you've finished with it, I've used it on a lot of applications and never had a problem. I love its portability.

In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP

Jeremy Falcon31-Oct-23 3:56

Jeremy Falcon

31-Oct-23 3:56

Just out of curiosity... can only assume connections are cheap (as in fast) since it's local, correct?

Interestingly enough, in the web world, we do the opposite at times. In fact, depending on the site, there may even be a connection pool.

Jeremy Falcon

pkfox31-Oct-23 7:30

pkfox

31-Oct-23 7:30

Yes I believe so Jeremy , the database is basically a very cleverly constructed flat file ( probably lots of linked lists in there ). Please correct me if I'm misdirected

In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP

Jeremy Falcon31-Oct-23 14:02

Jeremy Falcon

31-Oct-23 14:02

Dunno... never used it. I love the idea though, so just curious to know the deets.

Jeremy Falcon

raddevus1-Nov-23 4:27

raddevus

1-Nov-23 4:27

I highly recommend the podcast with the original creator of SQLite The Untold Story of SQLite With Richard Hipp - CoRecursive Podcast[^]

CoRecursive with Adam Gordon Bell is really great, but this particular one is one of the all-time best.
You will get the details of how SQLite came to be and a lot of information of the challenges that Hipp had as he created it. Really great!!! I promise. Smile | :)

jschell31-Oct-23 6:16

jschell

31-Oct-23 6:16

Long ago, decades, database corruption happened for all databases.

Lately it just doesn't happen.

So this was interesting to me. Googling I find that SQLite itself documents the causes...

How To Corrupt An SQLite Database File[^]

That lists quite few possible problems basically broken down into the following
1. The application using it is wrong.
2. Manual mismanagement of the environment.
3. Problems with the environment

milo-xml1-Nov-23 1:28

milo-xml

1-Nov-23 1:28

We had Symantec for our corporate AV and there were times I wondered if that was causing issues too.