DEV Community: Prachi

Introduction to Creating Extensions in PostgreSQL with C : Part-2

Prachi — Mon, 31 Jul 2023 07:14:54 +0000

Setting up the Development Environment is the first step.
Ensure that PostgreSQL and the required development libraries and headers are installed. You may install them using the package manager on the majority of systems.
Also, add a PostgreSQL binary path to your environment, to ensure that pg_config is there in the path.
Now we will create an extension 'addtwonumbers' that will add two numbers.

$ mkdir addtwonumbers

Now for building the extension we will create a Makefile.
We also need a control file addtwonumbers.control with the following content:

comment = 'Simple number add function'
default_version = '0.0.1'
relocatable = true
module_pathname = '$libdir/addme'

And then prepare the function and run the following command to make the file

#include "postgres.h"
#include "fmgr.h"

PG_MODULE_MAGIC;

PG_FUNCTION_INFO_V1(addme);

Datum
addtwonumbers(PG_FUNCTION_ARGS)
{
int32 arg1 = PG_GETARG_INT32(0);
int32 arg2 = PG_GETARG_INT32(1);

PG_RETURN_INT32(arg1 + arg2);
}

`$ make`

And now we can install the extension: $ sudo make install

Reference: https://www.percona.com/blog/postgresql-simple-c-extension-development-for-a-novice-user/

Introduction to Creating Extensions in PostgreSQL with C : Part-1

Prachi — Mon, 31 Jul 2023 07:02:13 +0000

Worldwide, developers utilise PostgreSQL, an open-source relational database management system (RDBMS) that is robust and adaptable. Extensions support is one of the most important features of PostgreSQL, it gives programmers the capabilities to expand the database through introduction of custom data types and functions.

C, C++, Python, and more programming languages are supported by PostgreSQL for extension development. While other languages are simple and convenient, there are several important benefits to adopting C for extensions:

One may create highly optimised and effective programmes using the low-level programming language C. This is especially important for extensions that need to do complex computations because it allows for seamless integration with the core of PostgreSQL for improved performance.
One can have complete control over memory management, data structures, and system resources while using C, allowing you to optimise extension's performance.
Since many of PostgreSQL's key features are implemented in C, extensions that require close interaction with the database's internals frequently use it.

PostgreSQL Replication (Part 3)

Prachi — Mon, 17 Jul 2023 01:05:09 +0000

Modes of Replication in PostgreSQL Database :

Synchronous mode of Replication : Transactions on the master database in this mode are not considered complete until all replicas have received the modifications. For the transactions to successfully complete on the master, all of the replica servers must be up at all times.

Asynchronous mode of Replication : When changes have only been made on the master server in this mode, transactions on the master server can be deemed complete. Later, these modifications are reproduced to the copies.

Types of PostgreSQL Database Replication?

Physical Replication of PostgreSQL Database :
In Physical replication, we deal with with files and directories.
Physical replication is done at file system level or disk level.
Logical Replication of PostgreSQL Database :
In Logical Replication, we deal with databases, tables, and DML operations.
Logical replication is done at the database cluster level.

PostgreSQL Replication (Part 2)

Prachi — Mon, 17 Jul 2023 01:04:31 +0000

PostgreSQL Replication

Models of PostgreSQL Database Replication :
Single-Master Replication (SMR) : This process replicates modifications to table rows in a selected master database server to one or more replica servers. The replica database's replicated tables are not allowed to accept any changes (apart from those made by the master). Changes are not replicated back to the master server, even if they occur.
Multi-Master Replication (MMR) : This method replicates changes to table rows in multiple designated master databases to the corresponding tables in all other master databases. Conflict resolution techniques are frequently used in this paradigm to prevent issues like multiple main keys.

Classes of PostgreSQL Replication :
Unidirectional Replication : Since in single-master replication data only moves in one direction, from master to replica, single-master replication is often referred to as unidirectional replication.
Bidirectional Replication : On the other side, data from Multi-Master Replication travels both ways and is referred to as bidirectional replication.

Data Replication

Prachi — Fri, 30 Jun 2023 11:54:39 +0000

PostgreSQL Replication refers to the process of copying data from one PostgreSQL database server to another server.
A key idea in database administration is data replication, which gives essential systems high availability, fault tolerance, and scalability. Data replication is essential for assuring data durability, reducing downtime, and dispersing the workload over different servers in PostgreSQL, a powerful and feature-rich open-source relational database.

Data replication has a variety of applications:

Online transactional processing (OLTP) performance: the transaction processing time and query time of an OLTP system can be improved by removing reporting query load.
Fault Tolerance: The replica server can take over in the event that the master database server fails,
Data Transfer
Testing Systems in Parallel: Results on the same data from the old and new systems must be compared when moving an application from one DBMS to another to make sure the new system performs as intended.

Reference: Data Replication
Data Replication in PostgreSQL

Wails and Echo framework with Go Language

Prachi — Mon, 01 May 2023 12:34:31 +0000

Two well-liked Go programming frameworks for creating web applications are Wails and Echo. Even if they have certain commonalities, they are made for various uses and scenarios.

Developers may construct cross-platform desktop applications with a native feel and look using Wails, a desktop application framework for Go. It blends web development's ease of use with Go's strength to produce programmes that work on Windows, macOS, and Linux.

The user interface of Wails, which was created using HTML, CSS, and JavaScript, is shown using a web view. The application's backend logic, which is built in Go, can be used to access system resources, communicate with the file system, and carry out other operations.

On the other side, Echo is a web framework for Go that is intended for creating APIs and online applications. It offers a selection of features and tools for creating cutting-edge online apps and is lightweight, quick, and versatile.

Echo offers middleware for handling functions like authentication, logging, and error handling and uses a router to manage HTTP requests. Additionally, it supports WebSocket communication, session management, and template rendering.

In conclusion, Echo is a web framework that is used to construct web apps and APIs, whereas Wails is a desktop application framework that employs web technologies to create native desktop applications. Both frameworks are well-liked and each has particular advantages and applications.

Applications in Go Language built on CRUD properties:

Prachi — Mon, 01 May 2023 12:26:10 +0000

Numerous Go-built applications that use CRUD operations are available. Here are a few instances:

Social media platform: A social media platform made using Go can leverage CRUD operations to help users upload new content, browse already-posted content, edit their own content, and delete content that is no longer required.
Blogging platform: A blogging platform made using Go can leverage CRUD operations to let users publish new blog entries, read previously published entries, edit or delete entries that are no longer necessary, and so on.
Go-based task management systems can leverage CRUD operations to help users add new tasks, examine already-existing tasks, edit task details like due dates or statuses, mark completed tasks as well as delete tasks that are no longer necessary.
E-commerce website: A Go-based e-commerce website can use CRUD operations to let users add new product listings, examine already-existing products, change the prices or other details of current products, and remove products that are no longer in stock.
Contact management system: A Go-based contact management system can use CRUD operations to let users add new contacts, view their existing contacts, edit their contact details, and delete contacts who are no longer required.

CRUD: Create, Read, Update and Delete

Prachi — Mon, 01 May 2023 12:21:35 +0000

CRUD, or Create, Read, Update, and Delete, is an acronym. It alludes to the four fundamental procedures that are frequently carried out on the information in a database or web application.

A software programme known as a CRUD application enables users to carry out these four fundamental actions on data that is stored in a database or other type of data storage system.

Create: This procedure entails updating the database with fresh information. For instance, a user might create a new contact in a contact management system by entering their name, email address, and phone number into a form and sending it to the system.
Read: Retrieving current data from the database is what this action entails. An individual might read a post or look at a user's profile on a social media platform, for instance.
Update: This process entails changing the database's current data. A user might alter their order or amend their shipping address, for instance, in an e-commerce system.
Delete: Data is deleted during this process from the database. An administrator in a content management system, for instance, could revoke a user account or delete a blog post.

CRUD apps are frequently used in web development because they offer a straightforward and standardised method of working with data. Creating CRUD apps is supported natively by a number of web frameworks and libraries, including Ruby on Rails and Django.e

Go Language: Why should you use it?

Prachi — Mon, 01 May 2023 12:16:22 +0000

Google created the programming language Go, sometimes referred to as Golang, in 2007. Go is an open-source, user-friendly programming language that may be used for a variety of purposes. Here are a few justifications for using Go in your upcoming project.

Go is a straightforward and simple-to-learn programming language that doesn't need much setup or configuration. It is perfect for both inexperienced and seasoned developers due to its straightforward syntax that is simple to read and understand. Because of the language's simplicity, you can create code that is simple to read and maintain, which lowers the likelihood of mistakes and defects.
Go is intended to be a language with excellent performance. It fast compiles, making it the best option for complicated applications. The simplicity of Go's syntax, which makes code optimisation by the compiler straightforward, contributes to the language's speed. A garbage collector is also included, which automatically maintains memory and releases resources when they are no longer required.
Concurrency is supported natively in Go, making it simple to create programmes that can handle several tasks at once. It makes use of goroutines, little threads that let you do several operations at once. This implies that you can create programmes that run quickly even when handling thousands of requests per second.
Go is a cross-platform language, so you can create code on one platform and execute it without any changes on another. It is the perfect option for designing programmes that need to operate on different platforms because it supports Windows, Linux, and macOS.
Go is a cross-platform language, so you can create code on one platform and execute it without any changes on another. It is the perfect option for designing programmes that need to operate on different platforms because it supports Windows, Linux, and macOS.

Installing and using Apache Age

Prachi — Mon, 13 Mar 2023 04:20:42 +0000

To use Apache Age, one needs to first install apache.

1.Install Apache Age:Apache Age can be downloaded and installed from the official website or using package managers such as apt-get, or brew.

2.Create a database: Once Apache Age is installed, a database can be created using the command-line interface or a GUI tool.

3.Create tables: Tables can be creatd using SQL commands.In Apache Age, we can also create graph and document tables using the appropriate commands.

4.Insert data:Data can be inserted into the tables using SQL commands or by using the appropriate commands for graph and document data.

5.Query data: We can query the data using SQL commands or by using the appropriate query language for graph and document data.
For example, you can use the Cypher query language to query graph data or use the appropriate JSON functions to query document data.

6.Scale the database: Apache Age is designed to be scalable, and more nodes can be added to the database to handle larger volumes of data.

7.Integrate with other tools: Apache Age integrates with other Apache projects such as Spark and Kafka, making it a part of a larger data processing ecosystem. These tools can be used to to process and analyze data stored in Apache Age.

Overall, using Apache Age involves creating and managing a database, creating tables, inserting data, querying data, and scaling the database as needed.

To know more about Apache Age, have a look at the Github Repository AGE Github Link: https://github.com/apache/age and https://age.apache.org

Features of Apache Age

Prachi — Mon, 13 Mar 2023 04:07:49 +0000

The key features of Apache Age are:

1.Hybrid database: Apache Age is a hybrid database system that combines the relational data model of PostgreSQL with support for graph and document data models.
2.Graph support: Apache Age provides native support for graph data, allowing users to store and query graph data using the Cypher query language.
3.Document support: Apache Age can store and query JSON, BSON, and Avro data formats, providing a flexible solution for managing document data.
SQL support: Apache Age supports SQL, allowing users to query their data using standard SQL queries.
4.Scalability: Apache Age is designed to be scalable and can handle large volumes of data.
5.High-performance: Apache Age is optimized for high-performance data processing, providing fast query performance.
6.Open-source: Apache Age is an open-source project and is available under the Apache License, Version 2.0.
7.ACID-compliant: Apache Age is ACID-compliant, ensuring data consistency and reliability.
8.Integration with other tools: Apache Age integrates with other Apache projects such as Spark and Kafka, making it a part of a larger data processing ecosystem.

Overall, Apache Age provides users with a powerful and versatile database system that can manage a wide range of data types and query them using multiple query languages.

To know more about Apache Age, have a look at the Github Repository AGE Github Link: https://github.com/apache/age and https://age.apache.org

Apache Age

Prachi — Mon, 13 Mar 2023 04:00:43 +0000

*What is Apache Age? *

Apache AGE is an open-source extension of PostgreSQL, a popular object-relational database management system. It allows users to use graph database features and Cypher query language in PostgreSQL.

AGE stands for "AgensGraph Extension", and is the graph database management system developed by Bitnine Global Inc. Apache AGE integrates the AgensGraph graph database engine into PostgreSQL, allowing it to provide efficient storage and querying of graph data.

It enables users to store and manage their data in a relational or graph format.This flexibility makes it suitable for a wide range of use cases, including social networking, recommendation systems, fraud detection, and more.

To know more about Apache Age, have a look at the Github Repository AGE Github Link: https://github.com/apache/age and https://age.apache.org