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

[Andrea Zagli <azagli libero it>]

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