New version of SQL Agent brings improved listing and fixes MongoDB driver.
Node ORM: SQL Agent 11
New version of SQL Agent brings some improvements and bug fixes.
- Update it via NPM
$ npm install sqlagent
- Documentation: https://github.com/totaljs/node-sqlagent
Improved listing method
I have improved sql.listing()
method for all databases. Now it returns an extended object with new properties: page
, pages
and limit
.
Output:
Inline callback
Inline callback can be defined in SqlBuilder
and it supports only the one callback function. The example below describes the functionality:
MongoDB problems
Each version of MongoDB is a bit different and this is a big problem for long term projects. Therefore I don't recommend to use MongoDB. This version of SQL Agent solves a problem with a new version of MongoDB driver and with storing static files in GridFS. Support Node PostgreSQL it's really good and helpful module.
PostgreSQL improvements
PostgreSQL Native C/C++ bindings
I have improved connection string for PostgreSQL by adding a native
parameter for enabling PostgreSQL native C/C++ bindings which is much faster than classic pure JavaScript implementation.
First install pg-native
:
Connection string:
Usage is absolutely same than you're use with pure JavaScript implementation, so just change your connection string and everything will work like a charm.
Fixed storing files in older PG version
I have fixed storing files in older < 9.3
versions of PostgreSQL. This module stores files in pg_largeobject
collection. Files are stored in chunks and reading/writing is built on Node.js streams.
Good to know
Node.js ORM SQL Agent is a part of Total.js platform. Buy a premium account and support this great JavaScript's platform.
Other posts from Total.js Platform
- 2024-04-19Installing Total.js v5: A Comprehensive Guide
- 2024-04-08How to create REST API using Total.js LessCode
- 2024-04-04Create UI parts visually with the power of Total.js UI Builder
- 2024-04-03Enhance your applications with Total.js v5 proxy functionality
- 2024-04-01March report 2024
- 2024-03-22How to scale your Total.js application with clusterization?
- 2024-03-01February report 2024
- 2024-02-19Building a CRUD API with Total.js: A Step-by-Step Guide
- 2024-02-01January report 2024
- 2024-01-18LessCode app