Mysql(2)
- 1. vs. A presentation by
- 2. contents w is MyS QL? hat where did it com from e ? w is Po s tg re S QL? hat where did it com from e ? My S QL vs. Po s tg re S QL w to get som ant e? A presentation by
- 3. w is M hat ySQL? pr o n o un c e d My S Q L w r it t e n in C a n d C++ t h e pr o d uc t o f MyS QL AB a n o pe n s o ur c e S QL (s t r uc t ur e d q ue r y l a n g ua g e ) d a t a ba s e ma n a g e me n t s ys t e m r e l a t io n a l d a t a ba s e ma n a g e me n t s ys t e m- (Databas e that g ro ups data us ing c o mmo n attribute s fo und in the data s e t re s ulting in c lumps o f o rg anize d data that are e as ie r to unde rs tand ) A presentation by
- 4. where did it com from e ? c r e a t e d by pe o pl e w h o t h o ug ht mS QL l a c ke d f un c t io n a l it y f o un d e d 1 9 9 5 , a c q uir e d by S un Mic r o s ys t e ms in 2 0 0 8 f o r $ 1 B 4 0 0 e mpl o ye e s in 2 5 c o un t r ie s o n e o f t he l a r g e s t o pe n s o ur c e c o mpa n ie s w o r l d w id e us e r ba s e o f o ve r 5 mil l io n MyS QL in s t a l l a t io n s w o r l d w id e o ve r 1 0 mil l io n pr o d uc t do w n l o a d s in 2 0 0 4 A presentation by
- 5. w is PostgresQL? hat a l s o kn o w n a s Po s t GRES pr o n o un c e d po s t g r e s QL o r po s t g r e s po s t g r e S QL r e f e r s t o it s o r ig in s a s po s t -In g r e s A presentation by
- 6. where did it com from e ? e vo l ve d f r o m In g r e s (l a t e r POS TGRES ) pr o j e c t a t UC Be r ke l e y, 1 9 8 6 sponsored by DARPA, National Science Foundation, Arm Research Office, and ESL, y Inc. o r ig in a l l y us e d Po s t QUEL in 1 9 9 4 , An dr e w Yu a n d Jo l l y Che n a d d e d t he POS TGRES S QL in t e r pr e t e r (a ka Po s t g r e s 9 5 ) A presentation by
- 7. vs. A presentation by
- 8. w does it all m hat ean? features features com plex rule sets faster than Po s tg re S QL transactions simpler database design complex database design ability to create basic w site eb use of procedural languages MyS QLs replication is thoroughly on the server tested ability to do nested there no need for cleanups in s subqueries of subselects MyS QL (vacuum s) A presentation by
- 9. w does it all m hat ean? Source: http://articles.techrepublic.com.com/5100-10878_11-1050671.html A presentation by
- 10. w does it all m hat ean? platforms platforms as of version 8, there is native native Window app s W indow support for W s indow s 2000 & XP only language support language support runs stored procedures in has m echanism for server-side m than a dozen ore libraries w C functions ith program ing languages (Java, m pow erful adm and com and-line in m Perl, Python, Ruby, Tcl, C/C++, tools and its ow PL/pgSQL, ODBC, n libraries for accessing MyS QL Perl, Python, Ruby, C, C++, PHP, databases are available in all major Lisp, Schem and Qt (just to e, program ing languages w m ith nam a few e ) language-specific APIs A presentation by
- 11. w does it all m hat ean? when to use when to use for applications that demands the for w applications w eb here performance use of foreign key references and w be an issue. ill transactions. users: Cox Com unications, NASA, m users: Afilias, The American Slashdot, The Associated Press Chem ical Society, BASF licensing licensing Berkeley License, w hich allow for s GNU GPL for GPL projects any use as long as a copy of the requires distribution of app w source ith Berkeley License is included w it ith code Com ercial License for m com ercial projects w you m hen donw to distribute the source code t ant for your app A presentation by
- 12. w does it all m hat ean? resources resources http://w w w .postgresql.org/ http://w w ysql.com w .m / random facts random facts the original logo w an elephant as the dolphin in logo symbolizes sm ashing through a w all; the speed, pow precision, and er, presum ably, the current logo is a good nature of the MyS QL m stream ore -lined and m odern database and com unity m version A presentation by
- 13. w to get som ant e? hello@momentumdesignlab.com 1.866.542.7124 A presentation by