Tag: INSERT

Feed: Planet MySQL; Author: Dave Stokes; JSON has proven to be a very import data format with immense popularity. A good part of my time for the last two or so years has been dedicated to this area and I even wrote a book on the subject.  This is a comparison of the implementations of handling JSON data in MySQL and MariaDB. I had requests from the community and customers for this evaluation. JSON Data Types Are Not All Equal MySQL added a JSON data type in version 5.7 and it has proven to be very popular.  MariaDB has  JSON ... Read More

Feed: Planet MySQL; Author: Ivan Ma; MySQL Replication Data Recovery using 'mysqlbinlog' - Part IIThe previous post (PART-I) http://mysqlhk.blogspot.com/2018/10/mysql-replication-recovery-from-binlog.htmlIt describes the Replication Recovery from binlog by using those binlog files to be treated as Relay Log.  The Relay Log mechanism when the server is startup, the recovery is the SQL_THREAD applier to apply data to the database.    Check on the PART-I post for details.Part II is about using the MySQL utility "mysqlbinlog" to dump the content from binlog files and apply the SQL to the Database. Documentation https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.htmlThe following sections describe the tutorial for Replication Data Recovery using 'mysqlbinlog'. The ... Read More

Feed: Planet PostgreSQL. Here is a series of articles that will focus on a new feature in version 11. During the development of this version, a feature caught my attention. It can be found in releases notes : https://www.postgresql.org/docs/11/static/release-11.html Allow heap-only-tuple (HOT) updates for expression indexes when the values of the expressions are unchanged (Konstantin Knizhnik) I admit that this is not very explicit and this feature requires some knowledge about how postgres works, that I will try to explain through several articles: How MVCC works and heap-only-tuples updates When postgres do not use heap-only-tuple updates and introduction to the ... Read More

Feed: R-bloggers. Author: Tamas Markó. Package introduction:Package myprettyreport helps to export ggplot2 graphs into a good-looking PDF file in a clear and easy way with a wide range of flexibility. It has a modular structure so the report elements can be combined in many ways. Installation:This package currently only available on Github so the proper way to install it: #install.packages("devtools") devtools::install_github("tarkomatas/myprettyreport") Quick overview: Functions of the package:start_report() is the first mandatory function to generate the report.add_cover_page() function generates the cover page of the report.add_new_page() function adds a single report page to the report.add_multiple_page() function adds multiple report pages to the ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Implementation Specification for Stored Procedures How Parsing and Execution of Queries Work In order to execute a query, the function sql_parse.cc:mysql_parse() is called, which in turn calls the parser (yyparse()) with an updated Lex structure as the result. mysql_parse() then calls mysql_execute_command() which dispatches on the command code (in Lex) to the corresponding code for executing that particular query. There are three structures involved in the execution of a query which are of interest to the stored procedure implementation: Lex (mentioned above) is the "compiled" query, that is the output from the ... Read More

Feed: Microsoft Azure Blog. Author: Kavitha Jonnakuti. Today we’re announcing the general availability of Row-Level Security (RLS) for Microsoft Azure SQL Data Warehouse, an additional capability for managing security for sensitive data. Azure SQL Data Warehouse is a fast, flexible, and secure cloud data warehouse tuned for running complex queries fast and across petabytes of data. As you move data to the cloud, securing your data assets is critical to building trust with your customers and partners. With the introduction of RLS, you can implement security policies to control access to rows in your tables, as in who can access ... Read More

Feed: Planet PostgreSQL. PostgreSQL 11 was released recently, with exciting new features. One of them is the ability to write SQL procedures that can perform full transaction management, enabling developers to create more advanced server-side applications. SQL procedures can be created using the CREATE PROCEDURE command and executed using the CALL command. Since OmniDB 2.3.0 it is possible to debug PostgreSQL PL/pgSQL functions. Support to PostgreSQL 11 functions and procedures was added in OmniDB 2.11.0. Last week we released OmniDB 2.12.0 with nice new features and a new revamped visual, so I’m going to show you how OmniDB 2.12.0 can ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Application developers often write code that interacts with a database using parameters supplied by application users. These parameters may include credentials, resource identifiers and other application-specific data. MySQL implements prepared statements for this purpose. A prepared statement, or parameterized query, is used to execute the same statement repeatedly in an extremely efficient manner. Prepared statements/parameterized queries offer the following major benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of nearly-identical statements, with only changes to literal or variable values in clauses, such ... Read More

Feed: Microsoft Azure Blog. Author: Rob Caron. Now in preview Local testing with live data means faster development with Azure Stream Analytics Live data local testing is now available for public preview in Azure Stream Analytics Visual Studio tools, which enables you to test jobs locally from the IDE using live event streams from Azure Event Hub, IoT Hub, and Blob Storage. The new local testing runtime can read live streaming data from the cloud or from a local static file. It works the same as the cloud runtime Azure Stream Analytics and therefore supports the same time policies needed ... Read More

Feed: Planet MySQL; Author: Shiv Iyer; There are basically two things which I majorly like about using MyRocks, 1. LSM Advantage – smaller space & lower write amplification and 2. Best of MySQL like replication, storage engine centric database infrastructure operations and MySQL orchestration tools. Facebook built RocksDB as an embeddable and persistent key-value store with lower amplification factor () compared to InnoDB. Let me explain a scenario were InnoDB proves less efficient compared to RocksDB in SSD:We know InnoDB is constrained by a fixed compressed page size. Alignment during fragmentation and compression causes extra unused space because the leaf nodes ... Read More