[cad-linux] Re: database access methods

Maybe it's that I'm not a programmer, but I can't understand why an access 
library
is required for any and all access to the db

If I were writing an app that would do some simple queries to the db, and the 
data I
wanted was in an easy to access format in the db, I would not use an access 
library
if a direct SQL connection were possible.

Same with writes to the db if my app were creating it's own tables within the
project db for data not available elsewhere in the db.  ie I wouldn't write an 
app
specific access library to reproduce what is already available via SQL

IMO it would run faster and be easier to program.



Lee Fickenscher (elfick@xxxxxxxxxx) wrote:
>
>
>On Thu, May 15, 2003 at 12:17:45AM -0500, Eric Wilhelm wrote:
>> I'm starting to see this as a 3-4 layered system:
>>
>> for modeling/geometric work:
>>      gui
>>      modeling kernel
>>      access library
>>      database
>>
>> for pm/administration/accounting:
>>      gui/spreadsheet
>>      access library
>>      database
>>
>> for performing inspections using your cell-phone:
>>      phone/viewer
>>      access library
>>      database
>
>Eric,
>I think you have it right on, I'd make the following abstrations though:
>
>
> UI (I call it just UI because its feasable to use text for some things)
> |
> --------
> |      |
> |      modeling_kernel
> |      |
> access_library
> |
> SQL DB (I specify SQL to show that it is a requirement for the library)
>
>
>I'm not sure that this asci will work in all viewers, but it looks ok in
>mine :-)
>
>What I'm trying to show is that the modeling kernel is optional
>depending on your needs, as you basically stated above.
>
>-Lee
>

Other related posts: