Tag: Database

Feed: R-bloggers. Author: Daniel Petzold. [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 Daniel Jerez on UnsplashData science can feel like an endless tunnel, with tremendous investment at the beginning and little visibility into where or when your results will emerge. Data science teams wrestle with many challenges, such as rapid iteration of new ideas, business alignment, productivity, transparency, and delivering durable value.As we’ve discussed ... Read More

Feed: Planet PostgreSQL. A couple of weeks ago I got a very nice surprise in the mail, but I was not able to write about it due to my eyes problems and current situation (a very few details can be found here). Anyway, promoting PostgreSQL is important, so here I am to tell you about what I received. Long story short: I received a PostgreSQL 12 celebrative coin! The envelope First of all, I clearly recognized the name on the envelope: Mark Wong is the treasurer of the PostgreSQL US organization, namely PGUS. The content The content of the evenlope ... Read More

Feed: Redis Labs. Author: Yossi Gottlieb. Redis Core Team member Madelyn Olson Last week we announced a new light-governance model for the open source Redis project, following Salvatore Sanfilippo’s stepping back from being Redis’s BDFL and sole maintainer. We believe that defining the right model for Redis was an important step, but it’s just as important to get the right people on board the new core team. In order to preserve the spirit of Redis and its unique DNA, we wanted the core team to consist of people who are already committed to and involved with the project. To that ... Read More

Feed: Recent Announcements. The new rules verify security and operational best practices for services such as Amazon CloudWatch, AWS CloudTrail, Amazon DynamoDB, Amazon Relational Database Service, Amazon EC2, AWS Identity and Access Management, Amazon Redshift, AWS Web Application Firewall and Elastic Load Balancing. For a full list of newly launched rules and supported Regions, click here. To learn more about AWS Config, visit the AWS Config webpage and technical documentation.   ... Read More

Feed: AWS Compute Blog. Author: James Beswick. This post is courtesy of Jakub Narloch, Senior Software Development Engineer.Today, AWS announced the support for Amazon API Gateway as an event target in Amazon EventBridge. This feature enables new integration scenarios for web applications and services. It allows customers to seamlessly connect their infrastructure, SaaS services, and APIs hosted in AWS. With API Gateway as a target for EventBridge, this creates new integration capabilities for new or existing web applications. This post explains how developers can now deliver events directly to their applications hosted on Amazon ECS, Amazon Elastic Kubernetes Service (EKS), ... Read More

Feed: Planet MySQL; Author: MyDBOPS; In my day to day tasks as a DB Engineer at Mydbops we have been using multiple MySQL tools for multiple use cases to ensure an optimal performance and availability for servers managed by our Remote DBA Team. A tool like pt-online-schema can be used for any DDL changes ( Overview to DDL algorithm ), if any tool which needs to scheduled for longer period we tend to use screen or cron. Some of the problems we face when we demonise the process or use screen for running processes. The daemon process gets killed when ... Read More

Feed: Actian. Author: Andre Beauchamp. Due to the global outbreak of COVID-19, schools worldwide had to shut down quickly. While many schools already operated with some online component, most were not equipped to become 100% digital in a matter of days. Further, it’s looking as if most school districts and higher education campus systems will have to adopt some sort of hybrid approach as a means of transitioning back to some level of in-person instruction and laboratories.  With our own online portal for digital learning, we saw a 200% increase in activity after the outbreak put schools on a total learn-from-home ... Read More

Feed: AWS Architecture Blog. We recently published a significant update to the AWS Well-Architected Framework, and as part of that update, the Performance Efficiency Pillar whitepaper has been streamlined and improved. The questions in the whitepaper are now better aligned with those in the AWS Well-Architected Tool, making it easy to cross-reference between them when reviewing workloads. With clearer headings and each best practice highlighted, you can quickly find what you need and then dive deep on any topic.We also updated the Performance Efficiency pillar to reflect the evolution of AWS and the best practices we are seeing in the ... Read More

Feed: Recent Announcements. With AWS WAF Security Automations, customers can automatically deploy a single web access control list with a set of AWS WAF rules to filter common threats and protect web applications and APIs deployed with Amazon CloudFront, an Application Load Balancer, or an Amazon API Gateway. This latest release integrates with AWS WAFv2 API and includes enhancements to existing features for improved performance and cost optimization.  Additional performance improvements to AWS WAF Security Automations version 3.0 include: Customers have the option to automatically deploy AWS Managed Rules Eliminated the dependency on NodeJS; updated code to Python 3.8 Resolved API ... Read More

Feed: Planet MySQL; Author: René Cannaò; ProxySQL Firewall Overview ProxySQL’s flexible query rules engine has many uses, from Read/Write splitting, sharding and even creating firewall blacklist. This allows ProxySQL to be loved by both Performance and Security-minded engineers. Starting in ProxySQL 2.0.9, ProxySQL has another Security feature: the Firewall Whitelist. Modeled on MySQL Enterprise Firewall, this allows a security-conscious administrator to tune access to only allow certain queries. Imagine a situation where your webapp gets hacked, which exposes your user’s database credentials. If your webapp connects directly to the database, the malicious user can do what they want to your ... Read More