|
|
MySQL, Dates and Time zones, Postgres and MindshareSaturday, May 10 2008 12:27 a.m. A database can’t be all things to everyone. Each one has its sweet spot. MySQL happens to be the Wal-Mart of the database world. A large market sweet spot with lots of really cheap stuff, questionably good for you and serving a basic need. Occasionally, MySQL will let you down with some basic things… like time zones. When you store a date/time, it's often (but not always) important to store the time zone information that came with it. If you think about it, it's not just useful to know it's 1:00pm when you're trying to calculate temporal differences between two dates. You need to know what time zone the date was for. You can just convert the date/time to the local time but then you lose the time zone that was associated with the date originally. A piece of information forever lost! If you always have a time zone associated with a date/time, then importing and calculating dates across multiple time zones is incredibly simple. If not, you have to make assumptions about the time zones that can be confusing and very error prone. But? Does MySQL blend? Dates and time zones that is. MySQL doesn't handle time zones correctly. Not to worry, 3 and half years ago we were promised it was in the plans. [22 Nov 2004 12:05] Sergei Golubchik Yes, we plan to add standard TIMESTAMP WITH TIME ZONE type soon Yet, MySQL 6.0 still does not support it. MySQL seems to be Linux's answer to dBase files with InnoDB added as a retrofix to be ACID compliant. Now, don't get me wrong, dBase has its place. It's actually very fast (when implemented with FoxPro), but it does have its limitations with both scaling and concurrency, as does MySQL. MySQL has improved both with a great implementation of replication and with InnoDB. But it's still not ready for extremely large or complex systems. Oracle is. PostgreSQL is. MSSQL is getting better. Will MySQL get there? A better question is will PostgreSQL get MySQL’s mindshare first and make it all not matter? Where MySQL is undoubtedly #1 is mindshare. With the further corporizatation of the product, will a truly open source database like PostgreSQL take over? It's interesting to note that because of the background of some MySQL users, many don't even see the need for ACID compliance. Other's don't see the need for time zone support in date times. Any most have no need to build super complex system or have the head room to scale to support Skype type database sizes. MySQL is good enough. And isn’t that what matters anyway?
#2
buy cialis online commented, on August 26, 2008 at 10:51 p.m. CT: buy cialis online online
#3
lvxvcy commented, on August 27, 2008 at 1:43 a.m. CT: mUWxJK <a href="http://xdoslgprhxkt.com/">xdoslgprhxkt</a>, [url=http://acgngyonhowk.com/]acgngyonhowk[/url], [link=http://xejjdkinzgzz.com/]xejjdkinzgzz[/link], http://krflnmlzhijz.com/
#4
Gmmowrrz commented, on August 27, 2008 at 8:54 a.m. CT: Jonny was here <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Porntv Free</a> 691870 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Sextv Free</a> 8-DD <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Boob Toob</a> 689701 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Tube8</a> kkgc <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Tuube Porn</a> fle
#5
Aqyezwtc commented, on August 27, 2008 at 8:59 a.m. CT: magic story very thanks <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Xxx Tube</a> =) <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Porntube</a> 683242 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Porn Tube</a> >:-OOO <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Freexxxtube</a> zrjb <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Eskimotube</a> heylx
#6
Hospiodb commented, on August 27, 2008 at 10:26 a.m. CT: Cool site goodluck :) <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Sextv 1</a> 9328 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Porn Tuubes</a> fxnr <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Porntv</a> chas <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Porntv</a> 54578 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Tube 8</a> 965602
#7
Kjxojmul commented, on August 27, 2008 at 10:35 a.m. CT: Very funny pictures <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Hentaitube</a> =-OO <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Gaytube</a> :-)) <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Pornotub
#8
Sqguzmdc commented, on August 27, 2008 at 11:21 a.m. CT: Very Good Site <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Sextv Stream</a> =]] <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Porntv Sex</a> =-]]] <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Sex Tuube</a> 79416 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Hentai Red Toob</a> 282 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Porntv Streams</a> dsxua
#9
Zbvwndkl commented, on August 27, 2008 at 11:33 a.m. CT: It's funny goodluck <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free X Tube</a> 984549 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Zoo Tube</a> 8-) <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Sextube</a> =]]] <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Nude Tube</a> 3883 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Xxxtube</a> :-((
#10
Cvdeojgq commented, on August 27, 2008 at 12:55 p.m. CT: good material thanks <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Sextv</a> rgyf <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Tube1</a> 28441 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Tube1</a> =[[ <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Boobtube</a> kuylng <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Online Porntv</a> %[[[
#11
Hjpqhaqb commented, on August 27, 2008 at 1:13 p.m. CT: Cool site goodluck :) <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Freesextube</a> %-PP <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Redtube</a> =-[ <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Pornotube</a> bnkbeg <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Porntube</a> 8574 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Porn Tube</a> >:-)))
#12
Mucbprom commented, on August 27, 2008 at 1:52 p.m. CT: I love this site <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Streaming Sextv Channels</a> 8-D <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Gratuit Porntv</a> 257041 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Porntv Teen</a> 379473 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Streaming Sextv Channels</a> uddc <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Porntv Flash</a> 5792
#13
Amczfewl commented, on August 27, 2008 at 2:11 p.m. CT: Jonny was here <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Lolitatube</a> 8-) <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Freextube</a> 413787 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Freeeskimotube</a> =( <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Freezootube</a> 208194 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Lesbiantube</a> 0007
#14
Hesybsir commented, on August 27, 2008 at 3:23 p.m. CT: i'm fine good work <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Boob Toob</a> sdhelt <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Playboy Models</a> 005078 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Tube8</a> %DDD <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Gratis Sextv</a> ktft <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Teen Vogue</a> 542
#15
Lbrfjkwy commented, on August 27, 2008 at 4:18 p.m. CT: very best job <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Playboy Models</a> quzey <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Teen Vogue</a> 20947 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Gratuit Porntv</a> gzazs <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">The Toob</a> 454 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Sextv Stream</a> =))
#16
Qhvbmsun commented, on August 27, 2008 at 4:40 p.m. CT: perfect design thanks <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Xtube</a> 990 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Freezootube</a> 8-))) <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Freehentaitube</a> jpq <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Freepornotube</a> 02812 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Freeporntube</a> 440798
#17
Yqkjizmk commented, on August 27, 2008 at 5:47 p.m. CT: Very funny pictures <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Online Porntv</a> 2587 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Zoo Toob</a> hgedz <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Tuube Porn</a> 480 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Playboysex</a> xelt <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Porntv</a> ctucyj
#18
Jwtacmmb commented, on August 27, 2008 at 6:13 p.m. CT: very best job <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Sex Tube</a> %-)) <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Xxxtube</a> =P <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Freesextube</a> 9579 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Zoo Tube</a> tegtbl <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Sextube</a> =-O
#19
Izomcwdy commented, on August 27, 2008 at 6:40 p.m. CT: It's serious <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Teen Vogue</a> 826482 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Animalsextube</a> 8((( <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Red Tuube</a> 61933 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Hot Tub</a> yww <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Porn Tuubes</a> %PPP
#20
Vkurxpuk commented, on August 27, 2008 at 7:07 p.m. CT: Best Site Good Work <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Freeporntube</a> 3068 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Zoo Tube</a> 41567 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Xxx Tube</a> :) <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Xtube</a> 1808 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Adulttube</a> 7897
#21
Sbqhplmx commented, on August 27, 2008 at 8:09 p.m. CT: <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Playboysex</a> dzyoiy <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Red Tuube</a> >:OOO <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Red Tub Video</a> rpud <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Boob Toob</a> 94181 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Comtube</a> hmigxv
#22
Qloawoxg commented, on August 27, 2008 at 8:39 p.m. CT: i'm fine good work <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Fetishtube</a> ysco <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Red Tube</a> :DDD <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Porntube</a> 35941 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Hentaitube</a> iippup <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Pornotube</a> 583
#23
Ogjkfvkp commented, on August 27, 2008 at 9:04 p.m. CT: It's funny goodluck <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Online Porntv</a> 59901 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Tube1</a> 437216 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">You Tube 8tv</a> =-)) <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Tuube Porn</a> 8((( <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Playboy Models</a> %[[[
#24
Ynvzilyb commented, on August 27, 2008 at 9:36 p.m. CT: Punk not dead <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Xxx Tube</a> 19569 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Incesttube</a> 87903 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Pussytube</a> %-PPP <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Pornotube</a> krm <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Hentaitube</a> >:DDD
#25
Fjpfznsn commented, on August 27, 2008 at 10:33 p.m. CT: very best job <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Porntv</a> 9054 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Teen Vogue</a> uauai <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Tuube Porn</a> xfxwjc <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Xxx Vogue </a> xra <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Tuube Porn</a> :-]]
#26
Kqqykgsp commented, on August 27, 2008 at 11:26 p.m. CT: I'm happy very good site <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Sextv</a> %-PPP <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Porntv Sex</a> =[[[ <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Tuube Porn</a> 698 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Porntv Sex</a> cppse <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Playboysex</a> =-[[
#27
Zftqbltn commented, on August 28, 2008 at 12:03 a.m. CT: Excellent work, Nice Design <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Xxxtube</a> vtu <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Porn Tube</a> >:-OO <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Sextube</a> sfehp <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Sex Tube</a> >:( <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Zootube</a> >:-))
#28
Pdyiarcb commented, on August 28, 2008 at 12:57 a.m. CT: good material thanks <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Ustube</a> >:OOO <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Free Stream Sextv</a> qdbv <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Porntv Teen</a> 463194 <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Ustube</a> >:)) <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Hot Tub</a> vmpao
#29
Mekpcbxv commented, on August 28, 2008 at 1:36 a.m. CT: this post is fantastic <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Zoo Tube</a> evct <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Free Eskimotube</a> mhm <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Nudetube</a> 908118 <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Incesttube</a> %-] <a href=" http://www.lastfm.ru/user/Berryzzs/jo... ">Ebonytube</a> 292
#30
Xmidwolo commented, on August 28, 2008 at 1:51 a.m. CT: I love this site <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Gratuit Porntv</a> zxnugs <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Red Toob</a> fkr <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Sextv Online</a> =] <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Gratuit Porntv</a> qnpg <a href=" http://www.lastfm.ru/user/Kimricks/jo... ">Vogue Xxx</a> 9280
#31
vukkwmxbjev commented, on August 28, 2008 at 1:54 a.m. CT: FHzp1j <a href="http://kjlimzxyxhwk.com/">kjlimzxyxhwk</a>, [url=http://ktccvrufhnek.com/]ktccvrufhnek[/url], [link=http://qtbkrfyqulmo.com/]qtbkrfyqulmo[/link], http://sxaqphkrdpnd.com/ Post a comment |
More Blog Entries
|
name commented, on August 26, 2008 at 9:54 p.m. CT:
comment1,