Oracle to Postgres : Happily Ever After edition

Prelude :The launch of the Oracle Autonomous Database ignited a lively debate about the future of the database administrator (DBA) role. Oracle envisioned a world where the DBA would become obsolete with a snap of their fingers, just like Thanos....

October 20, 2024

Data Analytics Dashboard Starter Kit with Neon, Streamlit, and Airflow

News

Data Analytics Dashboard Starter Kit with Neon, Streamlit, and Airflow

This is a submission for the Neon Open Source Starter Kit Challenge : Ultimate Starter Kit My Kit The Data Analytics Dashboard Starter Kit is an open-source project designed to provide a solid foundation for building interactive data analytics dashboards....

August 31, 2024

Dockerize NEXTJS and Setup Drizzle ORM with PostgreSQL locally with docker in NEXT.JS…

News

Dockerize NEXTJS and Setup Drizzle ORM with PostgreSQL locally with docker in NEXT.JS…

Download Docker Desktop we are going to need it. Step 1: Go into your IDE and create a new NEXT App npx create-next-app@latest Name your App anything and take all the default settings. Step 2: Now we have to create...

August 19, 2024

News

Using JSONB in PostgreSQL

Introduction JSONB, short for JSON Binary, is a data type developed from the JSON data type and supported by PostgreSQL since version 9.2. The key difference between JSON and JSONB lies in how they are stored. JSONB supports binary storage...

June 30, 2024

Running pgAdmin to manage a PostgreSQL cluster in Kubernetes

News

Running pgAdmin to manage a PostgreSQL cluster in Kubernetes

Suppose you need to do something in PostgreSQL in Kubernetes, and it is inconvenient to work with the database in the terminal, or you need to become more familiar with PostgreSQL or SQL commands. In that case, this article will...

June 26, 2024

PostgreSQL on steroids – how to ace your database configuration

News

PostgreSQL on steroids – how to ace your database configuration

Databases are complex beasts. They have options for various areas like memory usage, backups, write-ahead logs, monitoring, replication, and many more. Installing a database is just the beginning, we need to configure it accordingly later on to match our needs....

May 16, 2024

News

Beyond Unique Constraints in Odoo

Inspired by PostgreSQL exclusion constraints: Beyond UNIQUE by Hans-Jürgen Schönig In Odoo platform you could apply model constraints in two methods. the first one is using SQL constraints and the second is using Python. Odoo provide Python constraints to give...

May 9, 2024

Development News

When to use SQL vs NoSQL

For developers navigating the database landscape, the choice between SQL and NoSQL databases can be daunting, especially given the plethora of options available in the market today. From traditional relational databases such as MySQL or PostgreSQL to modern document-oriented such...

April 16, 2024

Week 0: New NOTR Server -Migrating Data from MongoDB to PostgreSQL

Development News

Week 0: New NOTR Server -Migrating Data from MongoDB to PostgreSQL

Introduction In week 0 of modifying my server for Neat on the Rocks, I focused on transferring part of my data from MongoDB (a non-relational database) to PostgreSQL (a relational database). This migration is critical as I aim to use...

April 15, 2024

Development News

Express

What is an Express Server?Express is a node js web application framework for building web and mobile applications. It is used to build a single page, multipage, and hybrid web application. It’s a layer built on top of the Node...

April 15, 2024

1 2 3