relational-database - w3toppers.com

What are the options for storing hierarchical data in a relational database?

My favorite answer is as what the first sentence in this thread suggested. Use an Adjacency List to maintain the hierarchy and use Nested Sets to query the hierarchy. The problem up until now has been that the coversion method from an Adjacecy List to Nested Sets has been frightfully slow because most people use … Read more

SQLite how to refer to column name by a query

I’m guessing from what little you have written that you want a variable list of fields (where the list of fields is retrieved from tableB) to be retrieved from tableA. This isn’t possible directly in SQL. You will need to make 2 calls, the first one to retrieve the list of fields, and the second … Read more