none
NodeJS & PostGreSQL database RRS feed

All replies

  • Hello,

    Thanks for sharing your research to us.

    I think if it is more appropriate to change the topic to be a general discussion.

    And if you encounter any issue during developing, you could post your specific question to this forum.

    Thanks for your understanding.


    <THE CONTENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED>
    Thanks
    MSDN Community Support

    Please remember to "Mark as Answer" the responses that resolved your issue. It is a common way to recognize those who have helped you, and makes it easier for other visitors to find the resolution later.

    Tuesday, September 3, 2013 3:24 AM
    Moderator
  • This question has nothing to do with ADO.NET or any Microsoft technology for that matter.  

    But here's your answer anyway ..

    • 'pg' Node package is stable and used in production databases  - This is all you need to do a simple SQL query in Postgres.

    NodeJS has several well supported ORMs some of which provide access to Postgres. You may need to install an additional postgres package to use them.   

    Here's some popular NodeJS ORMs that support Postgres:

    http://jugglingdb.co/ - Nice simple light weight ORM.  

       - Add  'postgres-adapter' package to your project - depends on the 'jugglingdb' and 'pg' packages (will auto install them).

    http://sequelizejs.com  - Very fully featured but looks like it's more heavy weight with numerous other package dependencies.

        - I suspect not as performant - probably due to use of 'promises' package + other stuff. 

       -  Just add 'sequelize-postgres' package to your project as it depends on 'sequelize' and  'pg'. 

    For any additional NodeJS packages ... just search https://npmjs.org/

    Regards,
    Tony

     

    Saturday, September 28, 2013 6:42 AM
  • I have seen brianc's PG module. But I have been having an issue with Windows 7 - 64 bit, as have other folks. Which is why I started to look here to see if MSFT has been looking at this.

    Issue is still open in GitHub.

    https://github.com/brianc/node-postgres/issues/405


    Dr. YSG

    Sunday, September 29, 2013 11:55 AM
  • So, since I have not getton a fix to the issue, I am looking to see how hard it is to do what BrianC does in PG myself. I am intriguied by his comment in the issue about a no-compile pure NodeJS solution. Sounds like something simple might be done that is more Win7 64 bit friendly (more standard). There are also packages for NodeJS for .NET and perhaps I should really be looking at that and an ADO.NET standards solution.

    So that why I threw this question to t he ADO.NET group. Does that make it clearer?


    Dr. YSG

    Sunday, September 29, 2013 12:13 PM
  • Just got BrianC's Pure NodeJS PostGreSQL to work (and it also handles PostGIS spatial queries). Very clean interface.

    https://github.com/brianc/node-postgres-pure

    I am also using the Edge.js module that is really sweet, that lets one call, run C#, F#, and marshall data between .NET and NodeJS. Very nice work. And Fast.

    http://tjanczuk.github.io/edge/#/


    Dr. YSG

    Wednesday, October 2, 2013 2:17 PM