Discussion on:

DIY: Create easy to use databases with LibreOffice Base

Hi Jack,
Thank you for this post.
How about using a form created with the LIbreOffice database that connects to a MySQL database and can be used to input data into the MySQL?
Also, can LibreOffice be used to run queries to a connected MySQL database?
Thanks,

There is a connector for MySQL in the create new database wizard.

LibreOffice really shines as a front end to several popular database types.

ricardoc -- that was actually going to be one of my next articles! you read my mind. I'll take that task on asap.

Thanks so much for reading DIY!

Jack

I've tried LibreOffice DB for several projects. If it's just a simple db such as described in the article Base works very nicely. But IMHO the lack of complete documentation and the occasional flackiness of Base just did not lend itself to creating more complex databases and reports.

Do these steps work equally well with OpenOffice?

Also, does OpenOffice work equally well as a front end to MySQL, PostgreSQL, etc.?

Thanks.