Tag: INSERT

Feed: Cloud Data Transformation Software | Matillion. Author: Arawan Gajajiva, Principal Architect; User Auditing Part 2 – Dimensional Modeling and Implementing Type 2 Dimensions In Part 1 of this series on Matillion security controls and how to enable user auditing, we showed how to use Matillion ETL to integrate with a couple Matillion v1 API endpoints as sources of User and Audit Logging data.  In Part 2 of this series, we show how to use Matillion ETL to implement a common data design pattern, Dimensional Modeling, to get the most insights out of this User and Audit Logging data. If ... Read More

Feed: Planet MySQL; Author: Continuent; Overview The Skinny In this blog post, we explore the correct way to implement bi-directional Tungsten Replication between AWS Aurora and Tungsten Clustering for MySQL databases. Background The Story When we are approached by a prospect interested in using our solutions, we are proud of our pre-sales process by which that we engage at a very deep technical level to ensure the we provide the best possible solution to meet with the prospect’s requirements. This involves an in-depth hands-on POC, in addition to the significant time and effort we spend building and testing the solution ... Read More

Feed: Planet PostgreSQL. We all know that in PostgreSQL we cannot drop an object if there are view dependencies on it:CREATE TABLE t (id integer PRIMARY KEY); CREATE VIEW v AS SELECT * FROM t; DROP TABLE t; ERROR: cannot drop table t because other objects depend on it DETAIL: view v depends on table t HINT: Use DROP ... CASCADE to drop the dependent objects too. ALTER TABLE t DROP id; ERROR: cannot drop column id of table t because other objects depend on it DETAIL: view v depends on column id of table t HINT: Use DROP ... Read More

Feed: Planet PostgreSQL. Soon it’s that time of the year again – basically a 2nd Christmas for followers of the “blue elephant cult” if you will :). I’m, of course, referring to the upcoming release of the next PostgreSQL major version, v12. So I thought it’s about time to go over some basics on upgrading to newer major versions! Database upgrades (not only Postgres) are quite a rare event for most people (at least for those running only a couple of DB-s). Since upgrades are so rare, it’s quite easy to forget how easy upgrading actually is. Yes, it is ... Read More

Feed: Planet MySQL; Author: Krunal Lathiya; SQL STUFF Function Example | Stuff Function In SQL Tutorial is today’s topic. SQL STUFF Function is used to replace the sequence of characters from the source string of given length from the new string given at the time of input to the function. It is replaced from the index which is also specified at the time of input. The STUFF() function deletes the part of the string and then inserts another part into the string, starting at the specified position. SQL STUFF Function Example See the syntax of stuff() function. SELECT STUFF (source_string, ... Read More

Feed: Planet MySQL; Author: Mark Callaghan; InnoDB repeatable read (RR) is complicated.  This is my short description. It isn't exactly correct.Summary Processing of statements within a transaction for InnoDB RR:Statements that are read-only and x-lock free use snapshot isolation Other statements use read committed (RC) with gap locks All statements observe uncommitted changes from the transaction It would have been simpler to use snapshot isolation as-is but that leads to more write-write conflicts. Sources of Confusion The repeatable read snapshot is created at the start of the first real statement (SELECT, INSERT, etc) and not by BEGIN or START TRANSACTION. It is ... Read More

Feed: Planet MySQL; Author: Marcelo Altmann; Working as a support engineer here at Percona is amazing, as you get a variety of requests, ranging from the most trivial questions to questions that require source code review and understanding of the internals of InnoDB, for example.In our world where High Availability is a must, everything is about being pro-active, and when we need to be reactive we must act fast. To do so we need to ensure we have proper monitoring in place that covers all possible failure scenarios. Unfortunately, that is not always possible and we are always improving and ... Read More

Feed: Planet MySQL; Author: Vitess; Vitess has an opinionated approach to database scalability. Some of those opinions have minimal controversy such as how durability should be provided via replication, but the one I find interesting is the 250GB per MySQL server recommendation.Is this a physical MySQL Limit?In short: no. By “physical limit” I mean is there a file format restriction that says databases can not be greater than 250GB?The physical limit for InnoDB is 64TB per tablespace, and in the default configuration each table is its own tablespace. With table partitioning, this limit can be extended even further.Is this a ... Read More

Feed: Planet MySQL; Author: Ahmed Bouchefra; Receive new Laravel tutorials. Receive new PHP tutorials. Laravel 6 is recently released with many enhancements, so we'll be learning, throughout this tutorial series how to create an example REST API CRUD application from scratch. The application we'll be building is a simple CRM with a MySQL database that exposes a set of RESTful API endpoints. You can see this Upgrade Guide for instructions on how to upgrade an existing web application from Laravel 5.8 to Laravel 6. Introducing REST APIs According to Wikipedia: Representational State Transfer (REST) is a software architectural style that ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I have to celebrate the anniversary of my last day in Oracle (that was 7 years ago!) somehow, and I think writing yet another blog post about Oracle MySQL bugs is a good way to do this. I am actually surprised (and happy) that public bugs database is still alive, maintained and considered important in Oracle, and I know who in Oracle was working hard all these years for this to happen!In my previous post in this series I've stopped on Bug #95954 and had not completed review of interesting MySQL bug reports that I've ... Read More