does a database created in windows run seamlessly on a mac

If I create a database in my Windows 10 version of LibreOffice will it run on a Mac with the mac version of LibreOffice installed. Any tweaks required?

Hello,

There is no manner in which seamlessly can be applied to the use of LO on different Operating Systems. One only need look at the various bug reports on Bugzilla to see that an error or problem can be present only on a particular OS. And whether you encounter a problem or not may entirely depend upon exactly what you are doing or using (for example database type - HSQLDB embedded vs MySQL).

In general, you should have little if any problems in moving from Windows to Linux to Mac. A notable difference in Base for Mac is the need for Java JDK to be installed vs just JRE for other OS’es. Another potential difference, depending on the database (not mentioned) is the connector to the database.

Thanks Ratslinger for the heads up. I’m an old Access and SQL database user but retired some years ago and I’m just trying to help someone with a small database to hold research reference material information for a thesis they are writing. I did not anticipate having to use an external data source. I had presumed the native Base tables, forms and queries would be sufficient for the job. Am I wrong? I’m a PC/Windows user but they will want to run any database I create on a Mac.

@Gadgee99 Let me say I am not a Mac user but from answered questions, and except for comments in the answer, you should not have any problems. Just one note here though. The current default DB included with Base is HSQLDB embedded v1.8. This is being replaced with Firebird 3.0 embedded (can currently use if ‘Enable Experimental features’ is turned on - Options → Advanced). May be default in v6.2. HSQLDB is very old and has its’ own set of problems regardless of OS. Just a heads up.

@Ratslinger Thank you for all the information. I’ll switch to experimental as by the time I get the database done the new version will probably have shipped! Many thanks again.