[Libreoffice-bugs] [Bug 51779] support for SQL datatype INTERVAL

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=51779

Buovjaga <ilmari.lauhakangas at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ilmari.lauhakangas at libreoff
                   |                            |ice.org

--- Comment #12 from Buovjaga <ilmari.lauhakangas at libreoffice.org> ---
(In reply to Gökay ŞATIR from comment #11)
> Is there an ongoing discussion about which db system to choose? Like this
> one:
> https://ask.libreoffice.org/en/question/88866/base-firebird-vs-hsqldb-
> embedded-database/
> 
> Or is the decision is made already?
> 
> I think SQLite could again be the candidate. Its latest versions support
> multiple reads at the same time, it handles multiple connections well.
> 
> SQLite just needs a wrapper for data types, which can be implemented on top
> of it.
> 
> Also, it has amalgamation, i personally find that feature valuable.

There is no ongoing discussion. The decision was made long ago. Since then,
there have been multiple Google Summer of Code projects and also TDF contracts
to bring embedded Firebird into a production-ready status.

I highly recommend you to contribute to the meta reports:
https://bugs.documentfoundation.org/showdependencytree.cgi?id=116970&hide_resolved=1
https://bugs.documentfoundation.org/showdependencytree.cgi?id=116968&hide_resolved=1

There are some fundamental data type differences between HSQLDB and Firebird,
but the upcoming Firebird 4.0 will solve a couple of these and hopefully a
future version will solve more. This would make it easier to migrate existing
database files from HSQLDB to Firebird.

https://firebirdsql.org/file/community/conference-2019/1_firebird_on_the_road_from4_to_5.pdf

Hopefully we will see 4.0 during the second quarter of 2020.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200418/6a3ce39e/attachment.htm>