In this post we are trying to come to some conclusions about the different sub-classing options in Django that have been discussed in previous newsletters. Due to the long delay between posts, I have listed the options again below as a reminder. […]
We now make available the fourth episode of the DjangoModelling.com Data Modelling Podcast. This session talks more about connections in data modelling. A new podcast in the series will be released on the first Monday of each month (God willing).
In this post we are looking at the basic performance of the different sub-classing options in Django that have been discussed in previous posts. The three options are listed again below. […]
We now make available the third episode of the DjangoModelling.com Data Modelling Podcast. This session talks about connections in data modelling. A new podcast in the series will be released on the first Monday of each month (God willing).
We now make available the second instalment of the DjangoModelling.com Data Modelling Podcast. This session talks about chickens and eggs in data modelling, and then discusses a simple example of data modelling. A new podcast in the series will be released on the first Monday of each month (God willing).
When modelling data, we often need to distinguish between different types of objects. For example, a mapping application may need to store information about both roads and lakes, or a library catalogue may need to store data about both books and DVDs. With these examples, the objects can be quite diverse and the details stored [...]
We now make available the inaugural DjangoModelling.com Data Modelling Podcast. This session talks about data modelling in the past and our reasons and methods for modelling data now. A new podcast in the series will be released on the first Monday of each month (God willing).
Data modelling is not the only limiter of performance. When I first started working with databases, performance in all aspects of computing was much worse than it is now. However well an expert might craft a query, and however simple the query might be, technical restrictions would always limit the performance to just a few [...]
A very common problem with databases is missing data. Missing data makes searches difficult (or impossible) and statistics unreliable. Two common reasons for this are: Records contain optional fields which have been left empty. Records are completely missing because some of the mandatory information was not available. Since the missing data was in mandatory columns, [...]
In this series of newsletters, we concentrate on data modelling in general and discuss relational databases when we need to consider specific applications. In general, we do not consider the so-called “NoSQL” databases. Relational database management systems lend themselves to the use of fixed schemas and also provide easy type checking. […]