Thanks SImon. Pretty much what I expected, just checking if I was missing
something obvious.
Pete
lcSQL Software http://www.lcsql.com
On Sun, Dec 16, 2012 at 9:00 AM, sqlite-users-requ...@sqlite.org wrote:
I think you 'should not use'. You can do an UPDATE and see whether it
updated
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 _
(SELECT
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
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
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
On 16 Dec 2012, at 11:10pm, Tim Johnson t...@akwebsoft.com 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 but
e-mail mgbg25171 mgbg25...@blueyonder.co.uk 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
* Simon Slavin slav...@bigfraud.org [121216 15:07]:
On 16 Dec 2012, at 11:10pm, Tim Johnson t...@akwebsoft.com 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
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