Sqlitefs: SQLite as a Filesystem
The sqlitefs GitHub repository provides a tool to mount SQLite database files as filesystems on Linux and MacOS, enabling standard filesystem operations with SQLite databases for easier data manipulation.
Read original article
The GitHub repository sqlitefs offers a tool that allows users to mount a SQLite database file as a standard filesystem on Linux and MacOS. This tool, named sqlite-fs, enables the use of a SQLite database file in a manner similar to a regular filesystem. To utilize sqlite-fs, users need to have the Rust programming language (version 1.38 or higher) and either libfuse for Linux or osxfuse for MacOS, as required by the fuse-rs library.
To mount a filesystem, the command `sqlite-fs <mount_point> [<db_path>]` is used. If the specified database file does not exist, sqlite-fs will create it along with the necessary tables. If no database file is provided, an in-memory database will be created, which will be deleted upon unmounting. Unmounting is done using `fusermount -u <mount_point>` for Linux and `umount <mount_point>` for Mac.
The tool supports various functions, including creating, reading, deleting directories and files, changing file attributes, copying and moving files, and creating hard and symbolic links. However, file lock operations and strict error handling are not implemented. This tool is particularly beneficial for developers looking to interact with SQLite databases in a filesystem-like manner, facilitating easier data manipulation and access.
Related
Optimizing Large-Scale OpenStreetMap Data with SQLite
The article discusses optimizing large-scale OpenStreetMap data with SQLite. Converting OSMPBF to SQLite enhanced search functionalities. Indexing, full-text search, and compression improved query performance, despite some false positives.
DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
DB Browser for SQLite (DB4S) is an open-source tool for SQLite databases, supporting Windows, macOS, Linux, and Unix. It enables table management, data manipulation, SQL queries, and visualization features. Version 3.12.2 is current, with a 3.13.x-rc1 release. Nightly builds are also available for testing.
First Contact with SQLite
The article explores surprising aspects of SQLite, like limitations in altering columns and data types. It notes the recent jsonb support and handling date/time values, praising SQLite's streaming features but favoring PostgreSQL.
Show HN: SQLite Transaction Benchmarking Tool
The "sqlite-bench" GitHub project tests SQLite transaction behavior. It provides code, compilation guidelines, and running instructions. To protect SSD, run benchmarks on in-memory filesystem first. Docker image available.
SQLite: 35% Faster Than the Filesystem
SQLite outperforms traditional file I/O by achieving 35% faster reads of small blobs and using 20% less disk space for 10-kilobyte blobs, despite some latency issues in specific scenarios.
12 commentsWhich was essentially SQL Server as a filesystem.
Project was ultimately cancelled.
fusermount: option allow_other only allowed if 'user_allow_other' is set in /etc/fuse.conf
It's "a file system interface placed on top of files and directories that are stored in database tables."[0]
[0] https://docs.oracle.com/en/database/oracle/oracle-database/1...
Related
Optimizing Large-Scale OpenStreetMap Data with SQLite
The article discusses optimizing large-scale OpenStreetMap data with SQLite. Converting OSMPBF to SQLite enhanced search functionalities. Indexing, full-text search, and compression improved query performance, despite some false positives.
DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
DB Browser for SQLite (DB4S) is an open-source tool for SQLite databases, supporting Windows, macOS, Linux, and Unix. It enables table management, data manipulation, SQL queries, and visualization features. Version 3.12.2 is current, with a 3.13.x-rc1 release. Nightly builds are also available for testing.
First Contact with SQLite
The article explores surprising aspects of SQLite, like limitations in altering columns and data types. It notes the recent jsonb support and handling date/time values, praising SQLite's streaming features but favoring PostgreSQL.
Show HN: SQLite Transaction Benchmarking Tool
The "sqlite-bench" GitHub project tests SQLite transaction behavior. It provides code, compilation guidelines, and running instructions. To protect SSD, run benchmarks on in-memory filesystem first. Docker image available.
SQLite: 35% Faster Than the Filesystem
SQLite outperforms traditional file I/O by achieving 35% faster reads of small blobs and using 20% less disk space for 10-kilobyte blobs, despite some latency issues in specific scenarios.