About the problem of DBMS choice & what to do if you have gone the wrong way | Roman Bugaev

Roman Bugaev
Meetup #4

1. Bugaev  Roman About  the  problem  of  DBMS  choice  &  what  to  do   if  you  have  gone  the  wrong  way
2. .NET  web-­‐‑developer
3. SQL or NoSQL, that is the question!
4. Ñ Learning  management  system Ñ SCORM   Ñ 1  million  active  users CyberU
5. Ñ No  transactions Ñ No  relations Ñ No  datatypes  (some) SimpleDB
6. Key  →  ALribute  →  Value select  count(*)  from  cyberu_users  where  RecordType  =  'user'  
7. Prons  &  Cons  
8. Ñ Everything  is  indexed Ñ Distributed Ñ Replicated Ñ Completely  hosted  on  Amazon  system BUT Ñ Latency  specially  if  you’re  not  on  ec2   (even  between  nodes) Ñ Only  strings,  lexicographical  string  only Ñ Huge  amount  of  code  
9. Ñ  If  you  love  writing  code-­‐‑-­‐‑  really,  truly  love  to   write  code-­‐‑-­‐‑  you'ʹll  love  it  enough  to  write  as   liLle  of  it  as  possible.  And  SQL  can  help  you.
10. SQL  is  awesome! -­‐‑  Structured  Query  Language -­‐‑  ACID Atomicity,  Consistency,  Isolation,  Durability -­‐‑  Predictable -­‐‑  Schema -­‐‑  Based  on  rational  algebra -­‐‑  Standardized  
11. No,  really,  it'ʹs  awesome! -­‐‑  Hardened -­‐‑  Free  and  commercial  choices -­‐‑  MySQL,  PostgreSQL,  Oracle,  DB2,  MS   SQL... -­‐‑  Commercial  support -­‐‑  Tooling -­‐‑  Everyone  knows  it -­‐‑  It'ʹs  mature!
13. Sellerhit
14. So... -­‐‑  Some  preLy  big  and  important   problems -­‐‑  And  brightest  engineers  in  the  world -­‐‑  Who  loooove  to  build  stuff
15. Yesterday'ʹs  problem  of   biggest  guys     Is  today'ʹs  problem  of   startup  in  garage    
16. Ñ  What  schema  can  be  fine  for  a  lot  of  product’s   types? E-­‐‑commerce
17. Books
18. Music
19. Jeans
20. Ñ Flexible  (and  sane) Ñ Searchable   Ñ Easy  to  use Ñ Fast MongoDB
21. Ñ Atomic  single  document  writes Ó If  you  need  atomic  writes  across   multi-­‐‑document  –  don’t  use   MongoDB   And  what  about  $$?
22. Ñ Orders,  Inventory  (id,  count)   and  Payment  Transaction  you   can  store  in  SQL Ñ UI  –  MongoDB,  ecomerce  -­‐‑  SQL   Most  boring  SQL  Scheme  ever    
23. Ñ  Double  check  you  choice  of  DBMS  and  tools   Ñ  Do  it  fast Ñ  Check  your  logic   Ñ  Enterprise  design Ñ  Id<User>  !=  Id<Product> Ñ  Unit  tests Ñ  Delete  code   Ñ  Optimize  your  tools Ñ  Be  brave! Data  migrations
24. Use  case  –  first,  DB  –  last   ©  Anonymous  
25. Neo4J  –  Graph  database
26. { Thx!  Q?   Bugaev  Roman,  @rbugaev