SQLite
-
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.
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[^]
-
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.
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
-
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
-
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
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.
-
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.
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
-
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.
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
-
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
-
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.
I've used it without issues in the past
-
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
-
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
-
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.
-
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. :)
