Tag: object

Feed: Planet MySQL; Author: Andrew Grimo; MySQL-Shell has had a set of “Util” object functions for almost a year as of this post. It is this added functionality that negates any reason someone would still need to use the old mysqldump client. It (mysqldump) helped the MySQL Community for a long, long time. It also introduced a large amount of garbage and messiness in with those bloated data files, as it really belongs to an older era. We can now move on ahead without it. This process of “moving ahead” is what I will demonstrate in this blog post. Note: ... Read More

Feed: R-bloggers. Author: Rstats on Jakub Nowosad's website. TLTR: Quantifing changes of spatial patterns requires two datasets for the same variable in the same area. Both datasets are divided into many sub-areas, and spatial signatures are derived for each sub-area for each dataset. Next, distances for each pair of areas are calculated. Sub-areas with the largest distances represent the largest change. To reproduce the calculations in the following post, you need to download all of relevant datasets using the code below: library(osfr) dir.create("data") osf_retrieve_node("xykzv") %>% osf_ls_files(n_max = Inf) %>% osf_download(path = "data", conflicts = "overwrite") You should also attach the ... Read More

Feed: R-bloggers. Author: R Views. [This article was first published on R Views, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Two hundred thirty new packages made it to CRAN in January. Here are my “Top 40” selections in ten categories: Data, Finance, Genomics, Machine Learning, Medicine, Science, Statistics, Time Series, Utilities, and Visualization. Data igoR v0.1.1: Provides tools to extract information from the Intergovernmental Organizations (‘IGO’) Database , version 3, provided by ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Point-In-Time Recovery (PITR) for MySQL databases is an important feature that is essential and covers common use cases, like a recovery to the latest possible transaction or roll-back the database to a specific date before some bad query was executed. Percona Kubernetes Operator for Percona XtraDB Cluster (PXC) added support for PITR in version 1.7, and in this blog post we are going to look into the technical details and decisions we made to implement this feature. Architecture Decisions Store Binary Logs on Object Storage MySQL uses binary logs to perform point-in-time recovery ... Read More

Feed: Planet PostgreSQL. PostgreSQL is one of the most advanced open source databases globally with a lot of great features. One of them is Streaming Replication which was introduced in PostgreSQL 9.0—known as Physical Replication. It works by sending the WAL segments generated by the primary PostgreSQL to another standby server also running PostgreSQL. However, if we only want to replicate a portion of the database tables, then Physical Replication in this case is not ideal. To improve the replication feature, PostgreSQL 9.4 came up with a feature called Logical Replication, in which we can perform efficient synchronous streaming replication ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . Welcome to the first feature summary of 2021! This month, amongst others, we have a couple of updates on ongoing previews, as well as a new color picker that features RGB color selector and a search bar to make discovery of features easier. Additionally, we are introducing new filter operations and make it easier to configure email subscription attachments. That’s not all though, so read on for all the details. Here is the full list of February updates: Reporting Analytics Data connectivity Service Mobile Visualizations Template Apps Developers Other ... Read More

Feed: Planet PostgreSQL. Just like in most databases, in PostgreSQL a trigger is a way to automatically respond to events. Maybe you want to run a function if data is inserted into a table. Maybe you want to audit the deletion of data, or simply respond to some UPDATE statement. That is exactly what a trigger is good for. This post is a general introduction to triggers in PostgreSQL. It is meant to be a simple tutorial for people who want to get started programming them.Create a simple tableWriting a trigger is easy. The first important thing you will need ... Read More

Feed: Cambridge Intelligence. Author: Andrew Disney. In a recent blog post, we explored the role of interactive timeline tools in a typical police investigation. We saw how KronoGraph unpicks big and complex call data records (CDR) and communications metadata, revealing specific clues that drive an investigation forward.CDR analysis rarely gives the full picture, though. To build a convincing case, investigators need to bring relevant information together from all available sources, linking it into a complete and compelling story that stands up in court.That’s no mean feat. A typical investigation could involve data from dozens of different sources: witness reports, central ... Read More

Feed: R-bloggers. Author: R on The broken bridge between biologists and statisticians. Another post for this series about diallel mating experiments. So far, we have published a paper in Plant Breeding (Onofri et al., 2020), where we presented lmDiallel, a new R package to fit diallel models. We followed up this paper with a series of four blog posts, giving more detail about the package (see here), about the Hayman’s models type 1 (see here) and type 2 (see here) and about the Griffing’s family of models (see here). In this post we are going to talk about the Gardner-Eberarth ... Read More

Feed: AWS Compute Blog. Author: James Beswick. In the Operating Lambda series, I cover important topics for developers, architects, and systems administrators who are managing AWS Lambda-based applications. This two-part series discusses core security concepts for Lambda-based applications. In the AWS Cloud, the most important foundational security principle is the shared responsibility model. This broadly shares security responsibilities between AWS and our customers. AWS is responsible for “security of the cloud”, such as the underlying physical infrastructure and facilities providing the services. Customers are responsible for “security in the cloud”, which includes applying security best practices, controlling access, and taking ... Read More