Re: [gnome-db] What are we doing with the API?

["Daniel Espinosa" <esodan gmail com>]

Firts, Very great Thanks Vivien for your GREAT job, I allways follow and promote GDA when I can in any forum, I think that the GDA architecture is great and have a long time of live and great things to do in the future, in order to allow any one to write great applications to access databases, all thanks to your work.

As any thing in the world you can use the great tools to create simple calls that make more easy the like, thats why I give you the thanks for the oportunity, I'll send a PATCH that include most "simple" functions to do the most common task using the actual functionality.

2006/9/8, Vivien Malerba <vmalerba gmail com>:

On 9/8/06, Daniel Espinosa <esodan gmail com> wrote:
> I lost the object of GDA!
>
> Ok talk about this:
>
> - I have a program that wants to save its data using diferent data sources
> (XML, SQLite, a DBMS)
>
> - I know that this could need diferent code for diferent provider, but I
> want to write my code once and try to make it works any where.
>
> - Becouse that, I'll create a simple but functional database structure, that
> may not use all the characteristics that much DBMS could give, but I just
> want to save data using any provider I have at hand.
>
> - I want a simple "one function, one action" API that works well, becouse
> time is money
>
> - I don't want a lot of code to do some simple task
>
> Is it GDA meets this? No!!!!! What are we doing?
>
> Other case:
>
> - I have a program that wants to get and update data in a data base
>
> - I know that this could need diferent code for diferent provider, but I
> want to write my code once and try to make it works any where.
>
> - I want a simple "one function, one action" API that works well, becouse
> time is money
>
>  - I don't want a lot of code to do some simple task
>
>  Is it GDA meets this? No!!!!! What are we doing?
>
> Then, why not to return most functions (keeping the actual functionality)
> that makes the most simple task, simple and fast!
>
> The most common task:
>
> - Query                     gda_connection_execute_command( Conection,
> SQL_Command)
> - Create Tables          gda_connection_create_table ( Connection,
> Table_Name, Column_Name, Column_Type, ..., -1)
> - Update Tables         It is simple in current API
> - Insert Data              It is simple in current API
> - Delete Data             It is simple in current API
>
> A simple API for simple task is better for multiple purposes and simple
> applications.
>

I've inversted a lot of time to aneble libgda to make accessible _all_
of the features of each DBMS while keeping the API _relatively_
simple. If you want a gda_connection_create_table(), then it's _very_
easy to write one which uses the current features of libgda, it's only
a wrapper.

Vivien

-- 
Trabajar, la mejor arma para tu superación
"de grano en grano, se hace la arena" (R) (entrámite, pero para los cuates: LIBRE)