Best Practices for Managing Database Modifications: Single vs. Separate Databases

I am developing a platform where businesses can register and manage their data through forms, allowing them to interact without the need to register directly with Coda. Currently, all operations such as registrations, modifications, and deletions are handled within a single database, which automatically generates personalized pre-filled links for modifications based on a unique business ID created during the initial registration. When businesses use the modification or deletion form (which is just a different view/layout of the same table), modifications are made by filling the BusinessID into a CorrectionID field, which is usually empty. Then, an automation for modification checks for existing entries with the CorrectionID matching the BusinessID when editing or deleting entries. (the modification automation finds the original registration entry, updates all columnvalues and then deletes the databas entry from the modification form (which got a seperate Business ID - as it’s an entry in the same database)

I am contemplating whether to keep everything in one database or to split the registration and modification/deletion processes into two separate databases. The new setup would involve checking for matching IDs across databases to synchronize changes.

I’m seeking advice on which approach might be faster, simpler, more efficient, and less prone to errors. Is it better to manage all operations within a single database or to use separate databases for different types of transactions? What would you suggest to do?

The amount of regstration data is manageable - 200-300 business regstrations maximum.

Thank you so much for your opinion!

1 Like

Hey @Huber_Stefan_Werner , thanks for reaching out! For building help, our Experts Directory is the best resource for that. Our experts can be found here!: Hire a Coda expert, connect with a Coda expert - Coda

If you are looking for general Coda training, we host live weekly demos that I’d love to invite you to. You can reserve your spot here!

In addition, as you start to get more familiar with Coda, below are some resources you’ll find helpful:

  1. Coda Courses for video courses to build along with our experts
  2. Coda Guides for a library of guides to level up your Coda docs and skills
  3. The Gallery tab for inspiration and templates

Please let me know if there’s anything I can do to support you during your Coda journey!

Happy building!