Tag: PostgreSQL

Feed: Planet PostgreSQL. FOSS4G 2017 is just a few weeks away. Many of the workshops will utilize OSGeoLive as a means for workshop participants to get up and running quickly with OSGeo Free and Open Source GIS tools and Boston data. OSGeoLive11 is a LUbuntu 16.04 distribution. OSGeoLive11 is going thru the final stages of prep. You can download the OSGeoLiveRC1 ISO for it from http://aiolos.survey.ntua.gr/gisvm/11.0/osgeo-live-11.0rc1-amd64.iso. Once OSGeoLive11 is fully prepped, it will be linked on the osgeolive site http://live.osgeo.org. If you want to run OSGeoLive11 from bootable media, you can burn the ISO to DVD or thumb drive and ... Read More

Feed: Planet PostgreSQL. One of the handy things Oracle does with dates is allow manipulation with standard arithmetic. Want tomorrow's date? Add one. Want a week ago? Subtract seven. Postgres does something close with its INTERVAL syntax, under the explanation that we don't necessarily want to make assumptions about what is being added to a date or timestamp. But Postgres has a big secret in the fact we can arbitrarily create operators to get the behavior we desire. No Place for Beginners or Sensitive Hearts So what happens if we happen to know that the developers and applications targeting the ... Read More

Feed: Planet PostgreSQL. Citus is Postgres that scales out horizontally. We do this by distributing queries across multiple Postgres servers—and as is often the case with scale-out architectures, this scale-out approach provides some great performance gains. And because Citus is an extension to Postgres, you get all the awesome features in Postgres such as support for JSONB, full-text search, PostGIS, and more. The distributed nature of Citus gives you new flexibility when it comes to modeling your data. This is good. But you’ll need to think about how to model your data and what type of database tables to use ... Read More

Feed: Planet MySQL; Author: Lukas Eder; In recent months, there had been some really exciting news from the MySQL team: These two SQL standard language features are among the most powerful SQL features that are available from most other databases. I frequently include them in conference talks about SQL (see my article about 10 SQL Tricks That You Didn’t Think Were Possible), and as well in the Data Geekery SQL Masterclass. With MySQL 8.0 now supporting these exciting features, the masterclass will be including MySQL as well (along with Oracle, SQL Server, PostgreSQL, and DB2). And, of course, these features ... Read More

Feed: Planet PostgreSQL. Oracle 7.3 supports it!That is how this all started. A gentleman tweeted about a Postgres limitation that Oracle has not had since at least since Oracle 7.3.  The problem As you can see in the tweet, Postgres by default will not defer a PRIMARY KEY check. Without the check being deferred the following will not work: postgres=# select * from demo; id  ----  1  2 (2 rows)postgres=# alter table demo add primary key(id);   ALTER TABLE postgres=# begin; BEGIN postgres=# update demo set id=id-1; UPDATE 2 postgres=# update demo set id=id+1; ERROR:  duplicate key value violates unique constraint ... Read More

Feed: Planet PostgreSQL. For most workloads the Postgres Autovacuum daemon works just fine. You go about your day with 3 workers that wake up once a minute to make sure that everything is nice and tidy. If things are dirty enough (around 10%) then one of the workers gets in gear and cleans things up. Unfortunately, if you have an inverted load from the norm, Autovacuum may not be able to keep up and you will suffer increased fragmentation and bloat. The norm The most common workload for Postgres (especially web based apps) includes many reads and some writes. It ... Read More

Feed: DB-Engines.com Blog. Author: Paul Dix. Blog > Postby Paul Dix (guest author), 20 July 2017Tags: InfluxDB, Time Series DMBSIn the middle of the big data hype cycle, before IoT was on the top of everyone’s buzz list, before Cloud Native was common lingo and before large enterprises were starting the work to de-silo their infrastructure monitoring and metrics data, Paul Dix, Founder of InfluxData, began building a purpose-built Time Series Platform. Flash forward to today, time series is now the fastest growing database segment, and the market is clearly moving beyond the re-purposed Cassandra and Hbase implementations that defined ... Read More

Feed: Planet MySQL; Author: Baron Schwartz (xaprb); Mon, Jul 10, 2017 in Databases Humor The removal of the query cache in MySQL 8.0 improves user experience and has been celebrated by many members of the MySQL community. With this good news, obviously, Hitler isn’t happy. (Parody Video). I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and lots of open-source software for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB. More about me. Comments ... Read More

Feed: IDERA Community Blog; Author: Vicky Harp; On Monday, June 12, 2017, a security researcher discovered that sensitive personal data of nearly all the 200 million registered voters from the USA was left exposed to the Internet. The owner stored the data on a publicly accessible cloud server -- Amazon Simple Storage Service (S3) object storage -- without any protection against public access. Consequently, anyone with an Internet connection could have accessed the data, simply by navigating to a six-character subdomain of Amazon. S3 is notorious for being left unlocked to the public, even by some of the largest organizations ... Read More

Feed: IBM Big Data & Analytics Hub - All Content; Author: chris-gillar; If you read a lot of development blogs nowadays, you’ll probably notice a common theme: developers don’t want to deal with databases. They want to focus on designing, building, testing, and deploying applications that deliver value to the business as quickly as possible.Because of this, developers often instinctively reach for whichever database platform minimizes the amount of time needed to design a schema, and allows them to get started fast. Focusing on the speed of development and the ability to “fail fast” is commendable, but this approach doesn’t ... Read More