Who destroyed base?

English
#61

It only shown one single problem: inclusion of an unrealistic but very populistic goal of creating an automatic migration between different database engines (i.e., something that automagically could take your carefully hand-crafter HSQLDB, and turn it into an identically behaving Firebird) has devastating effect on the project. When the task of implementing the FB support, the only reasonable goal of that project, was done, the other task - the migration wizard - was implemented somehow. When FB got out of experimental stage, the only thing that was too problematic was exactly that wizard - and that wizard had forced making FB - as a whole!!! - back experimental. A whole disaster.

Is there any real-world tool capable to migrate between different DBMSs lossless? We needed to focus on introduction of FB as the new default engine; then - if desired - moving HSQLDB to extension, for people still wanting to use those DBs (or, maybe, just continue supporting HSQLDB as a legacy - which at that stage would not mean dependency on Java (in this specific area), because we provided a Java-less default alternative). And that would make the project successful years ago. But - there is marketing. There is that “kill Java with fire”, which doesn’t want to stop anywhere except total extermination…

3 Likes
#64

I was more thinking of the gui, wich sometimes just doesn’t know some of the available functions (and yes, I’ve seen several added). Not my problem as I use SQL without gui, but in this thread it is a topic.

#73

I’ve never seen that. Thank you.

#62

This is very insightful. I have not yet braved FireBird or the Wizard, but your explanation hints at a larger issue I have noticed in my brief exposure to Base: Code smells of a lack of good software foresight and good planning. I’m experiencing behavior that indicates memory leaks (runs slower and slower then locks up computer) and inexplicable inconsistencies.

It feels like a project that rather than furiously keep fighting bugs, to take a breath, do a deep code review and focus on simplification, focusing on core unique functionalities and consolidate code. But C++ will always be buggy IMHO. I’m not smart enough to know what the most cost effective solution is - maybe AI + Rust when the tools become available?

#63

Please no “C++ will always be buggy” and “let’s rewrite in Rust” nonsense. (Well, at least I’m allergic to that, and will quit reading this otherwise. And most of all - the “AI will help coding!!!”)

Now about that visionarie’s “I know what all of you need to do” stuff. Well, in the world of The Document Foundation, which is not a dictatorship, and all the development is scratching own itch - you have no power to tell who should do what. So - people can dream as much as wanted, but only doing things themselves, or hiring someone and having things done for money, or - finally - hoping for the best - are the only options. (The option of TDF doing that for its funds is ~real, but needs its members’ support; so - becoming a member may be also a reasonable option.)

1 Like
#65

and Java is evil.
A simple upgrade to HSQL2 would have avoided all that trouble.

1 Like
#66

It’s really good to hear the TDF is not a dictatorship – and by implication the Foundation is open to suggestions. Sorry if I came across as ‘telling you what to do’. I didn’t even realize until just looking up who you are that you were a developer of LO. Thanks for what you do.

But if something isn’t working - and any objective observer would admit that Base has significant issues - one would think that the Foundation might be interested in community input. I for one would happily pay $100 for a ‘dream version’ of Base. But I’m not convinced the software engineering behind it is 1) genius enough to do such planning totally independently nor 2) willing to accept outside input on this

Again, this is not a “do it my way or else” comment. It is intended a honest input exploring Base and Base Tutorials for the last week, using both HSQLDB & MariaDB connection, using both Linux Debian distro supplied 7.4 and Latest LibreofficeDev 25.8 daily build versions and experiencing what one might kindly call Windows 3.1 level instability and inexplicable inconsistencies within the app (metric here, SAE there when US locale and no central units control)

Just because software is Open Source doesn’t mean it should be poorly designed.
I didn’t start this thread, titled “Who destroyed base?”, and as a believer in the benefits of FOSS (mostly the freedom part, but also the ‘scratch your own itch for free’ part), I am not here to bash LO. But sometimes the Emperor has no clothes and it is time to find a tailor.

PS I am not about to get into a flame war about Rust vs C++. For all I know, all Base needs is more testing etc. But it is true that Rust prevents a lot of run time bugs and seems to be growing in popularity. From what little I’ve used it, it seems more pleasant than C++.

#67

The question is not “should it be poorly designed or not”, and even not “is Foundation interested in input or not”. It simply is “what do you think you achieve writing your ideas here” - and I might imagine, that you think that Foundation gets your input by that. And my point is: no it does not. Here you are sharing your opinion with other users and mildly interested individual developers. The foundation does not rely on Ask (unfortunately); and hence my “become a member” advice.

#68

Fair enough. But in my defense, this is a subdomain of libreoffice.org, so it was reasonable of me to believe that a libreoffice.org forum might be in some way, shape, or form, administered by or related to The Document Foundation or whoever it is that determines what happens to LibreOffice Base. Otherwise, why is TDF asking for money? To do what? Is TDF’s primary role promoting FOSS or developing it? But more to the point, where can people such as those contributing to this thread contribute IDEAS (not money that simply hypes the wonders of Base while ignoring users constructive criticism).
Again, this is not personal, I have no knowledge of your role in Base development. And I truly hope that Base becomes an admired piece of software. But perhaps it it would be a better idea to hire someone with age & experience rather than hiring to spearhead a major conversion of underlying database engine someone fresh out of school who seemed to be spread rather thin.
https://www.ahunt.org/2013/05/gsoc-2013-libreoffice-firebird-sql-connector/

PS reread your post and will simply ask for your recommendation on where to better give input to the TDF.

#69

Let’s asl @ilmari - he knows best.

#70

Do you think running a domain, obtaining certificates for encryption, server capacity for downloads, discourse (this ask site), and gerrit etc comes for free?
.
IMHO you either need money or a professional (team) to ensure someone else is paying the next bill on your desk…

#71

When it’s about using foundation money, the place would be https://community.documentfoundation.org/c/board-discuss/26

Regarding Base, the board is currently discussing hiring a developer focusing on it.

2 Likes
#72

Of course not. Good point. Although I hope they aren’t spending too much on gerrit (not sure how well it is working vs. user testing)

And some TDF funds are going to lawyers. I’ll sit this one out.

https://community.documentfoundation.org/t/i-am-exhausted-this-is-my-resignation-from-the-board-of-directors-of-the-document-foundation/12950/6

#74

I cannot help with a solution to this problem. I only found, then read, this post as I searched for “Disadvantages of Base” whilst finally contemplating moving from Borland(Corel) Paradox 9, for a series of personal databases. This post has persuaded me not to go the Base route. This gives me a problem as I will migrate to Linux from Win 10.
I have used OOo/LO since version 1.8 in windows (at the time a disaster in Apple).
As a user of Paradox since 1992, it seems to me that the database engine needs to be stand-alone along with the functionality of the UI with integration to other programmes for the reporting (the weakest point of Paradox). Corel have achieved that to some extent but since Microsoft killed WordPerfect & Paradox there are few users outside of the US who will pay for these fringe programmes, in any case, they only work on Windows.
I will continue with LO but will have to install VirtualBox in Linux & continue to run Win10 with Win compatible DBs.
Maybe European governments could be persuaded to come to the rescue of Base as part of their detatchment from reliance on the US, afterall, at the serious DB level, Europe has SAP to counter Oracle, both rather too heavy for my PC!
In conclusion, can Base be largely unentangled from Write & Calc to allow more freedom to develop with less interdependance?

1 Like
#75

No, current forms are actually Writer documents.

#76

You compare a tiny addition to this office suite (~30 MB including various drivers) with a database development suite.

WINE can run Paradox: Making sure you're not a bot!
If you need Paradox data in LIbreOffice, install the JDBC driver for Paradox and connect a Base document.

1 Like

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.