User uses LO Calc Macro to save draft data in LO Base and export to database server

[lonk]

I would like to write codes in LO Calc Macro for accounting job.

My plan is every Lubuntu user saves her draft data in LO Base using LO Calc Macro.
After she rechecks, the draft data will be exported from LO Base to database server.

May I ask 3 questions?

1. Can LO Calc macro connect LO Base to save data?
2. Where can I find connection string for question no.1?
3. What is the best database for database server in doing this (Firebird/PostgreSQL/MariaDB)?

[Ratslinger]

Hello,

Yes you can, using macros, connect to Base from Calc or Writer and save data. Much information on connection methods can be found in a document by Andrew Pitonyak found here → see AndrewBase document.

As for best database, this entirely depends upon what you may be doing. Each DB has its own strengths and weaknesses and only a study by you can determine which is best for your needs. It is certainly beyond the scope of a question in this forum.

Do not see any reason to save in one database then pass it to another database - Base is already connected to a database.

[lonk]

Thank you so much.