This topic is locked

updating table prefixes throughout the system

2/6/2022 4:03:30 AM
PHPRunner General questions
D
Dynamiccomp author

I was wondering if there might be an easy way to project wide be able to change table prefixes throughout the entire project, without manually having to go through and change the prefixes?
I need to update this project to multiple folders, and I needed a couple of tables available to every project, so I thought the easiest way was to keep everything in the same database.

Any help would be very appreciated.

Sergey Kornilov admin 2/7/2022

This sounds like a bad idea. The typical approach is to have multiple databases. See SaaS application design article.