stellarsql / StellarSQL

🚧 (Archived) StellarSQL: a minimal SQL DBMS written in Rust
https://stellarsql.github.io/StellarSQL/stellar_sql/
MIT License
86 stars 16 forks source link

Feature/file storage: Append, Fetch, Delete, Modify Rows #5

Closed tom6311tom6311 closed 5 years ago

tom6311tom6311 commented 5 years ago

Brief

Features:

  1. Functions for row-level operations:
    • File::append_rows, File::fetch_rows, File::delete_rows, File::modify_rows
  2. Design test cases for the 4 functionalities
  3. Remove __rid__ attribute for each stored row.
  4. Implement the __valid__ attribute for each stored row, which indicates if the row has been deleted.
  5. Rename TableInfo to TableMeta
  6. Simplify the error-expected test cases by using Result.unwrap_err()

Known Issues:

  1. Currently, most of row operations require read/write over whole TSV file, which is very inefficient. This can be solved by further binary file implementations.