VentureBeat: What are graph database query languages?

VentureBeat: What are graph database query languages?. “Classic relational databases can store graphs, and before graph databases it was common for developers to use them because they were the only option. SQL can answer basic questions, but traditional query languages generally can’t answer the most useful and tantalizing questions. Ironically, perhaps, relational databases are not nearly as good at representing very complex relations as graph databases are. Often, the only solution for a relational database query is to return large blocks of data so the client software can run the analysis.”

ComputerWorld: How Google Tables can turn up your productivity

ComputerWorld: How Google Tables can turn up your productivity. “The final Tables version won’t be available for a while, but in the meantime, you can get a taste of what Google’s cookin’ up by checking out the service’s completely free beta version. There’s an awful lot to like about it, and if you decide to stick with it, you’ll be able to move directly from it into the official Tables version whenever that’s released. (Google says it expects that to happen sometime ‘in the next year.’)”

All Hyped Up for HyperCard: Further Adventures with an Apple Legacy Format (Library of Congress)

Library of Congress: All Hyped Up for HyperCard: Further Adventures with an Apple Legacy Format. “Jacob and Hilary assisted in updating and expanding the Sustainability of Digital Formats website, which provides information and analysis on over 500 digital file formats and offers guidance on the long-term preservation of digital content at the Library. Through their work, they assisted in providing current information on file formats to users at the Library of Congress and throughout the international digital preservation community. In this blog post, Jacob and Hilary discuss their research on the HyperCard file format.”

University of California Merced: Computer Science and Engineering Professor, Students Improve Database Query Results with NSF Grant

University of California Merced: Computer Science and Engineering Professor, Students Improve Database Query Results with NSF Grant. “Every time you surf the web, check your credit card balance, or even sign up for a class at UC Merced, you’re using a relational database. Relational databases are basically the back end of operating software, aggregating information and culling results based on your search or query. Improving the speed of these results, known as query optimization, is the focus of computer science and engineering Professor Florin Rusu and his third-year graduate students Yesdaulet Izenov and Asoke Datta.”

University of Hawaii: UH Hilo geographers’ digital project speeds response to public access queries

University of Hawaii: UH Hilo geographers’ digital project speeds response to public access queries. “Geographers at the University of Hawaiʻi at Hilo recently completed a pilot project with the County of Hawaiʻi Department of Planning to help modernize the county’s public access program. Shoreline public access locations and associated permitting documents were digitized in a pilot geospatial database by UH Hilo geographical data experts and UH Hilo department of geography and environmental science students and recent graduates.”

Even Facebook struggles: Zuck’s titanic database upgrade hits numerous legacy software bergs (The Register)

The Register: Even Facebook struggles: Zuck’s titanic database upgrade hits numerous legacy software bergs . “Facebook has had all sorts of no fun trying to migrate from MySQL 5.6 to version 8.0. A post from the social network’s engineering team reveals that Facebook’s last MySQL upgrade – to version 5.6 – took ‘more than a year’. Moving to version 8.0 has taken ‘a few years so far’.”

My Master Designer: Using Google Sheets As Database With Python

My Master Designer: Using Google Sheets As Database With Python. “In this article, we’ll use Google Sheets as a database with the help of Python. Use SQL or NoSQL softwares when large databases and complex operations are required. A reminder before you start reading the article Google Sheets isn’t exactly database software, but it’s a simple spreadsheet program where you can store your data.”

TechCrunch: Google’s AirTable rival, Tables, graduates from beta test to become a Google Cloud product

TechCrunch: Google’s AirTable rival, Tables, graduates from beta test to become a Google Cloud product. “Last fall, Google’s in-house incubator Area 120 introduced a new work-tracking tool called Tables, an AirTable rival that allows for tracking projects more efficiently using automation. Today, Google says Tables will officially ‘graduate’ from Area 120 to become an official Google product by joining Google Cloud, which it expects to complete in the next year.”

News@Northeastern: Supreme Court Ruling Clears Path For Researchers, Journalists Who Test Facebook And Other Platforms For Discrimination

News@Northeastern: Supreme Court Ruling Clears Path For Researchers, Journalists Who Test Facebook And Other Platforms For Discrimination. “The case, Van Buren v. United States, deals with a former police officer who agreed to search digital license plate records outside his official duties as an officer, in exchange for cash. It’s not the broad strokes of the incident, but the implication of the court ruling, that clears the way for researchers to continue the important work of probing websites and online platforms for evidence of bias and discrimination.”

BusinessWire: World’s Biggest Open Source Database Conference, Percona Live Sessions Now Available Online (PRESS RELEASE)

BusinessWire: World’s Biggest Open Source Database Conference, Percona Live Sessions Now Available Online (PRESS RELEASE). “Over two days, Percona Live ONLINE 2021 attracted thousands of attendees who wanted to discover more about the vast ecosystem of open source database technologies. These sessions are now available for replay on-demand. With 206 sessions and 196 speakers, the conference provided an opportunity for beginners and experts to learn from many of the largest organizations in the world, and hear from the people solving some of the biggest database challenges.”

ZDNet: Google makes Database Migration Service generally available

ZDNet: Google makes Database Migration Service generally available. “Google Cloud on Wednesday announced the general availability of its Database Migration Service (DMS), a serverless tool to migrate MySQL and PostgreSQL databases to Cloud SQL. Later in the year, Google will introduce support for Microsoft SQL Server. DMS supports migrations from both on-premises and other clouds. It offers a unique migration method that uses MySQL and PostgreSQL’s native replication capabilities and maximizes security, fidelity and reliability.”

GlobeNewswire: Crate. io Open Sources the Entire Codebase of CrateDB – the Database Purpose Built for Machine Data (PRESS RELEASE)

GlobeNewswire: Crate.io Open Sources the Entire Codebase of CrateDB – the Database Purpose Built for Machine Data (PRESS RELEASE). “Crate.io, developer and supplier of CrateDB, the purpose-built database optimized for machine data use cases, today announced that CrateDB is now a fully open source database solution. With today’s release of CrateDB 4.5, all enterprise features of the database are available under the Apache 2.0 open source license for the self-deploy Community edition.”

The Register: ‘Malwareless’ ransomware campaign operators pwned 83k victims’ MySQL servers, 250k databases up for sale

The Register: ‘Malwareless’ ransomware campaign operators pwned 83k victims’ MySQL servers, 250k databases up for sale. “A ‘malwareless’ ransomware campaign delivered from UK IP addresses targeting weak security controls around internet-facing SQL servers successfully pwned 83,000 victims, according to Israeli infosec biz Guardicore.”

Court Hands Journalists a Big Freedom of Information Act Win: Gun Data Access (CityBeat)

CityBeat: Court Hands Journalists a Big Freedom of Information Act Win: Gun Data Access. “Reveal, the Center for Investigative Reporting (CIR), originally sued for records in November 2017. The Department of Alcohol, Tobacco, and Firearms (ATF) never responded. ATF’s gun tracing database lists 6.8 million firearms linked to criminal activity. Reveal sought records for any gun traced back to law enforcement ownership. When Congress passed the Freedom of Information Act (FOIA) in 1966, modern databases did not exist. ATF argued that a search query exporting the results amounted to a ‘new’ record, which agencies aren’t required to disclose under the FOIA statute. The court disagreed.”

Borodutch: Build your own perpetual autonomous database backup machine from a Raspberry Pi for $10 and never pay for backups again

Borodutch: Build your own perpetual autonomous database backup machine from a Raspberry Pi for $10 and never pay for backups again. “Hello everybody! So I wrote a post on how to setup free backups for MongoDB. But then I thought that it was a bit too much equipment: you needed a USB thumb drive and an old laptop. And it hit me: I could do the same thing on a $10 Raspberry Pi Zero W if I just upload my backups to Google Drive directly!”