Ask Your Question

Can I create a web based database with LibreOffice Base?

asked 2016-09-26 12:34:42 +0100

bpaul gravatar image

I'm a beginning database student. Can I create a web-based database using LibreOffice Base? I'll have about 10 users and need to input customer data on a pad.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-10-06 20:06:30 +0100

EasyTrieve gravatar image

Here are the basic steps you take:

1) A web based database runs either on your internet hosting server or on a server that your internet hosting server can talk to.

For example. You go to a hosting company and pay for a hosting account and in return you get cpanel interface. From cpanel you drill down to databases, and then select and setup a database server, either MySQL, PostgreSQL, or the like, with user(s) and password(s). (You might also have the ability to setup an internet facing database server in other ways too like thru your school's account.)

2) Now this database server that you have setup can be connected to via either your web site (php code, or the like for example), or remotely from your notebook computer. In your notebook you can use a variety of tools to connect like phpMyAdmin, MS Access via ODBC, MyWorkbench, and LibreOffice via either the native SQL driver (extension) or an ODBC connector.

[Note, At the moment w/ LibreOffice I can't get the unixODBC to work without crashing LibreOffice, but the unixODBC is working otherwise. I'm still searching for an answer to this issue. But the native MySQL driver seems to connect to a MariaDB 10.1 data base ok, except that I'm getting an intermittent broken connection from time to time that I'm also still trying to chase down. I'm assuming all of these issues are solvable with a little more work on my part.]

ONCE you finally have the database set up, then you can use LibreOffice to "connect" to it and to manage it.

Have fun, as it's a great adventure.

edit flag offensive delete link more


If this answers your question please click on the ✔ (upper left area of answer).

EasyTrieve gravatar imageEasyTrieve ( 2016-10-06 20:18:02 +0100 )edit

answered 2016-09-28 06:44:11 +0100

frofa gravatar image

It depends what you mean by 'web-based'. LibreOffice Base is really just a 'front end' to an underlying RDBMS (Relational Database Management System) database. The actual database 'back-end' may be on a local network ('split' from the Base file itself) for sharing purposes. But if you want to connect Base to an online (web-based) database, it may prove easier and more cost-effective to adopt a form-centric, web-database solution - see this post by DACM.

Another idea - you might be able to locate your Base file on a file-share service (like, say, Dropbox), but only ONE user may connect at one time (to prevent database corruption). A client-server configuration (such as used by MySQL) is really the only way to protect against data-corruption with multiple concurrent users. In any case, I recommend you adopt a 'split' database setup (as above) to protect against data-loss - see THIS TUTORIAL for more information.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-26 12:34:42 +0100

Seen: 6,897 times

Last updated: Oct 06 '16