Tag: PostgreSQL

Feed: Planet MySQL; Author: Peter Gulutzan; Let's start by combining one new MariaDB feature -- VALUES (5) which is the standard equivalent of the old non-standard "SELECT 5" -- with another new feature in MariaDB 10.3.5, the FOR ... END FOR statement. mariadb>BEGIN NOT ATOMIC > DECLARE v INT DEFAULT 0; > FOR a IN (VALUES (7)) DO SET v = v + 1; END FOR; > SELECT v; >END; Error 2013 (HY000) Lost connection to MySQL server during query Oops. However, the MariaDB folks now know about this, it's bug MDEV-15940" and they know about the other bugs that ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; Encountered a problem while running the RODBC library from the R prompt as the root user, as follows: > install.packages('RODBC') It failed with the following library dependency: checking for unistd.h... yes checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package ‘RODBC’ * removing ‘/usr/lib64/R/library/RODBC’   The downloaded source packages are in ‘/tmp/RtmpdT1gay/downloaded_packages’ Updating HTML index of packages in '.Library' Making 'packages.html' ... done Warning message: ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dave Avery  | April 23, 2018 |  Posted In: MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL PREVIOUS POST Announcing the Percona Live 2018 live stream. This year at Percona Live Open Source Database Conference 2018 we are live streaming the Keynote Talks on Day 1 and 2. Percona is streaming the keynotes on Tuesday, April 24, 2018, and Wednesday, April 25, 2018 beginning at 9 AM PDT (both days). The keynote speakers include people from VividCortex, Upwork, Oracle, Netflix and many more. The keynote panels feature a cloud discussion and a cool technologies showcase. Use the live stream link if you don’t want ... Read More

Feed: Planet PostgreSQL. It has been awhile since I posted anything. Thought I would start back with a software package I use in many different situations, psycopg2 . Psycopg2 is a Python database adapter for Postgres that follows the Python DB API. It is feature rich and today I will introduce a feature new to the latest major release(2.7), namely the sql module for building complete SQL statements dynamically. I will give a quick run down of the basics below. For the official docs on the module see: http://initd.org/psycopg/docs/sql.html#module-psycopg2.sql. For example data I will be using the Pagila database (derived ... Read More

Feed: Planet PostgreSQL. We all love PgBouncer. It’s a great way to multiplex tens, hundreds, or even thousands of client connections to a small handful of Postgres sessions. What isn’t necessarily so endearing, is that it can’t pass authentication from itself to Postgres, as each Postgres session may exist before the connection to PgBouncer is established. Or can it? Let’s explore how things have evolved, but the news never really got out. Tell you what I got in mind As a proxy, PgBouncer authenticates on a per user/database basis. Since Postgres authenticates sessions before they connect, PgBouncer used to have ... Read More

Feed: Planet MySQL; Author: Marco; Well here we go another MySQL conference / Percona Live.Another huge and important event/milestone for the MySQL community.  But this time I will not be there. First time in many years I had to decline, drop my speech and say... "No I am so sorry, this time I cannot come". Was not an easy choice, not only because I am always excited to meet old colleagues, but also because PLSC is a great moment for brainstorming and to identify what could be good to push-on or to investigate better. Especially this year where we have ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles  | April 13, 2018 |  Posted In: Amazon Aurora, AWS, MariaDB, MongoDB, MyRocks, MySQL, Percona Monitoring and Management, Percona Software, Percona XtraBackup, ProxySQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live is just over a week away — there’s an awesome keynote lineup, and you really should register. Also don’t forget to save the date as Percona Live goes to Frankfurt, Germany November 5-7 2018! Prost! In acquisitions, we have seen MariaDB acquire MammothDB and Idera acquire Webyog. Some ... Read More

Feed: The Information Lab. Author: Pablo Saenz de Tejada. 18 April, 2018 | Pablo Sáenz de Tejada Maestro Beta Overview All the information in this post is based on the Project Maestro Beta 4 release. Functionality and options available might change when the product is officially released. Probably you have already heard about Project Maestro, Tableau’s coming soon ETL tool that allows us to have a fast and visual overview of our data and to prepare, cleanse and blend it easily to at the end output it to Tableau. There isn’t an official release date but in the meantime you ... Read More

Feed: Planet PostgreSQL. Introduced in OmniDB 2.6.0, the new OmniDB Console Tab provides an easy and comfortable way to interact with your databases. Users familiar with the psql command line utility will find that Console Tab behaves very similarly. In fact, many of the backslash commands Console Tab provides are present in psql. For example, ? shows a list with all commands available, its syntax and description. The command h can be another friend of yours, because it shows a comprehensive help about any PostgreSQL SQL command. The editor on the bottom of the tab area is full-featured just like ... Read More

Feed: Microsoft Azure Blog. Author: Christine Alford. Kentico on Windows Server 2012 R2: Kentico CMS is a free edition web content management system for building websites, online stores, intranets, and community sites. Create, manage, and integrate communities socially to encourage conversations about your brand. OpenText Process Suite 16.3 Marketplace Info VM: With intelligently automated, content-rich processes that you can quickly build and easily modify, Process Suite gives you the power to deliver a variety of new digital experiences with a much lower IT workload. Content Suite 16 (January 2018): OpenText Content Suite Platform is a comprehensive enterprise content management (ECM) ... Read More