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

[rayB]

I'm in the airline game. 379 columns is the widest table that I can find in
our production DB2 sub-systems - a highly denormalised table as I'm sure you
can imagine. Perhaps someone like FedEx or UPS may have requirements to go
real wide for their warehousing apps.

Nothing I can find in this big shop goes anywhere near the proposed limits.

rayB

-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED] 
Sent: Friday, 18-Mar-2005 02:19
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Proposal: limit the number of columns in a table
to2000.

On Thu, 2005-03-17 at 09:09 -0600, Fred Williams wrote:
> BTW, Most of the "enterprise" database engines I have worked with have
> had either published or "stealth" column count limits. All those that I
> remember were below 2000.  But I must admit I have not worked with any
> of the current releases of the "big boys."
> 

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

-- 
D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] SQLite3: Windows filename format in command-line program

[rayB]

Filenames using the Windows SQLite3 version of the CLI program now have to
be specified using forward-slashes, rather than the back-slashes used by the
SQLite2 CLI. Would someone kindly point me to where this change has been
documented, as my searches have so far proved fruitless?

 

Thank you in advance.

 

Regards.

 

rayB