NoSQL Databases
Redis compression: LogicMonitor's 85% reduction
LogicMonitor reduced a Redis model from roughly 80,000 to 11,383 bytes using float16 arrays and compression, but precision and peak-load costs need testing.
Database
The Database section covers how to design, query and run databases, relational and NoSQL alike. The guides explain the ideas behind a schema as well as the SQL that uses it, with examples for MySQL, PostgreSQL and SQL Server.
Designing a schema? Begin with constraints and validation rules, which keep bad data out of your tables. For NoSQL, data modelling for schema-less designs and consistency models explain the trade-offs that work differently from SQL. Other guides range from counting NULL and NOT NULL values in a column to what MySQL, PostgreSQL and SQL Server each offer, and from column-family stores to backups.
Preparing for an interview? SQL tricky interview questions works through the questions interviewers use to test SQL. Running a database in production? See backup and recovery strategies for relational databases before you need them.
Category · 91 articles · Follow Database
Latest in Database
NoSQL Databases
NoSQL data modeling for query-first database schemas
NoSQL data modeling starts with application queries; use document boundaries, partition choices and index review to build a schema around real workflows.
Relational Databases
pg_hint_plan 1.9.0 Now Supports PostgreSQL 19 and More
pg_hint_plan 1.9.0 introduces PostgreSQL 19 compatibility, enhancing execution plans.
Database
10 SQL Projects to Boost Your Data Analyst Resume in 2023
Elevate your data analyst resume with these 10 impactful SQL projects. Learn how to analyze data across sectors and showcase your analytical skills.
Database
SQL for Interviews: Tricky Questions
A detailed exploration of SQL tricky interview questions for Day 1, covering everything from Common Table Expressions to ACID properties and date manipulations
Database
MongoDB: New Generative AI for Developer Productivity
MongoDB adds generative AI features to its toolset, targeting to advance developer productivity. Learn how these AI capabilities integrate into MongoDB's various products and services.
Cyber Security
Protect Your Database from Cyberattacks: Top 10 Strategies
Discover the top 10 strategies to safeguard your database from potential cyberattacks. Learn the crucial steps to enhance data security and prevent breaches.
Interview Preparation
SQL or Python: Navigating Your Career Growth in 2023
Delve into an in-depth analysis of SQL and Python's strengths and applications to make an informed decision on the right language for your career growth in 2023.
Database
Harnessing the Strength of DSA: A Comprehensive Guide for Developers
Embark on a deeper exploration into Data Structures and Algorithms (DSA) with our insightful guide. Discover why mastering DSA can significantly elevate your developer skills.
Database Design
Databases in Data Science: Basics to Advanced Concepts
Delve deep into the world of databases integral to data science. From understanding the essential database skills to the intricacies of relational and NoSQL databases, this comprehensive guide serves as a beacon for data enthusiasts.
Relational Databases
Accurately Count NULL and NOT NULL Values in a SQL Column
Uncover the detailed steps to count NULL and NOT NULL values in a SQL column accurately. This guide covers structured examples to facilitate easier understanding for database enthusiasts.
Relational Databases
Relational Database Backup and Recovery: Methods and Tools
Dive into the essential backup strategies and recovery techniques for safeguarding data in relational databases. This guide covers full, incremental, and differential backups, along with recovery methods and tools to ensure data integrity and availability.