1. 16
    Extending SQLite with Rust to support Excel files as virtual tables databases rust sergey.khabibullin.com
    carlmjohnson avatar via carlmjohnson 10 months ago |
    Archive.org Archive.today Ghostarchive
    | 3 comments
  1. 6
    epilys avatar epilys 10 months ago | link

    I have a template repository for writing your own sqlite extension in rust: https://github.com/epilys/vfsstat.rs

    1. 2
      proctrap avatar proctrap edited 10 months ago | link

      So the real question is: How did they parse excel files ? They’re notoriously hard to handle if you really want to support more than your personal “happy path”.

      Edit: There seems to be a complete (read only) crate for this now, calamine. Will have to try that sometime.

      1. 2
        docteurklein avatar docteurklein 10 months ago | link

        The answer was in the article:

        Processing Excel files with Rust won’t be covered. This task is delegated to excellent and easy to use Calamine library. I recommend reading their documentation.

        Also, I won’t post and explain every piece of code for obvious reasons, but, of course, everyone is welcome at GitHub.