Re: [sqlite] Any limitation of file size on sqlite?

Hello! Sqlite databases 10Gb+ sizes work fine for me in multi-user web environment and 100Gb+ sizes were tested in my scenarios. The unsupported index compression is the main problem and so use more scalable FTS4 index when possible. Best regards, Alexey. http://pechnikov.tel 17.12.2012 0:03

Re: [sqlite] General setup on Mac OSX 10.7

* Simon Slavin [121216 15:07]: > > On 16 Dec 2012, at 11:10pm, Tim Johnson wrote: > > > I've recently set up drupal on my workstation which is hosting Mac > > OSX 10.7. I would welcome > > 1)Recommendations on what I should install to manage sqlite > >

Re: [sqlite] ordering result sets

e-mail mgbg25171 wrote: > I have modified my program to have next time (not shown) as well as next > date > What I'd to know is... > How do I order results firstly by earlest non-null/empty string next time > (ALL DAYS HERE WILL BE TODAY) order and then BY earliest

Re: [sqlite] General setup on Mac OSX 10.7

On 16 Dec 2012, at 11:10pm, Tim Johnson wrote: > I've recently set up drupal on my workstation which is hosting Mac > OSX 10.7. I would welcome > 1)Recommendations on what I should install to manage sqlite > 2)How they should be installed > NOTE: macports works well for me

[sqlite] General setup on Mac OSX 10.7

Greetings : I've recently set up drupal on my workstation which is hosting Mac OSX 10.7. I would welcome 1)Recommendations on what I should install to manage sqlite 2)How they should be installed NOTE: macports works well for me but alternative suggestions are welcomed. The macports list re

Re: [sqlite] Any limitation of file size on sqlite?

On Sun, 16 Dec 2012 22:02:41 +0200, Çağlar Orhan wrote: what gbytes bigger size of .sqlite file should significant to work on it properly? I mean, is there a 10-12 GB sqlite file that working properly and with any problem? Hi Çağlar, from my first hand experience on the geospatial/GIS

[sqlite] Any limitation of file size on sqlite?

Hello again, Thank you Simon. The page http://www.sqlite.org/limits.html has my answer partly. In MS IIS what gbytes bigger size of .sqlite file should significant to work on it properly? I mean, is there a 10-12 GB sqlite file that working properly and with any problem? Thanks Caglar -- facta

[sqlite] ordering result sets

I am returning records if today is more than x days from lastdate or I have previously specified a next date and that date is today. Here's my query "select f.*, lastdate, nextdate from" & _ "(" & _ "SELECT f.*, lastdate, nextdate" & _ "FROM firms f" & _ "LEFT JOIN" & _ "

Re: [sqlite] INSERT OR REPLACE

Thanks SImon. Pretty much what I expected, just checking if I was missing something obvious. Pete lcSQL Software On Sun, Dec 16, 2012 at 9:00 AM, wrote: > I think you 'should not use'. You can do an UPDATE and see whether it > updated