Developed with the software and tools below.
The sqlite3-partitioner project is designed to enhance SQLite databases by introducing efficient data partitioning capabilities. Right now, only timeseries partitioning is supported. I hope to make other partitioning methods available in the future. More information at https://nuuskamummu.github.io/Sqlite3_partitioner/
Download the .so/.dylib from https://github.com/nuuskamummu/Sqlite3_partitioner/releases
** partitioner-aarch64-apple-darwin.dylib ** partitioner-x86_64-unknown-linux-gnu.so ** no windows support yet, sorry!
Start the SQLite3 command-line (needs to be compiled with the .load function). Or load into your application using a suitable driver ** macOS
$ .load PATH-DOWNLOADED-FILE/partitioner-aarch64-apple-darwin** Linux
$ .load PATH-DOWNLOADED-FILE/partitioner-x86_64-unknown-linux-gnu
Use the CREATE VIRTUAL TABLE SQL command to define a new virtual table using the partitioner. Specify the partitioning interval (e.g., 1 hour) and the column arguments. Mark one column as the "partition_column," which will be used to determine the partitioning. This column should have the data type timestamp, but it will be stored as TEXT.
$ CREATE VIRTUAL TABLE test USING partitioner( 1 hour, col1 timestamp partition_column, col2 varchar );
Currently, the accepted interval formats are [integer] [hour] or [integer] [day]
$ INSERT INTO test (col1, col2) VALUES ('2023-01-01 01:30:00', 'Sample Data');
Indexing are not supported by the Sqlite API, but a workaround exists. Visit https://nuuskamummu.github.io/Sqlite3_partitioner/usage/ for more information
The library is experimental and not recommended for production use without further development and testing. The datetime parser may not handle all formats correctly; review and test thoroughly with your data. Currently, all shadow tables are visible, and altering them can lead to undefined behavior. Plans to hide shadow tables are underway
Contributions are welcome! Here are several ways you can contribute:
- Report Issues: Submit bugs found or log feature requests for the `` project.
- Submit Pull Requests: Review open PRs, and submit your own PRs.
- Join the Discussions: Share your insights, provide feedback, or ask questions.
Contributing Guidelines
- Fork the Repository: Start by forking the project repository to your local account.
- Clone Locally: Clone the forked repository to your local machine using a git client.
git clone https://github.com/nuuskamummu/Sqlite3_partitioner
- Create a New Branch: Always work on a new branch, giving it a descriptive name.
git checkout -b new-feature-x
- Make Your Changes: Develop and test your changes locally.
- Commit Your Changes: Commit with a clear message describing your updates.
git commit -m 'Implemented new feature x.' - Push to local: Push the changes to your forked repository.
git push origin new-feature-x
- Submit a Pull Request: Create a PR against the original project repository. Clearly describe the changes and their motivations.
- Review: Once your PR is reviewed and approved, it will be merged into the main branch. Congratulations on your contribution!
Contributor Graph
This project is protected under the Apache 2.0 (https://www.apache.org/licenses/LICENSE-2.0) License. For more details, refer to the LICENSE file.