<div dir="ltr"><div><span id="docs-internal-guid-22f0cc63-a992-e202-3856-78d75dbe992b"><p dir="ltr" style="line-height:1.92;margin-top:0pt;margin-bottom:8pt"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent">Hello I'm Finishing my Master Degree this Year (2016) in Information Technology at Petru Maior University Romania </span><span style="font-size:13.3333px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> (Last year i had some familiy issues that now are solved)</span></p><p dir="ltr" style="line-height:1.755;margin-top:0pt;margin-bottom:0pt"><a href="http://upm.ro/English/English.html" style="text-decoration:none"><span style="font-size:13.3333px;font-family:Arial;color:rgb(0,83,139);text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;background-color:transparent">http://upm.ro/English/English.html</span></a></p><p dir="ltr" style="line-height:1.755;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13.3333px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> </span></p><p dir="ltr" style="line-height:1.755;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13.3333px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent">I will work this summer on finishing integration of Firebird backend </span></p><p dir="ltr" style="line-height:1.755;margin-top:0pt;margin-bottom:0pt"><a href="https://wiki.documentfoundation.org/Development/GSoC/Ideas#Finish_Firebird_driver_integration" style="text-decoration:none"><span style="font-size:13.3333px;font-family:Arial;color:rgb(0,83,139);text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;background-color:transparent">https://wiki.documentfoundation.org/Development/GSoC/Ideas#Finish_Firebird_driver_integration</span></a></p><p dir="ltr" style="line-height:1.755;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13.3333px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> </span></p><p dir="ltr" style="line-height:1.755;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13.3333px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent">The main remaining issue is that the firebird data format embedded in the .odb file is endianess-dependent. The idea is to switch to Firebird's "archive" format that is not.</span></p><p dir="ltr" style="line-height:1.755;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13.3333px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> </span></p><p dir="ltr" style="line-height:1.755;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13.3333px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent">I started by cleaning the previous gerrit and submitting new one</span></p><br><p dir="ltr" style="line-height:1.755;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13.3333px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> Also as time permits fixing the following blockers for firebird integration :</span></p><p dir="ltr" style="line-height:1.8;margin-top:0pt;margin-bottom:0pt"><a href="https://bugs.documentfoundation.org/show_bug.cgi?id=69949" style="text-decoration:none"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent">  </span><span style="font-size:12px;font-family:Arial;color:rgb(0,83,139);text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;background-color:transparent">bug 69949</span></a><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> - table editor should support the autoincrement</span><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"><br class=""></span><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> </span><a href="https://bugs.documentfoundation.org/show_bug.cgi?id=71009" style="text-decoration:none"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> </span><span style="font-size:12px;font-family:Arial;color:rgb(0,83,139);text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;background-color:transparent">bug 71009</span></a><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> - relationship management not implemented in GUI</span><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"><br class=""></span><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> </span><a href="https://bugs.documentfoundation.org/show_bug.cgi?id=71251" style="text-decoration:none"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> </span><span style="font-size:12px;font-family:Arial;color:rgb(0,83,139);text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;background-color:transparent">bug 71251</span></a><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> - Creating table from default choices via wizard fails</span><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"><br class=""></span><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> </span><a href="https://bugs.documentfoundation.org/show_bug.cgi?id=74172" style="text-decoration:none"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> </span><span style="font-size:12px;font-family:Arial;color:rgb(0,83,139);text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;background-color:transparent">bug 74172</span></a><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> - no data type DECIMAL/NUMERIC </span><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"><br class=""></span><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> </span><a href="https://bugs.documentfoundation.org/show_bug.cgi?id=76072" style="text-decoration:none"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> </span><span style="font-size:12px;font-family:Arial;color:rgb(0,83,139);text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;background-color:transparent">bug 76072</span></a><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"> - view creation not implemented</span></p><br><p dir="ltr" style="line-height:1.8;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent">I will test also firebird 3.0 integration (it should work with old 2.5 c based api with no changes )</span></p><p dir="ltr" style="line-height:1.8;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent">I started last year a patch that needs to be reworked with Firebird 3.0 RC2/Final</span></p><p dir="ltr" style="line-height:1.8;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent">Some it's features would allow easy fixes for example autoincrement (implemented as identity)</span></p><p dir="ltr" style="line-height:1.8;margin-top:0pt;margin-bottom:0pt"><a href="https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.identity_columns.txt" style="text-decoration:none"><span style="font-size:12px;font-family:Arial;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;background-color:transparent">https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.identity_columns.txt</span></a></p><p dir="ltr" style="line-height:1.8;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent">True boolean datatype ...</span></p><p dir="ltr" style="line-height:1.8;margin-top:0pt;margin-bottom:0pt"><a href="http://www.firebirdsql.org/file/community/conference-2014/pdf/02_fb.2014.whatsnew.30.en.pdf" style="text-decoration:none"><span style="font-size:12px;font-family:Arial;color:rgb(0,83,139);text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;background-color:transparent">http://www.firebirdsql.org/file/community/conference-2014/pdf/02_fb.2014.whatsnew.30.en.pdf</span></a></p><p dir="ltr" style="line-height:1.8;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent">If nothing else is left to do i will create a branch with firebird 3.0 c++ oo api</span></p><p dir="ltr" style="line-height:1.8;margin-top:0pt;margin-bottom:0pt"><a href="https://github.com/asfernandes/fbstuff/tree/master/src/test" style="text-decoration:none"><span style="font-size:12px;font-family:Arial;color:rgb(0,83,139);text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;background-color:transparent">https://github.com/asfernandes/fbstuff/tree/master/src/test</span></a></p><p dir="ltr" style="line-height:1.8;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent">Api is  now fronzen according to the Firebird core developers</span></p><a href="https://github.com/FirebirdSQL/firebird/tree/master/examples/interfaces" style="text-decoration:none"><span style="font-size:14.6667px;font-family:Arial;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;background-color:transparent">https://github.com/FirebirdSQL/firebird/tree/master/examples/interfaces</span></a></span><br></div><div><br></div><div><br></div><div>Previous merged gerrits </div><div><a href="https://gerrit.libreoffice.org/#/q/status:merged+Popa">https://gerrit.libreoffice.org/#/q/status:merged+Popa</a><br></div><div><br></div><div>Proposal on google docs</div><a href="https://docs.google.com/document/d/1CnN9ltIcphsO9Am-v4LLmQ8tWVuwrOuLKldhkXgjrpw/edit?usp=sharing">https://docs.google.com/document/d/1CnN9ltIcphsO9Am-v4LLmQ8tWVuwrOuLKldhkXgjrpw/edit?usp=sharing</a><br></div>