GSoC 2024 Proposal: Improve the Database Cache Backend

Mei0707 · April 1, 2024, 5:02pm

Hi, here is my proposal for 2024 GSoC. I’m appreciate if you can take a look or give me the feedback, thanks!

Mei0707/GSoC-2024-Proposal-Improve-the-Database-Cache-Backend/blob/main/README.md

# GSoC-2024-Proposal-Improve-the-Database-Cache-Backend
## Table of Contents
1. Abstract (Existing problem, Goals, Benefit)
2. High level diagram
3. Low level
4. Task breakdown
5. Reference
6. About me
## 1. Abstract
### 1.1 Existing problem
Django-Mysql has good DatabaseCache, but, the existing problem with the Django-MySQL DatabaseCache implementation lies in its **lack of compatibility** with other database backends due to differences in SQL dialects and specific features offered by each database.
Developers using databases other than MySQL may face challenges in integrating and optimizing caching solutions within their Django applications. Supporting caching across multiple database backends requires rigorous testing and maintenance to ensure compatibility, performance, and reliability.

### 1.2	Goals
First of all, we need to understanding Django-MySQL features. Do the research and document the specific features, such as ```approx_count(), _clone(), count_tries_approx()```, and other relevant methods or functionalities. And determine how these features interact with MySQL database, and how they can be utilized for caching purposes.\
Then we will design the interface that abstracts these features, and then translate the interface to different database dialects, such as PostgreSQL, SQLite, Oracle, etc. Adapt the interface and implementation to utilize the specific features and capabilities offered by each database backend.\
Then develop separate Django cache backends for each supported database backend, incorporating the translated caching functionalities. And conduct comprehensive testing to ensure that the caching functionalities work as expected across different database backends.\
Finally, document the usage and configuration of the caching solution, provide examples, practices, and troubleshooting guidelines to assist developers in effectively utilizing the caching features within their projects.

### 1.3	Benefit

This file has been truncated. show original

Topic		Replies	Views
GSOC 2023: Improving the databse cache backend Mentorship	0	340	April 1, 2023
GSoC 2024 Proposal Feedback: Improve Database Cache Backend Mentorship	5	466	March 30, 2024
GSoC '23 - Improving the Database Caching Backend Ideas Mentorship	5	578	May 28, 2023
Participating at Gsoc 2024 Mentorship	11	1027	April 26, 2024
GSoC Proposal Feedback - Django Benchmarking Project Mentorship	6	863	April 17, 2022

GSoC 2024 Proposal: Improve the Database Cache Backend

Related topics