Re: [sqlite] sqlite3_get_table question

On Dec 30, 2008, at 1:29 AM, schachtobi wrote: > >> Date: Mon, 29 Dec 2008 11:20:58 +0700 >> From: Dan >> Subject: Re: [sqlite] sqlite3_get_table question >> To: General Discussion of SQLite Database >> Message-ID:

Re: [sqlite] SQLITE_MAX_VARIABLE_NUMBER and .import for very wide file

>> I am sure there is a better way to deal with 12K rows by 2500 columns, >> but I can't figure it out > > 2500 columns sounds like a nightmare to deal with > > could you perhaps explain that data layout a little? It is a download of a huge longitudinal survey (www.bls.gov/nls/nlsy79.htm)

Re: [sqlite] confusing with how to to this in sqlite

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rachmat Febfauza Sent: Sunday, December 28, 2008 9:13 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] confusing with how to to this in sqlite thanks simon

Re: [sqlite] sqlite3_get_table question

> Date: Mon, 29 Dec 2008 11:20:58 +0700 > From: Dan > Subject: Re: [sqlite] sqlite3_get_table question > To: General Discussion of SQLite Database > Message-ID: <65fa0cc6-4248-4675-8100-f069423e0...@gmail.com > Why (ncol+2)? I make the

[sqlite] About clustering (GUIDs, PK offsets, etc.)

Hello! I did find interesting article about this popular question http://blog.maxindelicato.com/2008/12/how-to-organize-a-database-tables-keys-for-scalability.html I would also like to add that  SQLite supports "attach" command due to which we are able to use a lot of database shards on a

Re: [sqlite] SQLITE_MAX_VARIABLE_NUMBER and .import for very wide file

On Sun, Dec 28, 2008 at 11:49:34PM -0800, Webb Sprague wrote: > I am sure there is a better way to deal with 12K rows by 2500 columns, > but I can't figure it out 2500 columns sounds like a nightmare to deal with could you perhaps explain that data layout a little?