SQLite

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day.

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

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

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

On windows do prisma format
Open in HxD or similar
See attached:

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

Preflight Checklist

I have completed all Troubleshooting Steps.
I'm on the latest version of Directus.
There's no other issue that already describes my problem.

Describe the Bug

When sele

This would allow the CLI to try connecting to a different node is the first node goes down.

Hi all. Congrats for the amazing software :)

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

It would be amazing to have the IN operator available in this drop-down list:

Describe the solution you'd like

Have the IN oper

Setup

Setup a project with sqlite using the following up.sql:

create table example (
    id integer not null primary key,
    calculated integer generated always as (id*2)
);

Versions

Rust: 1.56.0 nightly
Diesel: 1.4.7
Database: Sqlite
Operating System Linux

Feature Flags

diesel: sqlite

Problem Description

Sqlite does

No way to override migrations directory for CLI.

Nov	DEC	Jan
	28
2020	2021	2022

SQLite

Here are 7,959 public repositories matching this topic...

typeorm / typeorm

sequelize / sequelize

dbeaver / dbeaver

nocodb / nocodb

prisma / prisma

Bug description

How to reproduce

sqlitebrowser / sqlitebrowser

directus / directus

Preflight Checklist

Describe the Bug

sql-js / sql.js

Tencent / wcdb

rqlite / rqlite

fogleman / Craft

coleifer / peewee

doctrine / dbal

beekeeper-studio / beekeeper-studio

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

Describe the solution you'd like

stephencelis / SQLite.swift

amitshekhariitbhu / Android-Debug-Database

diesel-rs / diesel

Setup

Versions

Feature Flags

Problem Description

golang-migrate / migrate

go-xorm / xorm

bookshelf / bookshelf

simonw / datasette

mattn / go-sqlite3

launchbadge / sqlx

vrana / adminer

groue / GRDB.swift

saulpw / visidata

catfan / Medoo

bolt / bolt

mikro-orm / mikro-orm

benbjohnson / litestream

Related Topics