Since JavaScript and Node.js does not exist in Haiku yet, I planned on using LibreOffice Base to create front-ends for my PostgreSQL databases. However, I soon discovered the LibreOffice Base is flat-out broken!
I created two bug reports for LibreOffice Base (#software 15360 & 15361).
The first is critical since I cannot create a local database (#15361). We need to select what type of database to proceed in local DB creation:
We must be able to select what type of database to create locally: Firebird or HSQLDB, where I expected to see this:
The second is just as critical where I cannot add a Class Path for the JDBC driver for PostgreSQL. In the Advanced window, the option to select āUse a Java runtime environmentā is blocked and cannot select āClass Pathā button:
It should look like this instead:
So, at this point in time, we cannot create a local database or attach an external database. Hopefully, the team that maintains LibreOffice can quickly fix these two items.
Too bad Kexi was not migrated with Calligra Officeā¦that would be another front-end option for me if it existed in Haiku.
It will just take a rebuild for it to be available in Haiku. So the option on using Node.js might be possible for your usecase instead of LibreOffice Base. But still file the issue on HaikuPorts for others to take a look.
Thereās also Qt (with QML) ported to Haiku - which might be an easier way to create your front end apps. Just need to install the Qt dev packages from Haiku Depot
I looked for online courses regarding Qt and PostgreSQL development. I could not find any and no tutorials in creating a database app for PostgreSQL via Qt. Not sure what language Qt isā¦it is a bit confusing.
My extent of knowledge of Javascript and Node.js is from an online course, āLearn to build apps using Neo4jā, where āthe course starts at the very beginning with databases in general and progresses to actually building an application with NodeJS and JavaScript that employs Neo4J.ā It is very basic and that is all I know about Javascript and Node.js where I just needed to create an DB interface to quickly add/update/delete new database nodes in Neo4j. It is wire-frame (I think that is what is called)ābut functional. I could change the Cypher code to use SQL instead and point it to PostgreSQLāup and running with some tweaking of what I already know.
MS Access Forms, LibreOffice Forms, or Kexi Forms are more like what I expect to use development-wise in creating a database front-end. I am not a developerāI occasionally have to do something outside my database administration skill-set domain like this on occasionāas usual, I find programming a painful exercise.
I do enjoy database programming using languages as PL/SQL, TSQL (with VB via SSIS), and PL/pgSQL.
I was reviewing a Qt foundation course on Edemy and the instructor was identifying parts of a script, such as ādeconstructorā, ānamespaceā, and others that have no meaning to me. If that was a foundation introductionāI was already lost at the very beginning. [Even these foundation courses expect you to know something alreadyā¦not a good start for me.]
So I think this is a good suggestion for another programmerābut not me. Too steep of a learning curve. I do not want spend hundreds of hours learning/reading to do a simple app, where I can do the same thing inside LibreOffice in 1/100th of the time.
YABasic could be an option if the JDBC driver could be used and I have no clue how to do that in YABasic. In VB, I designate the JDBC drvier and it just works but VB was designed with databases in mind over the years.
However, I also need it be portable/replicable in Windows, Linux and Haiku since I have databases in three OS environments.
LibreOffice Base cannot open a created database. It cannot open an embedded Firebird or HSQLDB database that was created by another LibreOffice Base program from Linux or Windows.
For a pre-existing HSQLDB database:
For the FireBird database, hereās the error:
So, the current LibreOffice Base is COMPLETELY unuseable:
we cannot create a new local database [GitHub #4187]
we cannot attach/connect to an external database (i.e. PostgreSQL) [GitHub # 4188]
And now we cannot open a native embedded database [Git #4252].