On Sun, Dec 5, 2010 at 4:41 PM, Jimmie Houchin <[email protected]> wrote:
> On 12/3/2010 7:52 PM, Frank Church wrote:
>
>>
>> I am looking for a SqueakDBX demo that shows how to display the output of
>> records from the database, like outputting them in a tabular format.
>>
>> Does anyone know of an example somewhere?
>>
>>
> Hello,
>
> I apologize, I didn't even see this message until I saw Mariano's reply.
>
> I use SqueakDBX directly without Glorp connecting to a PostgreSQL database
> with about 50 million rows currently.
wait.....did I read correctly ???? 50 millioons rows ????? hey....you are
our biggest client ;) heheheh
> I am storing minutes of financial data. Since my data is by its nature very
> tabular I saw no need for using an ORM.
>
That completly makes sense.
>
> My use is very simple but maybe it will help.
>
> I currently only use SqueakDBX for retrieving this data. The data is
> inserted via a different program.
>
> Here is the method I use to get my data and insert it into a Matrix.
>
> loadOHLC
> "Loads the Open High Low Close (bid/ask) and hlavg, hlcavg columns from
> the database.
> Creates a OneWeekData (Matrix) object for the data."
>
> | con rows |
> con := self otogConnection.
> rows := (con execute: 'select startdate, bidopen, bidhigh, bidlow,
> bidclose, askopen, askhigh, asklow, askclose from ', self instrument, '
> where (', self week asDbxString, ' < startdate) AND (startdate < ', self
> weekEnd asDbxString , ')') rows.
> ohlc := OneWeekData rows: (rows size) columns: 10.
> 1 to: rows size do: [:row || newRow |
> newRow := ((rows at: row) values). newRow := newRow copyWith:
> (((newRow at: 3) + (newRow at: 4) + (newRow at: 5)) / 3).
> ohlc atRow: row put: newRow ].
>
> Maybe this real world example will help. As I said my usage is simple.
> SqueakDBX has worked very well for me.
>
Nice to hear that :)
>
> I simply wrote the sql statement I wanted executed with my columns ordered
> as I wanted for the rows retrieved. If I remember correctly each rows values
> are when passed the "values" message return an Array which is what I pass to
> my Matrix.
>
> If we aren't providing the answers desired. Please provide more
> information to direct us. Mariano has been very helpful for any of my
> questions.
>
> Jimmie
>
>
Thanks Jimmie
