Re: [gnome-db] Progress update on my branch

Il giorno gio 29 mar 2018 15:25:38 CEST, Pavlo Solntsev ha scritto:
> Interesting. Out of curiosity, why did you decide to build a separate
> library instead of polishing some other already available tools? It
> looks like it depends on libgda and libgda could be the best place to
> implement this feature.


first of all, unix philosophy: "Make each program do one thing well.  
To do a new job, build afresh rather than complicate old programs by  
adding new features."


second: i cannot edit libgda and i'm not pretty skilled to contribute  
in that way to libgda


for example i have also a library [1] to make reports, as libgda did  
after with GdaReportEngine


[1] http://saetta.ns0.it/gitweb?p=reptool/libreptool;a=summary


> On Thu, 2018-03-29 at 06:12 +0000, Andrea Zagli wrote:
>> Il giorno gio 29 mar 2018 02:40:53 CEST, Pavlo Solntsev ha scritto:
>> > [...]
>> >
>> > Meanwhile, I have started a very optimistic project. I realized,
>> > that
>> > the code doesn't allow effectively manage databases. For example,
>> > create DB objects from user provided data, e.g. xml. Actually,
>> > there is
>> > a way to do so, but it is not flexible and it is understandable
>> > only by
>> > people who familiar with the code. My goal here is to develop a
>> > infrastructure to generate database from xml and retrieve database
>> > information to xml. I decided to do this via DDL API. A new object
>> > GdaDdlCreator will be introduced which will be responsible for
>> > parsing
>> > input xml file. Other additional objects, e.g. GdaDdlTable,
>> > GdaDdlView,
>> > GdaDdlPkey, etc. will be used and generated from the user provided
>> > xml
>> > file. Also, I am planning to allow object initialization using
>> > xmlNodePtr. It will allow generation of single object from multiple
>> > xml
>> > files. Having these objects, we can create them using a new API,
>> > e.g.
>> > gda_server_operation_prepare_create_ddl_table. After all this work
>> > ,
>> > database should be generated/updated from simple xml without any
>> > code
>> > modification. It will also provide a convenient relationship
>> > between DB
>> > object and user data. Technically a parser may be written to
>> > generate
>> > such code from the xml file.
>> >
>> > I haven't pushed this work to git server yet.
>> >
>>
>>
>> i have a library that do the same things (WIP) (inspired by
>> http://www.liquibase.org/)
>>
>> http://saetta.ns0.it/gitweb?p=libzakdbt;a=summary