Question : I have a client/superior who keeps suggesting that I select max(primary_key) when I insert a new row. I […]
Tag: best-practices
Webapp & MySQL: Row Level Security
Question : I am trying to emulate row level security on a webapp I am developing using MySQL. Using this […]
Leaf Joins in Data Warehouse Design
Question : Upon modeling my very first data warehouse model (for historical stock market data), I stumbled across a data […]
(MySQL) user table and profile separate, or same table?
Question : I’m creating a blogging site that anyone can sign up and be an author for. I want each […]
What problems are solved by splitting street addresses into individual columns?
Question : We have a team who designs the tables and relations for software developers. In our organization, they are […]
refreshing 500k rows per day, what primary key to use? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Naming conventions for views and materialized views: “*_v”, “v_*”, “*_mv”, “mv_*” or none? [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
pros/cons of different ways to store whether a record is one of two options?
Question : I am trying to store whether an address is a Work address or a Home address. There will […]
Is it bad practice to launch more than 100 sql statements at once? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
How would I track price items from different stores over time? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]