PostgreSQL

check resultset for emptiness in clojure jdbc

i'm using clojure with jdbc, compojure, cheshire, postgresql, c3p0, tryin make REST. When i'm using this code as handlerIf reslutset is not empty i …

Clojure

Big Dataset: Analyzing All Reddit Comments With ClickHouse

In this blog, I'll use ClickHouse and Tabix to look at a new very large dataset for research.It is hard to come across interesting datasets, …

Data Science

PostgreSQL says SCRAM to MD5 authentication

Version 10 improves replication, simplifies partitioningWith the release of PostgreSQL 10, the open source database's developers are farewelling the …

Databases

Postgresql + R Sandbox

(This article was first published on <b>--Jean Arreola--</b>, and kindly contributed to R-bloggers)<p>ElephantSQL<p>ElephantSQL offers a free instance of …

Databases

How to Streamline Query Times to Handle Billions of Records

Here at Sisense, we love a challenge. So when a client comes to us and tells us they need to find a way to run queries on billions of records without …

Big Data

An Introduction to Spatial Analytics With PostGIS, PL/R, and R

This is the first in a series of posts intended to introduce PostgreSQL users to PL/R, a loadable procedural language that enables a user to write …

DevOps

Microsoft at PostgresOpen 2017

Earlier this year at Microsoft Build, we announced the public preview of Azure Database for PostgreSQL. Since then, we have been engaging deeply with …

Cloud Computing

Picking Your First Database to Migrate to Amazon RDS or Amazon Aurora with PostgreSQL-compatibility | Amazon Web Services

<i>David Rader is the vice president of engineering at OpenSCG.</i><p><i>OpenSCG</i> <i>is an AWS Consulting Partner and a leading expert in PostgreSQL, helping customers</i> …

Cloud Computing

ClearDATA Expands AWS Service Delivery Portfolio

AUSTIN, Texas, Aug. 22, 2017 /PRNewswire/ -- As healthcare organizations continue to migrate their IT infrastructure and data to the cloud, …

Cloud Computing

Now available in India: Azure Database for MySQL and Azure Database for PostgreSQL

We recently announced public preview availability of Azure Database for PostgreSQL and MySQL in West and Central India. PostgreSQL and MySQL are …

Cloud Computing

Connecting to PostgreSQL on Linux for the first time — Boundless Suite 4.10.0 User Manual

Connecting to PostgreSQL on Linux for the first time¶<p>Note<p>This section uses the command line utility psql and optionally the graphical utility …

Linux

Announcing Azure Database for MySQL and Azure Database for PostgreSQL availability in India

We’re excited to announce the public preview availability of Azure Database for MySQL and Azure Database for PostgreSQL in India data centers …

Cloud Computing

Using Databases in R

Databases using dplyr<p>As well as working with local in-memory data stored in data frames, dplyr also works with remote on-disk data stored in …

Databases

Amazon wants your enterprise database

Amazon's awaited release of PostgreSQL on Aurora sharply raises the stakes in its competition with Oracle. Still in public preview, when will Aurora …

Databases

How to tune postgresql performance for OLTP application

postgresql come with average confirguration for average hardware, make it available for all people across the globe. if your hardware above the …

Databases

Leaky PostgreSQL passwords plugged

DBAs: strap on your patching boots. Every DB in your clusters needs workPostgreSQL has released three security patches for versions 9.6.4, 9.5.8, …

Databases

series

TimescaleDB vs. Postgres for time-series: 20x higher inserts, 2000x faster deletes, 1.2x-14,000x faster queries<p><i>This is the first in a series of</i> …

Databases

How to Install PostgreSQL 9.6 on CentOS/RHEL and Fedora

PostgreSQL is a powerful, highly scalable, open source and cross-platform object-relational database system that runs on Unix-like operating systems …

Linux

Strategy for Migrating Partitioned Tables from Oracle to Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL Compatibility | Amazon Web Services

<i>Sandeep Kariro is a big data architect and Akm Raziul is a database architect at Amazon Web Services.</i><p>Enterprises have been using closed-source …

Databases

Using PostgreSQL with Azure And Node.js

TL;DR — Here is a video that covers all of the content in this post in case you’re all like “I’m not reading all of this”.<p>Azure has released support …

Why bother with NoSQL databases? Choose PostgreSQL for IoT.

<i>IoT applications generate torrents of data. Postgres is powerful but scales poorly. With TimescaleDB you can scale Postgres by 20x and harness its</i> …

Databases

The What and Why of PostgreSQL Views

Anna Rankin stops by to discuss the choice to go with PostgreSQL views in order to automate processes and clean up application code.<p>Views are …

Programming

How To install and setup PostgreSQL 9.6 on Debian Linux 9

How do I Install and setup PostgreSQL version 9.6 database system on Debian Linux version 9.x?

Linux

Analyzing Ethereum, Bitcoin, and 1200+ other Cryptocurrencies using PostgreSQL

<i>Cryptocurrencies are fueling a modern day gold rush. Can data help us better understand this evolving market?</i><p><i>Update: Thank you everyone for making</i> …

Cryptocurrency

Top 5: Getting started with Python, Ansible to manage PostgreSQL, and more

In this week's Top 5, we highlight machine learning, games, DevOps, and more!Top 5 articles of the week5. Using open source tools to play Dungeons …

Machine Learning

How to Migrate Your Oracle Database to PostgreSQL | Amazon Web Services

<i>Knievel Co is a database engineer at Amazon Web Services.</i><p>This blog post provides an overview on how you can migrate your Oracle database to …

Cloud Computing

PostgreSQL in a time of Kubernetes

A lot of time has passed at Zalando since the first services were started backed by PostgreSQL 9.0-rc1. Despite the adoption of other technologies, …

DevOps

Azure Database for PostgreSQL team hosts Ask Me Anything session

The Azure Database for PostgreSQL team will host a special Ask Me Anything session on /r/Azure, <b>Thursday, June 22, 2017</b> from <b>9:00 am</b> to <b>1:00 pm Pacific</b> …

Microsoft Azure

Testing PostgreSQL for Fun

When Programming is Not Fun<p>When the iteration loop is long, programming becomes frustrating.<p>Let’s say you have to change a low-level system that …

Programming

Using Docker Compose for NodeJS Development

This post was originally published on the Codeship Blog and is posted here with the author's permission.<p>Docker is an amazing tool for developers. It …

DevOps