Re: [sqlite] 2 Questions from a newbie

ticker of the stock and then > add an index to that column to allow quick lookups based on the > ticker. > > -Jeff > > On Tue, Aug 19, 2008 at 9:44 AM, .:UgumugU:. <[EMAIL PROTECTED]> wrote: >> Hi cstrader, >> >> Just send some table structure and the explain wh

Re: [sqlite] 2 Questions from a newbie

. Price sampling can be done at any rate (i.e. seconds, hourly, > daily, weekly, etc.) Your queries would determine "closing price" hourly, > dally, monthly, etc. > > Thoughts to ponder: How to handle stock "splits", Mergers, and ? > > Fred > > -Origi

Re: [sqlite] 2 Questions from a newbie

olumns? doesn't sound like you have the > db set up properly.. > > On Tue, Aug 19, 2008 at 11:53 AM, cstrader <[EMAIL PROTECTED]> > wrote: >> OK, cool idea... let me try that. >> >> >> - Original Message - >> From: "Jeff Hamilton" <[

Re: [sqlite] 2 Questions from a newbie

2008 at 9:44 AM, .:UgumugU:. <[EMAIL PROTECTED]> wrote: >> Hi cstrader, >> >> Just send some table structure and the explain what you are trying todo. >> In my opinion it is not a good way to deal with 2400 tables :) >> >> ugumugu >> >> cstra

[sqlite] 2 Questions from a newbie

I'm just starting with SQLite (from vb.net) and could use some advice. I have a set of 2400 (could get substantially higher) tables in a single database (each table contains daily stock prices for a different stock). Each table has 9 columns (all text for now) and some several thousand rows. So

[sqlite] Select All Tables?

Is there a way to SELECT UNION all of the tables in a database -- that is to create a big table with rows from each of the individual tables? I understand I can do multiple selects, but the command gets very long if there are a lot of tables. Thanks

Re: [sqlite] User-defined collation UNIQUE INDEX

Is there a way to SELECT UNION all of the tables in a database -- that is to create a big table with rows from each of the individual tables? I understand I can do multiple selects, but the command gets very long if there are a lot of tables. Thanks - Original Message - From: "D.

Re: [sqlite] General help, a bit OT

gt; To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Tuesday, July 15, 2008 8:40 AM Subject: Re: [sqlite] General help, a bit OT >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of cstrader >

Re: [sqlite] General help, a bit OT

[sqlite] General help, a bit OT >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of cstrader >> Sent: Tuesday, July 15, 2008 2:28 PM >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] Gene

Re: [sqlite] General help, a bit OT

it OT >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of cstrader >> Sent: Tuesday, July 15, 2008 2:28 PM >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] General help, a bit OT >> >>

Re: [sqlite] General help, a bit OT

; Sent: Tuesday, July 15, 2008 8:19 AM Subject: Re: [sqlite] General help, a bit OT > >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of cstrader >> Sent: Tuesday, July 15, 2008 2:03 PM >> To: General Discussi

[sqlite] General help, a bit OT

A bit off topic, but perhaps someone could direct me. I'm in vb.net I have to read thousands of tables and operate on each one in sequence. I need to do this fast. I want to read the data from 6 stored columns and many rows from each table. Once the table is read, I need to create derived

[sqlite] Char versus Float versus Int as primary key

Jay... I could do that and maybe will. But does anyone know whether it SHOULD matter? Or are you saying that there are no general principles in this regard? Thanks..

[sqlite] Another speed question....

I assume it is faster to key on only one variable rather than two? Thanks

[sqlite] Char versus Float versus Int as primary key

I'm looking to enhance query speed. Does it matter what variable type I use as the primary key? I'm thinking numbers might be faster than strings, but I'm not sure. Thanks!

Re: [sqlite] Read row data into array?

Thanks! The exec_table is helpful... I may get back to you for more info on this. For now, I'm just querying row by row.

[sqlite] Read row data into array?

Would someone be willing to share with me c++ code that reads the result of a select query into an array representing the data of the j rows in a selected column? I understand that callback() is executed once for each row of the data. But what is the best and fastest way to iteratively write

Re: [sqlite] Plugin help requested

that doesn't seem to be it - I have the same problem with this code. #include #include #define _SQLITE3_H_ extern "C" #define PLUGINAPI2 extern "C" PLUGINAPI2 typedef struct sqlite3 sqlite3; PLUGINAPI2 int sqlite3_open( const char *filename, sqlite3 **ppDb );

[sqlite] Plugin help requested

I'm trying create a .dll. The .dll compiles and looks fine and the code runs fine in console mode, but the host cannot read the .dll when the sqlite3_open line below is uncommented. Any ideas why would be appreciated. thanks! #include #include #define _SQLITE3_H_ extern "C"