Re: [sqlite] Why is SQLiteConnection.DataSource set as the database file without its extension?

Ludovic VP wrote: > > Is there a reason why SQLiteConnection.DataSource is set to the database file without the extension? > I'm not sure; however, it cannot be changed at this point without breaking backward compatibility. -- Joe Mistachkin ___

[sqlite] Why is SQLiteConnection.DataSource set as the database file without its extension?

Hi, Is there a reason why SQLiteConnection.DataSource is set to the database file without the extension? // System.Data.SQLite.SQLiteConnection public override void Open(){ ... _dataSource = Path.GetFileNameWithoutExtension(fileName); ... } Kindly, Ludovic

Re: [sqlite] Syatem.Data.SQLite Exception/Error handling via Try...Catch

Thomas E. Davis wrote: > > Essentially the error message gets written to the trace listeners before being > trapped by the Try...Catch block in which the database access attempt is nested. > I'm not sure which error message you are referring to? Could you provide the text of the error

Re: [sqlite] SQLite Provenance

If you want instant info on the 'provenance' of a website use the Firefox add-on "Flagfox". It gives you a little flag next to the address. John Gillespie On 6 July 2012 22:58, Gavin T Watt wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Thanks for the

Re: [sqlite] Updating on 32bit os slower than 64bit?

Are theses tests being run on the same hardware? On Tue, Jul 17, 2012 at 5:09 AM, Black, Michael (IS) wrote: > Something that might be useful is to strace that program Use the "-c" > switch to summarize the system calls first. Then use the "-tt" to show > relative

Re: [sqlite] SQLite4 key encoding -- Is it ever decoded?

On Tue, Jul 17, 2012 at 8:46 AM, Steven E. Harris wrote: > Per my recent posted messages here, I've been studying the data formats > for SQLite4. This question concerns the key encoding and how it is used. > > It's clear that the key encoding format is designed to allow >

[sqlite] SQLite4 key encoding -- Is it ever decoded?

Per my recent posted messages here, I've been studying the data formats for SQLite4. This question concerns the key encoding and how it is used. It's clear that the key encoding format is designed to allow lexicographic ordering of compound keys comprising concatenated attribute values, and that

[sqlite] How to get changed status of database?

Dear all, I'm trying to check database file whether it had been changed by other connections. First hint was a change counter value of sqlite file header. It was good solution to me, whatever I have to make implementation into sqlite to read 24'th byte offset in sqlite file. (It is also difficult

Re: [sqlite] Updating on 32bit os slower than 64bit?

Something that might be useful is to strace that program Use the "-c" switch to summarize the system calls first. Then use the "-tt" to show relative timestamps to identify specific bottlenecks. Also, set up a ram disk on the system and see if that's slow too. That will test the LVM

Re: [sqlite] Null Pointer Dereferences

On Mon, Jul 16, 2012 at 11:02 AM, Stephen Blessing < stephen.bless...@datasplice.com> wrote: > Hi SQLite, > > Have you ever run CppCheck on SQLite? > There are a lot of "Null Pointer Dereferences". > (Please see the attached file) > http://www.sqlite.org/testing.html#staticanalysis > > Thanks

Re: [sqlite] Updating on 32bit os slower than 64bit?

I've tried to set the SQLITE_THREADSAFE=2 and 1, but observed no difference. Any other flag that might affect this? Thanks -- View this message in context: http://sqlite.1065341.n5.nabble.com/Updating-on-32bit-os-slower-than-64bit-tp63292p63319.html Sent from the SQLite mailing list archive at

Re: [sqlite] Updating on 32bit os slower than 64bit?

Michael, Thanks for your reply. My /home is not NFS mounted. It is mounted locally using LVM. I just tested on another 32 bit linux system (rhel 5, not using LVM). It ran much faster than the 32 bit fedora, not as fast as the 64 bit scientific linux but close. I also tried to test on /tmp on the

[sqlite] Null Pointer Dereferences

Hi SQLite, Have you ever run CppCheck on SQLite? There are a lot of "Null Pointer Dereferences". (Please see the attached file) Thanks and best regards, Stephen Blessing Quality Assurance DataSplice, LLC 414 E. Oak Street Fort Collins, CO 80524 (970) 232-1647 supp...@datasplice.com

Re: [sqlite] set of db connections

On 17 Jul 2012, at 9:04am, Durga D wrote: > Hi Simon, what you suggest now? sigle object based or set of connections? Sorry, I have no experience with what you're doing. I hope someone else can advise you or you can try out a solution and tell whether it does what you

Re: [sqlite] Error: datatype mismatch (Yanhong Ye)

On Mon, Jul 16, 2012 at 9:29 PM, YAN HONG YE wrote: > I know the reason: > if I change the file encode to latin, it will suecess import the data; > but when I change the txt file to utf8 encode, It will get the error: > Error: datatype mismatch > I wanna know how to import

Re: [sqlite] set of db connections

Hi Simon, what you suggest now? sigle object based or set of connections? Thanks, On Mon, Jul 16, 2012 at 6:11 PM, Simon Slavin wrote: > > On 16 Jul 2012, at 2:59pm, "Igor Tandetnik" wrote: > > > Durga D wrote: > >> So, I