[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On 21/06/2022 21:23, Tom via list wrote:
Every now and then I play with LibreOffice using the documentation that comes with it. It has generally not been that good and I've failed to get the examples working. This time however I've managed to get nearly 100 pages into the Base documentation and it seems to be going quite well so far. I used to write lots of little but very useful apps in MS Access a long time ago and for the first time I have a feeling I may be able to do the same with Base!Real users are working in MariaDB/Oracle/Postgresql/NOSQL/etc .. :P
Just wondering if any of you have had any success with it and connecting to external DBs?
Tom te tom te tom
That said, I really miss the MS Visual-Basic API which allowed you to do all sorts of crazy things in Moffice, which I've never seen possible with the limited StarOffice-inspired API for Libre/Openoffice. The data model is horrendous... if anyone can point me to some more sensible programming interface, I've got to admit, I am curious, because scripting up handy macro functions was something that really enhanced my Office experience ...
And yeah, years gone by now, I scripted a PHP page to a MySQL database which I populated from a user-supplied text file .. Fun times..!
You can connect to the other databases relatively in theory - I'm
just working through the documentation to get a feel for the thing
before leaping into other DBS (tho probably not NOSQLs - which I
am convince only exist because someone never RTFM) . And ODBC will
allow you to connect to sqlLite and most other DBs.
I have a PHP shop and secure document control system using MySql which I hope to extend to access/base type things over the web - currently it just lets you build and populate tables but I hope to add all the other stuff later when I've gone over base and a RAD for ncurses to get my grounding sorted.
Tom te tom te tom
-- The Mailing List for the Devon & Cornwall LUG https://mailman.dcglug.org.uk/listinfo/list FAQ: https://www.dcglug.org.uk/faq/