Looking for advice around extending the database.

magicsponlast year

7

• 

  tyteen4a03last year

  the question is: why do you need to extend the database?

• 

  magicsponlast year

  If i want to use a single database, but only use payloadcms to handle the marketing content

  
  
  

  then custom tables for the saas site of things

  
  
  

  or, do i go all in on payloadcms and use it for everything... marketing content + saas app

  
  
  
• 

  tyteen4a03last year

  it's a separation of concerns issue more than a technology split issue; if hackers take down your entire marketing site, it shouldn't drag down your SaaS app

  
  
  

  if there's no need for your marketing site to talk to the SaaS app they should be developed as two separate apps

• 

  magicsponlast year

  yeah, that's my thinking. so you'd use two databases... one for payload, one for the saas thinger

• 

  tyteen4a03last year

  you can use payload as a backend for both, but they would be separate instances

• 

  magicsponlast year

  👍

• 

  dhan8417last year

  Say I wanted a multi-type search, that gave search results from marketing content and app data... is there a suggested way to have app data in the same database as Payload? I'm thinking different tables in a Postgres database using drizzle. But, how would migrations work?