[futurebasic] Re: [FB] Database Front-End

Message: < previous - next > : Reply : Subscribe : Cleanse
Home   : January 2008 : Group Archive : Group : All Groups

From: Christopher Wyatt <poetcsw@...>
Date: Sat, 19 Jan 2008 22:35:32 -0600
On Jan 19, 2008, at 6:31 PM, Brian Stevens wrote:
> My DBA background gives me an edge here even though I don't know  
> what an RB record set is. Typically, a manager coalesces data from  
> several tables as the result of a table join (in relational  
> databases data is structured in rows and columns. These rows and  
> columns are referred to as a table. Tables can be "joined" on common  
> keys allowing related data (based on key(s)) to be retrieved  
> programatically. RB's record set is probably a similar abstraction  
> to provide a common delivery regardless of how simple or complicated  
> the underlying joins.
>
I must not have worded my question properly...

Not even close what I was asking. I definitely know the guts of SQL  
after two 25 years of database development. (I'm a former DB2 / SQL  
jockey, btw. I've designed pretty massive systems -- retail chain POS/ 
Inventory control, medical systems, etc.)

An SQL API can return the query results, or any other command usually,  
as either a pointer to the memory blocks, an array with the data, or  
something else entirely. REALbasic returns everything as a "recordset"  
which you then process yourself -- no bindings to controls are  
possible as in VB, Delphi, or any "database" tool like 4D.

The problem with most XML databases is that they require loading  
everything into RAM. Really fast, but limits you to a query the size  
of memory / virtual memory.

The PostgreSQL plug-ins for RB from a third-party use arrays, instead  
of the recordset objects. Arrays are much faster, since you still need  
to convert a recordset into an array to do any serious work -- sans  
binding.

I'm wondering what approach would be best with FB. If I'm going to  
dink around with creating a library of functions, they should fit the  
"philosophy" of most FB coders.

- CSW