Question : I’ve a database system which we want to define tags for many tables into it. For example I’ve […]
Tag: best-practices
Is a surrogate key better than a natural key in this case
Question : I copied this code from here: CREATE TABLE records( email TEXT REFERENCES users(email), lat DECIMAL, lon DECIMAL, depth […]
Efficient way to insert/update/delete table records from complex query in Postgres 9.x
Question : I have this function which returns a set a records and I need to persist those records into […]
A clarification of MERGE best practices
Question : I just wanted to ask a clarification about something on the MSDN from the “Optimizing MERGE Statement Performance” […]
What are the first necessary actions needed to help secure a database’s schema & data? [closed]
Question : As it currently stands, this question is not a good fit for our Q&A format. We expect answers […]
Should database directory and file access be restricted to only the db user?
Question : I don’t know exactly how to word this question and I haven’t been able to find any specifics […]
Attacks on Postgresql listening for requests on ‘localhost’
Question : I am using jboss server for my servlets and the postgresql as the database server, listening on port […]
DB Structure: one table to hold all domain values? [duplicate]
Question : This question already has answers here: Is there a name for this database schema of key values? (5 […]
MySQL: Soft Delete post likes
Question : I have implemented a like/unlike features for posts in one of my projects. The like table is normalized […]
What is more efficient, a where clause or a join with million plus row tables?
Question : We run a website that has 250MM rows in one table and in another table that we join […]