Vertica Blog

Vertica Blog

Open Source

Go programming language logo and little blue beaver mascot

The Vertica SQL Driver for Go

Roger Huebner, Distinguished Engineer
July 11, 2019

We are happy to announce the alpha release of the Vertica SQL Driver for Go. Go, also called GoLang, is a statically-typed, high performance language, syntactically similar to C. Originating at Google, it has grown rapidly in popularity over the past decade and has become a language of choice for highspeed components. The Vertica SQL...
Machine learning robot studying equations and graphs

1 – Why Would You Do Machine Learning in a Database?

Waqas Dhillon, Product Manager - Machine Learning, Vertica
April 22, 2019

Co-authored with Paige Roberts. A lot of modern scalable analytical databases like Vertica allow you to do machine learning data analytics from end to end, right in the database, rather than moving and transforming the data first into something like a Spark dataframe or a Python data structure. Whenever people hear about this capability, they...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 6. Advantages of In-Database Machine Learning

Paige Roberts, Vertica Open Source Relations Manager
March 13, 2019

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. This is the final installment of the discussion. It was a lot of fun catching up and talking shop. In this final interview post, we talked about some of the advantages of doing...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 5. Vertica, KNIME, Python and the New Uber Created Vertica-Python Interface

Paige Roberts, Vertica Open Source Relations Manager
March 11, 2019

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and have been posting them one chunk at a time. In this post, we discuss how open source and Vertica interact, with focus on...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 4. How You Can Help With Your Favorite Open Source Project Without Being an Expert

Paige Roberts, Vertica Open Source Relations Manager
March 7, 2019

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and have been posting them one chunk at a time. In this post, Potts gives a few tips on how anyone who...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 3. Exciting News for Upcoming Python Release 3.8

Paige Roberts, Vertica Open Source Relations Manager
March 6, 2019

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and have been posting them one chunk at a time. In the first post, we discussed the wide variety of programming languages...
Cute cartoon puppy with Free Puppy sign

Open Source Software is Free, Like a Puppy

Joy King, VP Product & GTM Strategy, Vertica
March 4, 2019

Open source software has a long and inspiring history. In the very early days of software itself, academic collaboration was the norm. But in the late 70’s and early 80’s, manufacturers increasingly copyrighted their technologies, protected their source code, and required licensed use of software. The era of commercial software was born. Freedom! Richard Stallman...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 2. Advantages of KNIME and Letting Databases Do What Databases Do Best

Paige Roberts, Vertica Open Source Relations Manager
February 27, 2019

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and will post them up one subject at a time. In this second post, we discuss the advantages of KNIME for a...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 1. On Becoming a Core Python Committer and the Tools Used to Build Data Science

Paige Roberts, Vertica Open Source Relations Manager
February 26, 2019

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and will post them up one subject at a time. In this first post, we discussed the wide variety of programming languages...

Plotting data with vsql and gnuplot

Phil Molea, Sr. Information Developer, Vertica
December 6, 2018

Maurizio Felici authored this post. We all know how plotting data is a very useful – and widely adopted – technique. Linux (and MacOS) offer a wonderful command line tool to plot data called gnuplot. You can install and run gnuplot on one of your Vertica nodes so you don’t have to move data out...

Exporting to Parquet: Quick Tip

Phil Molea, Sr. Information Developer, Vertica
August 29, 2018

Jim Knicely authored this tip. Vertica can export a table, columns from a table, or query results to files in the Parquet format. dbadmin=> EXPORT TO PARQUET (directory = '/home/dbadmin/dim') AS SELECT * FROM dim; Rows Exported --------------- 1 (1 row) One restriction is the path to export must not exist. How do I get...

Introducing the Parallel Streaming Transformation Loader (PSTL) Solution

Soniya Shah, Information Developer
March 19, 2018

This blog post was authored by Soniya Shah. At Vertica, we understand how important it is that our customers can make decisions in near real time. Being able to do this not only requires the massive parallel processing that Vertica offers, but the ability to transform and ingest your data into Vertica as quickly as...