Editing Database package

Jump to navigation Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
Line 1: Line 1:
== Octave Forge ==
This Octave Forge has currently no maintainer and is known to nor well anymore.


Official GNU/Octave Forge Database package supports only '''Postgres'''


* https://octave.sourceforge.io/database/index.html
== osdbi ==


== 3rd Party ==
<!-- Posted on the mailing list by Stuart Edwards <sedwards2@cinci.rr.com> -->


On github/gitlab are several open source projects which supports different open source database solutions for GNU/Octave.
There's another package called osdbi that is released under the BSD license that I was able to make work, but only for sqlite3.
You can find it here:
http://jriedy.users.sonic.net/cgi/jriedy/cgit/cgit.cgi/osdbi/tree/doc/osdbi.texi
JRiedy the author will answer emails.  I use it on OS X 10.6 and octave 3.4.0.  Also on 10.5.8 but no luck on 10.7


* '''sqlite'''
** [https://github.com/rmartinjak/mex-sqlite3 mex-sqlite3] – An extension for MATLAB® or GNU/octave to access sqlite3 databases
** [https://github.com/Andy1978/octave-sqlite octave-sqlite] - sqlite3 wrapper as an .oct file for GNU/Octave
** [https://gnu-octave.github.io/octave-sqlite/ sqlite] - MATLAB® native sqlite compatible extension for GNU/octave.
* '''redis'''
** [https://gitlab.com/markuman/go-redis go-redis] - mex file extension for GNU/Octave to access Redis
* '''MariaDB''' / MySQL
** [https://gitlab.com/markuman/mex-mariadb mex-mariadb] - mex file extension for GNU/Octave to access MariaDB


==Installation==
== postgreSQL ==
<small>This install guide covers the official (postgres) database package only.</small>


Requires octave struct, libpq-dev, and liboctave-dev. In ubuntu/debian based systems this is handled with
<!-- Posted on the mailing list by Miguel <nunocavalheiromarques@gmail.com> -->
apt install octave-struct libpq-dev liboctave-dev
And if you want postgres
apt install postgresql postgresql-client


Next octave command line:
After some hours trying to connect to postgresql, I am geting convinced
there is currently no DB connection to postgresql DB from octave. Indeed,
there is a very nice small code for mkoctfile:


>> pkg install -forge database
  http://dirk.eddelbuettel.com/code/octave-pg/


Can take a long time on low power devices. Packages are compiled. Monitor process with top.
But,  I found there is no longer a libpq++ in postgresql
(http://blog.gmane.org/gmane.comp.db.postgresql.interfaces/month=20080701)...
Anyone knows if there is a libpqxx interface (I found nothing on google)?
In another approach, maybe "extern C" can be used to reimplement a libpq
(standard C) based oct of Dirk Eddelbuettel's code?


==Usage==
== Embedded SQL ==
Load it before any usage:


>> pkg load database
A [https://sourceforge.net/p/octave/feature-requests/30/ feature request] was open on the tracker to include it as a package.


===Connecting to a Database===
== SQLite ==


The user running octave must have permissions to access the pg db, or you can pass the username and pass via pg_connect. Here is an example where the user has access to pg without passing credentials.
* [https://github.com/markuman/go-sqlite go-sqlite] – simple sqlite3 wrapper.
conn = pq_connect (setdbopts ("dbname", "mydatabase"));
* [https://github.com/rmartinjak/mex-sqlite3 mex-sqlite3] – An extension for MATLAB® or GNU/octave to access sqlite3 databases
Here, you are specifying a key-value pair. So you want to fill in a key (dbname), and that dbname is mydatabase.


Note: If you get an error similar to:
   
<pre>could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
</pre>
Try connecting via the IP/port instead of the unix socket. e.g.
conn = pq_connect (setdbopts ("dbname", "testdatabase", "host", "localhost", "port", "5433", "user", "pguser", "password", "pguserpassword"))
Now, you are ready to read the db:
N = pq_exec_params (conn, "select * from Table1;")
Values are returned in a struct, e.g.:
<pre>
N =


  scalar structure containing the fields:
== redis ==


    data =
* https://github.com/markuman/go-redis
    {
      [1,1] = 3895
      [2,1] = 3942
      [3,1] = 3919
      [4,1] = 3866
      [5,1] = 3923
      [6,1] = 3969
      [1,2] = 1324612180367
      [2,2] = 1324612180369
      [3,2] = 1324612188073
      [4,2] = 1324612190313
      [5,2] = 1324612191841
      [6,2] = 1324612192922
    }
    columns =
    {
      [1,1] = value
      [1,2] = unixtime
    }
    types =
 
      1x2 struct array containing the fields:
 
        name
        is_array
        is_composite
        is_enum
        elements
</pre>
Display specific elements e.g.:
display(N.data)
 
Convert to a format which can be plotted/graphed on an x,y axis:
p = cell2mat (N.data)
 
Graph:
plot (p(:, 2), p(:, 1))
 
==Tips/Tricks==
===Cell2mat: Database Data Types Should be the Same===
Note that you must have all database columns be the same type in order for the values to not get potentially changed when using cell2mat. In the example above, if you have the UnixTime column above be a bigint, and the Value column be an Int, the UnixTime will get truncated. Changing the Value column to a bigint will resolve this.
===Built in Help Documentation===
octave:1> database_doc()
 
==Further Reading==
* https://octave.sourceforge.io/database/index.html
 
[[Category:Octave Forge]]
Please note that all contributions to Octave may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see Octave:Copyrights for details). Do not submit copyrighted work without permission!

To edit this page, please answer the question that appears below (more info):

Cancel Editing help (opens in new window)
Retrieved from "https://wiki.octave.org/Database_package"