On 03/31/2015 05:17 PM, Mark Romero wrote:
> Hey Everyone:
>
> Was there a recent Windows 7 64-bit update that affected SQLite?
>
> A few months ago one of the programs that I use (Lightroom) started to have
> long periods where it would stop responding. It wouldn't crash, but it
> would just kee
http://www.gaia-gis.it/OpenLite/
ogr2ogr from gdal.org can probably do it on the command line
Spatialite I think has a Virtual Postgres table tool too.
(You can probably ignore that these are mostly for spatial data, should
work fine on regular tables)
Honestly a small python script to read from s
Richard Cooke wrote:
> I'm trying to teach myself PHP and SQLite and I've tried to understand
> whether SQLite and SQLite3 are the same animal or are they completely
> different. I am using WAMP on a PC and the PHP version is 5.31. If I
> use sqlite_libversion(); I get a result of 2.8.17. If
Using R might actually be a convenient way to do it all in essentially
one step, and technically batch scriptable.
You'd need the RSQlite add on package, I think dbf reading is built in.
Alex
dave lilley wrote:
> 2009/11/12 Rich Shepard
>
>> On Thu, 12 Nov 2009, dave lilley wrote:
>>
>>> Not t
DaleEMoore wrote:
> I'd like to SUM(tripSeconds) and format output as
> days.hours:minutes:seconds.hundredths, but have not been able to figure out
> how to do that with sqlite. This didn't seem to come close:
>
> SELECT
> STRFTIME('%d', SUM(tripSeconds)) + '.' +
> STRFTIME('%H', SUM(tripSeconds)
Gilles Ganault wrote:
> On Fri, 23 Oct 2009 12:00:47 +0200, Thibaut Gheysen
> wrote:
>> You can use sqlite-manager (http://code.google.com/p/sqlite-manager/).
>
> Thanks for the tip, but I'd rather a stand-alone rather than a Firefox
> plug-in.
>
If you have the XUL libraries installed it will
Allen Fowler wrote:
> Hello,
>
> Can anyone recommend a Free, or reasonably priced Non-Free, GUI tool for
> creating and maintaining an SQlite databases that can run on both Windows and
> Linux?
>
> (Support for visual relation design would be great, too.)
>
> I found a list at:
> http://www.s
Robert,
1. When you build you want to make sure to override the default
directory settings. ./configure --builddir=/usr/
Check the directions and configure script for options
(make sure to run make clean before you attempt to run make again.)
2. Use Checkinstall, it will build a deb file specific
Original Message
Subject: [SpatiaLite-Users] spatialite-2.3.0 has been released
Date: Tue, 07 Apr 2009 20:27:51 +0200
From: Alessandro Furieri
Reply-To: spatialite-us...@googlegroups.com
To: spatialite-us...@googlegroups.com
Hi list,
I've just released SpatiaLite v.2.3.0 [st
You should talk with Alessandro Furieri a.furi...@lqt.it who is
currently working on adding Raster support to spatialite.
http://www.gaia-gis.it/spatialite/
It may be more efficient to store the data separately in well used
raster formats and attach them to the database as needed for queries.
Ale
Nuno Magalhães wrote:
>> Do you want this for data entry, or developing and managing the database
>> via SQL. I have yet to see a really good front end for data entry
>> although Dabo shows promise as a tool to make good data entry tools.
>
> Thanks, i'll look into it. I want it as a means to crea
Nuno Magalhães wrote:
>> Here lots of SQLite management tools
>>
>> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
>
> Keyword being "lots". I've been to that site, which was what prompted
> me to write in the first place. I'm looking for either web-based or
> *nix. I know there are lots, i
P Kishor wrote:
> On Thu, Feb 19, 2009 at 6:54 PM, His Nerdship
> wrote:
>> Hi,
>> I am converting a program from Paradox (stop laughing, please) to SQLite.
>> Paradox has a useful feature where you can specify the actual index of a row
>> in the table. This is handy when the table is displayed i
Salles, Joaquim Campos wrote:
> Hello,
>
> I'm looking for an SQLite utility (Windows / Linux) to import XML files
> into an SQLite Database (free/open source), so I can use it in a shell
> script to periodicly search a directory and import the XML files.
>
> I tried to find one in:
>
> http://w
John Machin wrote:
> On 21/01/2009 7:03 AM, Alex Mandel wrote:
>> Griggs, Donald wrote:
>>> Hi Alex
>>>
>>> I can't answer your specific questions, but I presume you've already
>>> studied the file format document (most recently menti
Griggs, Donald wrote:
> Hi Alex
>
> I can't answer your specific questions, but I presume you've already
> studied the file format document (most recently mentioned by Roger
> Binn's recent post):
>
> http://www.sqlite.org/fileformat.html
>
Yes I did read through that, but I didn't see what
I was looking through old posts and this one seemed quite similar to my
situation with one exception. I have full knowledge of what data I'm
trying to recover.
http://thread.gmane.org/gmane.comp.db.sqlite.general/35764
The basics, data was deleted from 4 tables via an ODBC connection. No
Vacuum ha
17 matches
Mail list logo