[sqlite] Did A Recent Windows & Update Affect SQLite???

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

Re: [sqlite] Direct PostgreSQL to SQLite connection?

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

Re: [sqlite] SQlite vs. SQlite3 - a beginners question

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

Re: [sqlite] Converting .dbf to SQLite

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

Re: [sqlite] SUM(tripSeconds) and format output as days.hours:minutes:seconds.hundredths?

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',

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

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

Re: [sqlite] GUI design & managment tool?

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: >

Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?

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

[sqlite] [Fwd: [SpatiaLite-Users] spatialite-2.3.0 has been released]

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

Re: [sqlite] designing a db to hold repeating data

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.

Re: [sqlite] Best GUI?

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

Re: [sqlite] Best GUI?

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,

Re: [sqlite] Any concept of row number in SQLite?

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

Re: [sqlite] SQLite utilty to import XML

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: > >

Re: [sqlite] Recover deleted records

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 mentioned by Ro

Re: [sqlite] Recover deleted records

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

[sqlite] Recover deleted records

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