Best of Database — December 2023

1. 1
   Article

   DEV·2y

   How Modern SQL Databases Are Changing Web Development - #4 Into the AI Era

   Explore how modern SQL databases are reshaping web development and enabling easier development of AI-powered applications.

   25
2. 2
   Article

   InfoWorld·2y

   SQL unleashed: 9 ways to speed up your SQL queries

   Learn 9 best practices for writing faster SQL queries, including retrieving only the columns you need, using CASE instead of UPDATE for conditional column updates, and pre-staging data for improved performance.

   21

   1
3. 3
   Article

   GitHub Blog·2y

   Upgrading GitHub.com to MySQL 8.0

   GitHub upgraded its fleet of 1200+ MySQL hosts to MySQL 8.0 over the course of a year. The upgrade was motivated by the end of life of MySQL 5.7, the desire for the latest features and security patches, and the need to maintain service level objectives. GitHub prepared for the upgrade by determining infrastructure requirements, ensuring application compatibility, and communicating the upgrade plan. During the upgrade process, challenges such as replication delay and query failures were encountered and addressed. The lessons learned from the upgrade will inform future upgrade processes.

   21
4. 4
   Article

   Baeldung·2y

   Understanding NewSQL Databases

   NewSQL databases combine the transactional consistency of SQL databases with the scalability and performance of NoSQL databases. They are suitable for applications requiring strong transactional consistency, high performance, and scalability.

   17
5. 5
   Article

   Community Picks·2y

   AmrDeveloper/GQL: Git Query language is a SQL like language to perform queries on .git files with supports of most of SQL features such as grouping, ordering and aggregations functions

   GQL is a query language similar to SQL, designed to perform queries on .git files. It supports most of the SQL features such as grouping, ordering, and aggregation functions.

   17

   1
6. 6
   Article

   Community Picks·2y

   Design Systems Database: Surf among top‑notch Design Systems

   The Design Systems Database features best-in-class design systems with components and foundations references from top-tier tech companies and leading UI teams.

   16

   1
7. 7
   Article

   gitconnected·2y

   Why Is It Hard to Horizontally Scale SQL Databases

   Learn about the challenges of horizontally scaling SQL databases, including maintaining ACID properties, handling distributed joins, and managing transactions across shards.

   14
8. 8
   Article

   JRebel·2y

   How to Improve JPA Performance

   Learn how to improve JPA performance by avoiding common causes of performance issues, such as using too many SQL queries and updating entities individually. Discover how to avoid the n+1 query problem and optimize data processing in the database.

   13

   2
9. 9
   Article

   Community Picks·2y

   Scaling SQL Databases: 8 Challenges of Horizontally Scaling SQL Databases

   Learn about the challenges of horizontally scaling SQL databases, including ACID properties and distributed complexity, the complexity of distributed joins, transaction management across shards, data distribution and sharding strategies, ensuring consistency across nodes, handling schema changes in distributed environments, maintaining foreign keys and constraints, and query optimization in distributed systems.

   13

   1
10. 10
    Article

    AWS in Plain English·2y

    Host a Dynamic Web App on AWS with Docker, Amazon ECR, and Amazon ECS

    Learn how to host a dynamic web app on AWS with Docker, Amazon ECR, and Amazon ECS using a three-tier AWS network VPC.

    11
11. 11
    Article

    InfoWorld·2y

    SQL unleashed: 7 SQL mistakes to avoid

    Learn about 7 common SQL mistakes to avoid when writing database applications, including blindly reusing queries, nesting views, running large multi-table operations in a single transaction, clustering on volatile columns, inefficiently counting rows, using triggers, and doing negative searches.

    11
12. 12
    Article

    Medium·2y

    Databases 101

    Choosing the right database is crucial for the success of a project. Different databases excel at different tasks and it is important to consider factors such as data type and usage. There are three main types of databases - user-facing databases, databases for analytics, and databases for operations. User-facing databases include relational databases and NoSQL databases. Analytical databases are used for analyzing data and include data warehouses and data lakes. Operational databases are used for internal operations and include key-value stores, time series databases, and logs/search databases.

    11