Tag: INSERT

Feed: Planet MySQL; Author: Mark Callaghan; My goal for the year is more time learning math and less time running MySQL benchmarks. I haven't done serious benchmarks for more than 12 months. It was a great experience but I want to learn new things. MySQL 8.0.14 has been released with fixes for a serious bug I found via the insert benchmark. I won't confirm whether it has been fixed. I hope someone else does.My tests and methodology are described in posts for sysbench, linkbench and the insert benchmark.  I hope the upstream distros (MySQL, MariaDB, Percona) repeat my tests and methodology ... Read More

Feed: Planet PostgreSQL. Security is a super important topic. This is not only true in the PostgreSQL world – it holds true for pretty much any modern IT system. Databases, however, have special security requirements. More often than not confidential data is stored and therefore it makes sense to ensure that data is protected properly. Security first !PostgreSQL: Listing all permissionsGaining an overview of all permissions granted to users in PostgreSQL can be quite difficult. However, if you want to secure your system, gaining an overview is really everything – it can be quite easy to forget a permission here ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/J Version 8.0.14 is the GA release of the 8.0branch of MySQL Connector/J. It is suitable for use with MySQL Serverversions 8.0, 5.7, 5.6, and 5.5. It supports the Java DatabaseConnectivity (JDBC) 4.2 API, and implements the X DevAPI. This release includes the following new features and changes, alsodescribed in more detail on https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-14.html As always, we recommend that you check the “CHANGES” file in thedownload archive to be aware of changes in behavior that might affectyour application. To download MySQL Connector/J 8.0.14 GA, see the “Generally Available(GA) Releases” tab at ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . In the Optimize MySQL Inserts Using Batch Processing article, a couple of ways to achieve faster INSERT speeds in MySQL were explored. The last example that was shown employed multiple-row inserts. At around 65% the throughput of LOAD DATA INFILE statement, the multiple-row insert is substantially faster than individual inserts, while not requiring a temporary text file. In today's tutorial, you'll get a closer look at how you can generate a multiple-row insert statement dynamically using the programming language of your choice. First, you'll see pseudo-code that outlines the steps; then, you'll ... Read More

Feed: R-bloggers. Author: Sebastian Wolf. How to Build a Shiny “Truck” part 2 — Let the LEGO “truck” app pull a trailer. An example of a modularized shiny app.In September 2018 I used an automotive metaphor explaining a large scale R shiny app. RViews published the article. I would summarize the article in one phrase. Upon building large applications (trucks) in R shiny there are a lot of things to keep in mind. To cover all these things in a single app I’m providing this tutorial. You can find all files of the app under https://github.com/zappingseb/biowarptruck — folder: example_packaged Summary (skip if you read the ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona is glad to announce the release of Percona XtraBackup 2.4.13 on January 18, 2018. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, it drives down backup costs while providing unique features for MySQL backups. New features and improvements: PXB-1548: Percona XtraBackup enables updating the ib_buffer_pool file with the latest pages present in ... Read More

Feed: R-bloggers. Author: tomaztsql. So this came as a surprise, when working on calculating simple statistics on my dataset, in particular min, max and median. First two are trivial. The last one was the one, that caught my attention. While finding the fastest way on calculating the median (statistic: median) for given dataset, I have stumbled upon an interesting thing.  While WINDOW function was performing super slow and calling R or Python using sp_execute_xternal_script outperform window function as well, it raised couple of questions. But first, I created a sample table and populate it sample rows: DROP TABLE IF EXISTS ... Read More

Feed: Planet PostgreSQL. What is JSON? JSON stands for “JavaScript Object Notification” which is a type of data format popularly used by web applications. This means, the data would be transmitted between web applications and servers in such a format. JSON was introduced as an alternative to the XML format. In the “good old days” the data used to get transmitted in XML format which is a heavy weight data type compared to JSON.Below is an example of JSON formatted string: { "ID":"001","name": "Ven", "Country": "Australia", "city": "Sydney", "Job Title":"Database Consultant"} A JSON string can contain another JSON object with-in ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . There are many different ways to migrate from PostgreSQL to MariaDB. This article will discuss some of those options. MariaDB's CONNECT Storage Engine MariaDB's CONNECT storage engine can be used to migrate from PostgreSQL to MariaDB. There are two primary ways that this can be done. See Loading the CONNECT Storage Engine for information on how to install the CONNECT storage engine. Tables with ODBC table_type The CONNECT storage engine allows you to create tables that refer to tables on an external server, and it can fetch the data using a compatible ... Read More

Feed: All - O'Reilly Media. Author: Tyler Ortman, Jeff Bleiel. Sandstone waves (source: Norm_Bosworth via Pixabay) Change is the only constant in the technology world, and programming languages are no exception. Competition among languages has led to improvements across the board. Established players like Java have added major features, while upstart languages like Go and Rust look to improve packaging and exception handling to add “fit and finish” to their ecosystems. As we enter 2019, we asked some of our O’Reilly authors and training course instructors for their thoughts on what’s in store for established players and fast-growing languages. Python ... Read More