I am writing a forum script using PGSql, and I am new to PGSql.
I am planning on having each thread that is started be a new table in the databae. Is this a bad idea? In the sense that there are potentially an infinite number of tables that will be generated? In other words, is it better to have the "possibly infinitley growing" data structure be a Table or a row?
Thanks
Is it bad to have a growing number of tables for a forum sci
Moderator: General Moderators
Re: Is it bad to have a growing number of tables for a forum sci
Yes, it's a bad idea.swraman wrote:I am writing a forum script using PGSql, and I am new to PGSql.
I am planning on having each thread that is started be a new table in the databae. Is this a bad idea? In the sense that there are potentially an infinite number of tables that will be generated? In other words, is it better to have the "possibly infinitley growing" data structure be a Table or a row?
Thanks
You need several tables - e.g.:
- users;
- forum sections;
- threads;
- posts;
with relations between them.
There are 10 types of people in this world, those who understand binary and those who don't