open-index/open-npm huggingface dataset:
npm package: @jsreport/jsreport-mongodb-store
Description: jsreport extension adding support for storing report templates inside mongodb
Author: Jan Blaha
Latest version: 4.2.0

# @jsreport/jsreport-mongodb-store
[![NPM Version](http://img.shields.io/npm/v/@jsreport/jsreport-mongodb-store.svg?style=flat-square)](https://npmjs.com/package/@jsreport/jsreport-mongodb-store)

**[jsreport](http://jsreport.net/) extension adding support for storing templates and reports inside [mongodb](https://www.mongodb.org/).**

## Installation

> npm install @jsreport/jsreport-mongodb-store

Then alter jsreport configuration with:

```js
{
  ....
  "store": {
    "provider": "mongodb",
  },
  "blobStorage": {
    "provider": "mongodb"
  },
  "extensions": {
    "mongodb-store": {
      "address": "127.0.0.1",
      "databaseName" : "std",
      "connectOptions": { /* any custom mongodb connection options can be passed here */ },
      "prefix": "jsreport_" // optional prefix for jsreport collections, defaults to no prefix
    }
  }
}
```

Connection options can be passed as values of `mongodb-store` key in config or as values inside the `connectOptions` key.

Note that both features are optional, you can use mongodb GridFS only for reports storage and fs-store (or any other store) for storing templates, also you can keep using file system storage for reports when required. In this case change `blobStorage` value to `fileSystem`.

You can also pass connection uri like this

```js
"store": {
  "provider": "mongodb"
},
"extensions": {
  "mongodb-store": {
    "uri": "mongodb://db1.example.net,db2.example.net:2500/?replicaSet=test"
  }
}
```

## Changelog

### 4.2.0
- minimum node.js version is now `22.18.0`

### 4.1.0

- optimizations for big workspaces
- create store indexes during schema creation

### 4.0.0

- minimum node.js version is now `18.15.0`
- update `mongodb` client to v6

### 3.2.0

- updated mongodb driver

### 3.1.1

- use matched count instead of the modified count

### 3.1.0

- optimizations regarding profiler persistence

### 3.0.1

don't fail when removing not existing blob

### 3.0.0-beta.1

Adaptations for the v3 APIs
npm package: @jsreport/jsreport-mssql-store
Description: Extension allowing to store template in Microsoft SQL Server
Author: Jan Blaha
Latest version: 4.2.1

# @jsreport/jsreport-mssql-store
[![NPM Version](http://img.shields.io/npm/v/@jsreport/jsreport-mssql-store.svg?style=flat-square)](https://npmjs.com/package/@jsreport/jsreport-mssql-store)

**[jsreport](https://github.com/jsreport/jsreport) template store extension allowing to persist data in [Microsoft SQL Server](https://www.microsoft.com/en/server-cloud/products/sql-server/)**


## Installation

> npm install @jsreport/jsreport-mssql-store

Then alter jsreport configuration
```js
{
	"store": {
		"provider": "mssql"
	},
	"extensions": {
		"mssql-store": {
			"user": "jsreport",
			"password": "password",
			"server": "janblaha-PC\\SQLEXPRESS",
			"database": "jsreport",
			"schema": "mycustomschema",
			"options": {
				/* required for sql azure */
				"encrypt": true,
				/* required for local dev instances */
				"trustServerCertificate": true
			}
		}
	}
}
```

Alternatively you can pass the connection string as uri
```js
"store": {
	"provider": "mssql"
},
"extensions": {
	"mssql-store": {
		"uri": "Server=tcp:jsreport.database.windows.net,1433;Initial Catalog=jsreport;Persist Security Info=False;User ID=myuser;Password=password;MultipleActiveResultSets=False;Encrypt=True;"
	}
}
```

**Make sure your TCP/IP protocol is enabled in the SQL Server Configuration Manager and the SQL Browser service is running.**

After jsreport initializes you should see tables like `jsreport.TemplateType` and others in `jsreport` database.

## Schema changes
If you do changes to the database schema by enabling additional extensions you need to drop the affected tables and let jsreport to reinitialize them.

## Changelog

### 4.2.1
- update deps to fix audit

### 4.2.0
- minimum node.js version is now `22.18.0`

### 4.1.0

- create store indexes during schema creation

### 4.0.0

- minimum node.js version is now `18.15.0`

### 3.1.1

- add support for odata ne operator

### 3.1.0

- Support for complex $filter in count quert. Fix for 3.7.1 profiler

### 3.0.0-beta.1

- Adaptations for the v3 APIs