Re: [sqlite] leaving database connection open

2009-08-14 Thread Igor Tandetnik
Ricardo Ayres Severo wrote: > My question is if I would face any problem by opening the database > when my application starts and actually never closing it. I don't do > any access across threads. You shouldn't have any problems with this. It's a pretty common access pattern (except that most ap

[sqlite] leaving database connection open

2009-08-14 Thread Ricardo Ayres Severo
Hi All, I'm using SQLite3 with a Embedded Linux application. The problem I'm facing is that there's a bug in the Linux kernel I'm using that the open files counter isn't being decremented when a file descriptor is closed. With that my application simply crashes after some time of usage. Because of