Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add blog post on "How to Configure FerretDB to work on Percona Distribution for PostgreSQL" #2911

Merged
merged 10 commits into from
Jun 27, 2023
Prev Previous commit
Next Next commit
update blog
  • Loading branch information
Fashander committed Jun 26, 2023
commit 366a5a47e4d7cd5251e873fb02a16092b0589e7f
Original file line number Diff line number Diff line change
Expand Up @@ -4,13 +4,13 @@ title: 'How to Configure FerretDB to Work on Percona Distribution of PostgreSQL'
authors: [alex]
description: >
In this article, we’ll guide you through the advantages of using FerretDB and how you can configure it to work natively on Percona Distribution of PostgreSQL.
image: /img/blog/ferretdb-percona-postgres.jpg
image: /img/blog/percona-ferretdb.png
keywords:
[enterprise postgresql, run mongodb workload on postgresql, postgresql tools]
tags: [tutorial, postgresql tools]
---

![Meet FerretDB at Percona University in Casablanca and Belgrade](/img/blog/ferretdb-percona-postgres.jpg)
![Meet FerretDB at Percona University in Casablanca and Belgrade](/img/blog/percona-ferretdb.png)
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I don't think this alt text is accurate


Imagine being able to leverage the flexibility and simplicity of the MongoDB query language through FerretDB together with the robust enterprise PostgreSQL tools and services provided by Percona.

Expand All @@ -22,13 +22,17 @@ In this article, we'll guide you through the advantages of using FerretDB and ho

Before we go into the technical details, let's find out what these two solutions are all about.

## What is Percona Distrubution of PostgreSQL
## What is Percona Distrubution of PostgreSQL?
AlekSi marked this conversation as resolved.
Show resolved Hide resolved

[Percona Distribution for PostgreSQL](https://www.percona.com/software/postgresql-distribution) is a software package provided by Percona, a world-class company that provides open source database software, support, and services.

Basically, this is a distribution of the PostgreSQL database management system (DBMS) that includes enhanced features to make it more manageable, scalable, and performant.

PostgreSQL database, widely used by millions of developers across the globe, has had a significant impact on open-source development.

![PostgreSQL Database](/img/blog/postgresql.png)
_source: [PostgreSQL website](https://www.postgresql.org/)_

Many software companies have built their applications on top of the database, extended its functionality, and provided robust infrastructures and services for it.
Percona is one of those companies, and have contributed immensely to the ecosystem with their array of PostgreSQL tools, extensions, and services.

Expand Down Expand Up @@ -139,7 +143,7 @@ We've connected to the Percona server for PostgreSQL and we're ready to start us

Note that FerretDB provides a list of flags for configuring your database – see them [here](https://docs.ferretdb.io/configuration/flags/).

Now let's access the PostgreSQL command line:
From a new terminal, let's access the PostgreSQL command line:

```sh
sudo su - postgres -c psql
Expand Down Expand Up @@ -179,7 +183,7 @@ mongodb://username:password@127.0.0.1/ferretdb?authMechanism=PLAIN
```

After setting up the connection, navigate and switch the context to the `ferretdb` database.
Let's insert some documents through the shell on Studio 3T.
Using the Intellishell, let's insert some documents through the shell on Studio 3T.

```js
db.test.insertMany([
Expand Down Expand Up @@ -238,6 +242,8 @@ db.test.insertMany([
])
```

![Displaying data through Studio 3T](/img/blog/displaying-studio3t-data.png)

What we want to do now is to explore and view the data we just inserted through FerretDB on the Percona server for PostgreSQL.

In your terminal, we will open a new `psql` terminal that takes us directly to the `ferretdb` database we created earlier, and contains our data.
Expand Down
3 changes: 3 additions & 0 deletions website/static/img/blog/displaying-studio3t-data.png
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
3 changes: 0 additions & 3 deletions website/static/img/blog/ferretdb-percona-postgres.jpg

This file was deleted.

3 changes: 3 additions & 0 deletions website/static/img/blog/percona-ferretdb.png
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

That image uses a wrong product name

Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
3 changes: 3 additions & 0 deletions website/static/img/blog/postgresql.png
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.