PostgreSQL

Ruby on Rails and Full-stack JavaScript

Recently, for a project I had to work on, I shifted from my regular routine of npm install to an entirely different stack built on a different …

Programming

From MySQL to PostgreSQL

In this article I will guide you through the steps I had to take to migrate Django projects from MySQL to PostgreSQL.<p>MySQL database has proven to be …

Databases

Why old-school PostgreSQL is so hip again

PostgreSQL (aka Postgres) is old as dirt, yet over the past five years it has panned out as pure gold. MongoDB got the billion-dollar IPO and AWS …

Databases

PostgreSQL 11 - Server-side Procedures (Part 1)

Last week marked a rather big step in the PostgreSQL world that went largely unnoticed. Thanks to the work done by 2ndQuadrant contributors, we now …

Databases

Expert Advice: NoSQL Options for Java Devs (Part 2)

A few months ago, I wrote about NoSQL Options for Java Developers. To create that post, I analyzed data from a variety of sources (Indeed jobs, …

Stack Overflow

Performance best practices for using Azure Database for PostgreSQL

Microsoft announced the public preview of Azure Database services for PostgreSQL and MySQL at Build 2017 which is a simple, fully managed database …

Cloud Computing

7 Reasons You Should Be Using PostgreSQL

PostgreSQL is an open source object-relational database system that has had more than 15 years of active development. Here are 7 reasons you should …

Programming

AWS re:Invent 2017: Amazon Aurora PostgreSQL headlines pre-show announcements

In the weeks leading up to re:Invent, Amazon has already a stream of data platform-related announcements. Early announcements, focused on gap-filling …

Cloud Computing

sum elements of json column postgres

I'm trying to sum all my elements of a specific type in a json column of the last 24 hours and I can't figure out my query...<p>So i have a json column …

JSON

How a single PostgreSQL config change improved slow query performance by 50x

At Amplitude, our goal is to provide easy-to-use interactive product analytics, so everyone can find answers to their product questions. In order to …

Python Programming

Why We Moved From NoSQL MongoDB to PostgreSQL

A couple of years ago, we moved our code base to a monorepo, which helped us scale tremendously in terms of code reuse and overall speed of …

MongoDB

Transaction Isolation Levels in PostgreSQL

Would you like to work with me? We are hiring engineers at SemaphoreCI. Apply here.<p>home<p>·<p>about<p>@igor_sarcevic · November 19, 2017<p>Misunderstanding …

Databases

Amazon Aurora expands reach, but maybe not far enough

Amazon has taken another big step in its quest to lure companies to swap out Oracle databases for AWS, but it can't remove every roadblock that might …

SEO

MariaDB, PostgreSQL, and MySQL

I am excited to join all of you virtually from Microsoft Connect(); and to share how we are broadening developer choice, joining communities, and …

Cloud Computing

Oracle Database Gateway for PostgreSQL - ORACLE-HELP

An organization have lot of choices to choose from the <b>RDBMS</b> world. <b>Oracle Database, Microsoft SQL Server, IBM DB2,PostgreSQL, MySQL</b> are few of them. …

Linux

Dbmgr

dbmgr is a command line tool for backing up and restoring databases. It's a useful tool for:<p>Backing up and restoring your development …

Databases

PostgreSQL master-slave replication on Heroku with Ruby on Rails

In that article I would like to explain what a <b>master-slave replication for PostgreSQL (postgres)</b> database means, how it could be useful for your <b>Ruby</b> …

Software Development

PostgreSQL Conference

<b>Join the Postgres Community in Seattle!</b><p>The Postgres Conference in conjunction with Seattle PostgreSQL User Group presents two days of educational …

Databases

Brytlyt is the fastest GPU database

London, UK -- (ReleaseWire) -- 11/13/2017 --After independent benchmarking by the leading expert in GPU Databases, Mark Litwintschik, Brytlyt's GPU …

Databases

PGConf Local: Seattle

Seattle / United States<br>November 13 - 14, 2017<p>PgConf US is thankful for support from our sponsors<p><b>Partner</b><p><b>Supporter</b><p>x<p>Command Prompt, Inc.<p><b>Media</b><p>Conference …

Databases

Best of PostgreSQL 10 for the Developer

2 weeks ago a new PostgreSQL major version with the number 10 was released (note the new numbering scheme!) and I already covered my favorite parts …

Databases

How to Install PostgreSQL 10 Using Source Code in Linux

<b>PostgreSQL</b> also called <b>Postgres</b> is a powerful and open source object-relational database system. It is an enterprise level database having features …

Linux

Big Data Transforms

(This article was first published on <b> R – Win-Vector Blog</b>, and kindly contributed to R-bloggers)As part of our consulting practice Win-Vector LLC has …

Data Science

How to Install and Configure Master-Slave Replication with PostgreSQL 9.6 on CentOS 7

PostgreSQL or Postgres is an open source object-relational database management system (ORDBMS) with more than 15 years of active development. It's a …

Linux

Upgraded ODBC Drivers with a Number of New Features

Devart, Czech software provider of database connectivity solutions and tools for database management and development, has announced the release of …

Microsoft SQL Server

Amazon Web Services adds PostgreSQL compatibility to its Aurora database

Public cloud computing giant Amazon Web Services Inc. has landed another blow against its rivals in the cloud database wars, announcing the general …

Cloud Computing

Now Available – Amazon Aurora with PostgreSQL Compatibility | Amazon Web Services

Late last year I told you about our plans to add PostgreSQL compatibility to Amazon Aurora. We launched the private beta shortly after that …

Cloud Computing

What it means to be a Postgres extension

Nearly 18 months ago, we open sourced our Citus distributed database and “unforked it” from PostgreSQL by refactoring Citus into a PostgreSQL …

Databases

Best PostgreSQL books, courses & tutorials 2017

PostgreSQL (also known as Postgres) is an object-relational database management system (ORDBMS). PostgreSQL was first released in 1996. some of it’s …

Databases

Think Cloud portable! Let Applications drive the Model

In our last intro to Modeling with Juju post we didn’t pay any attention to the hardware needed to run our workloads. We ran with Juju default values …

Cloud Computing