[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On 12/07/2022 14:34, Pentiddy wrote:
I am wondering if anyone local enough to me (Liskeard, Cornwall) with a good knowledge of LibreOffice Base might be able to provide a combination of training/ help set up a database for our Burial business? I have up to this point been using a spreadsheet (also LO) and after previous discussions and doing some reading I now feel it would be a good move to set it all up on a dedicated database.A somewhat academic question, but how to you (or you B.i.L.) propose to interface a LO Base database with QGIs, where it is likely to expect a more standard RDBMS like MySQL/MariaDB or PostGresql (or even sqlite!)? It will be very quick/simple to write a short script to import your CSV output from the spreadsheet(s) into one of these standard DBs. Whilst you can easily import spreadsheets into a DB table, this may not be the most efficient form to store this data, and perform useful queries on it. You may also need a lot of programming to get data Out of this table/DB into something that you can analyse/display in a more user-friendly format?This is something that I can pay for.Once this is done my Brother in law has said he could help me combine the DB with a QGis mapping system.Ideally for me this would be mostly at my home but I am happy to travel a little way, though obviously online is a possible for some of it too.I have had a little play with BASE, set up a basic schema, linked tables.I am however much happier being led through the next steps rather than wading and fumbling through the documentation...!Please contact me if you can help or pass on my request to anyone you know who might be able to help.Regards to all Anthony
FWIW years ago I wrote a short PHP script to import a text file of music a friend had on their computer into a mysql database, and another short PHP script for general users to query it from the web. I think both scripts were about a screenful long, and worked a charm. I'm not sure they took more than a few days to put together, albeit the UI was probably very basic !
Also, even before that, I confess to having imported a huge text 'database' of scientific data into a MS Access database via Visual Basic, which was something pretty simple for me in the 90s having programmed in BBC BASIC at home, and Pascal at college (don't ask...). But for any 'modern' task I would be looking very much at the widely-used tools/programs in the Linux sphere to do these quickly and simply, with plenty of support online for the kinds of operations one might need in common applications of said tools... (ie. python, mariadb/postgresq, etc).
TL;DR I probably have enough skill to do what you ask, but I'm a bit unsure of why you're choosing this particular method ...
</my 2dollar> Good luck, best regards, Michael.
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature
-- The Mailing List for the Devon & Cornwall LUG https://mailman.dcglug.org.uk/listinfo/list FAQ: https://www.dcglug.org.uk/faq/