Tag: Git

Feed: Cloud Data Transformation Software | Matillion. Author: Dayna Shoemaker; Want the very best Matillion ETL experience? Each new version of is better than the last. Make sure you are on the latest version to take advantage of the features, new components, and improvements introduced in Matillion ETL v1.40. Ready to upgrade? For more information on how to upgrade, check out our blog on How to Update Matillion – Best Practices. New Data Connectors Mandrill Query component Use the Mandrill Query component to load your Mandrill data into your cloud data warehouse. Snapchat Query component Use the Snapchat Query component ... Read More

Feed: Planet PostgreSQL. Postgres doesn’t have built in function to clone schema. However,  may of backend developers would like to perform a number of operations at schema level directly from command line tools such as psql or any database developer tools (DBeaver). One of the common operation is to copy or clone the entire schema. While researching any existing solutions, I stumbled upon  postgres-general thread where one of the developer(s) provided clone_schema.sql function. I uploaded the existing function provided in thread to my git repo here. However, when I tried to use it, it was throwing error related to sequence. I updated the ... Read More

Feed: Planet PostgreSQL. In a developer’s ideal world there’s only one stable and one development version of the product. Everyone updates immediately to the next stable version and nobody cares about anything older.As far as I can tell this has never actually happened, ever, in the history of anything. Working on many versions PostgreSQL is a mature and stable codebase. Users often run very old versions and they are usually reluctant to perform major upgrades frequently. Any upgrade involves some risk – anyone who tells you otherwise probably also has a great deal for you on some prime real estate ... Read More

Feed: Planet PostgreSQL. 2ndQuadrant has written before about how to build your own extension for Windows. This time we take a look at what it takes to port one written by someone else. I am building this for PostgreSQL 11 on Windows using Visual Studio 2019 and clang. Here we are working with the hashtypes extension. Unfortunately, at the time of writing, version 0.1.5 has not been released with the support for PostgreSQL 11. So we build one from git. git clone https://github.com/adjust/hashtypes.git The first thing we do is to take a look at the C source files. There are ... Read More

Feed: Planet MySQL; Author: Percona Community; Geoff Winans  | August 14, 2019 |  Posted In: MariaDB, MySQL, ToolsIn my roles as a DBA at various companies, I generally found the tooling to be quite lacking. Everything from metrics collection, alerting, backup management; they were either missing, incomplete or implemented poorly. DBA-Tools was born from a desire to build backup tools that supported my needs in smaller/non-cloud environments. As BASH is easily the most common shell available out there on systems running MySQL® or MariaDB®, it was an easy choice.How DBA-Tools came to beWhile rebuilding my home-lab two years ago, I decided I ... Read More

Feed: R-bloggers. Author: Daniel Oehm. If you’re like me, when running a process through a loop you’ll add in counters and progress indicators. That way you’ll know if it will take 5 minutes or much longer. It’s also good for debugging to know when the code wigged-out. This is typically what’s done. You take a time stamp at the start – start , print out some indicators at each iteration – cat(“iteration”, k, “// reading file”, file, “n”) and print out how long it took at the end – print(Sys.time()-start). The problem is it will print out a new line ... Read More

Feed: Planet MySQL; Author: Ankit Kumar; Today I am going to explain ways to execute shell or bash commands from mysql clients or stored procedure and function. There are basically 2 method to do so: Method 1: Use MySQL Client inbuilt feature  To run single command: ! command or system command. eg ! uptime or system command  To get terminal ! bash or ! sh Method 2: Deploy external plugin (lib_mysqludf_sys) Step 1: Download lib_mysqludf_sys from github:git clone https://github.com/mysqludf/lib_mysqludf_sys.git Step 2: Install libmysqlclient15-dev, for Ubuntu you can use:apt-get install libmysqlclient15-dev Step 3: Note down o/p of:mysql -uroot -pxxxx -e "select ... Read More

Feed: AWS Compute Blog. Author: Eric Johnson. This post is courtesy of Moheeb Zara, Senior Developer Advocate – AWS ServerlessWelcome to the sixth edition of the AWS Serverless ICYMI (in case you missed it) quarterly recap. Every quarter, we share all of the most recent product launches, feature enhancements, blog posts, webinars, Twitch live streams, and other interesting things that you might have missed! In case you missed our last ICYMI, checkout what happened last quarter here. Before we dive in to all that happened in Q2, we’re excited about this quarter’s launch of Amazon EventBridge, the serverless event bus that ... Read More

Feed: Redis Labs. Author: Chris Cheung. Successful applications tend to become complex over time. A microservices architecture offers the ability to decompose your app into many loosely-coupled services organized around business capabilities, thereby alleviating some of the complexities. Of course, microservices are not a free lunch, but for most large, complex apps, they allow teams to deploy new features faster, scale more easily, and pick the best technology stacks. But what about distributed data? Each microservice is able to select the right database for the right job by employing a data model based on key-value, graph, hierarchical, JSON, streams, search, and ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Damian Widera. I have been frequently asked about the tools for the Machine Learnign projects There are lot of them on the market so in my newest post you will find my view on them. I would like to start my first Machine Learning project. But I do not have tools. What should I do? What are the tools I could use? I will give you some hints and advices based on the toolbox I use. Of course there are more great tools but you should pick the ones you like ... Read More