Re: [sqlite] Encoding and Collation

Antonio Maniero wrote: > Why SQLite dropped the 8859 or single byte support for text? Is there > any technical reason? What do you mean, dropped? What exactly used to worked before and has stopped working now? What event has occurred between then and now that you attribute

[sqlite] Encoding and Collation

Hi Sorry by my bad English. Why SQLite dropped the 8859 or single byte support for text? Is there any technical reason? Is there any ready simple solution to use case insensitive collation on SQLite to work with non-English (Latin) characters? I don't need and I don't want a full ICU

Re: [sqlite] UNIQUE in PRAGMA Table_Info

On Sep 10, 2011, at 9:41 AM, Thomas Baumann wrote: > can you please add a column to the result of PRAGMA Table_Info() that > indicates this column is UNIQUE? > > Just like the notnull column. > > I don't want to parse the whole sql string for this property only. > > Or have I missed

Re: [sqlite] Database is full warnings

Simon: Thank you - let me run all this to ground. Ray On Sep 10, 2011, at 12:40 PM, Simon Slavin wrote: > > On 10 Sep 2011, at 8:28pm, Ray wrote: > >> I am using the Sqlite3 API. >> >> Why is so much free disc required? > > The error you reported means "I have run out of free space on a

Re: [sqlite] Database is full warnings

My mistake - sorry! On Sep 10, 2011, at 12:30 PM, Richard Hipp wrote: > On Sat, Sep 10, 2011 at 3:28 PM, Ray wrote: > >> I am using the Sqlite3 API. >> > > If you are using the sqlite3 API, then why is the warning message about the > sqlite2 API? Is that a bug in PHP?

Re: [sqlite] Database is full warnings

On 10-09-2011 21:48, Simon Slavin wrote: > > On 10 Sep 2011, at 8:47pm, Luuk wrote: > >> Should that 10Gb not be, if free space drops below 10% of diskspace? > > You are sort of correct. It is different things -- sometimes a percentage, > sometimes a fixed number -- in different OS and

Re: [sqlite] Database is full warnings

On 10 Sep 2011, at 8:47pm, Luuk wrote: > Should that 10Gb not be, if free space drops below 10% of diskspace? You are sort of correct. It is different things -- sometimes a percentage, sometimes a fixed number -- in different OS and different versions. I quoted 10Gig to show the OP that

Re: [sqlite] Database is full warnings

On 10-09-2011 21:40, Simon Slavin wrote: > > On 10 Sep 2011, at 8:28pm, Ray wrote: > >> I am using the Sqlite3 API. >> >> Why is so much free disc required? > > The error you reported means "I have run out of free space on a disk.". > > SQLite makes temporary files while you use it. If you

Re: [sqlite] Database is full warnings

On 10 Sep 2011, at 8:28pm, Ray wrote: > I am using the Sqlite3 API. > > Why is so much free disc required? The error you reported means "I have run out of free space on a disk.". SQLite makes temporary files while you use it. If you use some APIs these temporary files go in the same folder

Re: [sqlite] Database is full warnings

On Sat, Sep 10, 2011 at 3:28 PM, Ray wrote: > I am using the Sqlite3 API. > If you are using the sqlite3 API, then why is the warning message about the sqlite2 API? Is that a bug in PHP? > > Why is so much free disc required? > > I will the real answers from my hosting

Re: [sqlite] Database is full warnings

I am using the Sqlite3 API. Why is so much free disc required? I will the real answers from my hosting service Sent from my iPad On Sep 10, 2011, at 12:09 PM, Simon Slavin wrote: > > On 10 Sep 2011, at 7:47pm, Ray Irvine wrote: > >> [09-Sep-2011 09:10:20] PHP

Re: [sqlite] TransactionScope ON CONFLICT

>> In this example I added 10 objects to the context and I know that object #5 >> raises a PrimaryKey (or unique) Exception.>> What I read from the SQLite >> documentation I understand that object #6 till object #10 will be also add >> to the database.>> But this never happens.>> I assume you

Re: [sqlite] Database is full warnings

Sample message: [09-Sep-2011 09:10:20] PHP Warning: sqlite_exec() [function.sqlite-exec]: database is full in /home/xx/00build/include/t02enterreg.inc on line 738 On Sep 10, 2011, at 11:43 AM, Luuk wrote: > On 10-09-2011 19:45, Ray wrote: >> >> I am using sqlite on an application that

Re: [sqlite] Database is full warnings

On 10-09-2011 19:45, Ray wrote: > > I am using sqlite on an application that run on a hosting service. After > some 18 months, I have started to see a few database is full warnings from my > PHP application. I will receive a warning but all appears well with the > database. The

Re: [sqlite] UNIQUE in PRAGMA Table_Info

Thomas Baumann wrote: > can you please add a column to the result of PRAGMA Table_Info() that > indicates this column is UNIQUE? What should be reported for this table definition: create table FancyUnique(a, b, c, d, unique(a, b), unique(c, d) ); -- Igor Tandetnik

[sqlite] Database is full warnings

I am using sqlite on an application that run on a hosting service. After some 18 months, I have started to see a few database is full warnings from my PHP application. I will receive a warning but all appears well with the database. The application uses four databases and the warning has

[sqlite] Berkeley DB vs SQLite 3 in .NET

It's not a comprehensive test, but I thought readers here may be interested to see the results of some testing I've just completed comparing the Berkeley DB SQL API through Oracle's .NET wrapper (System.Data.SQLite) vs. the SQLite 3 engine and the sqlite.org edition of System.Data.SQLite. You can

[sqlite] UNIQUE in PRAGMA Table_Info

Hello, can you please add a column to the result of PRAGMA Table_Info() that indicates this column is UNIQUE? Just like the notnull column. I don't want to parse the whole sql string for this property only. Or have I missed something? Greetings and thanks in advance. Thomas B.

Re: [sqlite] TransactionScope ON CONFLICT

On 10 Sep 2011, at 4:22pm, Steffen Mangold wrote: > http://www.sqlite.org/lang_transaction.html > " Such transactions usually persist until the next COMMIT or ROLLBACK > command. > But a transaction will also ROLLBACK if the database is closed or if an error > occurs and the ROLLBACK conflict

Re: [sqlite] TransactionScope ON CONFLICT

Hi Simon, first nice to hear from you. :) > Fred helps solve Helen's problem one day, Helen may solve Fred's the > following week. Oh I'm not mean pro support. What you descript is what I'm searching for. Like a forum. > Can you show us a pointer to this information ? Sure,

Re: [sqlite] TransactionScope ON CONFLICT

On 10 Sep 2011, at 3:58pm, Steffen Mangold wrote: > I'm hoping doing all right to get technical support. :) Perhaps not. If you want technical support you have to pay for it. This mailing list is mostly a bunch of users who have run into their own problems over the years. Fred helps solve

[sqlite] TransactionScope ON CONFLICT

Hi, I'm hoping doing all right to get technical support. :) I have a question to the System.Data.SQLite in action with the .Net TransactionScope. In the SQLite documentation is written that the default behavior of a transaction in case of an error is "ABORT". In documentation is also writen

[sqlite] Minimal library size

Hi, Is it possible to get the library size down to 180 KB on Windows using Visual C++? I've also tried compiling for the a *nix based platform with gcc getting similar results as I have had for Windows. Namely, the smallest file size I can seem to get is ~300KB+. I've compiled for smaller code