Large amount of data? Use database

If you add data every fifteen seconds or so, please use a database.

Common computer hardware such as 4GB of RAM and common CPUs (general CPUs, not for supercomputing) cannot process the data quickly.

You should use a database if you imagine you will frequently record data until you may have a huge amount of data.

If you expect that you need to enter some data every fifteen seconds, you should consider using a database.

Microsoft Excel and LibreOffice cannot handle a very large amount of data. I am talking about general purpose computing. I just have a common Intel CPU. I just have 4GB of RAM.

If you imagine you will need to save a large amount of data, no office productivity suites can handle this situation.

Only use a database. A database can handle a large amount of data.

Common databases are MySQL and PostgreSQL. If you decide to use either one, it will be tricky to migrate from one to another. Please decide with your wisdom.

In my experience, different versions of MySQL were or are incompatible, meaning that upgrading from one version to another might or may cause data loss. For PostgreSQL, upgrading did not cause any data loss in my case.

C++ error message on Debian Linux: undefined reference to PQfinish

It was hard to use PostgreSQL, in my opinion. Writing with C++, I saw the errors and got rid of the errors:

/path/to/file/code.c:53: undefined reference to `PQfinish'
/tmp/ccblsFot.o: In function `show_binary_results':
/path/to/file/code.c:72: undefined reference to `PQfnumber'
/path/to/file/code.c:73: undefined reference to `PQfnumber'
/path/to/file/code.c:74: undefined reference to `PQfnumber'
/path/to/file/code.c:85: undefined reference to `PQgetvalue'

PostgreSQL update on Debian Linux

PostgreSQL 9.2.4 was released recently. I thought that it was time to update it to apply a security fix. I downloaded the source here: http://www.postgresql.org/ftp/source/

I typed:

userName@debianMachine:~$ su
Password:
root@debianMachine:/path/To/File# tar jxf postgresql-9.2.4.tar.bz2
root@debianMachine:/path/To/File# cd postgresql-9.2.4
root@debianMachine:/path/To/File/postgresql-9.2.4# ls
aclocal.m4  configure      contrib    doc         HISTORY  Makefile    src
config        configure.in  COPYRIGHT  GNUmakefile.in  INSTALL  README