Issue Description

What was unclear/insufficient/not covered in the documentation

How to update and increment in one single query

If possible: Provide some suggestion on how we can enhance the docs

Add this to the docs.

Additional context

#7268

Issue Template Checklist

When adding a new data store database in Metabase it tries to connect first with SSL (if the driver supports SSL), and then without, in that order. If either connection succeeds, the database details are accepted as valid. Yes, you can add driver specific JDBC options to use SSL, but there is no good feed

Issue type:

[x] question
[ ] bug report
[ ] feature request
[x] documentation issue

Database system/driver:

[ ] cordova
[x] mongodb
[ ] mssql
[ ] mysql / mariadb
[ ] oracle
[ ] postgres
[ ] cockroachdb
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo

TypeORM version:

[x] latest
[ ] @next
[ ] 0.x.x (or put your version here)

@madAndroid was kind enough to provide instructions on how to configure Redash with Auth0/SAML on the forum: https://discuss.redash.io/t/auth0-integration/586/5.

We should port this over to the Knowledge Base (either as a section in the Authentication Options page or a dedicated one).

Environment

• PostgreSQL version: All
• PostgREST+ version: 6.0.2 (713b214)

Current state

Currently, Comment on Table

COMMENT ON SCHEMA todos IS
  'Todos object description';

generate a summary for all operations on this resource

 /todos:
    get:
      tags:
        - todos
      summary: Todos object description
      parameters:

But sum

Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.

Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the

Environment

Knex version: 0.20.10
Database + version: Postgres 12

Bug

1. Explain what kind of behaviour you are getting and how you think it should do

knex.raw("?", [
  knex.insert({ id: "b", fields: { a: undefined } }).into("test"),
])

2. Error message

Hi guys, welcome! 😊

Background

ShardingSphere 5.x will present itself with new valuable features and simple configuration API to our community.

We will provide many of build-in sharding algorithms to users, which means uses can choose a proper one from sharding-algorithm selections before implementing the interface of the sharding algorithm themselves.

**Therefore we call for

I'm submitting a ...

• bug report
• [ X] feature request
• question

PostGraphile version: 4.4.4

postgraphile should honor variables in query string as defined in https://github.com/graphql/express-graphql#http-usage when the query is provided as post body.

with the following exampl

pgcli depends on humanize which is https://github.com/jmoiron/humanize.

The current version has a slightly odd behavior of rounding down unexpectedly:

In [11]: humanize.naturaltime(datetime.timedelta(seconds=120))                                                                         
Out[11]: '2 minutes ago'

In [12]: humanize.naturaltime(datetime.timedelta(seconds=119.9))      

We are suddenly running out of background workers and were told on Slack to increase timescaledb.max_background_workers from 8 to 16.

The documentation makes it seem like the timescaledb-tune tool will automatically set the key to a correct value. However the tool [always sets the value to 8](https://github.com/timescale/timesca

Hello @brianc,

I am working with @pspi on a modification of node-pg-copy-streams (cf brianc/node-pg-copy-streams#91) and it could be an opportunity to improve some things in this module.

Can you share with us your ideas about coding style / dev tooling for the modules related to pg ? Do you have written something on this somewhere ? I think that all these modules

If I were to deploy cube.js using AWS serverless architecture, is athena required?

The docs https://cube.dev/docs/deployment#serverless do not mention whether Athena is optional or required. But when reading it, I assume it is required because there are athena keys in the serverless.yml config. I'm evaluating the idea of using Postgres RDS as the sole datasource for cubejs.

Currently (on 0.9.4) the content of bytea columns is shown as a UTF-8 string in the table view.
It would be nice if these columns could be shown using hex encoding instead.

The encoding can be done in postgres using:

SELECT encode(my_checksum, 'hex') FROM my_table;

Introduction

It seems the API-description for "fetch" does not match the actual behaviour and the changelog information.

Issue Description

In the API description for "fetch"

https://bookshelfjs.org/api.html#Collection-instance-fetch

it reads

If you wish to trigger an error if the fetched collection is empty, pass {require: true} as one of the options to the fetch call

See https://forum.newsblur.com/t/how-to-set-default-full-article-retrieval-in-android-app/7111/4. The most recent comment says that it wasn't discoverable. Let's make it discoverable by adding a preference to turn it off (defaulted to on of course).

Given that we support CURRENT_TIMESTAMP, the lack of CURRENT_DATE feels like an omission. While you can hack it with date(now), I keep finding myself wishing there was a direct way to reference this. Given that now means CURRENT_TIMESTAMP, I think there's precedent for today meaning CURRENT_DATE. This is supported by all backends we support (and is in the ISO standard I believe).

if I understood it corretly from README.MD, we can install like this:

$ git clone https://github.com/donnemartin/dev-setup.git && cd dev-setup
$ ./.dots bootstrap osxprep brew osx

and later when we need datastores, we run

$ cd ~/dev-setup
$ ./.dots datastores

I understand that bootstrap copies the dot files to the home directory, such as .bash_profile and .exports.
but

1、我最近在使用Enterprisedb 10.4，然后参照下面的文章：https://www.enterprisedb.com/docs/en/10.0/Ora_Reference_Guide_v10/Database_Compatibility_for_Oracle_Developers_Reference_Guide.1.035.html

在pg admin里面输入了下面这些代码
CREATE DATABASE LINK chicago
CONNECT TO sue IDENTIFIED BY 'mypassword'
USING oci '//127.0.0.1/acctg';

但是却报了下面这个错，很疑惑，语法都是按照文档上来的，为什么会有这个问题呢
ERROR: syntax error at or near "TO"
SQL state: 4

What went wrong?

I'm getting deprecation warnings with openSSL encryption.

[2019/09/05 08:38:52][info] Using Encryptor::OpenSSL to encrypt the archive.
[2019/09/05 08:40:22][warn] Pipeline STDERR Messages:
[2019/09/05 08:40:22][warn] (Note: may be interleaved if multiple commands returned error messages)
[2019/09/05 08:40:22][warn]
[2019/09/05 08:40:22][warn] *** WARNING : depre

Can this App connect clickhouse database ?

In the documentation for connect() function, parameter server_settings has the following description:

An optional dict of server runtime parameters. Refer to PostgreSQL documentation for a list of supported options.

The link in the description returns erro

The steps described in our README does not work for me: https://github.com/citusdata/citus/blob/master/CONTRIBUTING.md#following-our-coding-conventions

The main problem is that after cloning the tools repo we need to run make install from top level instead of uncrustify because many of the variables are defined at the top level.

https://emotion.sh/

After this change in Material UI: mui-org/material-ui#6115