Live data from Hacker News

BeeBase, a programmable relational database with graphical user interface

beebase.sourceforge.io

81–90 of 110 posts

Re: BeeBase, a programmable relational database with graphical user interface

#81
post #80
post #73

Earlier quoted context omitted.

The replying comment side stepped the discussion of error messages lacking context that could be easily remedied to be identifiable and the response was "it's in the manual". All error messages meant to be understood by humans should be in the manual at minimum, but what the replyer suggested by ignoring the conversation was "your issue with the error message isn't important because you can figure it out yourself". I…

It's not important because there are many quirks to this software, including a Lisp-like programming language. Learning to use it involves internalising many things that aren't common knowledge, which one has to figure out by trial and error, and the manual. If you are seriously interested in BeeBase you'll be spending hours learning the basics of the Lisp-dialect and GUI toolkit, getting a hangup on that error messa…

> And let's say someone makes a patch that implements a new error message that specifies which of the two rules regarding table names has been breached, then what? More complaints about the next quirk? Some other error message?

Yes, this is how software development is done, assuming you like your customers.

Re: BeeBase, a programmable relational database with graphical user interface

#82
post #78
post #25

Earlier quoted context omitted.

Exactly, it's a bad error message if you need to read 8 pages of tutorial to get that basic feedback.

Let's take a look at how the big boys handle something similar... SELECT * FROM logs WHERE KEY = 'blah' LIMIT 10; /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'KEY = 'blah' LIMIT 10' at line 1 */ I think there is some expectation of technical literacy for the use of a database. This would include being able…

Yes, the error messages of modern SQL databases suck. On that note, SQL itself sucks (the two problems might be related). But that's no excuse to not do better. Besides, BeeBase seems more user-focused than MariaDB, presenting itself as a nice GUI tool. "Real developers" might not need good error messages, but they also don't need a GUI and would sooner use some unholy bash-sed-awk-Perl mixture.

Re: BeeBase, a programmable relational database with graphical user interface

#83
post #82
post #78

Earlier quoted context omitted.

Let's take a look at how the big boys handle something similar... SELECT * FROM logs WHERE KEY = 'blah' LIMIT 10; /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'KEY = 'blah' LIMIT 10' at line 1 */ I think there is some expectation of technical literacy for the use of a database. This would include being able…

Yes, the error messages of modern SQL databases suck. On that note, SQL itself sucks (the two problems might be related). But that's no excuse to not do better. Besides, BeeBase seems more user-focused than MariaDB, presenting itself as a nice GUI tool. "Real developers" might not need good error messages, but they also don't need a GUI and would sooner use some unholy bash-sed-awk-Perl mixture.

Are you aware of non SQL databases that give detailed errors?

Re: BeeBase, a programmable relational database with graphical user interface

#84
post #80

Earlier quoted context omitted.

It's not important because there are many quirks to this software, including a Lisp-like programming language. Learning to use it involves internalising many things that aren't common knowledge, which one has to figure out by trial and error, and the manual. If you are seriously interested in BeeBase you'll be spending hours learning the basics of the Lisp-dialect and GUI toolkit, getting a hangup on that error messa…

> And let's say someone makes a patch that implements a new error message that specifies which of the two rules regarding table names has been breached, then what? More complaints about the next quirk? Some other error message? Yes, this is how software development is done, assuming you like your customers.

Who are you referring to? Is it even someone in this thread?

Re: BeeBase, a programmable relational database with graphical user interface

#85
post #84

Earlier quoted context omitted.

> And let's say someone makes a patch that implements a new error message that specifies which of the two rules regarding table names has been breached, then what? More complaints about the next quirk? Some other error message? Yes, this is how software development is done, assuming you like your customers.

Who are you referring to? Is it even someone in this thread?

I was quoting you, using the > sign to refer to what you said directly. I thought the quote was useful to highlight that it can be easy to have a mental disconnect, or even an antagonism, between developers and their stakeholders.

Re: BeeBase, a programmable relational database with graphical user interface

#87
post #35

Honestly I think LibreOffice Base (and its brethren) are underappreciated and underdeveloped pieces of software these days. In 80s/90s stuff like dBase and Access seemingly were relatively popular, but that whole category of software seems to have mostly died out which is imho a shame. I suppose Access being somewhat notoriously horrible has something to do with that, suffocating the whole field. Considering how much…

to give some perspective, there is an app i've written as a complicated google sheets script, which would have been way simpler to maintain as a desktop app, but what the end-users want is the ability to have multiple people use it from multiple devices at once. that's become table stakes for a lot of software now, and it's really what has killed desktop apps for stuff like this.

Re: BeeBase, a programmable relational database with graphical user interface

#88
post #83
post #82

Earlier quoted context omitted.

Yes, the error messages of modern SQL databases suck. On that note, SQL itself sucks (the two problems might be related). But that's no excuse to not do better. Besides, BeeBase seems more user-focused than MariaDB, presenting itself as a nice GUI tool. "Real developers" might not need good error messages, but they also don't need a GUI and would sooner use some unholy bash-sed-awk-Perl mixture.

Are you aware of non SQL databases that give detailed errors?

Fair point. Databases encoding queries in JSON get some error messages for free, at least when it comes to "syntax". But I think even others do well.

I just logged into Grafana and tried writing a simple query. Upon failing I got a reasonably detailed and specific error message: 'parse error: expected type range vector in call to function "rate", got instant vector'.

I also tried XQuery in Xidel and it gave me nicely descriptive responses to whichever mistakes I introduced.

Re: BeeBase, a programmable relational database with graphical user interface

#89

I have to use Access at work. Im wondering if this could be a replacement. Certainly LO Base is not, much as I'd want it to be. I suppose it depends on whether the scripting language can do what vba can, especially with regards to xslx files.

Javascript and python supposedly are coming to excel.

Re: BeeBase, a programmable relational database with graphical user interface

#90
post #77
post #71

Earlier quoted context omitted.

No, there's a specificity to "name" and "group" that makes them similar, which is one part of why I settled on this example. The other is that I expected the recipient to have experience with regex and find the example dumb, confirming my position that one can very well demand a basic knowledge of the tool that isn't immediately communicated by it. Like knowledge of the regex language, or having spent ten minutes ski…

If it's any consolation, I (some random guy on the internet) would look for naming conventions in the manual if I was given the error "invalid name".

[deleted]
Post reply on HN