<DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Postgres_snippets" name="__https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Postgres_snippets" ADD_DATE="1390282977" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" style="margin-right: 0.5em;"/>SQL</A><a name="__SQL" href="#__SQL" style="margin-left: 0.5em;">&para;</a>

                        <HR>                    </DL><p>

                    <DT><a name="10.9 Mavericks upgrade" href="#10.9 Mavericks upgrade"><H3 ADD_DATE="1390420258">10.9 Mavericks upgrade</H3></a>

                    <DL><p>

                        <DT><a name="whether to upgrade" href="#whether to upgrade"><H3 ADD_DATE="1390420313">whether to upgrade</H3></a>

<DD>conclusion: *don&#39;t*, it breaks existing programs

</DD>

                        <DL><p>

                            <DT><A HREF="http://arstechnica.com/apple/2013/11/after-a-month-of-use-we-dish-out-our-biggest-gripes-with-os-x-mavericks/" name="http://arstechnica.com/apple/2013/11/after-a-month-of-use-we-dish-out-our-biggest-gripes-with-os-x-mavericks/" ADD_DATE="1390420491" ICON_URI="http://static.arstechnica.net/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://static.arstechnica.net/favicon.ico" style="margin-right: 0.5em;"/>After a month of use, we dish out our biggest gripes with OS X Mavericks | Ars Technica</A><a name="After a month of use, we dish out our biggest gripes with OS X Mavericks | Ars Technica" href="#After a month of use, we dish out our biggest gripes with OS X Mavericks | Ars Technica" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: No new software is bug-free, and OS X 10.9 doesn&#39;t buck the trend.

"When Mavericks' new responsive scrolling feature is working as designed, it draws sections of your window that aren't yet on-screen so that they show up more quickly when you scroll down (or up). [...] Unfortunately, the feature seems to have broken scrolling for other programs. I notice the problem most often in Chrome, Outlook 2011, and the Limechat IRC client [...] scrolling at higher speed becomes quite jerky and inconsistent"

"The problem is not an app not making use of a new feature. It is that an OS upgrade is breaking functionality of a perfectly working application."

"more recent MacBook Airs and the Retina MacBook Pros have integrated their power buttons into the keyboard, putting it up in the upper-right corner of the keyboard"

"In Mavericks, pushing that power button automatically puts the computer to sleep, no questions asked. You don't need to push down on the button for any particular length of time, and there's no dialog box to ask you what you wanted to do when you pushed the button (or if you meant to push it at all). And unlike some of our multi-monitor gripes, there's no way to revert the button behavior back to its pre-Mavericks state."

"Mavericks totally loses its mind if a network file share vanishes without being properly unmounted"

                            <DT><A HREF="http://reviews.cnet.com/8301-13727_7-57608663-263/5-things-to-do-before-upgrading-to-os-x-mavericks/" name="http://reviews.cnet.com/8301-13727_7-57608663-263/5-things-to-do-before-upgrading-to-os-x-mavericks/" ADD_DATE="1390421506" ICON_URI="http://reviews.cnet.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://reviews.cnet.com/favicon.ico" style="margin-right: 0.5em;"/>5 things to do before upgrading to OS X Mavericks | MacFixIt - CNET Reviews</A><a name="5 things to do before upgrading to OS X Mavericks | MacFixIt - CNET Reviews" href="#5 things to do before upgrading to OS X Mavericks | MacFixIt - CNET Reviews" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: If you are considering installing OS X Mavericks, think about not only system requirements, but also your current OS configuration and any installed software you use. Read this article by Topher Kessler on CNET.

"All too often, people upgrade their systems only to find that their programs now do not load, or regularly crash, only because they have not been updated" i.e. this means Mavericks will *break* existing programs

"unplug your backups from your system to prevent them from potentially being tampered with during the OS installation"

                            <DT><A HREF="http://www.zdnet.com/30-days-with-os-x-10-9-mavericks-7000023522/" name="http://www.zdnet.com/30-days-with-os-x-10-9-mavericks-7000023522/" ADD_DATE="1390420916" ICON_URI="http://www.zdnet.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.zdnet.com/favicon.ico" style="margin-right: 0.5em;"/>30 days with OS X 10.9 &#39;Mavericks&#39; | ZDNet</A><a name="30 days with OS X 10.9 &#39;Mavericks&#39; | ZDNet" href="#30 days with OS X 10.9 &#39;Mavericks&#39; | ZDNet" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: After 30 days with Apple&#39;s new operating system, I can sum up my experience in three words: It just works.

"the new memory compression feature is helping to make switching between applications smoother, especially system resource heavy Adobe programs such as Photoshop, Lightroom, Premiere Pro and After Effects"

"One of the things that I really like about OS X 10.9 is how it feels in many ways like 10.8."

"Battery life

Much better. I'd say that I'm getting an extra 45 minutes from a charge, which isn't bad at all."

                        </DL><p>

                        <HR>                    </DL><p>

                            <DT><a name="PrioritizeNetworkReachabilityOverSleep" href="#PrioritizeNetworkReachabilityOverSleep"><H3 ADD_DATE="1390361410">PrioritizeNetworkReachabilityOverSleep</H3></a>

                            <DL><p>

                                <DT><A HREF="http://mactips.dwhoard.com/mactips/system/wake-on-demand" name="http://mactips.dwhoard.com/mactips/system/wake-on-demand" ADD_DATE="1390361372" ICON_URI="http://mactips.dwhoard.com/_/rsrc/1286002097600/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://mactips.dwhoard.com/_/rsrc/1286002097600/favicon.ico" style="margin-right: 0.5em;"/>Wake on Demand doesn&#39;t work - mactips - Helpful configuration tips for OS X users</A><a name="Wake on Demand doesn&#39;t work - mactips - Helpful configuration tips for OS X users" href="#Wake on Demand doesn&#39;t work - mactips - Helpful configuration tips for OS X users" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: How can I configure the iMac to wake up when I try to connect to it from another computer?

                            </DL><p>

                            <DT><A HREF="http://support.apple.com/kb/HT3774" name="http://support.apple.com/kb/HT3774" ADD_DATE="1366920260" ICON_URI="http://support.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://support.apple.com/favicon.ico" style="margin-right: 0.5em;"/>About Wake on Demand</A><a name="About Wake on Demand" href="#About Wake on Demand" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: <p>The Wake on Demand feature of Mac OS X v10.6 or later,  lets your Mac continue to share items (such as music, printers, files, or your screen) when it is asleep.</p>

                            <DT><A HREF="http://lifehacker.com/348197/access-your-computer-anytime-and-save-energy-with-wake+on+lan" name="http://lifehacker.com/348197/access-your-computer-anytime-and-save-energy-with-wake+on+lan" ADD_DATE="1366920588" ICON_URI="http://kinja.com/assets/images/logos/favicons/lifehacker.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://kinja.com/assets/images/logos/favicons/lifehacker.ico" style="margin-right: 0.5em;"/>Access Your Computer Anytime and Save Energy with Wake-on-LAN</A><a name="Access Your Computer Anytime and Save Energy with Wake-on-LAN" href="#Access Your Computer Anytime and Save Energy with Wake-on-LAN" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: You want access to your home computer wherever you are, whatever you&#39;re doing, whether that&#39;s via a remote desktop connection, SSH, FTP, web interface, or any other remote access you&#39;ve set up. The catch is, you don&#39;t like throwing money away to an always-on system. Luckily you can have your digital cake and eat it, too, and today I&#39;ll show you how to boot and shut down your system remotely so that it&#39;s ready for you when you need it and it&#39;s not wasting energy when you don&#39;t.