Preferred database

Which database do you prefer to work with if you have the choice?

  • Total voters
    69
astyle said:
Ummmm... in your post, #1 can be described as a database instance (https://en.wikipedia.org/wiki/Instance_(computer_science)) on a server. Actual tables, and related programs to make use of contents. #2 can be described as a dataset. (https://en.wikipedia.org/wiki/Data_set) These are actual terms with a formal definition.
Click to expand...
Re #1: You can of course say 'database instance', but then you risk that someone might think you mean 'DBMS instance' which is different as it also includes the software needed to manage the database. Besides, my definition is supported by SQL - is that formal enough for you?
SQL: 
CREATE DATABASE foo;
You can then create objects inside foo (tables, views, stored programs, ...) and insert data into the tables. All that is one database. In fact, you often have multiple such databases running on a single DBMS instance. And I believe it's a similar story for noSQL database systems.
Re #2: Agreed, 'data set' is probably a better term for this. Sadly, that doesn't prevent people from using/misusing "database" to describe the same thing, though!
 
dbdemon said:
Re #1: You can of course say 'database instance', but then you risk that someone might think you mean 'DBMS instance' which is different as it also includes the software needed to manage the database. Besides, my definition is supported by SQL - is that formal enough for you?
SQL: 
CREATE DATABASE foo;
You can then create objects inside foo (tables, views, stored programs, ...) and insert data into the tables. All that is one database. In fact, you often have multiple such databases running on a single DBMS instance. And I believe it's a similar story for noSQL database systems.
Click to expand...
With the SQL statement in your post, you create a 'database instance' that is then available to be managed by the DBMS. SQL treats keyword 'DATABASE' as shorthand for 'database instance'. Kind of like telling Kate to create a text file that can then be edited by Kate, nano, or ed.

There's no such thing as 'DBMS instance'. DBMS is the whole package, like databases/mysql57-server that you install to get the ball rolling. I guess you can make a copy of the package for installation, and call that 'DBMS instance', or get a licensed copy of Oracle 11g DBMS on a DVD.

Traditional SQL systems put everything into one package, and may offer an API for other programming languages. NoSQL removes the requirement that everything needs to be part of the same package, allowing you to mix and match components to suit the puzzle at hand. Thanks to that, standards compliance got broken. Useful, out-of-the-box ideas needed a new name, and a new set of standards just to gain traction and credibility. Nothing bad about it, but a formal distinction needed to be made and acknowledged. IPv4 vs IPv6 follows the same pattern - new standards keep coming out as ideas gain traction.

Sometimes, you can understand from context that ppl mean 'dataset' when they say 'database'. 'Database' is kind of an umbrella term that is easier for the public to understand in a casual conversation. But when you're ready to get your hands dirty actually working with a database, it helps to have a decent handle on pretty in-depth knowledge - including making a distinction between different terms. :)
 
First_Law_of_Unix said:
What are some nice open source postgresql database content viewer which displays as charts?
Click to expand...
You can use databases/unixodbc to connect a LibreOffice spreadsheet to a PostgreSQL database, slurp up some data as a table, and then use the said spreadsheet to create charts from the data you slurped up. LibreOffice's Base component is also similarly useful. Once you set up the data pipeline, you can automate it as much as you want.

You can also use graphics/kqtquickcharts in a programming project, but that's more work than the spreadsheet method.
 
astyle said:
You can use databases/unixodbc to connect a LibreOffice spreadsheet to a PostgreSQL database, slurp up some data as a table, and then use the said spreadsheet to create charts from the data you slurped up. LibreOffice's Base component is also similarly useful. Once you set up the data pipeline, you can automate it as much as you want.

You can also use graphics/kqtquickcharts in a programming project, but that's more work than the spreadsheet method.
Click to expand...
Thanks will try this out.
This is great that libreoffice allows native integration to database datasets, would've never thought about it.

Installing pgAdmin4 is more difficult than it should be for installation, gave up on it for FreeBSD 14.2.
So now I'm using pgModeler which is good and installed via pkg, however displaying charts with it is terrible.

I'll try the "unixodbc" and "kqtquickcharts".

Can you provide a simple tutorial how to get this working?

I've reached where libreoffice spreadsheet asks "Name of the ODBC data source", do I need to also configure postgresql to enable ODBC?

Thanks.
 
First_Law_of_Unix said:
Can you provide a simple tutorial how to get this working?
Click to expand...
There should be something that you can find if you google around. Basic idea is that you should have an ODBC connection working first, and then tell the spreadsheet to use that working ODBC connection.

That's why you need databases/unixodbc installed and working. Once it tells you that it's successfully connecting to your PostgreSQL database, then you get to mess around in LibreOffice and use it to connect the spreadsheet.

Obviously, you gotta have a working PostgreSQL server with some databases and data on the other end of that unixodbc connection.
 
Thanks for the reply.

All the tutorials I see uses the linux driver.
Following a tutorial here, trying to make the best out of it with no luck:

I'm getting issues with unixODBC to get setup and connected with the PostgreSQL database:

Confirm and ensure that unixODBC is looking at the correct locations:
odbcinst -j

Has the double forward slashes // in the path DRIVERS............: /usr/local/etc//usr/local/etc/odbcinst.ini indicate that there might be an issue with how the environment variables or paths are being set or concatenated. Not sure how to resolve this...:

Code: 
unixODBC 2.3.12
DRIVERS............: /usr/local/etc//usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /usr/local/etc/odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

Add the PostgreSQL driver:
nano /usr/local/etc/odbcinst.ini

Code: 
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver      = /usr/local/lib/psqlodbcw.so


PostgreSQL data source:
nano /usr/local/etc/odbc.ini

Code: 
[PostgreSQL]
Description = PostgreSQL Data Source
Driver      = PostgreSQL
Servername  = 192.168.1.100
Port        = 5432
Database    = nike_footwear
Username    = admin

Register the driver, get an error:
user@user:/usr/home/user $ odbcinst -i -d -f /usr/local/etc/odbcinst.ini

Code: 
odbcinst: SQLInstallDriverEx failed with Unable to find component name.

Test the ODBC Connection, get an error while doing so:
user@user:/usr/home/user $ isql -v PostgreSQL

Code: 
[IM002][unixODBC][Driver Manager]Data source name not found and no default driver specified
[ISQL]ERROR: Could not SQLConnect

Verify the Paths:
ls -l /usr/local/lib/psqlodbcw.so

Code: 
-rwxr-xr-x  1 root wheel 534160 Aug 11 05:49 /usr/local/lib/psqlodbcw.so

user@user:/usr/home/user $ echo $ODBCINI

Code: 
/usr/local/etc/odbc.ini

user@user:/usr/home/user $ echo $ODBCINSTINI

Code: 
/usr/local/etc/odbcinst.ini

I'm in on FreeBSD 14.2

Thanks.
 
First_Law_of_Unix said:
Thanks for the reply.

All the tutorials I see uses the linux driver.
Following a tutorial here, trying to make the best out of it with no luck:

I'm getting issues with unixODBC to get setup and connected with the PostgreSQL database:

Confirm and ensure that unixODBC is looking at the correct locations:
odbcinst -j

Has the double forward slashes // in the path DRIVERS............: /usr/local/etc//usr/local/etc/odbcinst.ini indicate that there might be an issue with how the environment variables or paths are being set or concatenated. Not sure how to resolve this...:

Code: 
unixODBC 2.3.12
DRIVERS............: /usr/local/etc//usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /usr/local/etc/odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

Add the PostgreSQL driver:
nano /usr/local/etc/odbcinst.ini

Code: 
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver      = /usr/local/lib/psqlodbcw.so


PostgreSQL data source:
nano /usr/local/etc/odbc.ini

Code: 
[PostgreSQL]
Description = PostgreSQL Data Source
Driver      = PostgreSQL
Servername  = 192.168.1.100
Port        = 5432
Database    = nike_footwear
Username    = admin

Register the driver, get an error:
user@user:/usr/home/user $ odbcinst -i -d -f /usr/local/etc/odbcinst.ini

Code: 
odbcinst: SQLInstallDriverEx failed with Unable to find component name.

Test the ODBC Connection, get an error while doing so:
user@user:/usr/home/user $ isql -v PostgreSQL

Code: 
[IM002][unixODBC][Driver Manager]Data source name not found and no default driver specified
[ISQL]ERROR: Could not SQLConnect

Verify the Paths:
ls -l /usr/local/lib/psqlodbcw.so

Code: 
-rwxr-xr-x  1 root wheel 534160 Aug 11 05:49 /usr/local/lib/psqlodbcw.so

user@user:/usr/home/user $ echo $ODBCINI

Code: 
/usr/local/etc/odbc.ini

user@user:/usr/home/user $ echo $ODBCINSTINI

Code: 
/usr/local/etc/odbcinst.ini

I'm in on FreeBSD 14.2

Thanks.
Click to expand...
You're getting somewhere... do you have the PostgreSQL client installed and usable? that should be in ports.

-Start with making sure the PostgreSQL server is up and running and has data.
-Then make sure the PostgreSQL client (from ports or pkg, your choice) can run and get data from that server. Looks like driver alone is not enough. Normally database packages come with a server and client. 'Driver' is something that uses the client anyway to connect to the server.
-Then make sure unixodbc can use that client and tell you the connection is successful.

This is what it takes to be able to use unixodbc anywhere, be it in a spreadsheet or in a programming project.
 
astyle said:
You're getting somewhere... do you have the PostgreSQL client installed and usable? that should be in ports.

-Start with making sure the PostgreSQL server is up and running and has data.
-Then make sure the PostgreSQL client (from ports or pkg, your choice) can run and get data from that server. Looks like driver alone is not enough. Normally database packages come with a server and client. 'Driver' is something that uses the client anyway to connect to the server.
-Then make sure unixodbc can use that client and tell you the connection is successful.

This is what it takes to be able to use unixodbc anywhere, be it in a spreadsheet or in a programming project.
Click to expand...

Thanks for the reply and proper clarification astyle

Both the server and client of PostgreSQL 16 are installed:

root@user:/usr/home/user # pkg info postgresql16-client

Code: 
postgresql16-client-16.4
Name           : postgresql16-client
Version        : 16.4
Installed on   : Sun Aug 25 02:28:49 2024 EDT
Origin         : databases/postgresql16-client
Architecture   : FreeBSD:14:amd64
Prefix         : /usr/local
Categories     : databases
Licenses       : PostgreSQL
Maintainer     : pgsql@FreeBSD.org
WWW            : https://www.postgresql.org/
Comment        : PostgreSQL database (client)
Options        :
DEBUG          : off
DOCS           : on
GSSAPI         : off
LIBEDIT        : off
NLS            : on
OPTIMIZED_CFLAGS: off
PAM            : off
SSL            : on
Shared Libs required:
libreadline.so.8
libintl.so.8
Shared Libs provided:
libpq.so.5
libpgtypes.so.3
libecpg_compat.so.3
libecpg.so.6
Annotations    :
FreeBSD_version: 1400097
build_timestamp: 2024-08-11T01:04:44+0000
built_by       : poudriere-git-3.4.1-30-g79e3edcd
cpe            : cpe:2.3:a:postgresql:postgresql:16.4:::::freebsd14:x64
port_checkout_unclean: no
port_git_hash  : b4e71c8402
ports_top_checkout_unclean: no
ports_top_git_hash: 60a177caf1
repo_type      : binary
repository     : FreeBSD
Flat size      : 15.4MiB
Description    :
PostgreSQL is a sophisticated Object-Relational DBMS, supporting
almost all SQL constructs, including subselects, transactions, and
user-defined types and functions. It is the most advanced open-source
database available anywhere. Commercial Support is also available.


root@user:/usr/home/user # pkg info postgresql16-server

Code: 
postgresql16-server-16.4
Name           : postgresql16-server
Version        : 16.4
Installed on   : Sun Aug 25 02:47:45 2024 EDT
Origin         : databases/postgresql16-server
Architecture   : FreeBSD:14:amd64
Prefix         : /usr/local
Categories     : databases
Licenses       : PostgreSQL
Maintainer     : pgsql@FreeBSD.org
WWW            : https://www.postgresql.org/
Comment        : PostgreSQL is the most advanced open-source database available anywhere
Options        :
DEBUG          : off
DOCS           : on
DTRACE         : off
GSSAPI         : off
LDAP           : off
LLVM           : on
LZ4            : on
NLS            : on
OPTIMIZED_CFLAGS: off
PAM            : off
SSL            : on
TZDATA         : off
XML            : off
ZSTD           : on
Shared Libs required:
libzstd.so.1
libpq.so.5
liblz4.so.1
libintl.so.8
libicuuc.so.74
libicui18n.so.74
libicudata.so.74
libLLVM-15.so
Annotations    :
FreeBSD_version: 1400097
build_timestamp: 2024-08-22T09:43:12+0000
built_by       : poudriere-git-3.4.1-36-ge6fe6143
cpe            : cpe:2.3:a:postgresql:postgresql:16.4:::::freebsd14:x64
port_checkout_unclean: no
port_git_hash  : 357bf9735b
ports_top_checkout_unclean: no
ports_top_git_hash: b3cf46924d
repo_type      : binary
repository     : FreeBSD
Flat size      : 50.8MiB
Description    :
PostgreSQL is a sophisticated Object-Relational DBMS, supporting
almost all SQL constructs, including subselects, transactions, and
user-defined types and functions. It is the most advanced open-source
database available anywhere. Commercial Support is also available.


Ensuring if PostgreSQL server is up and running:
root@user:/usr/home/user # service postgresql status

Code: 
pg_ctl: server is running (PID: 1329)
/usr/local/bin/postgres "-D" "/var/db/postgres/data16"


Use PostgreSQL client to connect to PostgreSQL server and it's database:
user@user:/usr/home/user $ psql -U postgres -d nike_footwear -h localhost

Code: 
psql (16.4)
Type "help" for help.

nike_footwear=#


Check if the PostgreSQL server contains any data:
postgres=# \l

Code: 
                                                     List of databases
     Name      |  Owner   | Encoding | Locale Provider | Collate |  Ctype  | ICU Locale | ICU Rules |   Access privileges
---------------+----------+----------+-----------------+---------+---------+------------+-----------+-----------------------
 nike_footwear | postgres | UTF8     | libc            | C       | C.UTF-8 |            |           |
 postgres      | postgres | UTF8     | libc            | C       | C.UTF-8 |            |           |
 template0     | postgres | UTF8     | libc            | C       | C.UTF-8 |            |           | =c/postgres          +
               |          |          |                 |         |         |            |           | postgres=CTc/postgres
 template1     | postgres | UTF8     | libc            | C       | C.UTF-8 |            |           | =c/postgres          +
               |          |          |                 |         |         |            |           | postgres=CTc/postgres
(4 rows)


After thorough reviewing seems like I needed to add the proper details of the user and password in the odbcinst.ini file.

Now I get no errors and leading to a working unixOBDC functionality:

Code: 
root@user:/usr/home/user # odbcinst -i -d -f /usr/local/etc/odbcinst.ini

odbcinst: Driver installed. Usage count increased to 2.
    Target directory is /usr/local/etc
root@user:/usr/home/user #

I will confirm back more about the actual connectivity of the PostgreSQL database to the LibreOffice spreadsheet after getting some sleep.

Thanks again.
 
Last edited:
First_Law_of_Unix said:
Thanks for the reply and proper clarification astyle

Both the server and client of PostgreSQL 16 are installed:

root@user:/usr/home/user # pkg info postgresql16-client

Code: 
postgresql16-client-16.4
Name           : postgresql16-client
Version        : 16.4
Installed on   : Sun Aug 25 02:28:49 2024 EDT
Origin         : databases/postgresql16-client
Architecture   : FreeBSD:14:amd64
Prefix         : /usr/local
Categories     : databases
Licenses       : PostgreSQL
Maintainer     : pgsql@FreeBSD.org
WWW            : https://www.postgresql.org/
Comment        : PostgreSQL database (client)
Options        :
DEBUG          : off
DOCS           : on
GSSAPI         : off
LIBEDIT        : off
NLS            : on
OPTIMIZED_CFLAGS: off
PAM            : off
SSL            : on
Shared Libs required:
libreadline.so.8
libintl.so.8
Shared Libs provided:
libpq.so.5
libpgtypes.so.3
libecpg_compat.so.3
libecpg.so.6
Annotations    :
FreeBSD_version: 1400097
build_timestamp: 2024-08-11T01:04:44+0000
built_by       : poudriere-git-3.4.1-30-g79e3edcd
cpe            : cpe:2.3:a:postgresql:postgresql:16.4:::::freebsd14:x64
port_checkout_unclean: no
port_git_hash  : b4e71c8402
ports_top_checkout_unclean: no
ports_top_git_hash: 60a177caf1
repo_type      : binary
repository     : FreeBSD
Flat size      : 15.4MiB
Description    :
PostgreSQL is a sophisticated Object-Relational DBMS, supporting
almost all SQL constructs, including subselects, transactions, and
user-defined types and functions. It is the most advanced open-source
database available anywhere. Commercial Support is also available.


root@user:/usr/home/user # pkg info postgresql16-server

Code: 
postgresql16-server-16.4
Name           : postgresql16-server
Version        : 16.4
Installed on   : Sun Aug 25 02:47:45 2024 EDT
Origin         : databases/postgresql16-server
Architecture   : FreeBSD:14:amd64
Prefix         : /usr/local
Categories     : databases
Licenses       : PostgreSQL
Maintainer     : pgsql@FreeBSD.org
WWW            : https://www.postgresql.org/
Comment        : PostgreSQL is the most advanced open-source database available anywhere
Options        :
DEBUG          : off
DOCS           : on
DTRACE         : off
GSSAPI         : off
LDAP           : off
LLVM           : on
LZ4            : on
NLS            : on
OPTIMIZED_CFLAGS: off
PAM            : off
SSL            : on
TZDATA         : off
XML            : off
ZSTD           : on
Shared Libs required:
libzstd.so.1
libpq.so.5
liblz4.so.1
libintl.so.8
libicuuc.so.74
libicui18n.so.74
libicudata.so.74
libLLVM-15.so
Annotations    :
FreeBSD_version: 1400097
build_timestamp: 2024-08-22T09:43:12+0000
built_by       : poudriere-git-3.4.1-36-ge6fe6143
cpe            : cpe:2.3:a:postgresql:postgresql:16.4:::::freebsd14:x64
port_checkout_unclean: no
port_git_hash  : 357bf9735b
ports_top_checkout_unclean: no
ports_top_git_hash: b3cf46924d
repo_type      : binary
repository     : FreeBSD
Flat size      : 50.8MiB
Description    :
PostgreSQL is a sophisticated Object-Relational DBMS, supporting
almost all SQL constructs, including subselects, transactions, and
user-defined types and functions. It is the most advanced open-source
database available anywhere. Commercial Support is also available.


Ensuring if PostgreSQL server is up and running:
root@user:/usr/home/user # service postgresql status

Code: 
pg_ctl: server is running (PID: 1329)
/usr/local/bin/postgres "-D" "/var/db/postgres/data16"


Use PostgreSQL client to connect to PostgreSQL server and it's database:
user@user:/usr/home/user $ psql -U postgres -d nike_footwear -h localhost

Code: 
psql (16.4)
Type "help" for help.

nike_footwear=#


Check if the PostgreSQL server contains any data:
postgres=# \l

Code: 
                                                     List of databases
     Name      |  Owner   | Encoding | Locale Provider | Collate |  Ctype  | ICU Locale | ICU Rules |   Access privileges 
---------------+----------+----------+-----------------+---------+---------+------------+-----------+-----------------------
 nike_footwear | postgres | UTF8     | libc            | C       | C.UTF-8 |            |           |
 postgres      | postgres | UTF8     | libc            | C       | C.UTF-8 |            |           |
 template0     | postgres | UTF8     | libc            | C       | C.UTF-8 |            |           | =c/postgres          +
               |          |          |                 |         |         |            |           | postgres=CTc/postgres
 template1     | postgres | UTF8     | libc            | C       | C.UTF-8 |            |           | =c/postgres          +
               |          |          |                 |         |         |            |           | postgres=CTc/postgres
(4 rows)


After thorough reviewing seems like I needed to add the proper details of the user and password in the odbcinst.ini file.

Now I get no errors and leading to a working unixOBDC functionality:

Code: 
user@user:/usr/home/user $ odbcinst -i -s -f /usr/local/etc/odbcinst.ini
user@user:/usr/home/user $

I will confirm back more about the actual connectivity of the PostgreSQL database to the LibreOffice spreadsheet after getting some sleep.

Thanks again.
Click to expand...
What is in your odbcinst.ini ?
 
Got it working.

Jeeze, this database OBDC stuff is way more complicated than I expected it to be, and oddly enough, I previously knew it would be darn complicated.
OBDC is extremely finicky, every parameter must be perfect, every parameter changed requires a reinstallation of the initialization file and what makes it complicated is the fact that parameters are like in 5 different locations which needs to be checked upon. This is no good, would need to create some custom software to avoid this complexity. No tutorials or resources on how to get it working on FreeBSD is what kills me, thanks to FreeBSD forum, googling and GPT4o magic gets the trick done. Was a great learning experience on how to setup OBDC the old-school way, I can now simply download and install open source unixOBDC and get things rolling however I wish, this freedom is the beauty in the fruits of our labor.

Seems like I'm able to have the unixOBDC to install the driver (odbcinst.ini) and source (odbc.ini) initialization files as root user.
root@user:/usr/home/user # odbcinst -i -d -f /usr/local/etc/odbcinst.ini
Code: 
odbcinst: Driver installed. Usage count increased to 2.
    Target directory is /usr/local/etc

root@user:/usr/home/user # odbcinst -i -s -f /usr/local/etc/odbc.ini
Code: 
root@user:/usr/home/user #

Is it normal when installing the source file like the above, for it to not return any sort of acknowledgment?

The .ini file contents:

/usr/local/etc/odbcinst.ini
Code: 
[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/local/lib/psqlodbcw.so

/usr/local/etc/odbc.ini
Code: 
Description         = Test to Postgres
Driver              = /usr/local/lib/psqlodbcw.so
Trace               = Yes
TraceFile           = /tmp/sql.log
Database            = nike_footwear
Servername          = 192.168.1.100
UserName            = postgres
Port                = 5432
Protocol            = 6.4
ReadOnly            = No
RowVersioning       = No
ShowSystemTables    = No
ShowOidColumn       = No
FakeOidIndex        = No

So here is what I've found which worked for me:

Login as root.

Set permissions:
chmod 644 /usr/local/etc/odbcinst.ini
chmod 644 /usr/local/etc/odbc.ini



Set Environment Variables:
setenv ODBCINI /usr/local/etc/odbc.ini
setenv ODBCINSTINI /usr/local/etc/odbcinst.ini



Verify Environment Variables:
echo $ODBCINI
echo $ODBCINSTINI


Now, here is the most crucial part, which took me days to figure out:
After setting the permissions and environment variables of the .ini files, open a new terminal and only then install the initialization files using odbcinst as root.

Since I'm creating a prototype database and would like no password at this stage, I would also need to update the pg_hba.conf file:
nano /var/db/postgres/data16/pg_hba.conf

Add the following texts and save:
Code: 
host    nike_footwear    postgres    192.168.1.100/32    trust

Now need to restart postgres:
service postgresql restart

Now lets connect to the PostgreSQL database using the isql utility provided by UnixODBC to see if ODBC works:
isql -v PostgreSQL

Code: 
root@user:/usr/home/user # isql -v PostgreSQL
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| echo [string]                         |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

Thanks everyone for your great help, much obliged, now I still haven't got it connected to LibreOffice Spreadsheet yet... will try to get that figured out now.
 
First_Law_of_Unix said:
OBDC is extremely finicky, every parameter must be perfect, every parameter changed requires a reinstallation of the initialization file and what makes it complicated
Click to expand...
Hmmm, seems it was like that last time I looked, 10 years ago, and 20 years ago, and 30 years ago ... every time I found a different approach to avoid the pain! And each vendor has different implementations etc.

Sounds like you've persisted and got it working - hope it stays that way!
 
Actually these steps (using ODBC) are the same even on Windows. Even if there is a Windows utility to automate a lot of Excel tasks for creating a graph, connecting to a data source correctly is still the same process as what was outlined in this thread.
 
Got LibreOffice Spreadsheet connected to the PostgresSQL database via unixOBDC. astyle thank you for this great recommendation.

Would make a tutorial possibly might help any FreeBSD 14 users.
I need to figure out how to make the chart background color grey to prevent my eyes from burning.

I can finally view the data in proper order (ascending list):

Screenshot_20240906_192918.png


Screenshot_20240906_192645_.png
 
You must log in or register to reply here.
Back
Top