[sqlite] TR: Database base disk is malformed issue

found  out the version realeasing the specials indexes (1.0.99) http://www.synelia.fr/ Jean-François RIGHI Service Étude et Développement +33(0)3 27 08 08 08 mailto:jf.ri...@synelia.fr 3595 route de Tournai - C.S. 20009 - 59501 DOUAI Cedex France

[sqlite] ICU and collation strength [patch]

ed-collate-on-a-sqlite-string-comparison> Regards -- François Gannaz ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] order by "a huge number" does not work, but "random" well why ?

onto.ca> > On 14/01/2013 9:48 AM, François-xavier Jacobs wrote: > >> Hi everyone >> >> i would like to "seed random" a request, so i could do use some pagination >> system with a order by random(), is this possible sqlite ? when a tried to >> use "o

[sqlite] order by "a huge number" does not work, but "random" well why ?

Hi everyone i would like to "seed random" a request, so i could do use some pagination system with a order by random(), is this possible sqlite ? when a tried to use "order by 1234567892" it always return the same order ___ sqlite-users mailing list

Re: [sqlite] Index on BOOLEAN field

Thank you all On 13 sep, 22:24, "Jay A. Kreibich" wrote: > On Tue, Sep 13, 2011 at 09:16:32PM +0100, Simon Slavin scratched on the wall: > > > > > On 13 Sep 2011, at 7:22pm, Petite Abeille wrote: > > > > On Sep 13, 2011, at 2:15 PM, Simon Slavin wrote: > > > >> It's about

Re: [sqlite] Index on BOOLEAN field

Richard, Igor, I made some tests based on a) and b) cases described by Igor. I can see much faster SELECT with an index than without it: so Igor seems to be right. Richard, can you tell me in what cases performance will be less good? Thank you, Best Regards, François On 13 sep, 14:12

Re: [sqlite] Index on BOOLEAN field

Thank you Igor!. Igor, your a) and b) cases do concern me. But reading your both answers I am quite confused now :-) Best Regards, François On 13 sep, 14:03, "Igor Tandetnik" <itandet...@mvps.org> wrote: > François <francois.goldgewi...@gmail.com> wrote: > >

Re: [sqlite] Index on BOOLEAN field

Hello Richard, and thank you for this fast answer. Can we consider that creating an index for an integer field is a good practice if this field has at least 3 possible values ? Or more ? Best Regards, François On 13 sep, 13:33, Richard Hipp <d...@sqlite.org> wrote: > On Tue, Sep 13,

[sqlite] Index on BOOLEAN field

improve SELECT time execution ? Please note that it concerns an iPhone app. Thank you ! Best Regards, François ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] When open / close database on IOS ?

the contrary advice at the beginning of our exchanges. Why? Let's consider a simple example of a database used by only one iOS app, which performs many INSERT or UPDATE during a user session. Therefore it would be better to minimize data loss risk. Best Regards, François On 25 août, 23:36, Simon

Re: [sqlite] When open / close database on IOS ?

On 25 août, 19:29, Simon Slavin <slav...@bigfraud.org> wrote: > On 25 Aug 2011, at 5:19pm, François wrote: > > > 3) So SQLite correctly deals with crashes (this is amazing!) But when > > app crashes, database connection may be not closed. Could it be a > > problem? F

Re: [sqlite] When open / close database on IOS ?

. Is this true ? If yes, what is the exact role of the close ? Thank you Best Regards, François On 25 août, 17:53, Simon Slavin <slav...@bigfraud.org> wrote: > On 25 Aug 2011, at 4:32pm, François wrote: > > > 1) Do you suggest to open only one connection for all dat

[sqlite] When open / close database on IOS ?

! Best Regards, François ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite bug report: Bad truncation in column mode with non ASCII characters

In ".mode column", the function used to compute the length of the string to print does not account for multi-byte characters, resulting in a shorter string, and all remaining fields in the line shifted to the left. Example: sqlite> select * from test limit 3; namename2 name3

[sqlite] SQLite with read-only filesystems and hot-journal

Hello, list! I am currently using SQLite Databases (v3.5.8) stored on NAS servers and I have to take snapshosts of these storage devices. The snapshots must be accessible, and the database files can be found in well-named directories whose content has read-only permissions. My problem is that