Re: [sqlite] SQLite database for google maps

2009/11/28 logan : > I'm trying to find if someone has got a database of Google maps for a > particular town in an SQLite file. I'm looking to write an application > which will query this database and find text directions. This is more > of a fun project for me than anything

[sqlite] Moving Average?

I'm trying to calculate a moving average in sqlite through sqliteman. I'm just trying to get some of the analytic functions to work, but I keep getting a syntax error. I got this from a sql wiki page, so I hope something like this will work. select sum(salary) over (partition by months order

Re: [sqlite] SQLite data types.

On Sat, Nov 28, 2009 at 10:24 PM, Ted Rolle, Jr. wrote: > I'm laboring under a false impression.  I thought that the SQLite data > types were limited to text, integer, float, and something else. > you are under a correct impression. SQLite supports INTEGER, TEXT, REAL, and

[sqlite] SQLite data types.

I'm laboring under a false impression. I thought that the SQLite data types were limited to text, integer, float, and something else. On the SQLite site there's Currency, date-time with and without timestamps. Where can I find a listing of these? Ted

Re: [sqlite] SQLite database for google maps

On Sat, Nov 28, 2009 at 08:42:54AM -0600, P Kishor wrote: > On Sat, Nov 28, 2009 at 12:14 AM, logan wrote: > > Hi All, > > > > I'm trying to find if someone has got a database of Google maps for a > > particular town in an SQLite file. I'm looking to write an application > >

Re: [sqlite] [solved] SQLite won't import 53, 066, 244 row 11 gigabyte CSV file

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Simon Slavin wrote: > On 28 Nov 2009, at 3:55pm, Walter Dnes wrote: > >> ...and import worked. So it appears that the maximum csv file is probably >> around 2 gigabytes. > > That does make sense of some kind, but it indicates that someone is using

Re: [sqlite] [solved] SQLite won't import 53, 066, 244 row 11 gigabyte CSV file

On 28 Nov 2009, at 3:55pm, Walter Dnes wrote: > ...and import worked. So it appears that the maximum csv file is probably > around 2 gigabytes. That does make sense of some kind, but it indicates that someone is using signed integers for file sizes. Signed would be about 2 gigabytes,

[sqlite] [solved] SQLite won't import 53, 066, 244 row 11 gigabyte CSV file

Thanks for the help. I eventually got it working. And I'm working on the next stage of my project. On Fri, Nov 27, 2009 at 06:31:03PM -0800, Roger Binns wrote > Alternatively use split to make the input a series of files each > less than 4GB in size. Or use a 64 bit host. [...] > If using

Re: [sqlite] SQLite database for google maps

On Sat, Nov 28, 2009 at 12:14 AM, logan wrote: > Hi All, > > I'm trying to find if someone has got a database of Google maps for a > particular town in an SQLite file. I'm looking to write an application > which will query this database and find text directions. I think you

[sqlite] SQLite database for google maps

Hi All, I'm trying to find if someone has got a database of Google maps for a particular town in an SQLite file. I'm looking to write an application which will query this database and find text directions. This is more of a fun project for me than anything else, so I welcome all suggestions if

[sqlite] Fix aliasing violations

A cast can never fix an aliasing violation. Andreas. --- sqlite-3.6.16/src/vdbeaux.c.~1~ 2009-06-26 20:17:20.0 +0200 +++ sqlite-3.6.16/src/vdbeaux.c 2009-11-27 19:19:02.0 +0100 @@ -1046,17 +1046,17 @@ void sqlite3VdbeIOTraceSql(Vdbe *p){ ** request, then increment *pnByte by