pg-hstore

pg-hstore

A node package for serializing and deserializing JSON data to hstore format

Install pg-hstore

$ npm install pg-hstore

Usage

stringify

var hstore = require('pg-hstore')();
var source = { foo: "oof", bar: "rab", baz: "zab" };
hstore.stringify(source, function(result) {
  ...
  // result = '"foo"=>"oof", "bar"=>"rab", "baz"=>"zab"'
  ...
});

parse

var hstore = require('pg-hstore')();
var source = '"foo"=>"oof", "bar"=>"rab", "baz"=>"zab"';
hstore.parse(source, function(result) {
  ...
  // result = { foo: "oof", bar: "rab", baz: "zab" } 
  ...
});

Similar packages

Other packages similar to pg-hstore

sequelize

Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite, and Microsoft SQL Server. It supports many features including transactions, relations, and migrations. Unlike pg-hstore, which is focused specifically on hstore serialization and deserialization, Sequelize provides a full ORM solution with broader database interaction capabilities.

pg-promise

pg-promise is a PostgreSQL interface for Node.js that provides a flexible and powerful way to interact with PostgreSQL databases. It supports query building, transactions, and connection management. While pg-promise does not specifically focus on hstore, it can be used in conjunction with pg-hstore to handle hstore data types.