kanopo
kanopo
PostsComments
DTDrizzle Team
Created by kanopo on 10/13/2023 in #help
Multi-App Single-Schema
Hi, I was playing around with drizzle for a Proof of Concept exercise where i have api and website that can both interact with postgresql trough drizzle. - There are some example for this use case?
- From a migration stand point is it possible a configuration of this type? - how to migrate only the api or only the website or both of them? Thank you
1 replies
DTDrizzle Team
Created by kanopo on 10/12/2023 in #help
Generate column from another column postgresql
CREATE TABLE IF NOT EXISTS "Organizations" (
  "id" SERIAL,
  "name" VARCHAR(255),
  "lowercaseName" VARCHAR(255) GENERATED ALWAYS AS (LOWER("name")) STORED,
  
  PRIMARY KEY("id"),
  UNIQUE("lowercaseName")
);
CREATE TABLE IF NOT EXISTS "Organizations" (
  "id" SERIAL,
  "name" VARCHAR(255),
  "lowercaseName" VARCHAR(255) GENERATED ALWAYS AS (LOWER("name")) STORED,
  
  PRIMARY KEY("id"),
  UNIQUE("lowercaseName")
);
Hi guys, I've been watching the docs and the discord server for quite some time and I haven't been able to find instructions about this use case using drizzle. Thank you
2 replies