joabj writes: For years, PostgreSQL users would ask when their favorite open source database system would get the UPSERT operator, which can either insert an entry or update it if a previous version already existed. Other RDMS have long offered this feature. Bruce Momjian, one of the chief contributors to PostgreSQL, admits to being embarrassed that it wasn't supported. Well, PostgreSQL 9.5, now generally available, finally offers a version of UPSERT and users may be glad the dev team took their time with it. Implementations of UPSERT on other database systems were "handled very badly," sometimes leading to unexpected error messages Momjian said. Turns out it is very difficult to implement on multi-user systems. "What is nice about our implementation is that it never generates an unexpected error. You can have multiple people doing this, and there is very little performance impact," Momjian said. Because it can work on multiple tables at once, it can even be used to merge one table into another.

prisoninmate writes: January 10, 2016, will enter in the Linux history books as the day when the Linux kernel 4.4 LTS (Long-Term Support) has been officially released by Linus Torvalds and his team of hard working kernel developers. Prominent features of Linux kernel 4.4 LTS include 3D support in the virtual GPU driver, allowing for 3D hardware-accelerated graphics in virtualization guests, a leaner and faster loop device that supports Asynchronous I/O and Direct I/O, thus increasing the system's performance and saving memory, and support for Open-Channel Solid State Drives (SSDs) through LightNVM. Phoronix also took a look during the newest kernel's development cycle, and has an overview of 4.4's new features.

Jalopnik reports that Elon Musk's predicted window for being able (for Tesla owners, that is) to call up your autonomous car and have it find its own way from New York to California, or vice versa, is astonishingly close: 24-36 months from now. From the article: As far as the summoning feature is concerned, Tesla plans for the 33-foot range to greatly expand—soon. Within two years, Musk predicted that owners will be able to summon their car from across the country. “If you’re in New York and your car is in Los Angeles, you can summon your car to you from your phone and tell the car to find you,” Musk said. “It’ll automatically charge itself along the journey. I might be slightly optimistic about that, but not significantly optimistic.” In getting from one place to another, Musk said autopilot “is better than human in highway driving, or at least it will be soon with machine learning.” If it’s not already better than human, Musk said it will be within the coming months. But right now, Musk said the car still needs a human around, just in case. “The car currently has sensors to achieve that cross-country goal,” Musk said. “But you’d need more hardware and software, you’d need more cameras, more radars, redundant electronics, redundant power buses and that sort of thing.

MojoKid writes: Solid State Drive technology continues to make strides in performance, reliability and cost. At the CES 2016 show there were a number of storage manufacturers on hand showing off their latest grear, though not many made quite the splash that Toshiba's OCZ Technology group made with the annoucement of their new RevoDrive 400 NVMe PCI Express SSD. OCZ is tapping on Toshiba's NVMe controller technology to deliver serious bandwidth in this consumer-targeted M.2 gumstick style drive that also comes with a X4 PCI Express card adapater. The drive boasts specs conservatively at 2.4GB/sec for reads and 1.6GB/sec for writes in peak sequential transfer bandwidth. IOPs are rated at 210K and 140K for writes respectively. In the demo ATTO test they were running, the RevoDrive 400 actually peaks at 2.69GB/sec for reads and also hits every bit of that 1.6GB/sec write spec for large sequential transfers.

An anonymous reader writes with a link to this article at Boy Genius Report about a software upgrade now hitting Tesla owners, which begins: Tesla earlier today began pushing out version 7.1 of its software to Model S and Model X owners and, suffice it to say, it's a doozy of a software update. While we'll get to the full changelog shortly, we first wanted to highlight a feature called Summon which enables users to park their cars without having to be inside it. Conversely, it also lets Tesla owners summon their cars that already happen to be parked.

prisoninmate writes: Oracle's Unbreakable Enterprise Kernel (UEK) Release 4 is an important engineering effort and introduces performance improvements and enhancements for some of the most essential components, including CPU schedulers and Automatic NUMA Balancing, along with powerful new features, such as real-time kernel patching, which is possible thanks to the Ksplice open-source extension of the Linux kernel 4 branch, which lets users to apply patches to the running kernel without the need to reboot the system, thus improving security and simplify the management of cloud infrastructures.

MojoKid writes: Intel is taking another stab at the PC-in-your-pocket form factor with their next gen Compute Sticks. These over-sized thumbstick devices plug into the HDMI port of any TV or monitor and offer a full-fledged computing experience and Intel has now made them faster and more capable. New for 2016, there are three new base model Compute Sticks to choose from. The first is an entry-level option running a quad-core Atom x5-z8400 quad-core processor clocked at 1.44GHz to 2.24GHz with 2GB of RAM, 32GB of eMMC storage, a pair of USB ports, 802.11ac Wi-Fi, and Windows 10. But perhaps more interesting are the new 6th Generation Intel Core M models. The higher end of the two is powered by a Skylake Core m5-6Y57 vPro processor while the lower end version is equipped with a Core m3-6Y30. Both models boast 4GB of DDR3-1866 RAM, 64GB of eMMC storage expandable via microSD card slot, 802.11ac Wi-Fi, and three USB 3.0 ports (one on the Compute Stick and two on the power adapter). Without an OS, the Core m3 model runs $300; Windows 10 adds $100 to the price tag. The Core m5 Compute Stick will run $500 and, at least for now, doesn't appear to offer a version with Windows 10 pre-installed. The new Compute Sticks will be available in February.

iamvego writes: Later than the typical release cadence, PostgreSQL 9.5 has finally been released, and brings with it a slew of new features including UPSERT functionality, row-level security, and some big data features (CUBE/ROLLUP, join pushdown for foreign data wrappers, TABLESAMPLE, BRIN indexing and more). The previous release had brought about some new JSON functions and operators, but they only queried the data; 9.5 comes with new operators which now allow modification of JSON values, so it no longer has to be manipulated outside of the database. PostgreSQL's wiki has a more detailed overview of the new features.

An anonymous reader writes: A $5 million lawsuit filed in New York federal court alleges that Apple's iOS 9 mobile operating software significantly slows down the iPhone 4S. According to the complaint: "The update significantly slowed down their iPhones and interfered with the normal usage of the device, leaving Plaintiff with a difficult choice: use a slow and buggy device that disrupts everyday life or spend hundreds of dollars to buy a new phone. Apple explicitly represented to the public that iOS 9 is compatible with and supports the iPhone 4S. And Apple failed to warn iPhone 4S owners that the update may or will interfere with the device's performance."

An anonymous reader writes: FCC filings published today are offering a glimpse of the "Enterprise Edition" of Google Glass. According to Engadget: "...The work-focused eyepiece touts a much slicker (and likely more durable) design with both a larger display prism and a hinge that lets you fold it up for travel. The test photos also reveal a spot for a magnetic battery attachment and what looks to be a speedier Atom processor. There's still no word on when Google will announce this headset, although the FCC presence hints that it might not take long."

MojoKid writes: We all know what Microsoft wants to do with Windows 10. It's supposedly the last monolithic release of Windows and the ultimate plan is to unite hardware from different device categories under a single, universal ecosystem. That includes smartphones, which is an area where Microsoft has historically struggled hard to compete. The release of a premium "Surface Phone" of some sort, however, could prove to be a game changer. Microsoft is aggressively pushing Windows 10 upgrades, and makes no bones about it, all in an effort to get developers on board to build universal Windows 10 cross-platform apps and spur mobile development. In that respect, Microsoft needs to finally make an impact in the handset space and Windows 10 Mobile is the company's one shot to do just that. And it appears that Microsoft is working on what could be essentially a true Surface Phone, or at least something very similar. In a recent interview, Mary Jo Foley pushed Microsoft's Chief Marketing Officer Chris Capossela on the prospect of a Surface Phone and he confirmed the company is working on a "breakthrough" phone that is the "spiritual equivalent" of their very successful line of Surface branded products. Capossela has been with Microsoft for over two decades. He used to write speeches for Bill Gates and is intimately familiar with Microsoft's many products and strategies.

Earlier this month, we noted the Perl 6 advent calendar. Now, an anonymous reader writes to note that, right on schedule, and after 15 years of work, Perl 6 has been released. The top two bullet points in the linked description say that the newest Perl "retains the core values of Perl: expressiveness, getting the job done, taking influences from natural language, and pushing the boundaries of language design," and that is "has clean, modern syntax, rooted in familiar constructs but revisiting and revising the things that needed it." However, while it's nice to see Perl 6 reach official release, the team behind it takes pains to note that work goes on: "We will continue to ship monthly releases, which will continue to improve performance and our user’s experience." Further, "[T]his Rakudo release is not considered the primary deliverable for this Christmas; it is the language specification, known as “roast” (Repository Of All Spec Tests), that is considered the primary deliverable."

An anonymous reader writes: The Payment Card Industry Security Standards Council (PCI SSC) has announced (PDF) that it will push back the mandatory implementation of TLS 1.1+ encryption, over the very insecure SSL 3.0 and TLS 1.0 protocols, subject to POODLE attacks. PCI SSC cites "complications" that may come from dealing with EMV chip&PIN cards in the US, the new mobile payment platforms, and browser upgrades for the insecure SHA-1 algorithm.

An anonymous reader writes: Wine 1.8.0 is now the latest stable release of Wine Is Not An Emulator and available from WineHQ.org. Wine 1.8 features include support for DirectWrite, Direct2D support, very limited Direct3D 11 support, simple application support of DIrect3D 10, support for process jobs, 64-bit architecture support on OS X, networking updates, and over 13,000 other individual changes.

An anonymous reader with news of the newest release of open source WordPress, which adds a slew of new features to the blog management tool that will "make your site more connected and responsive." You can download the new release now from WordPress.org/Download (7.3MB). WordPress is a content management system (CMS) that powers 25 percent of the Web. The latest version is dubbed "Clifford" in honor of jazz trumpeter Clifford Brown.

linuxscreenshot writes: Just in time for the holidays, it's a new release of elementary OS. Freya 0.3.2 is a minor release, mostly focused around solving some issues folks have had with UEFI & SecureBoot, but we've also managed to sneak in some internationalization updates and a couple new features. Screenshots are available.

MojoKid writes: AMD's Radeon Technologies Group has announced a couple of new features for Radeon graphics support in 2016. FreeSync over HDMI support will be coming to all Radeons that currently support FreeSync. FreeSync over HDMI, however, will require new displays. The HDMI specification doesn't currently have support for variable refresh rates, but it does allow for vendor specific extensions. Radeon Technologies Group is using these vendor specific extensions to enable the technology. A number of FreeSync over HDMI compatible displays are slated to arrive early next year from brands including LG, Acer, and Samsung. The first notebook with FreeSync has also launched. Lenovo's Y700 gaming notebook is the first with a validated, FreeSync-compatible panel. The Radeon Technologies Group also announced that support for DisplayPort 1.3, HDMI 2.0a and HDR displays was coming in the 2016 pipeline as well. With current 8-bit panels, the range of colors, contrast, and brightness presented to users is only a fraction of what the human eye can see. When source material is properly mapped to an HDR panel, colors are more accurately displayed representing more closely what the human eye would see in the real world.

LichtSpektren writes: After previously apologizing on October 16th for forcing Windows 10 on some users of Windows 7 and 8.1 via the Windows Update mechanism, Microsoft disabled the default update option for Windows 10, so that users eligible for the new OS would have to opt in manually. Gregg Keizer at ComputerWorld reports today that Microsoft will soon switch the default option back to "on" again, possibly as early as tomorrow's "Patch Tuesday" update. Users who do not want Windows 10 are strongly advised to turn off automatic updating to avoid accidentally installing the OS.

itwbennett writes: The OpenSSL Software Foundation has released new patches for the popular open-source cryptographic library, but for two of its older branches, OpenSSL 1.0.0t and 0.9.8zh, they will likely be the last security updates because support for these these two branches will end on Dec. 31. Previous research has shown that many companies using in-house built software keep poor records of which library versions their developers used in which of their applications. 'This makes it very likely that some systems and applications with OpenSSL 0.9.8 and 1.0.0 will never be updated, leaving them exposed to any critical vulnerabilities found in the library in the future,' writes Lucian Constantin.

An anonymous reader writes: A "useful and usable distribution of Perl 6" was released Saturday, a new beta version of the Rakudo compiler to support the coming production release this Christmas. And there's already 467 Perl 6 modules on the new archive at proto.perl6.org (though Perl 6 will also be able to load modules written in other languages). "Perl has a huge community of avid users that continues to thrive in spite of detractors," says one developer, pointing to new applications for big data, in a new article reporting that over one million people have downloaded ActivePerl's own Perl distribution just in 2015. And this week also saw the release of two new "Advent Calendars" of programming tips, one for Perl 5 and one for Perl 6.