BeeBase, a programmable relational database with graphical user interface

[LkpPo]

Good morning,

I wanted to introduce this little, unpretentious piece of software, which is intended as a small programmable database for hobbyists, like a mini Access but with a scripting language for those who like parentheses.

Your opinions are welcome.

Regards,

[psadri]

Great! This reminds me of FileMaker and similar RAD desktop tools. Curious to know what kind of projects people are using it for?

[hilti]

Amiga?! Just reading this warmed my heart. Awesome project - congratulations!

[pkphilip]

Very nice! Looks great!

May I suggest that you have a "Get Started" button right on the home page itself with a very basic tutorial?

[SuperHeavy256]

Thanks for sharing. I was looking for something just like this actually.

[ComodoHacker]

Is there any technical docs on internals? How it does I/O, caching, consistency, concurrency etc.?

[vincnetas]

Apparently saved project created with BeeBase is basically a sqlite DB, that you can open with any sqlite browser. So i think a lot of value could come from standardised sqlite format, upon which you could build different UI's to manipulate the content of said sqlite DB and then provide a app that would build client UI based on content of same sqlite file.

[brktime]

Yes, BeeBase uses the sqlite3 file format. You can make changes to the sqlite3 file with other SW, but there are some rules to be followed if you want BeeBase to work with those changes. More info is in the manual here: https://beebase.sourceforge.io/index.php?page=documentation&...

[cess11]

You can export to SQLite3, but not import it back in again.

[vincnetas]

Ok so first feedback. Launched app. Went to create a new table. Entered name : "users". Got error "Invalid name". Got confused, whats illegal about the name. After some time figured out that name must start with UPPER case latter.

This could have been the error message instead of generic "Invalid name".

[brktime]

True, this could be improved. Note though that if you hover over the text entry box, there is a tool tip that says this:

Name of the field. Must begin with an uppercase letter followed by further letters, digits or underscore characters. Non-ASCII letters like German umlauts are not allowed.

[cess11]

It's explained on page 8 of the manual, in the tutorial section.

[kazinator]

It's a poor restriction. The table name I want is 収入. Now what?

[zokier]

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 business users are stretching Excel to fill the gap, I do think there would be demand for better options. I guess Airtable etc are the modern alternatives.

I find it just a shame that databases as a concept is something that has been relegated to be hidden deep in the backends and accessed only by specialized DB admins or through narrow and leaky APIs; SQL is considered arcane wizardry instead of being suitable for technical business users like afaik it was originally envisioned as.

[humanfromearth9]

I haven't seen anything that beats the UI and UX of FileMaker Pro from the 90s.

[zem]

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.

[lysecret]

Notion is putting the database in the Center in a way.

[larodi]

Cool that it runs on Amiga. I’d love to see a local store use Amiga based UI for the warehouse. Also the fact it was started as another project in 1994 makes it double cool.

[nxobject]

Beyond your computer/workstation, I'd love if there was a personal database program that could also access via your phone, so you can use it on the go (even via dynamic DNS if needed) – modern no-code platforms do that, but data sovereignty would be nice.

[xet7]

Try:

https://www.nubuilder.com

https://github.com/nuBuilder/nuBuilder-4.5

[Willamin]

Lately I've started using a barebones SQLite DB for this and a GUI DB editor program (TablePlus, which happens to have an iOS app as well).

I'd always relied on ORMs in whatever web application I used to interact with DBs for the most part, but I've recently been learning more about views, triggers, and more complex relations. It's been insightful and I've found that much of what I want from a program like BeeBase is covered by knowing more SQL.

----

That being said, I'd love to see what you described too. I don't mean for this to be like the infamous "why do you need dropbox when you have rsync" comment. I just wanted to give an anecdotal alternative to use until someone creates what you described!

[rambambram]

Try good ol' PHPMyAdmin from your local webhosting company!? The view on a mobile screen in portrait mode is not even that bad.

[sesm]

From a cursory glance, the Lisp dialect that BeeBase is using is closest to Common Lisp, is that correct? Sorry, I'm not an expert on CL, but it would be great to see a quick comparison of BeeBase Lisp with other popular Lisp dialects, like this: https://clojure.org/reference/lisps

[brktime]

Yes, it is close, although it is completely homebrewn and lacks a lot of functionality of common lisp. Think of it as taking the syntax from lisp, some basic lisp functions, and then adding functionality for programming your database.

[aitchnyu]

30 rows from multiple tables in a 1024*786 screen (wild guess). I was part of a rewrite of an app, that previously crammed 30 rows into a small screen, and 10 rows after.

[ljsocal]

Reminds me a bit of Lotus Agenda. That never made it out of DOS (except in Hobbs, the unreleased prototype Windows version)

[ranger_danger]

Reminds me of Microsoft Access in the 90s. We used that to run our entire repair business and it worked great.

[hgyjnbdet]

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.

[cyanydeez]

Javascript and python supposedly are coming to excel.

[SuperHeavy256]

Man, that tutorial was difficult to read. No images or GIFs?

[Self-Perfection]

I believe I have seen something similar on Maemo but cannot find it now.

[egeozcan]

> BeeBase is available for Windows, Mac, Linux and Amiga

What a nice surprise!

How do you test? Could you automate it?

[rho4]

How does it compare to MS Access or FileMaker?

[layer8]

It runs on the Amiga.