mrbouzaffour/simple-database

Trying to clone SQL

Simple Database Project

This project is a simple database system implemented in C. It provides basic functionalities to manage rows and tables efficiently. The system allows operations like insertion, deletion, and querying of data structured in rows within tables.

Features

• Row Management: Supports operations on individual data entries (rows).
• Table Management: Organize rows in a pageable table format.
• Dynamic Row and Table Size Calculation: Automatically calculates sizes based on row structures.
• Data Serialization and Deserialization: For storing and retrieving structured data.
• Memory Management: Includes functions for dynamic memory allocation and deallocation for tables.
• Supported Operations: Currently, the system only supports insert and select operations.

Installation

Clone the repository to your local machine:

git clone https://github.com/yourusername/simple-database.git
cd simple-database

Usage

To compile the project, run the following command from the root of the project directory:

gcc -o db_program db.c command_processor.c input_management.c row_serialization.c statement_executor.c statement_preparer.c table.c -I.

This will create an executable named db_program which you can run to interact with the database.

simple-database's Issues

here are multiple definitions of certain constants (ID_SIZE, USERNAME_SIZE, EMAIL_SIZE, ID_OFFSET, USERNAME_OFFSET, EMAIL_OFFSET, ROW_SIZE, PAGE_SIZE, ROWS_PER_PAGE, TABLE_MAX_ROWS) across different source files

This typically happens when constants are defined in header files that are included in multiple source files, leading to each source file having its own copy, which then collide during the linking process.
NEED TO FIX THIS ASAP.