Working with PostgreSQL in DevScribe

PostgreSQL is a widely used relational database for building web applications, backend systems, and data-driven applications.

DevScribe’s Database Client supports PostgreSQL, allowing you to connect to a PostgreSQL database and work with it alongside the rest of your development workflow.

Connect to a PostgreSQL Database

To connect a PostgreSQL database in DevScribe:

1. Open the Database plugin.
2. Create a New Connection.
3. Select Postgres as the database type.
4. Enter the connection details for your PostgreSQL database.

The connection form includes:

• Connection Name
• Host
• Port
• Default Database
• Username
• Password

The Default Database field is optional. You can leave it blank to browse all available databases.

Once the connection details are entered, use Test Connection to verify the connection before saving it.

Explore Your PostgreSQL Database

After connecting, your PostgreSQL database is available from the Database workspace.

You can explore the database structure and work with its tables and schemas directly from DevScribe.

This is useful when working with an existing application because you can inspect the database structure without leaving the same workspace where you’re working with your code, APIs, and documentation.

Run PostgreSQL Queries

DevScribe also provides a query workspace for working with your database.

You can write SQL queries to retrieve and inspect data from PostgreSQL.

For example:

SELECT * FROM accounts;

The query results can be viewed directly in DevScribe, making it easier to inspect database data while developing or debugging an application.

Work With PostgreSQL Alongside Your APIs

Databases and APIs are often closely connected.

An API endpoint may read information from PostgreSQL, update a record, or create a new entry. When both the API and database are available in the same development workspace, it becomes easier to understand how they work together.

You can test the API and inspect the underlying database without constantly switching between different tools.

Why Use PostgreSQL in DevScribe?

Working with PostgreSQL in DevScribe can be useful when you need to:

• Explore an existing PostgreSQL database
• Inspect tables and schemas
• Run SQL queries
• Check data while developing an API
• Understand how an application interacts with its database
• Keep database work alongside documentation and other development resources

Conclusion

DevScribe’s Database Client brings PostgreSQL into the same workspace as your APIs, code, documentation, and other development tools.

Whether you’re exploring a database, running queries, or investigating how an application interacts with PostgreSQL, you can work with the database without leaving your DevScribe workspace.