Difference between revisions of "Database package"

From Octave
Jump to navigation Jump to search
(minor updates)
(fixing a typo)
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This Octave Forge has currently no maintainer and is known to nor well anymore.
+
== Octave Forge ==
  
 +
Official GNU/Octave Forge Database package supports only '''Postgres'''
  
== osdbi ==
+
* https://octave.sourceforge.io/database/index.html
  
<!-- Posted on the mailing list by Stuart Edwards <sedwards2@cinci.rr.com> -->
+
== 3rd Party ==
  
There's another package called osdbi that is released under the BSD license that I was able to make work, but only for sqlite3.
+
On github/gitlab are several open source projects which supports different open source database solutions for GNU/Octave.
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'''
== postgreSQL ==
+
** [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
<!-- Posted on the mailing list by Miguel <nunocavalheiromarques@gmail.com> -->
+
* '''redis'''
 
+
** [https://gitlab.com/markuman/go-redis go-redis] - mex file extension for GNU/Octave to access Redis
After some hours trying to connect to postgresql, I am geting convinced
+
* '''MariaDB''' / MySQL
there is currently no DB connection to postgresql DB from octave. Indeed,
+
** [https://gitlab.com/markuman/mex-mariadb mex-mariadb] - mex file extension for GNU/Octave to access MariaDB
there is a very nice small code for mkoctfile:
 
 
 
  http://dirk.eddelbuettel.com/code/octave-pg/
 
 
 
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?
 
 
 
== Embedded SQL ==
 
 
 
A [https://sourceforge.net/p/octave/feature-requests/30/ feature request] was open on the tracker to include it as a package.
 
 
 
== SQLite ==
 
 
 
* [https://github.com/markuman/go-sqlite go-sqlite] – simple sqlite3 wrapper.
 
* [https://github.com/rmartinjak/mex-sqlite3 mex-sqlite3] – An extension for MATLAB® or GNU/octave to access sqlite3 databases
 
 
 
   
 
 
 
== redis ==
 
 
 
* https://github.com/markuman/go-redis
 

Latest revision as of 09:40, 1 June 2019

Octave Forge[edit]

Official GNU/Octave Forge Database package supports only Postgres

3rd Party[edit]

On github/gitlab are several open source projects which supports different open source database solutions for GNU/Octave.

  • sqlite
    • mex-sqlite3 – An extension for MATLAB® or GNU/octave to access sqlite3 databases
    • octave-sqlite - sqlite3 wrapper as an .oct file for GNU/Octave
  • redis
    • go-redis - mex file extension for GNU/Octave to access Redis
  • MariaDB / MySQL
    • mex-mariadb - mex file extension for GNU/Octave to access MariaDB