Tag: PostgreSQL

Feed: Planet PostgreSQL. The first meeting of the Silicon Valley Postgres Meetup was last night. Amazon Web Services sponsored the facilities in Cupertino and Roland Lee from Hemdalldata presented on:How to Auto-Cache Postgres with no code changes. There were about 20 people in attendance as well as another half a dozen that participated via Amazon Chime. Debbie Cerda, our Director of Business Development flew out from Austin, Tx to host. When we launched the Silicon Valley Meetup we wanted to ensure that it would not conflict with the well respected San Francisco PUG. Based on initial response, there is not a ... Read More

Feed: Planet PostgreSQL. SQL extract provides access to the components of temporal data types—i.e. date, time, timestamp, and interval.SQL extract uses the keyword from to separate the field name from the value.EXTRACT( FROM )The field names are SQL keywords too—you must not put them in double or single quotes.SQL extract returns an exact numeric value. For second, it also includes fractions. The following table lists the extract fields defined by the SQL standard.Meaningextract fieldYearYEARMonthMONTHDay of monthDAY24 hourHOURMinuteMINUTESeconds (including fractions)SECONDTime zone hourTIMEZONE_HOURTime zone minuteTIMEZONE_MINUTERelated FeaturesExtract can only get single fields. To extract the full date (year, month, day) or time (hour, ... Read More

Feed: Planet PostgreSQL. Oh my goodness, Data Days! When we rescheduled PGConf US Local: Seattle from August to November we did so due to attendee feedback. It was amazing - people didn't want to go to a conference on Saturday in August (I wonder why). I know, we should have known but it was a new model and we tried. We are extremely pleased with the results of the shift in schedule. The conference now takes place during "professional hours" on "professional days." Because of the shift and sponsor support we have added three new tracks, reopened the CFP, and ... Read More

Feed: Google Cloud Big Data and Machine Learning Blog. Author: Google Cloud Big Data and Machine Learning Blog Team. Innovation in data processing and machine learning technology Friday, September 15, 2017 By Nick Mihailovski, Product Manager Editor’s note: Last week, the Google Data Studio team announced new features that make it even more useful for creating and sharing rich, visual reports that accelerate time-to-insight from data in a Google BigQuery-powered data warehouse. We’ve re-posted a version of the original announcement below for your convenience. Over the past six months we’ve launched over 25 new features in Google Data Studio including: ... Read More

Feed: Percona Database Performance Blog. Author: Colin Charles. Colin Charles  | September 15, 2017 |  Posted In: Database Poll, MongoDB, MySQL PREVIOUS POST In this blog post, we talk about the results of Percona’s time series database poll “What Database Engine Are You Using to Store Time Series Data?” Time series data is some of the most actionable data available when it comes to analyzing trends and making predictions. Simply put, time series data is data that is indexed not just by value, but by time as well – allowing you to view value changes over time as they occur. Obvious uses include ... Read More

Feed: Planet PostgreSQL. This talk is proving to be great content for those who are not necessarily Postgres Users. Last night I presented this talk at the Seattle Web Developers Meetup. The location was Adobe, next to Google and Tableau. I didn't even know there was a small tech complex on N. 34th in Seattle. There were about 27 people, which falls in line with the 50% rule of Meetups[1]. Here are my observations from the audience: Surprisingly the majority of developers were Python web developers (as a group) Many of them do not use Postgres and wanted to hear ... Read More

Feed: Planet PostgreSQL. Upcoming community awesomenessNow that summer is over and we have officially decided never to schedule anything in August again, we need to share a bunch of upcoming community goodness! PGConf US and NYCPUG are hosting: PGConf US Mini: NYC tomorrow! Bruce Momjian will be speaking on Postgres v10. This is the second mini that PGConf US has organized. The first was last May in Austin. It looks like a great lineup and turnout. Debbie Cerda will be hosting the Silicon Valley Postgres Meetup on September 19th with speakers Erik Brandsberg of Heimdall Data and Roland Lee on: How ... Read More

Feed: Microsoft Azure Blog. Author: Alessandro Segala. Node.js is arguably one of the most popular technologies in use on the cloud. Many devs all over the world have embraced this platform which, according to the 2017 survey by the Node.js Foundation, is being enjoyed by those who create back-end, front-end, mobile, and even desktop apps. At Microsoft, we are investing heavily in Node.js and JavaScript, which are first class citizens on Azure and across many other products. Whether you are a full-stack, a DevOps specialist, an architect or simply playing around with Node.js, these are seven of the (many) reasons ... Read More

Feed: Planet PostgreSQL. This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity. Partitioning in Postgres 10 and Beyond Monday, September 11, 2017 Postgres 10 is adding partitioning syntax to Postgres. This ends the previous Frankenstein-style partitioning setup of having to configure child tables, check constraints, and triggers or rules. You would think that the partitioning feature is now complete. Oh, no! It seems there are now more partitioning enhancement requests than we had before adding the syntax. I knew there would be new ... Read More

Feed: Planet PostgreSQL. “Thirty years ago, my older brother was trying to get a report on birds written that he’d had three months to write. It was due the next day. We were out at our family cabin in Bolinas, and he was at the kitchen table close to tears, surrounded by binder paper and pencils and unopened books on birds, immobilized by the hugeness of the task ahead. Then my father sat down beside him, put his arm around my brother’s shoulder, and said, ‘Bird by bird, buddy. Just take it bird by bird.’” — Bird by Bird: Some ... Read More