Databases
StackOverflow2013
Postsdbo
POIs it possible to create a node.js module which uses c libraries for monetdb connection?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIs it possible to create a node.js module which uses c libraries for monetdb connection?
    primarykey
    data
    text
    <p>I am trying to connect <code>monetdb</code> with <code>node.js</code>. I have a simple (20 line) c program which can query <code>moentdb</code> using mapi libraries.</p> <p>Can I use those libraries to build something(module/addon) for <code>node.js</code> which uses these libraries and connect to <code>monetdb</code>?</p> <p>(using odbc is an option but it have its own disadvantages.)</p> <p><strong>Update1 :</strong><br> node-ffi is pretty awesome. I was able to create a fetch table program pretty easily. (I have added my working code for example.)</p> <p>So if I have 3 options<br> 1. ODBC<br> 2. node-ffi<br> 3. a c program to fetch database data and listens to connection from node.js through socket </p> <p>In terms of performance which is better option to implement, if I have little less time to develop a addon for node.js</p> <pre><code>var ffi = require("ffi"); var libmylibrary = ffi.Library('/usr/local/lib/libmapi.so', { "mapi_connect":["int",["string",'int',"string","string","string","string"]], "mapi_query":['int',["int","string"]], "mapi_fetch_row":["int",["int"]], "mapi_fetch_field":["string",["int","int"]] }); var res = libmylibrary.mapi_connect("localhost", 50000,"monetdb", "monetdb", "sql", "demo"); console.log(res); var ret=libmylibrary.mapi_query(res,"select * from table"); while(libmylibrary.mapi_fetch_row(ret)){ console.log(libmylibrary.mapi_fetch_field(ret,0)); console.log(libmylibrary.mapi_fetch_field(ret,1)); } </code></pre> <p><strong>Update 2:</strong><br> Above code is not recommended for production use...it does not use async functionality of node.js so please use it for baby steps</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USGaurav
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POIs it possible to create a node.js module which uses c libraries for monetdb connection?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POIs it possible to create a node.js module which uses c libraries for monetdb connection?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POIs it possible to create a node.js module which uses c libraries for monetdb connection?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COTry taking a look at http://stackoverflow.com/questions/15393039/why-v8-in-node-js-is-faster-than-in-my-native-c-addon. I came across it one day and found it interesting, and it may be of use to you.
      singulars
      1. POIs it possible to create a node.js module which uses c libraries for monetdb connection?
      1. USNick Mitchinson
    2. COIn c++ addon I have looked at github, full code is written with v8/node headers... I am not sure if a library purely written in c can be added to addon.... I see most of the users criticizing node.js for lack of db libs if it can be done then all dbs can be connected through node.js
      singulars
      1. POIs it possible to create a node.js module which uses c libraries for monetdb connection?
      1. USGaurav
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload