Re: [sqlite] testing Avg() function in other database engines

Sybase ASE 12.5.3: 3 3.33 Regards, Jarek > -Wiadomość oryginalna- > Od: Dennis Cote [mailto:[EMAIL PROTECTED] > Wysłano: 8 lutego 2006 20:11 > Do: sqlite-users > Temat: [sqlite] testing Avg() function in other database engines > > Hi All, > > I have a question that I

Re: [sqlite] Please Need Advice on 64 Bits Platform

I've just built SQLite 3.2.7 on HP-UX 11 in 64-bit mode. Loading 1000 000 records into a simple table (using .read from SQL script with inserts, 1 in a single transaction) took 5 min 40 s (the same in 32-bit - 06:29) and creating index 56 s (01:14 for 32-bit). Unfortunately, this is heavily

ODP: [sqlite] Possible bug regarding endiannes and realstorageclass (sqlite3)

> Od: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Wysłano: 18 sierpnia 2005 20:11 > Do: sqlite-users@sqlite.org > Temat: Re: [sqlite] Possible bug regarding endiannes and > realstorageclass (sqlite3) > > On Thu, 2005-08-18 at 09:40 -0700, Robert Simpson wrote: > >

ODP: [sqlite] ANN: SQLiteSpy 1.1 Database Manager with REGEXP keyword support

Hi Ralf, perhaps I'm naive, but are there any chances for versions for *other* OS platforms ? Regards, Jarek Jaroslaw Nozderko GSM +48 601131870 / Kapsch (22) 6075013 [EMAIL PROTECTED] IT/CCBS/RS - Analyst Programmer > -Wiadomość oryginalna- > Od: Ralf Junker [mailto:[EMAIL

ODP: [sqlite] Proposal: limit the number of columns in a table to2000.

> I used google to dig up the column count limits on some > common database engines: > > DB2 255 > Oracle 1000 > SQL Server 1024 > PostgreSQL 1600 > MySQL 3398 > Informix 32767 > Sybase ASE 12.5 - 1024 or 254, depending on whether columns are

ODP: RE(1): [sqlite] SQLite Advocacy

Hi, > > 10. SQLite runs on almost ever operating systems. SQL Server runs > > on MS Windows exclusively. > > > yep, but again who cares, 99% of the world is on windows This is probably true for desktops, but not for servers. And a lot of people cares. > > 13. Open source and Free Software such

[sqlite] Varchar with numbers dumped without quotes

SQLite: 2.8.13 OS: HP-UX B.11.11 Hi, char and varchar fields containing digits only are dumped without qoutes: sqlite> create table my_table(id integer primary key, A varchar(25), B char(25)); sqlite> insert into my_table values(NULL, '1234567890','1234567890'); sqlite> insert into

RE: [sqlite] Re: SQLite version 3 design question: '500'=500?

Sybase ASE 12.5.1: CREATE TABLE test1(a VARCHAR(100)) INSERT INTO test1 VALUES('501') INSERT INTO test1 VALUES(' 502 ') SELECT * FROM test1 WHERE a=501 SELECT * FROM test1 WHERE a=502 SELECT * FROM test1 WHERE a<'502' Result: "Implicit conversion from datatype 'VARCHAR'

RE: [sqlite] SQLite version 3 design question: '500'=500?

Similar for Sybase ASE 12.5 (wasn't it MSSQL ancestor ?): SELECT '500' = 500 500 === 500 SELECT 500 = '500' Incorrect syntax near '=' I think "SELECT '500' = 500" is not a comparison here, just selection of constant 500 with '500' as column name, just like "select 500 as '500'". Regards,

RE: [sqlite] How do I cross compile for FreeBSD

Hi Cory, sorry, I don't remember your previous post. What version of FreeBSD and SQLite are you interested in ? I have FreeBSD 5.2 and I compile SQLite (up to 2.8.11 so far) without problems. I'll try 2.8.12 tonight. I can publish a binary in 1 or 2 days. Is it OK ? Regards, Jarek Jaroslaw