RailsConf 2019 - Database Design for Beginners by David Copeland

RailsConf 2019 - Database Design for Beginners by David Copeland
_______________________________________________________________________________________________
Cloud 66 - Pain Free Rails Deployments
Cloud 66 for Rails acts like your in-house DevOps team to build, deploy and maintain your Rails applications on any cloud or server.
Get $100 Cloud 66 Free Credits with the code: RailsConf-19
($100 Cloud 66 Free Credits, for the new user only, valid till 31st December 2019)
Link to the website: cloud66.com/ra...
Link to sign up: app.cloud66.co...
_______________________________________________________________________________________________
Rails’ migrations were a revelation when Rails came out, as it provided a way to manage your database schema, but also included many wonderful defaults that made all Rails developers pretty good at database schema design! But these defaults are just the beginning. Properly modeling your database can bring many benefits, such as fewer bugs, more reliable insights about your users or business, and developer understanding. We’ll talk about what makes a good database design by understanding the concept of normalization and why a properly normalized database yields benefits.

[@mbigras]

I've been waiting for this one for years now. Bravo! Crisp and fun, thanks very much!

[@UliTroyo]

Thank you, great talk!

[@faizco-darazshop7923]

This is absolutely great talk.. and that example is brilliant

[@alanlennon3871]

you prolly dont care but does any of you know of a method to log back into an Instagram account..? I was stupid lost my account password. I would appreciate any tips you can offer me.

[@quentinquinn8205]

@Alan Lennon instablaster =)

[@alanlennon3871]

@Quentin Quinn Thanks for your reply. I got to the site thru google and im in the hacking process atm. Seems to take a while so I will get back to you later with my results.

[@alanlennon3871]

@Quentin Quinn it did the trick and I now got access to my account again. Im so happy:D Thank you so much, you saved my ass !

[@quentinquinn8205]

@Alan Lennon Glad I could help =)

[@Andre_XX]

In the real world you will find this is far more difficult than you think. There are many subtleties with data. The same underlying data can be transformed into a different model depending on your point of view. Another complication that is usually poorly modelled is the time dimension. Data is not always static. There are multiple time dimensions. The time something changes in the real world. The time data actually changes in the database. The time data was supposed to change in the database.

[@TheCodeConnoisseur]

Fantastic

[@victormartins-software3912]

Wow, brilliant, thank you 🙏

[@Matheus.Richard]

I would rather provide a default value for the finishing move than adding all those safe operators. Kinda like the NullObject pattern. It seems cleaner to me.

[@JB-im8sg]

I don't see how this represents the null object pattern tbh. If you're just providing a meaningless default value instead of null why can't null just be good enough?

[@Nuatheone]

This talk makes no sense to me... especially for beginners it's over complicated and badly explained. Examples are not well picked and confusing.

[@blackstratmx]

@@Nuatheone I think it isn't for beginners.