#database-management

[ follow ]
#mysql
fromHackernoon
2 months ago
Ruby on Rails

Want Everyone Out of the Database? Here's How the Pros Do It | HackerNoon

Single-user mode is essential for performing critical database tasks without conflicts.
Transitioning back to multi-user mode is crucial after maintenance to restore normal operations.
fromRealpython
1 week ago
Ruby on Rails

MySQL Databases and Python - Real Python

MySQL is highly popular for database management, especially for applications needing data access.
The course teaches integration of MySQL with Python for practical application use.
fromHackernoon
2 months ago
Ruby on Rails

Want Everyone Out of the Database? Here's How the Pros Do It | HackerNoon

Single-user mode is essential for performing critical database tasks without conflicts.
Transitioning back to multi-user mode is crucial after maintenance to restore normal operations.
fromRealpython
1 week ago
Ruby on Rails

MySQL Databases and Python - Real Python

MySQL is highly popular for database management, especially for applications needing data access.
The course teaches integration of MySQL with Python for practical application use.
more#mysql
#data-strategy
Data science
fromMedium
2 months ago

Database Revolution Series: A Modern Guide to Data Management

Modern data management relies on both SQL and NoSQL databases to address the needs of structured and unstructured data.
fromMedium
2 months ago
Data science

Database Revolution Series: A Modern Guide to Data Management

Multi-model and cloud-native databases are transforming data management for businesses.
fromMedium
2 months ago
Data science

Database Revolution Series: A Modern Guide to Data Management

SQL databases manage structured data efficiently, while NoSQL is ideal for unstructured data.
Data science
fromMedium
2 months ago

Database Revolution Series: A Modern Guide to Data Management

Modern data management relies on both SQL and NoSQL databases to address the needs of structured and unstructured data.
fromMedium
2 months ago
Data science

Database Revolution Series: A Modern Guide to Data Management

Multi-model and cloud-native databases are transforming data management for businesses.
fromMedium
2 months ago
Data science

Database Revolution Series: A Modern Guide to Data Management

SQL databases manage structured data efficiently, while NoSQL is ideal for unstructured data.
more#data-strategy
fromRealpython
1 week ago
Privacy professionals

Episode #247: Exploring DuckDB & Comparing Python Expressions vs Statements - The Real Python Podcast

DuckDB provides a powerful and efficient way to manage large datasets in Python with easy-to-use syntax.
Data science
fromHackernoon
1 month ago

How to Process Large Files in Data Indexing Systems | HackerNoon

Efficiently processing large files in data indexing pipelines requires managing processing granularity and balancing commit frequency to optimize performance and recoverability.
#mariadb
fromTechCrunch
6 months ago
Miscellaneous

How do you solve a problem like MariaDB? Cozy up to the community, says new CEO | TechCrunch

MariaDB aims for closer collaboration with its foundation after stabilizing under K1 Investment Management following a turbulent period.
fromTechCrunch
6 months ago
Miscellaneous

How do you solve a problem like MariaDB? Cozy up to the community, says new CEO | TechCrunch

MariaDB aims for closer collaboration with its foundation after stabilizing under K1 Investment Management following a turbulent period.
more#mariadb
#google-cloud
fromInfoQ
1 month ago
Angular

Google Enhances AlloyDB Vector Search with Inline Filtering and Enterprise Observability

Google enhances AlloyDB with inline filtering and observability features for improved performance in vector search operations.
fromInfoQ
1 month ago
Data science

Google Cloud Introduces HDD Tier for Spanner Database, Cutting Cold Storage Costs by 80%

Google introduces tiered storage for Spanner, offering a cost-effective HDD option for older data management.
The new HDD storage is 80% cheaper than SSD, optimizing operational costs.
fromInfoQ
9 months ago
Data science

Google Cloud Introduces Geo-Partitioning for Spanner: Reduced Latency and Cost Optimization

Google Cloud added geo-partitioning to Spanner to enhance performance and user experience for geographically dispersed applications, optimizing costs.
fromInfoQ
1 month ago
Angular

Google Enhances AlloyDB Vector Search with Inline Filtering and Enterprise Observability

Google enhances AlloyDB with inline filtering and observability features for improved performance in vector search operations.
fromInfoQ
1 month ago
Data science

Google Cloud Introduces HDD Tier for Spanner Database, Cutting Cold Storage Costs by 80%

Google introduces tiered storage for Spanner, offering a cost-effective HDD option for older data management.
The new HDD storage is 80% cheaper than SSD, optimizing operational costs.
fromInfoQ
9 months ago
Data science

Google Cloud Introduces Geo-Partitioning for Spanner: Reduced Latency and Cost Optimization

Google Cloud added geo-partitioning to Spanner to enhance performance and user experience for geographically dispersed applications, optimizing costs.
more#google-cloud
#sql
Data science
fromfaun.pub
2 months ago

SQL vs. NoSQL Explained: When to Use Which and Why It Matters to Modern Data Management

SQL and NoSQL databases are essential in modern data management to handle data growth and real-time processing needs.
fromSimplilearn.com
1 year ago
Python

SQL vs Python: Unveiling the Best Language for Your Needs

SQL excels in raw data extraction speed and query performance due to its tight integration with databases.
fromMedium
3 months ago
Data science

A Comprehensive Guide for Mastering SQL Aggregate Functions and Grouping.

SQL aggregate functions and GROUP BY are essential for data summarization and analysis.
fromSitepoint
3 months ago
Data science

Types of SQL Commands: DDL, DML, DQL, DCL, and TCL - SitePoint

SQL is essential for data management in relational databases.
Understanding basic SQL commands is enough for effective database management.
Security measures are crucial in database management.
SQL can be integrated with programming languages for data applications.
Data science
fromTheregister
10 months ago

Codd almighty! Has it been 50 years of SQL already?

SQL was originally known as SEQUEL and played a key role in the development of the relational database model.
Data science
fromfaun.pub
2 months ago

SQL vs. NoSQL Explained: When to Use Which and Why It Matters to Modern Data Management

SQL and NoSQL databases are essential in modern data management to handle data growth and real-time processing needs.
fromSimplilearn.com
1 year ago
Python

SQL vs Python: Unveiling the Best Language for Your Needs

SQL excels in raw data extraction speed and query performance due to its tight integration with databases.
fromMedium
3 months ago
Data science

A Comprehensive Guide for Mastering SQL Aggregate Functions and Grouping.

SQL aggregate functions and GROUP BY are essential for data summarization and analysis.
fromSitepoint
3 months ago
Data science

Types of SQL Commands: DDL, DML, DQL, DCL, and TCL - SitePoint

SQL is essential for data management in relational databases.
Understanding basic SQL commands is enough for effective database management.
Security measures are crucial in database management.
SQL can be integrated with programming languages for data applications.
fromSitePoint Forums | Web Development & Design Community
2 months ago
Web design

How to Insert a new record in new table for each row in existing table

Creating a new table for subscription years is more efficient than adding columns to an existing table.
Transforming column data into rows allows better data management and historical tracking of subscriptions.
fromTheregister
10 months ago
Data science

Codd almighty! Has it been 50 years of SQL already?

SQL was originally known as SEQUEL and played a key role in the development of the relational database model.
more#sql
DevOps
fromHackernoon
2 months ago

SQL Server to AWS RDS Migration: The Good, the Bad, and Everything in Between | HackerNoon

Cloud migration can lead to cost savings but requires careful usage monitoring.
#software-development
fromInfoWorld
2 months ago
DevOps

Why database design choices matter to developers

Developers are increasingly using cloud databases for improved application deployment and management.
fromDevOps.com
5 months ago
Web development

Improving the Developer Experience by Deploying CI/CD in Databases - DevOps.com

CI/CD practices enhance efficiency in software development but are underutilized in database deployment.
fromCodeProject
8 months ago
JavaScript

Spring Boot's Caching Features

Caching improves system efficiency by reducing response times and load on databases or services.
Spring Boot provides an easy way to implement caching via specific dependencies and annotations.
fromDBmaestro
3 years ago
DevOps

If You Don't Have Database Delivery Automation, Brace Yourself for These 10 Problems | DBmaestro

Only 12% of respondents can deploy database changes daily, illustrating a significant gap in current practices.
Configuration drifts are the predominant cause of database errors, highlighting the need for automation.
DevOps
fromInfoWorld
2 months ago

Why database design choices matter to developers

Developers are increasingly using cloud databases for improved application deployment and management.
fromDevOps.com
5 months ago
Web development

Improving the Developer Experience by Deploying CI/CD in Databases - DevOps.com

CI/CD practices enhance efficiency in software development but are underutilized in database deployment.
fromCodeProject
8 months ago
JavaScript

Spring Boot's Caching Features

Caching improves system efficiency by reducing response times and load on databases or services.
Spring Boot provides an easy way to implement caching via specific dependencies and annotations.
fromDBmaestro
3 years ago
DevOps

If You Don't Have Database Delivery Automation, Brace Yourself for These 10 Problems | DBmaestro

Only 12% of respondents can deploy database changes daily, illustrating a significant gap in current practices.
Configuration drifts are the predominant cause of database errors, highlighting the need for automation.
more#software-development
#oracle
fromComputerWeekly.com
7 months ago
DevOps

At CloudWorld, Oracle completes hyperscaler trifecta with AWS | Computer Weekly

Oracle launches partnership with AWS to offer customers seamless connectivity between Oracle Database and AWS services.
fromhackernoon.com
2 months ago
Business intelligence

Set up Oracle Data Guard Faster Than Getting Your Morning Coffee With This Guide

Oracle Data Guard facilitates high availability and disaster recovery in Oracle databases.
Implementing a physical standby database in Oracle 21c is streamlined with Data Guard Broker.
fromComputerWeekly.com
7 months ago
DevOps

At CloudWorld, Oracle completes hyperscaler trifecta with AWS | Computer Weekly

Oracle launches partnership with AWS to offer customers seamless connectivity between Oracle Database and AWS services.
fromhackernoon.com
2 months ago
Business intelligence

Set up Oracle Data Guard Faster Than Getting Your Morning Coffee With This Guide

Oracle Data Guard facilitates high availability and disaster recovery in Oracle databases.
Implementing a physical standby database in Oracle 21c is streamlined with Data Guard Broker.
more#oracle
#data-backup
fromMedium
3 months ago
Miscellaneous

Backup types-Inconsistent, App consistent, crash consistent

Backup processes must be managed carefully to ensure data consistency, especially with databases.
fromMedium
3 months ago
Miscellaneous

Backup types-Inconsistent, App consistent, crash consistent

Inconsistent backups can occur if changes are made during the backup process, leading to data protection issues.
Crash-consistent backups capture all data at the same time but miss data in memory, resembling a server crash recovery.
Application-consistent backups ensure data across applications is in a stable state, offering highest data protection.
fromMedium
3 months ago
Miscellaneous

Backup types-Inconsistent, App consistent, crash consistent

Backup processes must be managed carefully to ensure data consistency, especially with databases.
fromMedium
3 months ago
Miscellaneous

Backup types-Inconsistent, App consistent, crash consistent

Inconsistent backups can occur if changes are made during the backup process, leading to data protection issues.
Crash-consistent backups capture all data at the same time but miss data in memory, resembling a server crash recovery.
Application-consistent backups ensure data across applications is in a stable state, offering highest data protection.
more#data-backup
fromTechCrunch
2 months ago
Miscellaneous

No-code app builder Softr expands beyond Airtable databases | TechCrunch

Softr enables users to create client portals and internal tools without developer resources using its no-code app builder.
#sql-server
fromITPro
8 months ago
JavaScript

How to check your SQL Server version

Understanding SQL Server versions is crucial for support and feature availability.
Different SQL Server versions have specific support timelines and features.
Outdated SQL Server versions may lack essential security updates.
fromHackernoon
8 months ago
Data science

Is Now the Right Time to Start Using Azure Data Studio? | HackerNoon

Azure Data Studio is an improved alternative to SQL Server Management Studio, especially for user-friendliness and modern database management needs.
fromHackernoon
4 years ago
JavaScript

Here's How to Keep Tempdb From Becoming Your Worst Nightmare | HackerNoon

Tempdb is vital for SQL Server operations; its mismanagement can lead to severe system performance issues.
fromITPro
8 months ago
JavaScript

How to check your SQL Server version

Understanding SQL Server versions is crucial for support and feature availability.
Different SQL Server versions have specific support timelines and features.
Outdated SQL Server versions may lack essential security updates.
fromHackernoon
8 months ago
Data science

Is Now the Right Time to Start Using Azure Data Studio? | HackerNoon

Azure Data Studio is an improved alternative to SQL Server Management Studio, especially for user-friendliness and modern database management needs.
fromHackernoon
4 years ago
JavaScript

Here's How to Keep Tempdb From Becoming Your Worst Nightmare | HackerNoon

Tempdb is vital for SQL Server operations; its mismanagement can lead to severe system performance issues.
more#sql-server
#best-practices
fromHackernoon
1 year ago
DevOps

How to Use Docker to Template Local Database | HackerNoon

Creating a database template allows for faster resets, improving local development efficiency.
fromHackernoon
1 year ago
DevOps

How to Use Docker to Template Local Database | HackerNoon

Creating a database template allows for faster resets, improving local development efficiency.
more#best-practices
#automation
fromAmazic
4 months ago
DevOps

Atlas is out to make database schema management declarative and compliant - Amazic

Atlas is a tool that automates database schema management, allowing developers to focus on defining desired states.
fromInfoWorld
3 months ago
DevOps

5 new features in EDB Postgres AI

The Hybrid Control Plane enhances efficiency and productivity by automating database management tasks in hybrid environments.
fromAmazic
4 months ago
DevOps

Atlas is out to make database schema management declarative and compliant - Amazic

Atlas is a tool that automates database schema management, allowing developers to focus on defining desired states.
fromInfoWorld
3 months ago
DevOps

5 new features in EDB Postgres AI

The Hybrid Control Plane enhances efficiency and productivity by automating database management tasks in hybrid environments.
more#automation
fromSitePoint Forums | Web Development & Design Community
3 months ago
Web design

How can I optimize the performance of a WordPress website with multiple plugins and ensure fast loading times without compromising functionality?

Optimize WordPress performance using caching, image optimization, database maintenance, and minifying files, while keeping necessary plugins.
#spring-boot
fromCodeProject
6 months ago
DevOps

Effective Strategies for Implementing Multi-Tenancy in Spring Boot Applications

Multi-tenancy enables a single software application to support multiple user groups while maintaining isolated data and configurations to optimize resource utilization.
fromHackernoon
5 years ago
JavaScript

Spring Data JPA: Speed Up Development & Business Focus | HackerNoon

Spring Data JPA simplifies database interactions, enhancing development efficiency and focusing on business logic.
fromCodeProject
6 months ago
DevOps

Effective Strategies for Implementing Multi-Tenancy in Spring Boot Applications

Multi-tenancy enables a single software application to support multiple user groups while maintaining isolated data and configurations to optimize resource utilization.
fromHackernoon
5 years ago
JavaScript

Spring Data JPA: Speed Up Development & Business Focus | HackerNoon

Spring Data JPA simplifies database interactions, enhancing development efficiency and focusing on business logic.
more#spring-boot
Business intelligence
fromInfoQ
3 months ago

AWS Introduces S3 Tables Bucket: Is S3 Becoming a Data Lakehouse?

AWS introduces S3 Tables Bucket, enhancing analytics workloads with improved performance and integration.
fromLogRocket Blog
3 months ago
JavaScript

Mastering charts and database visualization with ChartDB - LogRocket Blog

ChartDB simplifies the process of visualizing and managing database schemas, making data interpretation and communication more effective.
#postgresql
fromTheregister
6 months ago
Miscellaneous

Users remain on PostgreSQL 12 as end of life looms

PostgreSQL 12 will reach end of life soon; many users must prepare for upgrades to remain supported.
fromTheregister
6 months ago
Miscellaneous

Users remain on PostgreSQL 12 as end of life looms

PostgreSQL 12 will reach end of life soon; many users must prepare for upgrades to remain supported.
more#postgresql
#tech-support
fromTheregister
5 months ago
Miscellaneous

Relocation is a complete success - until the last minute

David's story emphasizes the critical importance of redundancy in tech support and system operations.
fromTheregister
5 months ago
Miscellaneous

The sad tale of the Alpha massacre

Gandalf and his team encountered humorous yet instructive tech support challenges while ensuring proper QA tool utilization for software testing.
fromTheregister
5 months ago
Miscellaneous

Relocation is a complete success - until the last minute

David's story emphasizes the critical importance of redundancy in tech support and system operations.
fromTheregister
5 months ago
Miscellaneous

The sad tale of the Alpha massacre

Gandalf and his team encountered humorous yet instructive tech support challenges while ensuring proper QA tool utilization for software testing.
more#tech-support
fromHackernoon
3 years ago
JavaScript

Internationalizing Database Data Using Linked Localization Tables | HackerNoon

Implementing efficient multilingual support in applications is crucial for global accessibility.
fromThe Bootstrapped Founder
6 months ago
Bootstrapping

Running Lean at Scale

Podscan reduced its database size significantly, highlighting a strategic shift in resource management and scaling for profitability.
fromCodeProject
6 months ago
JavaScript

Best Practices in SQL Coding

Writing SQL code following best practices is crucial for maintainability and performance.
fromThe Bootstrapped Founder
7 months ago
DevOps

When Podcasts Attack: The Unexpected Challenges of External Data

Implement robust logging and monitoring from the start to manage data at scale effectively.
fromTheregister
7 months ago
Privacy professionals

Muppet broke datacenter every day, in its own weighty way

The article highlights the unpredictable nature of IT systems, where even the smallest details, like a person's weight on a raised floor, can cause major failures.
#orm
fromCodeProject
8 months ago
Java

Reasons Why You Should Understand the Differences Between JPA and Hibernate

JPA standardizes object-relational mapping in Java, while Hibernate serves as its leading implementation with additional features.
fromDjangocentral
1 year ago
Django

Django ORM Cheatsheet: Mastering Database Operations in Django

Django's ORM simplifies and abstracts database operations, making it accessible for both beginners and experienced developers.
fromCodeProject
8 months ago
Java

Reasons Why You Should Understand the Differences Between JPA and Hibernate

JPA standardizes object-relational mapping in Java, while Hibernate serves as its leading implementation with additional features.
fromDjangocentral
1 year ago
Django

Django ORM Cheatsheet: Mastering Database Operations in Django

Django's ORM simplifies and abstracts database operations, making it accessible for both beginners and experienced developers.
more#orm
fromInfoWorld
8 months ago
JavaScript

DBOS: A better way to build applications?

DBOS Cloud is an innovative transactional serverless computing platform built on top of DBOS, revolutionizing traditional operating systems by implementing OS services on a distributed database.
fromBerlin Startup Jobs
11 months ago
DevOps

Job Vacancy: Infrastructure/Backend Engineer (f/d/m) // Maya Climate | IT / Software Development Jobs | Berlin Startup Jobs

Seeking Infrastructure/Backend Engineer with cloud expertise, database management skills, CI/CD experience, and devotion to security and reliability.
[ Load more ]