Tag: SQL

Feed: Planet MySQL; Author: Marco; I think that very often we are so focus in analyzing internals, or specific behaviours/situations/anomalies that we tend to forget the simple things. It happened to me that last week a couple of customers raise the same question:  "How ProxySQL manage the default schema, or the ones declared inside a FROM/JOIN?"I was a bit surprise because I was given that for granted, and my first thought was, 'well read the documentation', but then I realize we do not have a clear section in the documentation about this. Given that and also because I realize I ... Read More

Feed: Planet PostgreSQL. Today is one year since I started working seriously on pg_chameleon.With this commit I changed the project's license to the 2 clause BSD and the project's scope, evolving the project into a MySQL to PostgreSQL replica system.Initially this change was just a try. I needed to synchronise the data between MySQL and PostgreSQL and at that time the only option I had it was to use the MySQL foreign data wrapper, eventually to copy the data locally every now and then. However, because the previous implementation relied on a MySQL replica this approach approach wasn't really feasible.If ... Read More

Feed: R-bloggers. Author: David Smith. What do women do in films? If you analyze the stage directions in film scripts — as Julia Silge, Russell Goldenberg and Amber Thomas have done for this visual essay for ThePudding — it seems that women (but not men) are written to snuggle, giggle and squeal, while men (but not women) shoot, gallop and strap things to other things.   This is all based on an analysis of almost 2,000 film scripts mostly from 1990 and after. The words come from pairs of words beginning with "he" and "she" in the stage directions (but not ... Read More

Feed: R-bloggers. Author: hrbrmstr. I’ve blathered about my crawl_delay project before and am just waiting for a rainy weekend to be able to crank out a follow-up post on it. Working on that project involved sifting through thousands of Web Archive (WARC) files. While I have a nascent package on github to work with WARC files it’s a tad fragile and improving it would mean reinventing many wheels (i.e. there are longstanding solid implementations of WARC libraries in many other languages that could be tapped vs writing a C++-backed implementation). One of those implementations is JWAT, a library written in ... Read More

Feed: R-bloggers. Author: Nicholas Tierney. Take a look at the data This is a phrase that comes up when you first get a dataset. It is also ambiguous. Does it mean to do some exploratory modelling? Or make some histograms, scatterplots, and boxplots? Is it both? Starting down either path, you often encounter the non-trivial growing pains of working with a new dataset. The mix ups of data types – height in cm coded as a factor, categories are numerics with decimals, strings are datetimes, and somehow datetime is one long number. And let's not forget everyone's favourite: missing data ... Read More

Feed: R-bloggers. Author: Rstats on Julia Silge. I have a new visual essay up at The Pudding today, using text mining to explore how women are portrayed in film. The R code behind this analysis in publicly available on GitHub. I was so glad to work with the talented Russell Goldenberg and Amber Thomas on this project, and many thanks to Matt Daniels for inviting me to contribute to The Pudding. I’ve been a big fan of their work for a long time! Related To leave a comment for the author, please follow the link and comment on their blog: ... Read More

Feed: What's New. This Quick Start implements a high availability solution built with Microsoft Windows Server and SQL Server running on Amazon Elastic Compute Cloud (Amazon EC2), using the Always On Availability Groups feature of SQL Server Enterprise edition. The Quick Start also deploys Windows Server Failover Clustering (WSFC) to complement the high availability and disaster recovery features in the AWS Cloud. This update includes the following features:• SQL Server 2016 and license-included Amazon Machine Image (AMI) provided by Amazon.• Two options for the Active Directory implementation: You can use AWS Directory Service for Active Directory, or manage the EC2 ... Read More

Feed: R-bloggers. Author: Data Science Riot!. The recent release of the blscrapeR package brings the “tidyverse” into the fold. Inspired by my recent collaboration with Kyle Walker on his excellent tidycensus package, blscrapeR has been optimized for use within the tidyverse as of the current version 3.0.0. New things you’ll notice right away include: All data now returned as tibbles. dplyr and purrr are now imported packages, along with magrittr and ggplot, which were imported from the start. No need to call any packages other than tidyverse and blscrapeR. Major internal changes install.packages("blscrapeR") The BLS: More than Unemployment The American ... Read More

Feed: Planet MySQL; Author: Peter Gulutzan; MySQL has thrown away the mysql.proc table for version 8.0 Development Releases. The best explanation that I've seen is the one that Dmitry Lenev gave at a conference last October. To summarize it: mysql.proc and its ilk are non-transactional, redundancy is bad, and MySQL can fix some known bugs by moving over to information_schema tables backed by InnoDB. Of course I approve for a separate reason: mysql.proc is non-standard and therefore it is a mistake. On the other hand, programmers that have invested some time in using mysql.proc will have some trouble changing them ... Read More

Feed: R-bloggers. Author: R Views. This example groups stocks together in a network that highlights associations within and between the groups using only historical price data. The result is far from ground-breaking; you can already guess the output. For the most part, the stocks get grouped together into pretty obvious business sectors. Despite the obvious result, the process of teasing out latent groupings from historic price data is interesting. That’s the focus of this example. A central idea of the approach taken here comes from the great paper of Ledoit and Wolf, “Honey, I Shrunk the Sample Covariance Matrix” (http://www.ledoit.net/honey.pdf) ... Read More