Re: [sqlite] light weight write barriers

2012-11-05 Thread Theodore Ts'o
On Mon, Nov 05, 2012 at 05:37:02PM -0500, Richard Hipp wrote: > > Per the docs: "Only the superuser or a process possessing the > CAP_SYS_RESOURCE capability can set or clear this attribute." That > prevents most applications that run SQLite from being able to take > advantage of this, since mos

Re: [sqlite] light weight write barriers

2012-11-05 Thread Richard Hipp
On Mon, Nov 5, 2012 at 5:04 PM, Theodore Ts'o wrote: > On Mon, Nov 05, 2012 at 09:03:48PM +0100, Pavel Machek wrote: > > > Well, using data journalling with ext3/4 may do what you want. If you > > > don't do any fsync, the changes will get written every 5 seconds when > > > the automatic journal

Re: [sqlite] light weight write barriers

2012-11-05 Thread Theodore Ts'o
On Mon, Nov 05, 2012 at 09:03:48PM +0100, Pavel Machek wrote: > > Well, using data journalling with ext3/4 may do what you want. If you > > don't do any fsync, the changes will get written every 5 seconds when > > the automatic journal sync happens (and sub-4k writes will also get > > Hmm. But th

Re: [sqlite] Problem with create … from … order by on largish data

2012-11-05 Thread Tod Olson
Great! Thank you for the pointers. -Tod On Nov 5, 2012, at 3:21 PM, Richard Hipp wrote: > On Mon, Nov 5, 2012 at 3:58 PM, Tod Olson wrote: > >> Is there a predicted next release date? Or more to the point, >> does anyone have a guess about when the fix for that 32-bit int >> overflow error w

Re: [sqlite] Problem with create … from … order by on largish data

2012-11-05 Thread Richard Hipp
On Mon, Nov 5, 2012 at 3:58 PM, Tod Olson wrote: > Is there a predicted next release date? Or more to the point, > does anyone have a guess about when the fix for that 32-bit int > overflow error will be in general release? > http://www.sqlite.org/draft/ http://www.sqlite.org/draft/releaselog/3_

Re: [sqlite] Problem with create … from … order by on largish data

2012-11-05 Thread Tod Olson
Is there a predicted next release date? Or more to the point, does anyone have a guess about when the fix for that 32-bit int overflow error will be in general release? -Tod On Nov 3, 2012, at 3:18 PM, Tod Olson wrote: > > On Nov 3, 2012, at 7:32 AM, Richard Hipp > wrote: > >> On Fri, Nov 2,

Re: [sqlite] SQLite on Windows Phone 8

2012-11-05 Thread Noah Hart
Hello Peter, This is a common configuration. Please visit the C#SQLite project here: http://code.google.com/p/csharp-sqlite/ and post questions to the usergroup here: https://groups.google.com/forum/?fromgroups#!forum/csharp-sqlite Please keep in mind the following: This is not an offici

Re: [sqlite] Anybody using REGEXP in the ICU extension?

2012-11-05 Thread Alexey Pechnikov
I use REGEXP operator from ICU extension but the patch will not break my applications. 2012/11/5 Richard Hipp > Is anybody using the REGEXP operator that is included with the ICU > extension of SQLite? > > The reason I ask is that the current ICU REGEXP implementation is broken. > We are wanting

Re: [sqlite] SQLite on Windows Phone 8

2012-11-05 Thread Joe Mistachkin
Peter Naldal wrote: > > Original message: > ** > Topic: [sqlite] SQLite on Windows Phone 8 > Hi > "Visual Studio 2012 for Windows Phone" offers installation of "SQLite for > Windows Phone 8" as an extension. To enable programming against this > extension a wrapp

Re: [sqlite] SQLite on Windows Phone 8

2012-11-05 Thread Peter Naldal
Has anybody tried to install "SQLite for Windows Phone 8"? Any success? I can install it. It shows up fine under References, but then what? The Object Browser shows nothing. What namespace can I reference? What classes can I use? \Peter Original message: ** Top

[sqlite] Anybody using REGEXP in the ICU extension?

2012-11-05 Thread Richard Hipp
Is anybody using the REGEXP operator that is included with the ICU extension of SQLite? The reason I ask is that the current ICU REGEXP implementation is broken. We are wanting to fix it. But the fix runs a serious risk of breaking any legacy applications that depend on the old broken behavior.

Re: [sqlite] Required help on Sqlite+TCL -testsuit

2012-11-05 Thread Richard Hipp
On Mon, Nov 5, 2012 at 5:38 AM, brijesh_philips wrote: > Hi, > > I am New to sqlite and TCL. I need information regarding, > > 1. Where i can download TCL Testsuit to test sqlite ? > I am using Cygwin environment , testsits are available for cygwin > environment ? Does the same run on Linux to

Re: [sqlite] Required help on Sqlite+TCL -testsuit

2012-11-05 Thread brijesh_philips
I have the sqlite-amalgamation-3071401 and binaries for the TCL also extracted to the root directory respective folders... -- View this message in context: http://sqlite.1065341.n5.nabble.com/Required-help-on-Sqlite-TCL-testsuit-tp65374p65375.html Sent from the SQLite mailing list archive at Na

[sqlite] Required help on Sqlite+TCL -testsuit

2012-11-05 Thread brijesh_philips
Hi, I am New to sqlite and TCL. I need information regarding, 1. Where i can download TCL Testsuit to test sqlite ? I am using Cygwin environment , testsits are available for cygwin environment ? Does the same run on Linux too ? 2. How to install / compile and run these testsuits ? A reply

Re: [sqlite] EXT :Re: Compiling SQLite3 with MSVC 2010

2012-11-05 Thread Black, Michael (IS)
For gcc try -Wextra and -Wconversion. You'll get tons of warnings. -Wall just does the ones most people are concerned with. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems _