#databases

[ follow ]
#sql

How to Use JSON Data Fields in MySQL Databases - SitePoint

The integration of JSON in SQL databases provides flexibility but should not undermine the principles of relational database design.

API with NestJS #162. Identity columns with the Drizzle ORM and PostgreSQL

The PostgreSQL community now recommends using identity columns over serial types for defining primary keys.

How to Use JSON Data Fields in MySQL Databases - SitePoint

The integration of JSON in SQL databases provides flexibility but should not undermine the principles of relational database design.

API with NestJS #162. Identity columns with the Drizzle ORM and PostgreSQL

The PostgreSQL community now recommends using identity columns over serial types for defining primary keys.
moresql
#data-management

Database vs. Spreadsheet: Choose the Right Tool for You | ClickUp

Choosing between databases and spreadsheets significantly impacts data efficiency and management strategies.
Understanding the specific strengths of each tool can enhance business decision-making.

An Overview of PostgreSQL indexing | HackerNoon

Effective index management in PostgreSQL 16 is key to optimizing database performance as data volumes increase.

Database vs. Spreadsheet: Choose the Right Tool for You | ClickUp

Choosing between databases and spreadsheets significantly impacts data efficiency and management strategies.
Understanding the specific strengths of each tool can enhance business decision-making.

An Overview of PostgreSQL indexing | HackerNoon

Effective index management in PostgreSQL 16 is key to optimizing database performance as data volumes increase.
moredata-management
#kubernetes

Running data workloads on Kubernetes.

Kubernetes now supports stateful applications and persistent storage for data workloads.
CNCF provides whitepapers and guidance for running databases on Kubernetes.

5 Best practices for implementing GitOps for stateful applications and databases in Kubernetes - Amazic

GitOps is beneficial for managing stateful applications and databases in Kubernetes, although challenges exist.

Running data workloads on Kubernetes.

Kubernetes now supports stateful applications and persistent storage for data workloads.
CNCF provides whitepapers and guidance for running databases on Kubernetes.

5 Best practices for implementing GitOps for stateful applications and databases in Kubernetes - Amazic

GitOps is beneficial for managing stateful applications and databases in Kubernetes, although challenges exist.
morekubernetes

Neurelo is building a simpler way for developers to connect a database to an application | TechCrunch

Neurelo has developed a programming interface that simplifies the interaction between databases and applications by creating customized APIs based on the individual data model.
The company has raised $5 million in seed funding to further develop their solution.

Database views in Django

Databases support creating and working with views, which are like virtual tables.
Django's migration system can create views using the RunSQL operation.

ERP's storage requirements and options in the cloud | Computer Weekly

ERP is a central nervous system for businesses, connecting operations, processes, and departments.
ERP requires storage with low latency, good read/write speeds, reliability, and data protection.
[ Load more ]