Postgres Archives - SD Times https://sdtimes.com/tag/postgres/ Software Development News Mon, 01 May 2023 19:33:31 +0000 en-US hourly 1 https://wordpress.org/?v=6.1.1 https://sdtimes.com/wp-content/uploads/2019/06/bnGl7Am3_400x400-50x50.jpeg Postgres Archives - SD Times https://sdtimes.com/tag/postgres/ 32 32 Vercel introduces a suite of serverless storage solutions https://sdtimes.com/data/vercel-introduces-a-suite-of-serverless-storage-solutions/ Mon, 01 May 2023 19:33:31 +0000 https://sdtimes.com/?p=51055 Vercel announced its suite of serverless storage solutions: Vercel KV, Postgres, and Blob to make it easier to server render just-in-time data as part of the company’s efforts to “make databases a first-class part of the frontend cloud.” Vercel KV is a serverless Redis solution that’s easy and durable, powered by Upstash. With Vercel KV, … continue reading

The post Vercel introduces a suite of serverless storage solutions appeared first on SD Times.

]]>
Vercel announced its suite of serverless storage solutions: Vercel KV, Postgres, and Blob to make it easier to server render just-in-time data as part of the company’s efforts to “make databases a first-class part of the frontend cloud.”

Vercel KV is a serverless Redis solution that’s easy and durable, powered by Upstash. With Vercel KV, it’s possible to generate Redis-compatible databases that can be written to and read from Vercel’s Edge Network in regions that you designate, requiring only minimal configuration.

Vercel Postgres is a serverless SQL database built for the frontend, powered by Neon. Vercel Postgres provides a completely managed, fault-tolerant, and highly scalable database that offers excellent performance and low latency for web applications. It’s specifically designed to work flawlessly with Next.js App Router and Server Components, as well as other frameworks like Nuxt and SvelteKit. This makes it easy to retrieve data from your Postgres database and use it to create dynamic content on the server with the same rapidity as static content.

Lastly, Vercel Blob enables users to upload and serve files at the edge, and is powered by Cloudflare R2. Vercel Blob can store files like images, PDFs, CSVs, or other unstructured data and it’s useful for files normally stored in an external file storage solution such as Amazon S3, files that are programmatically uploaded or generated in realtime, and more. 

“Frameworks have become powerful tools to manipulate backend primitives. Meanwhile, backend tools are being reimagined as frontend-native products. This convergence means bringing data to your application is easier than ever, and we wanted to remove the final friction point: getting started,” Vercel stated. 

Vercel KV, Vercel Postgres, and Vercel Blob are built on open standards and protocols, designed for low latency, efficient data fetching, and fully integrated with Vercel’s existing tools and workflows.

Additional details are available here

The post Vercel introduces a suite of serverless storage solutions appeared first on SD Times.

]]>
Pivotal launches transaction and streaming processing for Greenplum 6, Pivotal Postgres https://sdtimes.com/data/pivotal-launches-transaction-and-streaming-processing-for-greenplum-6-pivotal-postgres/ Tue, 19 Mar 2019 17:20:03 +0000 https://sdtimes.com/?p=34743 Pivotal is expanding the scope of its cloud-native enterprise platform with the release of Greenplum 6 and Pivotal Postgres. Announced today during the company’s Greenplum Summit in San Francisco, Pivotal says the new releases are part of a broader commitment to PostgreSQL. Greenplum 6 is more scalable and has greater concurrency over the previous iteration, … continue reading

The post Pivotal launches transaction and streaming processing for Greenplum 6, Pivotal Postgres appeared first on SD Times.

]]>
Pivotal is expanding the scope of its cloud-native enterprise platform with the release of Greenplum 6 and Pivotal Postgres. Announced today during the company’s Greenplum Summit in San Francisco, Pivotal says the new releases are part of a broader commitment to PostgreSQL.

Greenplum 6 is more scalable and has greater concurrency over the previous iteration, Pivotal said. It features improved performance in the analytics platform’s functions such as “point queries, data science exploration, fast event processing and long-running analytical queries.” The company says the integration of transaction and streaming processing with the platform’s analytics and AI features will “allow users to analyze more data without unwanted movement between niche database environments.”

Pivotal Postgres is an open-source Postgres package with modules for large production deployments. The company plans to add more over time, saying they want to allow developers to focus on their business problem rather than researching and acquiring all the right modules, with the right version compatibilities across the components.

“We’re offering Pivotal Postgres, because of PostgreSQL’s consistent market growth, flexibility and its enterprise readiness,” the company wrote in the announcement. “PostgreSQL is a remarkably versatile database. It can handle many data models including relational, object-relational, and graph, as well as many data types and languages. This allows developers to cast a broad net with Postgres and simplify their portfolio with fewer specialized data stores.”

 

The post Pivotal launches transaction and streaming processing for Greenplum 6, Pivotal Postgres appeared first on SD Times.

]]>
2014 Turing Award goes to MIT’s Michael Stonebraker https://sdtimes.com/acm/2014-turing-award-goes-to-mits-michael-stonebraker/ https://sdtimes.com/acm/2014-turing-award-goes-to-mits-michael-stonebraker/#comments Wed, 25 Mar 2015 16:45:55 +0000 https://sdtimes.com/?p=11599 The Association for Computing Machinery (ACM) has announced Michael Stonebraker as the 2014 ACM A.M. Turing Award recipient for his work in modern database systems. Stonebraker is a researcher at the Massachusetts Institute of Technology’s Computer Science and Artificial Intelligence Laboratory (CSAIL). “Mike has been a trailblazer in the field of databases by asking the … continue reading

The post 2014 Turing Award goes to MIT’s Michael Stonebraker appeared first on SD Times.

]]>
The Association for Computing Machinery (ACM) has announced Michael Stonebraker as the 2014 ACM A.M. Turing Award recipient for his work in modern database systems. Stonebraker is a researcher at the Massachusetts Institute of Technology’s Computer Science and Artificial Intelligence Laboratory (CSAIL).

“Mike has been a trailblazer in the field of databases by asking the essential questions about how we collect, organize and access information in our lives,” said Daniela Rus, director of CSAIL. “He has been both a devoted academic and a serial entrepreneur, and all of us at CSAIL are so inspired by his work and proud to have him as a colleague.”

According to the ACM, Stonebraker is a pioneer in database systems architecture, a founder of multiple database companies, and has invented a number of fundamental concepts found in most modern database systems today.

“Michael Stonebraker’s work is an integral part of how business gets done today,” said Alexander L. Wolf, president of the ACM. “Moreover, through practical application of his innovative database-management technologies and numerous business startups, he has continually demonstrated the role of the research university in driving economic development.”

This is the first year that the ACM Turing Award, also known as the Nobel Prize in Computing, comes with a US$1 million prize, funded by Google. And Alan Turing was back in the spotlight this year when a movie about his work in breaking codes during World War II was nominated for an Academy Award.

“The efficient and effective management of Big Data is crucial to our 21st-century global economy,” said Alan Eustace, senior vice president of knowledge at Google. “Michael Stonebraker invented many of the architectures and strategies that are the foundation of virtually all modern database systems.”

The ACM noted that database systems are one of the most commercially successful software systems and a vital part of today’s global economy. And thanks to Stonebraker’s work, he ensured their widespread adoption.

Some of Stonebraker’s recent work includes the development of Ingres and Postgres. With Ingres, he made major contributions such as query language design, query processing techniques, access methods and concurrency control. The release of Postgres introduced the object-relational model of database architecture, according to the ACM.

In addition, Stonebraker has developed one of the first distributed database systems—Distributed Ingres—and has been an advocate for a “no size fits all” approach to database systems architecture. Other contributions include real-time processing over streaming data sources, optimized database systems for complex queries, a distributed main-memory online transaction processing system, and an extreme-scale data-management and data-analysis system.

“It’s every computer scientist’s dream to get this award, and I am so very honored to be selected,” said Stonebraker. “It reinforces and validates the importance of the work that I have been doing alongside so many other researchers in the field of database management systems.”

Past winners have included Vint Cerf and Robert E. Kahn (2004); Peter Naur (2005); Frances E. Allen (2006); Edmund M. Clarke, E. Allen Emerson and Joseph Sifakis (2007); Barbara Liskov (2008); Charles P. Thacker (2009); Leslie G. Valiant (2010); Judea Pearl (2011); Shafi Goldwasser and Silvio Micali (2012); and Leslie Lamport (2013).

The ACM will present Stonebraker with the 2014 Turing Award at its annual awards banquet on June 20, in San Francisco.

The post 2014 Turing Award goes to MIT’s Michael Stonebraker appeared first on SD Times.

]]>
https://sdtimes.com/acm/2014-turing-award-goes-to-mits-michael-stonebraker/feed/ 1
Heroku lets you ‘Follow’ your database https://sdtimes.com/heroku/heroku-lets-you-follow-your-database/ Mon, 05 Nov 2012 00:00:00 +0000 https://sdtimes.com/?p=326 New service for Postgres databases hosted inside Heroku allows developers to create read-only copies on the fly … continue reading

The post Heroku lets you ‘Follow’ your database appeared first on SD Times.

]]>
Turns out, being a follower instead of a leader can be a good thing, at least when it comes to Postgres. Heroku announced last week that its in-PaaS database support for Postgres now includes the ability to create “Followers.” Followers are asynchronous, read-only copies of the databases developers rely on for their applications.

For developers, this means a direct copy of a running database can be spun up and used to replace the active one for upgrades, or when there is need for expanded capacity on the database tier.

Heroku is offering Followers as a solution to the problems associated with keeping a single database of information spread out across slaves in a cluster fashion. The service is available to all languages used on Heroku, and is also available in its standalone database services.

Craig Kerstiens is product manager of Heroku Postgres, and he said there are a number of use cases he’s seen from developers who participated in the earlier versions of this service, before it was formally announced.

“We have a lot of users that will maintain [a Follower] and keep it around for failover, so if something happens to the leader database, you can failover to [the Follower],” he said. “Then there are other users who bring them online for an hour or two to help with a burst of traffic. You can bring one online and split read traffic to it, and have write traffic go to your leader, and then get rid of [the Follower] later.”

Key to this capability is the fact that creating a Follower doesn’t slow down the primary database, said Kerstiens. “It does not interrupt the primary database. Under the covers, we capture a database backup, so we stream the write-ahead log and it’s archived elsewhere, so we can bring it online with no real impact on what you’re seeing on performance.”

Today, Kerstiens said he’s seen users with as many as four or five Followers up and running, and he said there’s no hard limit to how many can be used at once. Though he expects there will be some ceiling associated with capacity, he said users have not yet hit that limit.

The post Heroku lets you ‘Follow’ your database appeared first on SD Times.

]]>