Tag: python

Feed: Planet MySQL; Author: Alena Subotina; February 22nd, 2021 The article provides a comprehensive walkthrough outlining the aspects of how to install MySQL Server on Windows using MySQL Installer. Learn the subtleties of the MySQL installation process step-by-step to ensure you have MySQL Server together with its tools running smoothly. Download MySQL Installer The most convenient way to install and set up MySQL Server on the Windows Operating System is to apply MySQL Installer. This setup wizard provides the means to simplify the installation and configuration processes of MySQL products that run on Microsoft Windows. The list of MySQL products ... Read More

Feed: R-bloggers. Author: Lou Bajuk. [This article was first published on RStudio Blog, 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. Photo by Stillness InMotion on Unsplash In previous posts, we’ve talked about the critical importance of interoperability, and how it helps organizations and data science teams get the most out of their analytic investments. We’ve focused recently on the ways that R and Python can be used together, and how RStudio’s products ... Read More

Feed: Planet PostgreSQL. © Laurenz Albe 2021PostgreSQL commit ee28cacf61 has added new options for the target_session_attrs connection parameter. This article explores how the new options can be used to simplify high availability and horizontal scaling solutions.What is target_session_attrs?The PostgreSQL client shared library libpq has support for connection strings to more than one database server: psql 'host=server1.my.org,server2.my.org port=5432,5432 dbname=mydb user=myself' In the URL connection string format, that would look like psql 'postgresql://myself@server1.my.org:5432,server2.my.org:5432/mydb' Then the client will first try to connect to server1.my.org, and if it cannot reach that server, it will try to connect to server2.my.org.This is useful in combination with ... Read More

Feed: Planet PostgreSQL. In this post I will show you how I discovered that the backend was putting data into a new table (generate_plist) but the website was still using the ports.pkg_plist column. The result was stale data being shown on the website (for older ports) or no data at all (for newer ports). How long? Since Oct 2017, because that’s when configure_plist showed up on the website. Nobody noticed until recently. I can only guess that I made the backend changes with intent to change the frontend later. I should have created myself a ticket. Why was the change ... Read More

Feed: AWS Big Data Blog. In our previous post, we introduced PyDeequ, an open-source Python wrapper over Deequ, which enables you to write unit tests on your data to ensure data quality. The use case we ran through was on static, historical data, but most datasets are dynamic, so how can you quantify how your data is changing and detect anomalous changes over time? At Amazon, we’ve leveraged PyDeequ on AWS Glue to address this problem. AWS Glue is a serverless data integration service that allows you to easily prepare and combine your data for analytics, machine learning (ML), and ... Read More

Feed: AWS Compute Blog. Author: Julian Wood. This post is written by Hari Ohm Prasath Rajagopal, Senior Modernization Architect and Vamsi Vikash Ankam, Technical Account Manager In this post, I show how to build a flexible in-memory AWS Lambda caching layer using Lambda extensions. Lambda functions use REST API calls to access the data and configuration from the cache. This can reduce latency and cost when consuming data from AWS services such as Amazon DynamoDB, AWS Systems Manager Parameter Store, and AWS Secrets Manager. Applications making frequent API calls to retrieve static data can benefit from a caching layer. This ... Read More

Feed: AWS Architecture Blog. Research organizations across industry verticals have unique needs. These include facilitating stakeholder collaboration, setting up compute environments for experimentation, handling large datasets, and more. In essence, researchers want the freedom to focus on their research, without the undifferentiated heavy-lifting of managing their environments. In this blog, I show you how to set up a managed Jupyter environment using custom tools used in Life Sciences research. I show you how to transform the developed artifacts into scripted components that can be integrated into research workflows. Although this solution uses Life Sciences as an example, it is broadly ... Read More

Feed: R-bloggers. Author: hrbrmstr. [This article was first published on R – rud.is, 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. Brim Security maintains a free, Electron-based desktop GUI for exploration of PCAPs and select cybersecurity logs: along with a broad ecosystem of tools which can be used independently of the GUI. The standalone or embedded zqd server, as well as the zq command line utility let analysts run ZQL (a domain-specific query ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Alaa Mahjoub. In many cases, for an enterprise to build its digital business technology platform, it must modernize its traditional data and analytics architecture. A modern data and analytics platform should be built on a services-based principles and architecture. Introduction part 1, provided a conceptual-level reference architecture of a traditional Data and Analytics (D&A) platform. This part, provide a conceptual-level reference architecture of a modern D&A platform. Parts 3 and 4, will explain how these two reference architectures can be used to modernize an existing traditional D&A platform. This will be ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: akash. Increased consumption of data, more powerful computing, and the strong inclination towards data-driven decisions in business have made data science a crucial part of today's business environment. According to IBM, there is a huge demand for data scientists and data analysts in the present time. Python and R are the two most popular tools for programming for data science. Python and R both are open-source and free and were developed back in the early 1990s. For practitioners of machine learning and data science, these two tools are absolutely essential. While ... Read More