Skip to content
#

PostgreSQL

postgresql logo

PostgreSQL is a database management system that is object-relational. PostgreSQL originated from the Ingres project at the University of California, Berkeley.

Here are 22,085 public repositories matching this topic...

xaragen
xaragen commented Aug 10, 2021

Working on a project I ran into the documentation for customizing the Foreign Key.
The docs read:

// https://sequelize.org/master/manual/assocs.html
// For example, to use UUID as the foreign key data type instead of the default (INTEGER), you can simply do:

const { DataTypes } = require("Sequelize");

Foo.hasOne(Bar, {
  foreignKey: {
    // name: 'myFooId'
    type: D
supabase
Isaiah-Hamilton
Isaiah-Hamilton commented Dec 17, 2021

Feature request

Is your feature request related to a problem? Please describe.

Currently, when clicking the supabase logo in the footer the scrolling is very jagged. The feature is adding smooth scrolling to the land page.

Describe the solution you'd like

Add smooth scrolling.

Describe alternatives you've considered

Let me know if you have any ideas.

Additional c

dbeaver
KOLANICH
KOLANICH commented Jan 11, 2019

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

prisma
binary64
binary64 commented Aug 2, 2021

Bug description

On windows, I run prisma format and note the unusual file ending. The lines are all LF, but the very last line is CRLF.

This causes issue on my Linux CI where it formats it ending in LF's only, causing a diff to occur and the build to fail.

How to reproduce

  1. On windows do prisma format
  2. Open in HxD or similar
  3. See attached:

![image](https://user-images.g

directus
cube.js
leogodin217
leogodin217 commented Sep 17, 2021

Describe the bug
Using a time dimension on a runningTotal measure on Snowflake mixes quoted and unquoted columns in the query. This fails the query, because Snowflake has specific rules about quoted columns. Specifically:

  • All unquoted column names are treated as upper case
  • Quoted column names are case sensitive.

So "date_from" <> date_from

To Reproduce
Steps to reproduce

questdb
ysdede
ysdede commented Dec 16, 2021

Describe the bug

QuestDB throws an error if my query returns 0 rows when using SAMPLE BY. It works fine and responds 0 row found without SAMPLE BY.

My query (I run it on QuestDB web console directly)

SELECT ts, pair, side, round(nsum(size)) as size
FROM liquidations
WHERE pair = 'ETC-USDT-PERP' and side = 'sell' and size > 500
SAMPLE BY 1m
ALIGN TO CALENDAR WITH OFFSET '00:00'

Created by Michael Stonebraker

Released July 8, 1996

Repository
postgres/postgres
Website
www.postgresql.org
Wikipedia
Wikipedia