Tag: INSERT

Feed: Planet PostgreSQL. 1. Introduction PostgreSQL is packed with several security features for a database administrator to utilize according to his or her organizational security needs. The word Security is a very broad concept and could refer to completely different procedures and methodology to achieve in different PostgreSQL components. This blog is divided into part 1, 2 and 3 and I will explain the word Security with regards to PostgreSQL version 12.1 and how it is practiced in different areas within the system. In Part 1 of the blog, I will be discussing the basic security features that exist in ... Read More

Feed: Planet MySQL; Author: Chandan Kumar; Introduction Before I talk about installation of MySQL inside docker, it's more important to knowwhat is Docker?- Docker is a tool designed to create , deploy ,and run an application any where. -It allow us to package up application with all requirements such as libraries and other dependencies and ship it all as a PACKAGE.who uses Docker?Developer : Docker enables developer to develop application without spending much time on IT infrastructure.Sysadmin :-Docker enables sysadmin to streamline the software delivery, such as develop and deploy bug fixes and new features without any roadblock. Enterprise :-Docker works in ... Read More

Feed: R-bloggers. Author: R on Stats and R. [This article was first published on R on Stats and R, 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. If you have the chance to work with an experienced programmer, you may be amazed by how fast she can write code. In this article, I share some tips and shortcuts you can use in RStudio and R Markdown to speed up the writing of your ... Read More

Feed: MemSQL Blog. Author: Rick Negrin. There is a trend in industry which says that modern applications need to be built on top of one or more special-purpose databases. That every application benefits from using the best-of-breed technology for each requirement. And that the plethora of special-purpose options available from certain cloud providers is reasonable to manage. That’s all BUNK. The reality is that navigating the choices, figuring out how to use them effectively, and dealing with the ETL and inevitable data sprawl, is so difficult that the pain far outweighs any technical advantage you might get. In the vast ... Read More

Feed: Planet PostgreSQL. On 20th of January 2020, Amit Kapila committed patch: Allow vacuum command to process indexes in parallel.   This feature allows the vacuum to leverage multiple CPUs in order to process indexes. This enables us to perform index vacuuming and index cleanup with background workers. This adds a PARALLEL option to VACUUM command where the user can specify the number of workers that can be used to perform the command which is limited by the number of indexes on a table. Specifying zero as a number of workers will disable parallelism. This option can't be used with ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; Everybody talks about how continuous delivery is desirable to deliver products faster, so you can get feedback faster, get to revenue faster, and compete effectively. That said, continuous delivery is not easy. Achieving continuous delivery requires you to focus on your internal processes. Being a skeptical person, I asked myself, "Will focusing on our internal processes really enable us to deliver value to customers, as and when needed?"In fact, we did significantly cut our release cycles. We also found that shortening our release cycles helped us solicit feedback along the way, and build ... Read More

Author: . We typically talk about transactions in the context of Data Manipulation Language (DML), but the same principles apply when we talk about Data Definition Language (DDL). As databases increasingly include transactional DDL, we should stop and think about the history of transactional DDL. Transactional DDL can help with application availability by allowing you perform multiple modifications in a single operation, making software upgrades simpler. You’re less likely to find yourself dealing with a partially upgraded system that requires your database administrator (DBA) to go in and fix everything by hand, losing hours of their time and slowing your ... Read More

Author: mkysel. We typically talk about transactions in the context of Data Manipulation Language (DML), but the same principles apply when we talk about Data Definition Language (DDL). As databases increasingly include transactional DDL, we should stop and think about the history of transactional DDL. Transactional DDL can help with application availability by allowing you perform multiple modifications in a single operation, making software upgrades simpler. You’re less likely to find yourself dealing with a partially upgraded system that requires your database administrator (DBA) to go in and fix everything by hand, losing hours of their time and slowing your ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; As on every release MySQL Shell 8.0.19 includes several bug fixes as well as new features. However, this release includes some significant changes: Fixes for bugs in the schema definition:  Cascading keys in multi-primary mode. Introduction of InnoDB ReplicaSet. These changes required updates to the metadata schema definition, some of which incompatible with previous versions. InnoDB Cluster and ReplicaSet deployments that are created using MySQL Shell 8.0.19 will automatically use the new version of the metadata schema. However, to use InnoDB Cluster deployments created in older Shell versions (8.0.18 or earlier) with ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; If you are reading this blog post, you likely already know the purpose of user-defined functions (UDF) in MySQL. If you need a quick refresher on UDF’s take a look at the MySQL reference manual.  You may have created your own UDFs as well. Have you ever run into character set related issues with your UDF?  If yes, then this blog post will interest you. If you are planning to write new UDFs then it will be good to know this information. The initial design of MySQL UDF framework did not consider ... Read More