Ask Your Question
2

Why use a backend data base? [closed]

asked 2012-09-01 17:44:19 +0100

DonLow gravatar image

updated 2012-09-01 21:55:26 +0100

tohuwawohu gravatar image

Obviously I'm new to database management. I'm finding the learning curve to pretty steep. All help is appreciated. My question today is about the advantages of, or reasons for, using a "backend" database manager (MySQL or H2) along with LibreOffice Base as the "frontend". I can easily enough see the advantages of using Base as a frontend, but why do I need another program to store the data in?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 00:52:54.932032

1 Answer

Sort by » oldest newest most voted
1

answered 2012-11-19 19:18:07 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

The Base database is really only useful if you interface with it via the Base frontend. Using a separate backend can provide a plethora of advantages, although many of them may not be useful to you. For example: if you interfaced with MySQL, you could use the backend as an application database as well. MySQL is frequently used in web applications, so having the web application database shared with the database that you can manually work with is very useful. While the Base database is designed to take up minimal space on your disk and be relatively simple, MySQL, PostgreSQL, SQLite, H2, Oracle and MS SQL are all designed with performance and high scalability in mind. If you don't already have one of these databases, there probably isn't an immediate need for you to use one. However, if one exists, you can use base to interface with it easily!

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-09-01 17:44:19 +0100

Seen: 1,457 times

Last updated: Nov 19 '12