Pop-Up Thingie

>>> Magnum BBS <<<
  • Home
  • Forum
  • Files
  • Log in

  1. Forum
  2. Usenet
  3. COMP.LANG.MUMPS
  • YottaDB transactions using SQL, Node.js, Python, PHP, Go and Ruby

    From K.S. Bhaskar@21:1/5 to chris....@gmail.com on Mon Mar 15 10:57:24 2021
    On Monday, March 15, 2021 at 1:35:13 PM UTC-4, chris....@gmail.com wrote:
    Over the last few weeks all M/Gateway Developments' language bindings, together with our SQL engine, have been updated to include direct access to database transaction processing functionality.

    All products mentioned here will work with YottaDB and the InterSystems databases (Cache and IRIS). All language bindings offer a choice of high performance in-process access to a locally installed database via the API or to a local or remote database
    via the network.

    SQL: https://github.com/chrisemunt/mgsql
    Node.js: https://github.com/chrisemunt/mg-dbx (https://www.npmjs.com/package/mg-dbx)
    PHP: https://github.com/chrisemunt/mg_php
    Python: https://github.com/chrisemunt/mg_python
    Ruby: https://github.com/chrisemunt/mg_ruby
    Go: https://github.com/chrisemunt/mg_go

    Products listed are, of course, Open Source solutions. Enjoy!

    Excellent news! Congratulations, Chris.

    Regards
    – Bhaskar

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Chris Munt@21:1/5 to All on Mon Mar 15 10:35:12 2021
    Over the last few weeks all M/Gateway Developments' language bindings, together with our SQL engine, have been updated to include direct access to database transaction processing functionality.

    All products mentioned here will work with YottaDB and the InterSystems databases (Cache and IRIS). All language bindings offer a choice of high performance in-process access to a locally installed database via the API or to a local or remote database
    via the network.

    SQL: https://github.com/chrisemunt/mgsql
    Node.js: https://github.com/chrisemunt/mg-dbx (https://www.npmjs.com/package/mg-dbx)
    PHP: https://github.com/chrisemunt/mg_php
    Python: https://github.com/chrisemunt/mg_python
    Ruby: https://github.com/chrisemunt/mg_ruby
    Go: https://github.com/chrisemunt/mg_go

    Products listed are, of course, Open Source solutions. Enjoy!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Antoine Koener@21:1/5 to All on Sat Mar 27 03:31:57 2021
    Le lundi 15 mars 2021 à 18:57:25 UTC+1, K.S. Bhaskar a écrit :
    On Monday, March 15, 2021 at 1:35:13 PM UTC-4, chris....@gmail.com wrote:
    Over the last few weeks all M/Gateway Developments' language bindings, together with our SQL engine, have been updated to include direct access to database transaction processing functionality.

    All products mentioned here will work with YottaDB and the InterSystems databases (Cache and IRIS). All language bindings offer a choice of high performance in-process access to a locally installed database via the API or to a local or remote
    database via the network.

    SQL: https://github.com/chrisemunt/mgsql
    Node.js: https://github.com/chrisemunt/mg-dbx (https://www.npmjs.com/package/mg-dbx)
    PHP: https://github.com/chrisemunt/mg_php
    Python: https://github.com/chrisemunt/mg_python
    Ruby: https://github.com/chrisemunt/mg_ruby
    Go: https://github.com/chrisemunt/mg_go

    Products listed are, of course, Open Source solutions. Enjoy!
    Excellent news! Congratulations, Chris.

    Regards
    – Bhaskar

    Excellent work !

    I have quickly review the mg_python source code and found that "strcpy" is still in use. :-(
    And looked a bit more and see that password or username are passed has is from the python code.

    https://github.com/chrisemunt/mg_python/blob/5e29a542519667a99cf994e0dc19952c089bf6f6/src/mg_python.c#L341
    https://github.com/chrisemunt/mg_python/blob/5e29a542519667a99cf994e0dc19952c089bf6f6/src/mg_dba.h#L1109

    I've stopped there my review because I think that the code may be full of buffer overflows ...

    I would suggest to check other libraries also for same vulnerabilities...

    Anyway this is still excellent contribution to open source community...

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Chris Munt@21:1/5 to Antoine Koener on Wed Apr 7 10:10:22 2021
    On Saturday, March 27, 2021 at 10:31:58 AM UTC, Antoine Koener wrote:
    Le lundi 15 mars 2021 à 18:57:25 UTC+1, K.S. Bhaskar a écrit :
    On Monday, March 15, 2021 at 1:35:13 PM UTC-4, chris....@gmail.com wrote:
    Over the last few weeks all M/Gateway Developments' language bindings, together with our SQL engine, have been updated to include direct access to database transaction processing functionality.

    All products mentioned here will work with YottaDB and the InterSystems databases (Cache and IRIS). All language bindings offer a choice of high performance in-process access to a locally installed database via the API or to a local or remote
    database via the network.

    SQL: https://github.com/chrisemunt/mgsql
    Node.js: https://github.com/chrisemunt/mg-dbx (https://www.npmjs.com/package/mg-dbx)
    PHP: https://github.com/chrisemunt/mg_php
    Python: https://github.com/chrisemunt/mg_python
    Ruby: https://github.com/chrisemunt/mg_ruby
    Go: https://github.com/chrisemunt/mg_go

    Products listed are, of course, Open Source solutions. Enjoy!
    Excellent news! Congratulations, Chris.

    Regards
    – Bhaskar
    Excellent work !

    I have quickly review the mg_python source code and found that "strcpy" is still in use. :-(
    And looked a bit more and see that password or username are passed has is from the python code.

    https://github.com/chrisemunt/mg_python/blob/5e29a542519667a99cf994e0dc19952c089bf6f6/src/mg_python.c#L341
    https://github.com/chrisemunt/mg_python/blob/5e29a542519667a99cf994e0dc19952c089bf6f6/src/mg_dba.h#L1109

    I've stopped there my review because I think that the code may be full of buffer overflows ...

    I would suggest to check other libraries also for same vulnerabilities...

    Anyway this is still excellent contribution to open source community...

    Many thanks for taking a look at mg_python.

    For the benefit of those not familiar with C programming, the use of the C string copy function - strcpy() - does not necessarily mean that the code is probably full of buffer overflows. The risk is not inherent in the use of this function (which,
    incidentally is still part of the standard C library) per se, but in the way it is (mis)used. I appreciate that some software houses mandate that it should not be used but the alternatives come with their own problems. The cold reality is that there is
    no standard replacement for this function - at least not one that's portable. To give some context: a quick scan of the PHP and Apache code base reveals that the developers of these products still use strcpy(), so we're in good company!

    While these mg_* language bindings have only recently been released as Open Source products the core code on which they are built has actually been in production use for around 20 years and, as such, I believe we have already addressed most, if not all,
    buffer overflow scenarios.

    The username/password referred to in the review is related to the use of the API of the InterSystems products. It is up to the Python developers to decide how this password should be protected. mg_python does not involve itself with the security layer -
    this is the responsibility of the developer.

    Of course, should anyone find an actual buffer overrun in mg_python then feel free to identify the problem and submit the fix. This is an Open Source initiative!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • Who's Online

  • Recent Visitors

    • Miguel Fonseca
      Wed Jun 11 20:46:30 2025
      from London via Telnet
    • Plume
      Wed Jun 11 09:17:59 2025
      from Uk via Telnet
    • Bob Worm
      Wed Jun 11 08:48:42 2025
      from Wales, Uk via Telnet
    • Centurion
      Tue Jun 10 22:39:19 2025
      from Berea, Ohio via Telnet
    • Bob Worm
      Tue Jun 10 22:08:07 2025
      from Wales, Uk via Telnet
    • Rick V
      Tue Jun 10 21:42:39 2025
      from Plymouth, Mn via Telnet
    • Bob Worm
      Tue Jun 10 18:05:17 2025
      from Wales, Uk via Telnet
    • Plume
      Tue Jun 10 17:23:42 2025
      from Uk via SSH
  • System Info

    Sysop: Keyop
    Location: Huddersfield, West Yorkshire, UK
    Users: 491
    Nodes: 16 (2 / 14)
    Uptime: 82:29:53
    Calls: 9,679
    Calls today: 3
    Files: 13,722
    Messages: 6,173,296
    Posted today: 3

© >>> Magnum BBS <<<, 2025