RE: [sqlite] Encryption?

On Wed, 2007-12-19 at 16:10 -0800, James Dennett wrote: > > -Original Message- > > From: Jason Tudor [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, December 19, 2007 4:06 PM > > To: sqlite-users@sqlite.org > > Subject: [sqlite] Encryption? > > > > Is there any encryption functionality

RE: [sqlite] Encryption?

> -Original Message- > From: Jason Tudor [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 19, 2007 4:06 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Encryption? > > Is there any encryption functionality built into SQLite? Not in the public domain version. > Also, can I use

[sqlite] Encryption?

Is there any encryption functionality built into SQLite? Also, can I use extensions other than .db for SQLite database filtes? Thanks Tudor

[sqlite] How to detect prepared queries associated with a connection?

Hi, I threw an exception closing my connection due to prepared queries that were not finalized. I have a wrapper around sqlite3_close. I would like to detect and finalize all prepared statements associated with the connection prior to calling sqlite3_close(). Is there a way to query the

[sqlite] SQLite 3.5.4 and libc version less than GLIBC_2.3

Is "safe" recompile sqlite3 to use LIBC with version less than 2.3 (like GLIBC_2.2.4)? Thanks for the help, Best regards, Joaquim - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Trying to understand SQLITE3_BUSY

[EMAIL PROTECTED] wrote: "Doug" <[EMAIL PROTECTED]> wrote: Well, I'm stuck. If I use the CLI I get: D:\dev\SQLite\3_4_1\Bin>sqlite3 myproj.db SQLite version 3.4.1 Enter ".help" for instructions sqlite> pragma synchronous=0; SQL error: database is locked sqlite> .quit However, I find I can

Re: [sqlite] Trying to understand SQLITE3_BUSY

"Doug" <[EMAIL PROTECTED]> wrote: > Thank you Richard. > > I have full rights to that directory tree and to the main database file, but > it turns out the journal was created by a service, and so the journal was > only writable by the service account. > That solved it. > > Thanks again --

RE: [sqlite] Trying to understand SQLITE3_BUSY

Thank you Richard. I have full rights to that directory tree and to the main database file, but it turns out the journal was created by a service, and so the journal was only writable by the service account. That solved it. Thanks again -- one small stress removed from my life :) >

Re: [sqlite] SQLite for NAS storage - DVR like application

Trilok Soni wrote: Hi John, On Dec 18, 2007 11:53 PM, John Stanton <[EMAIL PROTECTED]> wrote: Sqlite depends upon POSIX file locks. It is no better or no worse than the POSIX lock implementation on your platform. Thanx for the reply. My platform is based on Linux running on ARM9, with

Re: [sqlite] recognizing a sqlite database?

On 12/19/07, Dave Dyer <[EMAIL PROTECTED]> wrote: > > Is there an officially sanctioned magic number test to recognize > a sqlite database? I'd like to allow a user to browse for a file, > and if it happens to be a sqlite database to take a separate path. > You could read the file and check for

[sqlite] recognizing a sqlite database?

Is there an officially sanctioned magic number test to recognize a sqlite database? I'd like to allow a user to browse for a file, and if it happens to be a sqlite database to take a separate path. - To unsubscribe,

Re: [sqlite] How to truncate the hour

I think your description of 1198990800 is a little off sqlite> select datetime(1198990800, 'unixepoch'); 2007-12-30 05:00:00 To "truncate the hour", as you say: sqlite> select strftime('%s', date(1198990800, 'unixepoch')); 1198972800 Which translates to 2007-12-30 00:00:00 -Clark -

Re: [sqlite] Trying to understand SQLITE3_BUSY

"Doug" <[EMAIL PROTECTED]> wrote: > Well, I'm stuck. If I use the CLI I get: > > D:\dev\SQLite\3_4_1\Bin>sqlite3 myproj.db > SQLite version 3.4.1 > Enter ".help" for instructions > sqlite> pragma synchronous=0; > SQL error: database is locked > sqlite> .quit > > However, I find I can copy the

Re: [sqlite] How to truncate the hour

Joanne Pham wrote: > Hi P > Sorry for the confusion! > Current my hourAppAcclTable is store the following > 1, 1198990800 > 2, 1198998000 > which is 2007-12-29 21:00:00 and 2007-12-29 23:00:00 if I used the datetime > function to show the time format. > What I want is to store

Re: [sqlite] shared cache mode locking

Some additional info: when the sqlite_lock is returned there is another thread that appears to be reading the same table. Does the sqlite3 step return sqlite_locked in this case? Thanks, Ken Ken <[EMAIL PROTECTED]> wrote: While using the new 3.5.4 sqlite3_enable_shared_cache I ran into a

Re: [sqlite] How to truncate the hour

Hi P Sorry for the confusion! Current my hourAppAcclTable is store the following 1, 1198990800 2, 1198998000 which is 2007-12-29 21:00:00 and 2007-12-29 23:00:00 if I used the datetime function to show the time format. What I want is to store this time stamp in different table but

RE: [sqlite] Trying to understand SQLITE3_BUSY

Well, I'm stuck. If I use the CLI I get: D:\dev\SQLite\3_4_1\Bin>sqlite3 myproj.db SQLite version 3.4.1 Enter ".help" for instructions sqlite> pragma synchronous=0; SQL error: database is locked sqlite> .quit However, I find I can copy the database and journal and do the same thing on the copy

[sqlite] shared cache mode locking

While using the new 3.5.4 sqlite3_enable_shared_cache I ran into a strange lock situation. SQLITE_LOCK is returned from an insert statement, even though the thread/connection performed a successful "begin exclusive" transaction. begin exclusive insert into

Re: [sqlite] How to truncate the hour

On 12/19/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi, > strftime doesn't work for me. I appreciate if you can help me on this. > > My hourlyAppAcclTable > row1 - 1, 1198990800 -- (which is 12-29-2007 21:00:00) > row 2 - 2, 1198998000 - (which is 12-29-2007 23:00:00) > I want to

Re: [sqlite] How to truncate the hour

select date(startTime, 'unixepoch','-8 hours'); SQLite's date/time functions are documented at http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions -Clark - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, December 19, 2007

Re: [sqlite] How to truncate the hour

Hi, strftime doesn't work for me. I appreciate if you can help me on this. My hourlyAppAcclTable row1 - 1, 1198990800 -- (which is 12-29-2007 21:00:00) row 2 - 2, 1198998000 - (which is 12-29-2007 23:00:00) I want to truncate all the hour fraction and store these time in dayAppAcclTable

Re: [sqlite] How to truncate the hour

On 12/19/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, > I have the table as defined below: > hourlyAppAcclTable ( appid INTEGER, > startTime INTEGER -- is number of seconds in > GMT time in the integer > . > ) > > the values

[sqlite] How to truncate the hour

Hi All, I have the table as defined below: hourlyAppAcclTable ( appid INTEGER, startTime INTEGER -- is number of seconds in GMT time in the integer . ) the values in this table is : row1 - 1, 1198990800 row 2 - 2,

Re: [sqlite] Trying to understand SQLITE3_BUSY

"Doug" <[EMAIL PROTECTED]> wrote: > I have a database file that was created with version 3.4.1. It _may_ have > been written to at some point with 3.5.3 - can't say for sure. At some > point a transaction was started and the app was stopped (probably me in the > debugger). I assume I was using

[sqlite] Trying to understand SQLITE3_BUSY

I have a database file that was created with version 3.4.1. It _may_ have been written to at some point with 3.5.3 - can't say for sure. At some point a transaction was started and the app was stopped (probably me in the debugger). I assume I was using 3.4.1 at the time it but it could

Re: [sqlite] Re: getting PRIMARY KEY of last inserted object ?

Fine, thanks a lot ! yvon

Re: [sqlite] SQlite in PDA with Windows CE

noel frankinet schrieb: Jorge Rodríguez Pedrianes a écrit : Hello, Anybody Knowk to use sqlite embeden in a PDA??, I saw that i can download a .dll to windows, but can I use this dll in PDA? I saw the documentation but don't find anything about this. Anybody can I help me?? If your happy

Re: [sqlite] SQlite in PDA with Windows CE

Jorge Rodríguez Pedrianes a écrit : Hello, Anybody Knowk to use sqlite embeden in a PDA??, I saw that i can download a .dll to windows, but can I use this dll in PDA? I saw the documentation but don't find anything about this. Anybody can I help me?? Thanks!!!

Re: [sqlite] SQLite for NAS storage - DVR like application

Hi Dario, On Dec 19, 2007 6:36 PM, Darío Mariani <[EMAIL PROTECTED]> wrote: > Current implementations of NFS on Linux have a decent lock mechanism > (as far as I know). You'll have to check your NAS device how does it > handle NFS locking. Thanx. I was hoping the same from NFS :) > But, if your

[sqlite] SQlite in PDA with Windows CE

Hello, Anybody Knowk to use sqlite embeden in a PDA??, I saw that i can download a .dll to windows, but can I use this dll in PDA? I saw the documentation but don't find anything about this. Anybody can I help me?? Thanks!!!

Re: [sqlite] sqlite in a daemon

My application is running 24x7 with huge data loads and around 10 open connections all the time. On Dec 19, 2007 4:50 AM, Renaud HUILLET <[EMAIL PROTECTED]> wrote: > > I have that for my soft and it works fine. > > I also have a swap mecanism to update the sqlite file : the daemon gets the >

Re: [sqlite] SQLite for NAS storage - DVR like application

Current implementations of NFS on Linux have a decent lock mechanism (as far as I know). You'll have to check your NAS device how does it handle NFS locking. But, if your NFS device is a complete box and not just a disk array with an ethernet card, you will be better creating a small client-server

Re: [sqlite] SQLite for NAS storage - DVR like application

Hi John, On Dec 18, 2007 11:53 PM, John Stanton <[EMAIL PROTECTED]> wrote: > Sqlite depends upon POSIX file locks. It is no better or no worse than > the POSIX lock implementation on your platform. Thanx for the reply. My platform is based on Linux running on ARM9, with having 128MB of the