|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Dunno... never used it. I love the idea though, so just curious to know the deets.
Jeremy Falcon
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
We had Symantec for our corporate AV and there were times I wondered if that was causing issues too.
|
|
|
|
|
It's a "file". It requires backups like any other file. It is "single user". How it performs, depends on the quality of the code using it. Which includes atomicity.
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
|
|
|
|
|
I've used it without issues in the past
|
|
|
|
|
Thanks for the feedback everyone!
|
|
|
|
|
Halt before release. (7)
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
Prevent ?
Before = Pre
Release = vent
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
|
|
|
|
|
YAUT. Easy for Monday.
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
Peter_in_2780 wrote: Easy for Monday. Except... today is Tuesday
Happiness will never come to those who fail to appreciate what they already have. -Anon
And those who were seen dancing were thought to be insane by those who could not hear the music. -Frederick Nietzsche
|
|
|
|
|
Been working 3 days straight, lost track...
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
With no time off ?
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
|
|
|
|
|
Not continuous! I'm a senior volunteer firefighter, working in communications, dispatching resources and managing firefighting. We've had an unprecedented run of Total Fire Ban days (7 in October, more than the last 3 whole fire seasons) and I've worked shifts in the Ops room on the last 3 days. Normally it would only be that intense if we had major fires in our district or I was deployed out of town. (I've turned down about 20 requests for deployment so far this month.)
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
Fair play to you Peter
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
|
|
|
|
|
Wordle 864 5/6
🟨⬛⬛⬛🟨
⬛⬛🟩🟩⬛
⬛🟩🟩🟩⬛
⬛🟩🟩🟩⬛
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 864 5/6
🟨⬜⬜🟨⬜
⬜⬜🟩🟩⬜
⬜🟩🟩🟩⬜
⬜🟩🟩🟩⬜
🟩🟩🟩🟩🟩
The last four rows of yours and mine have the same green 💚 pattern.
|
|
|
|
|
I almost ran into the same trap.
|
|
|
|
|
Wordle 864 3/6
⬜⬜⬜⬜🟨
⬜🟨⬜🟩🟨
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 864 4/6
⬜🟩🟨⬜🟨
🟨🟩⬜🟨⬜
⬜🟩🟩🟩⬜
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 864 5/6*
⬜⬜🟨🟨🟨
🟨🟨⬜🟨⬜
⬜🟩🟩🟩⬜
⬜🟩🟩🟩⬜
🟩🟩🟩🟩🟩
Happiness will never come to those who fail to appreciate what they already have. -Anon
And those who were seen dancing were thought to be insane by those who could not hear the music. -Frederick Nietzsche
|
|
|
|