How Figma’s databases team lived to tell the scale
Our nine month journey to horizontally shard Figma’s Postgres stack, and the key to unlocking (nearly) infinite scalability.
Kubernetes- and OpenShift- ready migration to PostgreSQL
CYBERTEC Migrator is fully Kubernetes- and OpenShift-ready. We rely on modern container technology, which is perfect for quick deployment.
PostgreSQL to Microsoft Excel via Npgsql
Find out how you can integrate and store the use of data in PostgreSQL from Excel with Npgsql. For all Excel heroes here.
CYPEX - graphical PostgreSQL app development
CYPEX graphical PostgreSQL app development cuts your development costs by providing customers with instant visual feedback.
Oracle to PostgreSQL: Technical quick guide
This quick-start migration guide show various aspects you need to take into consideration when migrating from Oracle to PostgreSQL.
Feature complete migration from oracle to PostgreSQL
CYBERTEC Migrator is a feature-complete migration tool which allows you to facilitate Oracle migrations.
Scalefield - Get a first impression
Scalefield is a product developed by CYBERTEC that allows you to easily host PostgreSQL within your own private cloud.
Postgres.AI bot interview for PGSQL Phriday #015
Pavlo Golub is interviewing postgres.ai chat bot about UUIDs for PGSQL Phriday 015 initiated by Lætitia Avrot
PostgreSQL: Why true Open Source matters
Data oulives applications. Data matters. So does reliable and well maintained software as well. Read more about Open Source benefits.
Cloud Services and Fully Managed Postgres
Cloud services are not a thing to get around. Read more about what you should take in consideration when using Postgres Cloud services.
Implementing Raft: Part 4 - Key/Value Database - Eli Bendersky's website
Broken foreign keys: how can that happen in PostgreSQL?
Do you have a broken foreign key? This article shows possible causes for broken foreign keys, so that you know what to avoid in the future.
What you should know about PostgreSQL minor upgrades
Read all there is to know about minor upgrade in PostgreSQL: how, why and when to install them, and what if your software vendor forbids it.
Upgrading GitHub.com to MySQL 8.0
GitHub uses MySQL to store vast amounts of relational data. This is the story of how we seamlessly upgraded our production fleet to MySQL 8.0.
PGSQL Phriday #014: PostgreSQL Events
Participate in "PGSQL Phriday #014: PostgreSQL Events" blogging event. Post invites you to share your experiences, insights, and favorite moments
PostgreSQL on s390x
I am happy to announce PostgreSQL family is growing again, with the addition of IBM’s z-series architecture, called “s390x” in Debian terms.
The Query Strikes Again
On Thursday, 12 Oct. 2022, the EMEA part of the Datastores team — the team responsible for Slack’s database clusters — was having an onsite day in Amsterdam, the Netherlands. We’re sitting together for the first time after new engineers had joined the team, when suddenly a few of us were paged: There was an…
Using multiple triggers on the same table in PostgreSQL
What happens if you deploy many triggers on the very same PostgreSQL table? What order do the multiple triggers fire in?
ERROR: current transaction is aborted in PostgreSQL
ERROR: current transaction is aborted, commands ignored until end of transaction block in PostgreSQL: what it means & how to fix this error.
D1: open beta is here
D1 is now in open beta, and the theme is “scale”: with higher per-database storage limits and the ability to create more databases, we’re unlocking the ability for developers to build production-scale applications on D1
Vectorize: a vector database for shipping AI-powered applications to production, fast
Vectorize is our brand-new vector database offering, designed to let you build full-stack, AI-powered applications entirely on Cloudflare’s global network: and you can start building with it right away
Getting Started With Neon Branching — Smashing Magazine
Branches are a really nice (and safe) way to configure or reconfigure your database without fear of screwing up the production database. Let’s take a closer look at how branching works with [Neon](https://bit.ly/46cEgX1), and the good news is, you probably already know how it works!
Citus: 7 commonly used advanced SQL tools
How to use 6 commonly-needed SQL tools in Citus. When you run advanced SQL in Citus, what's possible? What SQL statements work? Find out.
Citus: Row store vs. column store in PostgreSQL
Row store vs. column store - what is the best option? Are column stores “always cool”? Find out in the context of PostgreSQL and Citus.
"hired" vs. "fired" - fuzzy search in PostgreSQL
How to implement community open source PostgreSQL to do a fuzzy search & get better results. Find out how to use the fuzzystrmatch extension.
Data locality: Scaling PostgreSQL with Citus intelligently
How to use data locality to increase performance while sharding PostgreSQL data with Citus. What is database locality
Conditional foreign keys and polymorphism in SQL: 4 Methods
How to model conditional foreign keys: 4 methods to transfer a reference to a polymorphic type to SQL. Explore how PostgreSQL features like JSON support and table inheritance can help.
Postgres v16: 14 Cool New Features
Find out what PostgreSQL v16 has to offer, what the top new features will be and why the new postgres is so cool and useful.
Indexing "LIKE" in PostgreSQL and Oracle
How to index LIKE conditions in PostgreSQL and Oracle. Answers the question: Why is LIKE indexing simpler in Oracle? Is it better?
Cloudflare Workers database integration with Upstash
Announcing the new Upstash database integrations for Workers. Now it is easier to use Upstash Redis, Kafka and QStash inside your Worker
Reproducible builds: a PostgreSQL query optimization example
Learn how to rewrite a query to speed up performance - a practical example where Christoph speeds up a PostgreSQL query by a factor of 27,000
Lessons Learned Running Presto at Meta Scale - High Scalability -
Presto is a free, open source SQL query engine. We’ve been using it at Meta for the past ten years, and learned a lot while doing so. Running anything at scale - tools, processes, services - takes problem solving to overcome unexpected challenges. Here are four things we learned while scaling up Presto to Meta scale, and some advice if you’re interested in running your own queries at scale. Scalin
Subqueries and performance in PostgreSQL
This article discusses how subqueries perform in PostgreSQL and how to rewrite queries to improve their performance.
Use HOT, so CLUSTER won't rot in PostgreSQL
How to use HOT updates to maintain the row order established by CLUSTER to get efficient index scans in PostgreSQL.
ERROR: invalid byte sequence - Fix bad encoding in PostgreSQL
Fix ERROR: invalid byte sequence for encoding - Wrong encoding causes data corruption in PostgreSQL. How to fix bad encoding.
D1: We turned it up to 11
We've been heads down iterating on D1, and we've just shipped a major new version that's substantially faster, more reliable, and introduces Time Travel: the ability to restore a D1 database to any point in time.
PostgreSQL ALTER DEFAULT PRIVILEGES - permissions explained
ALTER DEFAULT PRIVILEGES command for PostgreSQL permissions explained: learn how to use it correctly, know its pitfalls and use cases.
Announcing database integrations: a few clicks to connect to Neon, PlanetScale and Supabase on Workers
Today we’re announcing Database Integrations – making it seamless to connect to your database of choice on Workers.
Let’s party and upgrade PostgreSQL and PostGIS together
Learn how to upgrade PostGIS together with PostgreSQL all in one go. Step by step instructions using pg_upgrade.
Improved support for Nuxt on Vercel
Nuxt on Vercel now supports KV for Redis, Incremental Static Regeneration, and more.
Introducing storage on Vercel
New to the Vercel dashboard: Vercel KV, Vercel Postgres, and Vercel Blob. Announcing serverless storage solutions available on Vercel.
The growing pains of database architecture
How the Figma infrastructure team reduced potential instability by scaling to multiple databases
Stored procedures in PostgreSQL: getting started
Learn all about stored procedures in PostgreSQL right here with examples created by a database expert. Includes syntax & tips
PostgreSQL: Finding the current timestamp
How can I find the current timestamp in PostgreSQL? Read more about real time, statement time and transaction time.
ShopifyQL Notebooks: Simplifying Querying with Commerce Data Models - Shopify
We recently released ShopifyQL Notebooks, a powerful self-serve tool which enables merchants to explore their business metrics without any SQL expertise. Here’s how we used ShopifyQL and commerce data models to make it possible.
Reserve connections in PostgreSQL 16
A brand-new patch in PostgreSQL 16 provides a way to reserve connection slots for non-superusers. Find out the news here!
Transaction ID wraparound: a walk on the wild side
Have you ever seen data corruption from transaction ID wraparound? Avoid PostgreSQL performance problems - read here what causes it.
A unique constraint where NULL conflicts with everything
A cute solution for an unusual request for a unique constraint in PostgreSQL. This blog showcases range data types & exclusion constraints.
Pagination and the problem of the total result count
This article compares pagination methods for PostgreSQL and their performance. Also, avoid displaying the total result count!
hex, oct, bin integers in PostgreSQL 16
NEW in PostgreSQL 16 - support for non-decimal notation of integer constants. Find out how the changes will affect you-- adds possibilities!
I Migrated from a Postgres Cluster to Distributed SQLite with LiteFS
Why and how I migrated from distributed postgres to distributed sqlite on kentcdodds.com
Making static sites dynamic with Cloudflare D1
In this blog post, I'll show you how to use D1 to add comments to a static blog site. To do this, we'll construct a new D1 database and build a simple JSON API that allows the creation and retrieval of comments.
Xata Workers: client-side database access without client-side secrets
Xata is on a mission to solve the industry’s hardest data problems with their Serverless Data Platform. We’re excited to have Xata building their serverless functions product – Xata Workers – on top of Workers for Platforms. Here is Xata’s story.
Easy Postgres integration on Cloudflare Workers with Neon.tech
Neon.tech is a database platform that allows you to branch your (Postgres compatible) database exactly like your code repository. And with the release of their Cloudflare Workers integration you can get started in minutes
Putting The Graph In GraphQL With The Neo4j GraphQL Library — Smashing Magazine
If building a GraphQL API backed by a native graph database sounds interesting or at all helpful for the problems you’re trying to solve as a developer, perhaps you’d like to give the open-source [Neo4j GraphQL Library](https://srv.buysellads.com/ads/long/x/TCZPLYDDTTTTTTFR6JINCTTTTTTGVUIVKKTTTTTTCT2NTYYTTTTTTI4BVH7U4JBCKQ466IDGV2IUWESGCV7WALL5QYYE) a try. Let’s take a closer look at the reasons w
Why and how GitHub encrypts sensitive database columns using ActiveRecord::Encryption
You may know that GitHub encrypts your source code at rest, but you may not have known that we encrypt sensitive database columns as well. Read about our column encryption strategy and our decision to adopt the Rails column encryption standard.
pgbouncer: Types of PostgreSQL connection pooling
Connections are not free. Conserve your resources - find out about connection pooling in PostgreSQL with pgbouncer.
VACUUM does not shrink my PostgreSQL table
Did you ever wonder why VACUUM does not shrink PostgreSQL data files? Learn all the most useful secrets of VACUUM.
Safely Adding NOT NULL Columns to Your Database Tables - Shopify
Recommendations from Shopify's Data Migrations team for adding NOT NULL columns safely to your own database tables, based on a recent investigation into schema change safety using using the popular Large Hadron Migrator (LHM) gem.
LISTEN / NOTIFY: Automatic client notification in PostgreSQL
If 1000's of users constantly poll the database, a lot of load is caused for no benefit. LISTEN / NOTIFY is a better way, find out how.