Re: [sqlite] Is it bad to...

David Gewirtz wrote: John Stanton wrote: What language are you using? Certain language environments would make implementing the server clumsy. I'm using an environment called the Frontier Kernel (http://www.frontierkernel.org), which is the open source version of the original UserLand

RE: [sqlite] Is it bad to...

John Stanton wrote: > What language are you using? Certain language environments would make implementing the server clumsy. I'm using an environment called the Frontier Kernel (http://www.frontierkernel.org), which is the open source version of the original UserLand Frontier. As obscure as that

Re: [sqlite] PRAGMA table_info() reveals primary keys

Dennis Cote wrote: You should create a documentation bug ticket so these things will get fixed. Done. -- David - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] PRAGMA table_info() reveals primary keys

David Crawshaw wrote: I had need of a programmatic interface to determine the primary keys of a table, so I went to add it to pragma table_info, only to discover it is already there. The comment in pragma.c seems out of date, failing to mention the sixth column 'pk', and so is

Re: [sqlite] Using TEXT vs BLOB

On Fri, 10 Nov 2006, toofah wrote: I am somewhat new to sqlite and am a novice at setting up databases for a product, so here goes: Gary, This is a good learning situation. Lots of useful information on the web site: . What are the Advantages/Disadvantages to

[sqlite] Using TEXT vs BLOB

I am somewhat new to sqlite and am a novice at setting up databases for a product, so here goes: What are the Advantages/Disadvantages to using TEXT vs. BLOB to store and access data in sqlite...or are they pretty equal. Most of my data is string data...but for some reason the previous

Re: [sqlite] Is it bad to...

The traditional CGI approach is to open and close the database for each transaction. If you build your own threaded server to avoid that it does not make sense to continue the open and close situation. Opening and closing the DB is not an enormous overhead, but is ugly if your clients are

Re: [sqlite] Journal file corrouption on power failure .

"jayanth KP" <[EMAIL PROTECTED]> wrote: > I have set PRAGMA synchronous=FULL; > Do your power-off-corruption thing and send me copies of both the journal file and the original database and I will see what I can find. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Journal file corrouption on power failure .

"jayanth KP" <[EMAIL PROTECTED]> wrote: > Hi, > >I have a question regarding powerfailure. I am using sqlite version 2.8.13 > . I am seeing that the database is getting corrupted after power failure > during delete database entry operation. > > Try setting PRAGMA synchronous=FULL; --

[sqlite] Journal file corrouption on power failure .

Hi, I have a question regarding powerfailure. I am using sqlite version 2.8.13 . I am seeing that the database is getting corrupted after power failure during delete database entry operation. Here are my observation that may give you gugs some insight: 1. I see a journal file in the

[sqlite] Re: Is it bad to...

* David Gewirtz <[EMAIL PROTECTED]> [2006-11-10 02:45]: > In my ongoing attempt to find the best approach for integrating > SQLite into a threaded Web-serving environment, I came upon > a truly crude kludge, and I wanted to know if it's bad from an > SQLite architectural standpoint. I know it's

RE: [sqlite] weird (and dangerous) bug in Microsoft Compiler

Robert, I re-verified using your option set, and I still get the same problem. there is clearly something wrong here, and it is not easy to track down. I wonder if you could help me with this. Shall we take this off-line, so that we dont clutter the list, and report back when done ? I would