# Latest

## Latest

This release adds PostgreSQL support for the vRAM service. PostgreSQL is a much better storage medium for this data because the integrity of the vRAM data is validated on chain. Postgres is scalable, has high integrity for not losing data, is easy to setup, and should fix the issues some have been having with lost IPFS data.

Unfortunately, it does not appear that this update will speed up the vRAM fetch/post process, but I'm happy with the integrity and scaling potential. Data is also stored in the IPFS node to still allow p2p sharing via swarm peers and/or the broader IPFS network.

As a DSP operator to use the new PostgreSQL feature, you'll need to first get a list of all accounts staked to the vRAM service for your DSP, you can use dsphq.liquidapps.io for this. Then you can set the following variables in your toml file and restart the DSP to begin replaying. You need to reset allow\_api\_non\_broadcast and postgresql\_force\_replay to false after to avoid security issues, specifically related to CPU drain attacks and to also allow fetching from cache.

## under \[dsp] section

allow\_api\_non\_broadcast = true

## under \[ipfs] section

postgresql = true postgresql\_force\_replay = true

After running setup-dsp you can replay each account by following the directions here: <https://docs.liquidapps.io/liquidapps-documentation/dapp-service-providers/dsps/dsp-maintenance/replay-contract>

#### ​[docs](https://liquidapps.gitbook.io/liquidapps-documentation)​ <a href="#docs" id="docs"></a>

* updated zeus test flags, added --ipfs-postgres flag, PostgreSQL db must be run locally and manually, there is an install script provided to install go 1.19.4
* updated DSP install guide to include section on installing Go dependencies and Go server for handling PostgreSQL data add/get
* updated replay script to include new env var for bypassing DSP cache to force storing new data export IPFS\_POSTGRESQL\_FORCE\_REPLAY=true
* added section to PostgreSQL install instructions for creating blocks table and text\_pattern\_ops index
* added section to PostgreSQL for setting up systemd process for go server process

#### ​[@liquidapps/zeus-cmd](https://www.npmjs.com/package/@liquidapps/zeus-cmd)​ <a href="#liquidapps-zeus-cmd" id="liquidapps-zeus-cmd"></a>

* added flag --ipfs-postgres to allow testing the feature locally, requires setting up your own local PostgreSQL instance configured to postgresql://postgres:password\@localhost:5432/postgres
* add start-localenv step to run 15-ipfs-ds-postgres if above flag set
* added script to install go and dependencies at zeus/boxes/groups/microservices/ipfs-ds-postgres/scripts/install-go.sh

#### ​[@liquidapps/dsp](https://www.npmjs.com/package/@liquidapps/dsp) <a href="#liquidapps-dsp" id="liquidapps-dsp"></a>

* added new params to config.toml postgresql = true to enable feature
* added postgresql\_port = 8090 to set port at which go IPFS PostgreSQL instance is running

#### ​[@liquidapps/dapp-client](https://www.npmjs.com/package/@liquidapps/dapp-client)​ <a href="#liquidapps-dapp-client" id="liquidapps-dapp-client"></a>

#### ​[@liquidapps/box-utils](https://www.npmjs.com/package/@liquidapps/box-utils)​ <a href="#liquidapps-box-utils" id="liquidapps-box-utils"></a>

#### dappservices contract <a href="#dappservices-contract" id="dappservices-contract"></a>

### DSP Services: <a href="#dsp-services" id="dsp-services"></a>

#### ​[LiquidAccount Service](https://docs.liquidapps.io/en/v2.0/services/vaccounts-service.html)​ <a href="#liquidaccount-service" id="liquidaccount-service"></a>

#### ​[LiquidVRAM Service](https://docs.liquidapps.io/en/stable/services/ipfs-service.html)​ <a href="#liquidvram-service" id="liquidvram-service"></a>

#### ​[LiquidStorage Service](https://docs.liquidapps.io/en/stable/services/storage-service.html)​ <a href="#liquidstorage-service" id="liquidstorage-service"></a>

#### ​[LiquidHarmony Service](https://docs.liquidapps.io/en/stable/developers/harmony-getting-started.html)​ <a href="#liquidharmony-service" id="liquidharmony-service"></a>

#### ​[LiquidScheduler Service](https://docs.liquidapps.io/en/stable/developers/cron-getting-started.html) <a href="#liquidscheduler-service" id="liquidscheduler-service"></a>

#### ​[LiquidLink Service](https://app.gitbook.com/o/-MTfRLkrJZvJCeGkkrkU/s/-MTfSc9O76OFJpqcb3QC/~/changes/FA3MW9qK6MUpYFlCBgV9/dapp-network-services/dapp-network-services/liquidlink) <a href="#liquidlink-service" id="liquidlink-service"></a>

#### [LiquidAutb Service](https://github.com/liquidapps-io/zeus-sdk/tree/master/boxes/groups/services/auth-dapp-service) <a href="#liquidlink-service" id="liquidlink-service"></a>

#### Link Library <a href="#link-library" id="link-library"></a>