Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases > #521

Re: Selecting a database app??

Show all headers | View raw

Dave wrote:
^^^^
Please use your real name here.

> I have been collecting data about cities and the nation in a spreadsheet
> (LO Calc).  I planned to move the data to LO Base, but those plans died
> when I learned that Base can't do the things I need, or work with other
> reporting software.

You need to differentiate between LibreOffice Base, the DataBase Management 
System (DBMS), and the OpenDocument Database format.

> So, I'm looking for suggestions on another database engine.

Are you sure?
 
> […]
> I also need to have charts with up to four curves on the same axis.
> There are report generators that will do this, they just need JDBC or
> ODBC drivers for the database engine.

Or neither of those.
 
> Specific requirements (such that I know them) are:
> * Data size:			<100 GB
> * Simultaneous transactions:	2 for now, 16 later, more if a web 
> app.
> * Cost:				Free (this proj. has low income 
> pot'l.)
> * OS:				Linux
> * Other:			Time is tight, so easy is good
> SQL will be used
> Data types are int, float, memo
> 
> Hope this is enough to get a recommendation.  I have heard good words
> about MariaDB, PostgreSQL, and MySQL, but really don't know which is the
> most suitable.

ISTM you are approaching this problem from the wrong direction.  Your goal 
is to generate reports.  Reporting, however, is _not_ a feature of a 
database *engine*.  In the case of LibreOffice Base, it is a feature of the 
DBMS.

See for example 
<http://help.fabasoftfolio.com/index.php?topic=doc/Configuration-of-Relational-Reporting/example-use-of-libreoffice-base-as-reporting-tool.htm>

First find a (free) report generator that suits your purpose, then find a 
(free) DBMS that supports the (free) database engine that creates databases 
that you can access with your report generator and meet your requirements.


Of the mentioned requirements, I presume MySQL (with InnoDB as engine), 
MariaDB (which is a MySQL fork; replaces InnoDB with XtraDB, and adds Aria 
as engine), and PostgreSQL all can meet them.  I know it for certain for 
MySQL because I have worked with it for 14 years, and the InnoDB engine for 
about 10 years.  The common acronym LAMP (Linux, Apache, MySQL, PHP) also 
suggests that of those, MySQL would have the best support.  I find it very 
easy to set up a LAMP stack on GNU/Linux.

You might like MariaDB better than MySQL because it is less Oracle.  In 
principle, every software that works with MySQL 5.0 should support the 
MariaDB features that both have in common.  But I may not be as easy to set 
up.  (I have not tried yet.)

See <news:comp.databases.mysql> for more on both.

PostgreSQL, by contrast to MySQL and MariaDB, is an Object-Relational 
Database Management System (RDBMS) and might be a bit of an overkill in your 
case.  (I have not worked with it yet so I cannot say more about it.)  See 
<news:comp.databases.postgres> for more.

I am not aware that MySQL or MariaDB have reporting capabilities, however 
there is reporting software that can access databases created with these 
DBMSes.

-- 
PointedEars

Twitter: @PointedEars2
Please do not Cc: me. / Bitte keine Kopien per E-Mail.

Back to comp.databases | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Selecting a database app?? Dave <dboland9@fastmail.fm> - 2014-06-24 10:19 -0400
  Re: Selecting a database app?? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-24 17:11 +0200
    Re: Selecting a database app?? Dave <dboland9@fastmail.fm> - 2014-06-24 11:54 -0400

csiph-web