Storing time-series data, relational or non?
I am creating a system which polls devices for data on varying metrics such as CPU utilisation, disk utilisation, temperature etc. at (probably) … Read more
relational-database
Does the join order matter in SQL?
Disregarding performance, will I get the same result from query A and B below? How about C and D? — A select * … Read more
Laravel – Eloquent “Has”, “With”, “WhereHas” – What do they mean?
I’ve found the concept and meaning behind these methods to be a little confusing, is it possible for somebody to explain to me … Read more
When and why are database joins expensive?
I’m doing some research into databases and I’m looking at some limitations of relational DBs. I’m getting that joins of large tables is … Read more
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Can anyone explain how to implement one-to-one, one-to-many and many-to-many relationships while designing tables with some examples? 4 Answers 4
What is the difference between Views and Materialized Views in Oracle?
What is the difference between Views and Materialized Views in Oracle? 8 Answers 8
What are the options for storing hierarchical data in a relational database?
Good Overviews Generally speaking, you’re making a decision between fast read times (for example, nested set) or fast write times (adjacency list). Usually, … Read more