31 Oct '16, 11pm

Keeping Data Integrity in Check: Conditional Unique Indexes for Soft Delete

Keeping Data Integrity in Check: Conditional Unique Indexes for Soft Delete by Karol Galanciak — Today Soft delete is a pretty common feature in most of the applications. It may increase complexity of the queries, nevertheless, not deleting anything might be a right default as the data might prove to be useful in the future: for restoring if a record was removed by mistake, to derive some conclusions based on statistics and plenty of other purposes. It may seem like it’s a pretty trivial thing: just adding a column like deleted_at and filtering out records that have this value present. But what happens when you need to do some proper uniqueness validation on both model layer and database level? Let’s take a look what kind of problem can easily be overlooked and how it can be solved with a conditional index. Read more

Full article: http://www.rubyflow.com/p/emlwjs-keeping-data-integrity-i...

Tweets

Tesla Model S Owners Share Data Showing Durable Battery Degradation

Tesla Model S Owners Share Data Showing Durable...

hybridcars.com 01 Nov '16, 8pm

Data shared by Model S owners shows battery degradation could stay within the 90 percent mark through 200,000 miles driven...