SQL Agent 11

Tue Jan 16 2018 22:38:41 GMT+0100 (Central European Standard Time), Peter Širka

Node ORM: SQL Agent 11

New version of SQL Agent brings some improvements and bug fixes.

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.

sql.listing('users', 'tbl_user');
sql.exec(console.log);

Output:

{
    count: 300,
    items: [....].
    page: 1,
    pages: 10,
    limit: 10
}

Inline callback

Inline callback can be defined in SqlBuilder and it supports only the one callback function. The example below describes the functionality:

sql.listing('tbl_user').make(function(builder) {
    builder.where('age', '>', 18);
    builder.callback(function(err, response) {
        console.log(err, response);
    });
});

sql.update('tbl_user').make(function(builder) {
    builder.where('age', '>', 18);
    builder.inc('countview', 1);
    builder.callback(function(err, response) {
        console.log(err, response);
    });
});


sql.exec();

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:

$ npm install pg pg-native

Connection string:

postgresql://user:password@127.0.0.1/database_name?native=true

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.


Tags

Follow us

Latest blogs
Total.js Code Editor v1
Fri Dec 07 2018 22:55:13 GMT+0100 (Central European Standard Time)
New release: Total.js v3.1
Fri Dec 07 2018 11:41:40 GMT+0100 (Central European Standard Time)
New CDN for Flow + Dashboard + Flowboard
Sun Nov 04 2018 09:05:03 GMT+0100 (Central European Standard Time)
OpenPlatform v3
Mon Oct 15 2018 10:11:07 GMT+0200 (Central European Summer Time)
New Single Page Application template
Fri Oct 12 2018 21:25:34 GMT+0200 (Central European Summer Time)

Latest comments
Nice tip
Mauro Junior
Thu Sep 20 2018 21:41:02 GMT+0200 (Central European Summer Time)
Not only for Total.js. You can communicate with different websocket servers.
Peter Širka
Mon Apr 23 2018 20:08:20 GMT+0200 (Central European Summer Time)
Marko: you need to create a buffer with this codepage and write byte-to-byte string. I recommend ...
Peter Širka
Mon Apr 23 2018 20:06:21 GMT+0200 (Central European Summer Time)
Is WEBSOCKETCLIENT only for internal ws connections between totaljs apps?
Stelios Stephanua
Fri Mar 16 2018 06:04:22 GMT+0100 (Central European Standard Time)
Total.js is amazing! ;)
Leonardo Hessel
Tue Dec 19 2017 19:51:15 GMT+0100 (Central European Standard Time)

Pixabay


Read more

Total.js Code Editor v1

Products: Try our real-time collaboration tool for Total Developers. Code Editor offers great features for development.

Fri Dec 07 2018 22:55:13 GMT+0100 (Central European Standard Time)
New release: Total.js v3.1

News: I have released a new version of Total.js with bug fixes and with small improvements.

Fri Dec 07 2018 11:41:40 GMT+0100 (Central European Standard Time)
New CDN for Flow + Dashboard + Flowboard

News: I have changed CDN for Flow + Dashboard + Flowboard components to KeyCDN.

Sun Nov 04 2018 09:05:03 GMT+0100 (Central European Standard Time)
OpenPlatform v3

News: I have published a new version of OpenPlatform. New, better, faster, more secure and more simpler.

Mon Oct 15 2018 10:11:07 GMT+0200 (Central European Summer Time)
New Single Page Application template

News: I have published free, beautiful and simple Total.js + jComponent SPA template under MIT license.

Fri Oct 12 2018 21:25:34 GMT+0200 (Central European Summer Time)
Flow: How to find a specific component?

Tutorials: This tutorial shows you a quick way how to find a specific component in the Flow designer.

Mon Sep 03 2018 20:21:30 GMT+0200 (Central European Summer Time)1