Database package: Difference between revisions

From Octave
Jump to navigation Jump to search
(add MySQL/MariaDB)
(restructure database page)
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 ony '''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 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
(seems to have moved to http://lovesgoodfood.com/jason/git/osdbi.git as of 20160527)
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://github.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://github.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/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
 
   
 
== redis ==
 
* https://github.com/markuman/go-redis
 
== MySQL / MariaDB ==
 
* https://github.com/markuman/mex-mariadb

Revision as of 16:29, 28 March 2018

Octave Forge

Official GNU/Octave Forge Database package supports ony Postgres

3rd Party

On github 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