libsqlfs
pocketbase
libsqlfs | pocketbase | |
---|---|---|
10 | 177 | |
581 | 33,430 | |
0.0% | 2.7% | |
0.0 | 9.7 | |
6 months ago | 8 days ago | |
C | Go | |
GNU Lesser General Public License v3.0 only | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
libsqlfs
-
The File Filesystem
Closest I found: https://github.com/guardianproject/libsqlfs
> The libsqlfs library implements a POSIX style file system on top of an SQLite database. It allows applications to have access to a full read/write file system in a single file, complete with its own file hierarchy and name space. This is useful for applications which needs structured storage, such as embedding documents within documents, or management of configuration data or preferences. Libsqlfs can be used as an shared library, or it can be built as a FUSE (Linux File System in User Space) module to allow a libsqlfs database to be accessed via OS level file system interfaces by normal applications.
-
Why you should probably be using SQLite
- Use clone file to duplicate the cached data directory to give to individual tests.
One thing I'd like to pursue is to store the Postgres data dir in SQLite [1]. Then, I can reset the "file system" using SQL after each test instead of copying the entire datadir.
[1]: https://github.com/guardianproject/libsqlfs
-
SQLite: 35% Faster Than the Filesystem
Not sure about compression but somebody could probably hack it in an afternoon using this:
https://github.com/guardianproject/libsqlfs
or something similar to check the potential for speed up.
- Libsqlfs: A Posix-style file system on top of an SQLite database
- FUSE based Posix style file system on top of an SQLite database
-
Why the Windows Registry sucks technically (2010)
Maybe there isn't a database engine that explicitly supports file system daya structures, but you could implement a filesystem in the application layer using SQLite as a storage mechanism.
Here's an example of someone doing that very thing.
https://github.com/guardianproject/libsqlfs
- Is it time to remove reiserfs?
- SQLite Archive Files
-
A Future for SQL on the Web
now let's see what it takes to make absurd-fs, where we use https://github.com/guardianproject/libsqlfs to make a filesystem on top of sqlite on top of the File System Access API.
gotta keep ourselves fully looped. β₯
pocketbase
-
Wouldn't it be cool to have a Supabase for SQLite?
It's an obvious question, but have you looked into Pocketbase?
https://github.com/pocketbase/pocketbase
- Redis Re-Implemented with SQLite
-
Using Google Sheets as the back end/APIs of your app
I'd like to plug PocketBase [0] for a similar use case.
Last week I was looking for a place to store random data with API access, and was looking at making a Google Sheets backend, but PocketBase was easy and didn't have a 60 rpm quota.
Deploying to a cheap VPS was very easy with CapRover.
[0] https://pocketbase.io/
- Soul: A SQLite REST and Realtime Server
-
Deploying Pocketbase with Docker, Nginx and SSL
What is Pocketbase? Pocketbase is an open-source backend solution offering a real-time database, file storage, and seamless user authentication with OAuth integration, all readily available right out of the box.
-
Ask HN: What two software products should have a kid?
Browsing HN, GitHub and the like we get to see a huge variety of software products and code bases.
I often see products and think - if this product X, got together with Y, it would be pretty cool - kind of like if they had a kid together.
Not too literally, but more on the conceptual level - my level of programming is low.
E.g. Just some....
- pocketable.io & datasette (+with some more charting) [https://pocketbase.io, https://datasette.io]
-
Ask HN: What development tools are you using for your current project?
I'm working on a personal project and found myself looking for an alternative to Postman/Insomnia this morning. This made me realize i've been using the same tools for so long for work (mobile development, finance) that this project may be a good time to try out some new things.
Here are a few tools that i've been using lately that I really enjoy:
https://pocketbase.io/ - A dead-simple self-hosted firebase/supabase-like "backend in a box" using golang and sqlite. So far i've been really impressed. I've gone the route of extending the base offering with more go code and am really enjoying the experience.
https://excalidraw.com/ - An open source whiteboarding tool. Slick to use and after learning some keybinds I've gotten pretty fast at throwing together diagrams to explain things to people on my team. The killer piece though is that the filetype is just json, so I can source control my diagrams. Even better, their "export to png" function has a box to embed the json data _into_ the png, allowing me to slap the diagram in places that only accept images (think confluence) and still be able to change the diagram later if needed. 10/10.
https://docs.gitlab.com/ee/ci/ - Gitlab's CI/CD toolset is really impressive, and I've gotten really intimate with it's deeper features over the past year. I'd be curious though to hear from someone who's familiar with it vs it's competitors.
- No longer accepting donations (Pocketbase)
- FLaNK Weekly 08 Jan 2024
-
Pocketbase: Open-source back end in 1 file
Is there an article somewhere, outside of the Pocketbase docs, presenting that pattern?
- https://github.com/pocketbase/pocketbase/blob/master/core/ap...
What are some alternatives?
sqlite-zstd - Transparent dictionary-based row-level compression for SQLite
supabase - The open source Firebase alternative.
sqlitefs - sqlite as a filesystem
Appwrite - Your backend, minus the hassle.
dirs-rs - a low-level library that provides config/cache/data paths, following the respective conventions on Linux, macOS and Windows
surrealdb - A scalable, distributed, collaborative, document-graph database, for the realtime web
StorX - PHP library for flat-file data storage
Strapi - π Strapi is the leading open-source headless CMS. Itβs 100% JavaScript/TypeScript, fully customizable and developer-first.
sqlfs - Sqlite FUSE filesystem with sqlcipher support
litestream - Streaming replication for SQLite.
nix-1p - A (more or less) one page introduction to Nix, the language.
thin-backend - π₯ Thin Backend is a Blazing Fast, Universal Web App Backend for Making Realtime Single Page Apps